Home > Step-by-Step Excel Manuals

Step-by-Step Excel Manuals

Microsoft Excel Self-Study

Based on our 24+ years of Excel training and industry software design.

Step-by-step, how-to-do manuals that cover from beginning Excel to advanced Excel VBA topics.

  • Step-by-step visual instructions
  • Problem layout and construction strategies
  • Each manual contains 100's of industry examples
  • Apply the manual towards a class later
  • Manuals for: business / industry >
    & engineering / science >
Holiday Sale
Bolt

Business and Industry

Bolt

Microsoft Excel Solutions Handbook

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 >

Price: $49.00
Sale: $36.00

Add to Cart

Excel VBA Problem Solver

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 >

Price: $75.00
Sale: $56.00

Add to Cart

Creating Advanced Excel VBA Apps

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 >

Price: $110.00
Sale: $82.00

Add to Cart

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

Price: $145.00
Sale: $108.00

Add to Cart
Bolt

Engineering and Science

Bolt

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 >

Price: $75.00
Sale: $56.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 >

Price: $99.00
Sale: $74.00

Add to Cart

Interfacing Excel VBA with Fortran

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 >

Price: $119.00
Sale: $89.00

Add to Cart

Excel-Aided Engineering and Science

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 >

Price: $145.00
Sale: $108.00

Add to Cart
Need Help? Please call us at 1.805.498.7162

Copyright © 2002-2022

EMAGENIT All Rights Reserved