Excel Data Validation
Data validation allows you to limit or restrict the values that a particular cell will accept. It allows […]
Blog
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 […]
Windows 10 Versions
Windows 10 Home is designed for use in PCs, tablets and 2-in-1 PCs. It includes all features directed […]
Excel Tables Introduction
What is an Excel table? Before answering that I will define the word tabular. If data is in […]