The Complete Excel Manual Self-Study

Learn to use Excel in amazing new ways that will save you time and effort. Our "all in one" Excel manual covers everything we know about using Excel and Excel VBA tasks to solve industry problems.

The Complete Excel Manual

Our all-in-one Excel manual that covers everything we know on using Excel and Excel VBA in business and industry.

How our manual can help you.

Excel-Aided Engineering and Science

Our "all-in-one" manual contains the must know Excel industry topics, tips, and design strategies that you need to solve your tough problems quickly. It discusses the Excel basics like workbook and worksheet operation; worksheet formatting; problem layout; using formulas and functions; sorting and filtering; using shapes and pictures; and creating charts.

How to layout data tables and setup data processing problems is also covered. Also discussed is how to use Excel's report automation tools like Excel tables; PivotTables; Pivot Charts; and Power Query to build your reports at the click of a button.

Our manual also covers how to create hi-tech dashboards using ActiveX controls, charts, drawing shapes, and other Excel elements. You will not believe what you can do with this program.

Lastly our complete beginning to advanced Excel VBA write-up is included that will show you how to automate your everyday Excel tasks and solve large scale Excel data problems in seconds.

  • Controlling workbooks, worksheets, formats, the Ribbon, and Excel help
  • How to build formulas, cell names, functions, UIs and array formulas on the worksheet
  • Using Sort, Filter, Excel tables, Slicers, functions, PivotTables... to analyze data
  • How to use Conditional Formatting and Data Validation to flag data and build forms
  • How to create and format charts and chart reports in Excel
  • Learn to build hi-tech dashboards in Excel
  • Using Power Query to link, query, and filter databases, text files, and workbooks
  • How to use the VBA Editor, modules, and debug tools
  • Complete VBA language, VBA procedure, and Excel automation review 
  • Using VBA to process various datasets in workbooks and text files
  • Chart automation using Excel VBA
  • How to develop advanced UIs from VBA, ActiveX controls, events, userforms, shapes...
  • Commanding databases and text files with ADO, SQL, and VBA

What you will learn in our manual.

Expert Excel Training

$129.00

Buy the manual now and apply its price to a class later. Just type your transaction # in the comments when purchasing a class.

Coming in October

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 along with our full VBA write up
Book:2200+ pages with 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

Associated classes.

Need Help? Please call us at 1.629.207.9662

Copyright © 2002-2023

EMAGENIT All Rights Reserved