The Excel Master Guidebook Series (7 books)

Description:

keywords:microsoft office training,microsoft office 2010 training,microsoft office button excel,microsoft office training videos,hosted microsoft office,

This comprehensive book series (7 books) will teach you everything you want and should know about Excel.

The books are suitable for beginners and for advanced users.

What is included?

Book I: Getting Familiar with Excel
- The Ribbon Explained
- Exploring The Worksheet
- Quick Analysis Tool
- Customizing Excel
- Installing Apps and Add-ins

Book 2: The Basics Explained
- Number Formatting
- Working With Cells and Ranges
- Creating Templates
- Formatting Techniques
- Protecting Worksheets

Book 3: Formulas & Functions
- Text Formulas
- Financial Formulas
- Statistical Formulas
- Lookup Formulas
- Array Formulas

Book 4: Charts & Graphics
- Creating Charts
- All Chart Types Explained
- Advanced Charting Techniques
- Creating Sparkline Graphics
- Use Pictures and Graphics

Book 5: Data Management & Analysis
- Sorting Data
- Filtering Lists
- Working with Pivot Tables
- Performing What-if Scenarios
- Use the Excel Solver

Book 6: Macros & VBA Programming
- Recording Macros
- Running Macros
- Creating User Defined Functions
- VB Editor Explained
- Edit Macros Using VBA

Book 7: Shortcuts & Functions List
- List of keyboard shortcuts
- Shortcuts for Formulas
- Shortcuts for Navigation
- Shortcuts for Data Entry
- List of all functions

keywords:microsoft office training,microsoft office 2010 training,microsoft office button excel,microsoft office training videos,hosted microsoft office,

./upload/Microsoft%20Office/The_Excel_Master_Guidebook_Ser_8_20_2017_3_43_52_PM.jpg
eBook Details:
Category: Microsoft Office
Author: Excel Expert
Language: English
ISBN10: B0100LT2CA
ISBN13:
Pages: 685
PubDate: 2015-06-18 00:00:00
UploadDate: 8/20/2017 3:43:52 pm

The Latest Upload

The Most Related

Category