Microsoft Excel Solutions Handbook

At a quick glance.

Our manual is a combination of beginning, intermediate, and advanced Excel topics and also covers hi-tech dashboard design.
Covers everything from typing data to using functions and formulas to automated reporting using Power Query, Excel tables, and Pivot Tables.
Also discusses must know topics like problem organization; using names to pass data efficiently; and data processing.
100's of real world examples included.

More about the manual.

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.

Some key manual topics.

It's a 1000+ page manual, there's a lot of topics!

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 type, debug, and use Excel worksheet functions like IF, VLOOKUP, SUMIFS, COUNTIFS, INDEX, SUM, MAX, MIN, ...and much much more
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 create, edit, 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!

Manual specifications and download.

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:	1200+ pages with Excel examples
Platform:	Windows 7 and above
Sent:	Sent within 3 hr after purchase Mon-Fri 8:00 AM - 7:00 PM CT
Versions:	Excel 2013 for Windows and above