The Excel Master Guidebook Series (7 books)

The Excel Master Guidebook Series is a comprehensive set of books about Excel.

After reading these 7 books, you will be an Excel Master.

Topics discussed in the books are are:

1. Getting Familiar with Excel

- The Ribbon Explained
- Exploring The Worksheet
- Quick Analysis Tool
- Customizing Excel
- Installing Apps and Add-ins

2. The Basics Explained

- Number Formatting
- Working With Cells and Ranges
- Creating Templates
- Formatting Techniques
- Protecting Worksheets

3. Formulas & Functions

- Text Formulas
- Financial Formulas
- Statistical Formulas
- Lookup Formulas
- Array Formulas

4. Charts & Graphics

- Creating Charts
- All Chart Types Explained
- Advanced Charting Techniques
- Creating Sparkline Graphics
- Use Pictures and Graphics

5. Data Management & Analysis

- Sorting Data
- Filtering Lists
- Working with Pivot Tables
- Performing What-if Scenarios
- Use the Excel Solver

6. Macros & VBA Programming

- Recording Macros
- Running Macros
- Creating User Defined Functions
- VB Editor Explained
- Edit Macros Using VBA

7. Shortcuts & Functions List

- List of keyboard shortcuts
- Shortcuts for Formulas
- Shortcuts for Navigation
- Shortcuts for Data Entry
- List of all functions

And much more!

Complete your purchase and download these 7 books now to become an Excel Master!