The Complete Excel Manual Self-Study

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