Welcome! The Microsoft® Excel® Step-By-Step Training Guide Series is designed to quickly teach you the most common basic and intermediate Microsoft® Excel® formulas & features, including Pivot Tables, & the VLOOKUP formula. Each book is organized into step-by-step sections, with screenshots, and easy to follow steps allowing you to learn and grow your knowledge of Microsoft® Excel® at your own pace.
Learn more about the book series below:
Fundamentals:
-
Sum, Subtraction, Multiplication, & Division,
-
Average, Min, Max, Today, Networkdays, & SumIF
Pivot Tables (an introduction):
-
Organizing & summarizing data
-
Formatting results, & adding Pivot Charts
Excel® Features:
-
Data Sorting, Formula Trace,
-
Text-To-Columns, & Conditional Formatting
Text Functions:
-
LEN, TRIM, CONCATENATE,
-
MID, PROPER, UPPER, & LOWER
Logic & Lookup Functions:
-
IF & AND
-
Learn how to use a basic VLOOKUP formula
Fundamentals:
-
Sum, Subtraction, Multiplication, & Division,
-
Average, Min, Max, Today, Networkdays, & SumIF
Pivot Tables (an introduction):
-
Organizing & summarizing data
-
Formatting results, & adding Pivot Charts
Excel® Features:
-
Data Sorting, Formula Trace,
-
Text-To-Columns, & Conditional Formatting
Text Functions:
-
LEN, TRIM, CONCATENATE,
-
MID, PROPER, UPPER, & LOWER
Logic & Lookup Functions:
-
IF & AND
-
Learn how to use a basic VLOOKUP formula
-
Organizing & summarizing data
-
Formatting results
-
Inserting Pivot Charts
-
Displaying averages & percentages
-
Ranking data
-
Grouping data
-
Inserting calculated fields
-
How to create a basic Dashboard
-
Optional instructions for protecting Dashboard data and hiding tabs
-
Updating Dashboard data, while keeping the existing formatting and presentation intact
-
What the VLOOKUP formula does
-
The parts of the VLOOKUP formula
-
Detailed examples with screenshots using a basic VLOOKUP formula
-
Incorporating the IFERROR functionality into your VLOOKUP formula
-
What to do when you attempt to lookup a value in the table_array, but none exists
-
What to do when you don’t have a unique lookup_value
-
What to do when the unique lookup_value is listed more than once in the table_array
-
Detailed example applying the VLOOKUP formula across multiple workbooks and tabs
-
A review of common VLOOKUP error messages / issues and how to resolve them
