Excel Power Query Introduction
What is Power Query? This is what Microsoft says: “Power Query is a data transformation and data preparation […]
Blog
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 […]
Tabular Data Format
One of the most important considerations in working with and presenting data is the data format, also known […]
Pivot Table Data Structure
For your Excel pivot tables to be useful and easy to work with, you must first ensure that […]
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 […]