The Complete Excel Manual

Our "all in one" Excel manual covers everything needed to solve your Excel or Excel VBA tasks. It's our complete write-up.

• Includes our full Excel and Excel VBA write-ups. It is everything rolled into one manual.
• Over 2200+ pages of must know Excel topics, methods, and strategies.
• 100's of examples like the ones below.
• Our manual will show you how to supercharge Excel.
• Buy a manual now, apply the price towards a class later. They are free with our classes.

Manual Specs.

What's in our manual.

Our 2200+ page manual contains the must know industry Excel topics, tips, and design strategies that you need with our full Excel VBA write-up. Topics include basic cell operation, worksheet formatting, formula design, sorting, filtering, PivotTables, array formulas, external data access, modeling, chart creation and linking Excel with other programs like Word and PowerPoint. It also covers dashboard topics including using ActiveX controls, charts and drawing shapes. Also covered is our complete Beginning Excel VBA and Advanced Excel VBA write-ups. Some sample manual problems are illustrated below.

Click to enlarge, scroll < > if hidden.

Key Excel and Excel VBA topics covered in the manual.

• Excel element overview; creating, opening, saving workbooks; using the Ribbon; and using Excel Help
• Worksheet formulas, cell naming, formula construction, data processing, functions, formatting, security, and array formulas
• Sorting, copying and pasting data, data entry, filters, PivotTables, Slicers, and Excel tables
• Using Conditional Formatting to flag data and build interfaces
• Using Data Validation to flag user input and control models and forms
• How to create charts and chart reports in Excel
• Advanced Microsoft Excel dashboard design
• Problem optimization in Excel using Solver
• Linking team workbooks together in Excel
• Using Power Query and MS Query to link, query, and filter databases, text files, and workbooks
• How to use Excel VBA to make useful, time saving tools
• VBA Editor windows, VBA modules, and debug tool review
• Complete VBA language review including loops, logic, variables, arrays, procedures, and functions
• How to use objects, properties, and methods in VBA to control Excel
• Automating key Excel elements with VBA
• Using VBA to process data on single and multiple worksheets/workbooks
• Automating charts with Excel VBA
• Controlling Windows folder system with VBA
• Using events, ActiveX controls, userforms, shapes, worksheets, and VBA to create advanced program UIs
• Commanding databases and text files with ADO, SQL, and VBA
• Overview of commanding Word, PowerPoint, and Outlook with VBA