Step-by-Step How to Do Excel Manuals

Covers the Excel topics, strategies, and methods needed to solve your Excel workplace tasks quickly.

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. Learn More >

Buy a manual now, apply the price towards a class later. Manuals come free with our classes.

Price: $49.00

Add to Cart

Covers the must know Excel VBA fundamentals you can use to automate calculations, formatting, data processing, and reports.

Fundamental VBA topics covered include how to use the Excel VBA Editor, VBA modules, and the Editor's debugging tools.
Shows you how to build programs; type and use Excel VBA; use logic and loops; and setup simple interfaces to run your code.
Demonstrates how to use VBA to control key Excel elements that are used to solve common industry problems.
1000's of lines of useful code, over 100 real world examples, and the proven strategies we use to develop Excel VBA software. Learn More >

Buy a manual now, apply the price towards a class later. Manuals come free with our classes.

Price: $75.00

Add to Cart

Covers the VBA topics needed to design powerful UI driven data processing, database, and calculation tools for Excel.

Contains our complete Excel VBA write-up spanning from beginning Excel VBA to advanced Excel VBA topics.
Shows you how to create hi-tech Excel VBA interfaces from userforms, ActiveX controls, events, charts...
Also covers topics like multi-folder data processing, solving complex data sets; analyzing text files, and querying databases.
1000's of lines of useful code, 100's of real world examples, and the proven strategies we use to develop Excel VBA software. Learn More >

Buy a manual now, apply the price towards a class later. Manuals come free with our classes.

Price: $110.00

Add to Cart

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 Microsoft Excel and Excel VBA macro write-up. It is everything rolled into one manual, basically all the above manuals.
Covers the Excel topics needed to perform a variety of tasks including creating formulas and using functions; data processing; automated reporting; and dashboard design.
Includes our complete Excel VBA write-up that shows you how to build automated calculations, models, data processing, advanced UIs, and database tools.
100's real world examples and 1000's of lines of useful code included. Learn More >

Buy a manual now, apply the price towards a class later. Manuals come free with our classes.

Price: $145.00

Add to Cart

Excel VBA Handbook for Engineers and Scientists

Covers how to use Excel VBA to perform essential tasks like automated calculations, data processing, charting, and reporting.

Explains in detail how to use the Excel VBA language, VBA Editor, and VBA modules and perform code debugging.
Covers how to control key Excel elements with VBA like workbooks, worksheets, ranges, shapes, formats, functions, and Excel's data tools.
Shows how to use Excel VBA to perform tasks like copying / pasting data; automating calculations; creating / formatting reports; and building charts.
1000's of lines of useful code, over 100 real world examples, and the proven strategies we use to develop Excel VBA software. Learn More >

Buy a manual now, apply the price towards a class later. Manuals come free with our classes.

Price: $75.00

Add to Cart

Excel VBA App Design for Engineers and Scientists

Covers the Excel VBA topics needed to design powerful UI driven data processing, analysis, modeling, and database tools.

Contains our complete Excel VBA write-up covering fundamental to advanced Excel VBA topics.
Discusses how to create event driven interfaces using VBA, userforms, ActiveX controls, charts, and worksheets
Covers key topics including multi-folder / workbook data processing; automated models; controlling databases; and automating Solver / Analysis Toolpak.
1000's of lines of useful code, 100's of real world examples, and the proven strategies we use to develop Excel VBA software. Learn More >

Buy a manual now, apply the price towards a class later. Manuals come free with our classes.

Price: $99.00

Add to Cart

Covers how to combine the speed and computational power of Fortran DLLs with the interface, data processing, and modeling abilities of Excel VBA.

Covers creating and running Fortran DLLs from various Excel VBA interfaces and models.
In depth review of Fortran DLL / VBA data type matching, argument list design, and calling rules.
Contains our full write-up for Excel VBA including UI design, data processing, automated charting, and modeling.
1000's of lines of useful code, 100's of real world examples, and key Fortran / Excel VBA topics not found anywhere else. Learn More >

Buy a manual now, apply the price towards a class later. Manuals come free with our classes.

Price: $119.00

Add to Cart

Our "all-in-one" Excel manual covers the Excel and VBA topics needed to build powerful model, analysis, optimization, and data tools.

Includes our full Microsoft Excel and Excel VBA macro write-up. It is everything we have rolled into one manual, basically all the above manuals.
Covers the Excel topics needed to perform tasks like data processing, automated reporting, modeling, numerical analysis, design optimization, and dashboard design.
Includes our complete Excel VBA write-up that shows you how to build automated calculations; models; data processing tools; advanced UIs; and database tools.
100's real world examples and 1000's of lines of useful VBA code included. Learn More >

Buy a manual now, apply the price towards a class later. Manuals come free with our classes.

Price: $145.00

Add to Cart

Step-by-Step How to Do Excel Manuals

Step-by-step Excel manuals based on over 23 years of Excel training and industry software design.

Microsoft Excel Manuals for Business and Industry

Covers the Excel topics, strategies, and methods needed to solve your Excel workplace tasks quickly.

Covers the must know Excel VBA fundamentals you can use to automate calculations, formatting, data processing, and reports.

Covers the VBA topics needed to design powerful UI driven data processing, database, and calculation tools for Excel.

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

Microsoft Excel Manuals for Engineers and Scientists

Covers how to use Excel VBA to perform essential tasks like automated calculations, data processing, charting, and reporting.

Covers the Excel VBA topics needed to design powerful UI driven data processing, analysis, modeling, and database tools.

Covers how to combine the speed and computational power of Fortran DLLs with the interface, data processing, and modeling abilities of Excel VBA.

Our "all-in-one" Excel manual covers the Excel and VBA topics needed to build powerful model, analysis, optimization, and data tools.