Why Use Excel Tables?
Why would you want to use Excel tables? Why not just stick with Excel ranges or just leave […]
Excel
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 […]
Pivot Table Data Structure
For your Excel pivot tables to be useful and easy to work with, you must first ensure that […]
Excel Tables Introduction
What is an Excel table? Before answering that I will define the word tabular. If data is in […]
Excel Headers and Footers
This post is about a few suggestions and tips about setting up our headers and footers in your […]
Excel Introduction
Wikipedia says: “Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features […]
Excel Table Names
What are some of the best practices for naming your tables in Microsoft Excel? The website Excel Campus […]