Microsoft Excel Solutions Handbook

How our manual can help you.

Our manual covers the Microsoft Excel skills and strategies you need for today's workplace to get the job done quickly.
It discusses core Excel topics like workbook operation; typing data; copying and pasting; worksheet formatting; problem setup; using formulas and functions; sorting and filtering; and creating charts. How to build forms, setup tables, and process data is also discussed.
When you are done with the basics, it shows you how to utilize Excel tables, PivotTables, Pivot Charts, and Power Query to build automated reports that integrate, shape, and calculate data at the click of a button.
Other key topics discussed include how to use logic in formulas; build array formulas that lookup and process complex datasets; and coloring data using logic and Conditional Formatting.
Our manual also covers how to create industry grade dashboards using ActiveX controls, charts, drawing shapes, and other key Excel elements.

What you will learn in our manual.

Overview of the main Excel elements that make up a workbook and how to use them
How to create, open, view, and save workbooks
How to use the Ribbon, Excel dialog boxes, shortcut menus, and help
Typing and entering data on the worksheet
How to format worksheets including cell colors, fonts, borders, merging, text alignment...
How to analyze, sort, and filter data using Excel's Sort, Auto Filter and Advanced Filter tools
Performing worksheet calculations using cell references, ranges, formulas, and names
Performing drag and fill operations on the worksheet for formulas and data
How to use and debug worksheet functions like IF, VLOOKUP, SUMIFS, SUM, MAX, MIN...
How to properly design worksheet tables to store data
Using Excel tables and slicers to rapidly build adaptive reports and calculations
Creating and using PivotTables and Pivot Charts to rapidly process data
Using Conditional Formatting and logic to flag data on the worksheet
Using Data Validation on the worksheet to constrain user entry and build robust forms
How to setup and use ActiveX and Form controls on the worksheet for calculations and forms
Importing text files into Excel
Creating different types of charts in Excel including combined charts
How to link Excel with Word and PowerPoint
Accessing databases and external data sources using MS Query and Power Query
Microsoft Excel dashboard design...and much more!

What You Learn in Excel Solutions Handbook

Applicable Excel business and industry classes.

Buy now, apply your manual price to an Excel class later.

Next Class: Check Dates

Beginning Excel
for Business and Industry

Learn More >

Next Class: Check Dates

Intermediate Excel
for Business and Industry

Learn More >

Next Class: Check Dates

Advanced Excel
for Business and Industry

Learn More >

Next Class: Check Dates

Excel Dashboards
for Business and Industry

Learn More >

Excel Training Services

Excel Public Training

Excel Virtual Training

Excel Onsite Training

Excel Self-Study Manuals

Excel Classes - Business and Industry

Beginning Excel for Business and Industry

Intermediate Excel for Business and Industry

Advanced Excel for Business and Industry

Excel Dashboards for Business and Industry

Beginning Excel VBA for Business and Industry

Excel VBA Data Processing for Business and Industry

Advanced Excel VBA for Business and Industry

Excel Classes - Engineers / Scientists

Microsoft Excel for Engineers for Scientists

Excel Data Analysis for Engineers and Scientists

Excel VBA for Engineers and Scientists

Excel VBA Data Analysis for Engineers and Scientists

Adv Excel VBA Design for Engineers and Scientists

Calling Fortran DLLs from Excel VBA

Microsoft Excel Manuals

Microsoft Excel Solutions Handbook

Excel VBA Problem Solver

Creating Advanced Excel VBA Apps

The Complete Excel Manual

Excel VBA Essentials for Engineers and Scientists

Advanced Excel VBA Apps for Engineers and Scientists

App Design Using Excel, VBA, and Fortran

Excel Aided Engineering and Science

EMAGENIT Company Information

US Military

Excel Training for US Military

For:	Business and Industry
Format:	ADOBE PDF and Excel Files as zip file download
Covers:	Covers beginning to advanced general Excel topics, VBA macros are not covered in this manual
Book:	Fully illustrated, step-by-step instruction, with over 100 fully documented Excel examples
Platform:	Windows 7 and above
Download:	Sent within 3 hrs after purchase Mon-Fri 8:00 AM - 7:00 PM CT
Versions:	Excel 2013 for Windows and above

Microsoft Excel Solutions Handbook Self-Study Manual

How our manual can help you.

What you will learn in our manual.

Manual specifications and download.

Buy a manual.

Applicable Excel business and industry classes.

Buy now, apply your manual price to an Excel class later.