Import a Text File into Excel
How do you import a text file of data into Microsoft Excel? Let’s discuss two different ways of […]
Mike
Excel Index and Match
Excel’s Index and match functions used together can solve complex lookup problems. Let’s jump right into an example […]
Excel Find Nth Occurrence of Char in a String
In Microsoft Excel, what formula would you use to find the Nth occurrence of a character (or string) […]
Excel Extract Nth Word from a Text String
In Microsoft Excel, how would you extract the Nth word in a string? If you are using Excel […]
Pivot Table Example
Here is a simple example of how to create a pivot table in Excel that is based on […]
Why Use Excel Tables?
Why would you want to use Excel tables? Why not just stick with Excel ranges or just leave […]
Excel Power Query Introduction
What is Power Query? This is what Microsoft says: “Power Query is a data transformation and data preparation […]
Excel Dynamic Data Validation
What do we mean by dynamic data validation? Suppose we are asking users to enter a product (or […]
Excel Data Validation
Data validation allows you to limit or restrict the values that a particular cell will accept. It allows […]
Excel Conditional Formatting
Conditional formatting is a spreadsheet tool that changes how cells appear when values meet specific conditions. Here we’ll […]
Excel Workbook Properties
You can modify your Excel workbook (file) properties to better find, document, and describe your Excel files. For […]
Excel Sparklines
Sparklines were introduced in Excel 2010 to represent data in any tiny chart form without an axis and […]