The Complete Excel and Excel VBA Manual Self-Study

How our manual can help you.

• 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.