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
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 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 […]
Excel Chart Formatting
As an example I will use a simple column chart with only one series of data. It shows […]
Excel Simple Combo Chart
What is an Excel Combo chart? A combo chart in Excel displays two chart types (such as column […]
Excel Chart Hiding Data
In this example we will have a simple column chart that will exclude a column of data from […]
Excel Chart x Axis Showing Series
Have you ever been frustrated with creating a simple graph showing years in one column and a bunch […]
Excel Headers and Footers
This post is about a few suggestions and tips about setting up our headers and footers in your […]