Call us at: 1.805.498.7162 1.805.558.9277

Home > Microsoft Excel Workshops > Microsoft Excel Self-Study Manuals

Microsoft Excel and Microsoft Excel VBA Self Study Manuals

for Business, Engineering and Science

Our Microsoft Excel Self Study Manuals are based on our 14 plus years of Excel training and macro development. They contain extensive Microsoft Excel and Microsoft Excel VBA knowledge based on our consulting and software design experiences. They not only contain "how to" information, but also practical application discussions as well.

Manual Format and Download

Our manual is in the form of ADOBE PDF's and Excel Files. Once purchased, you will receive a password and download instructions within 2 hrs during our business hours of Mon-Fri 8:00 AM-4:30 PM Pacific Time. If purchased off hours, the password and instructions will be sent at the beginning of the next business day.

Business Self-Study

Microsoft Excel Essentials Self Study

for Business Professionals

Covers: Excel 2000-2010

Over 800 pages of useful Excel tips, formulas and strategies derived from over 14 years of Microsoft Excel training.

This Microsoft Excel self study manual covers all the vital Microsoft Excel skills you will use in an office environment. This book is a combo of our beginning, intermediate and advanced Excel workshops. Complete Manual Outline

Price: $50.00

Beginning Microsoft Excel VBA Self Study

for Business Professionals

Covers: Excel 2000-2010

Over 700 pages of useful Excel VBA programming strategies including an extensive VBA overview, data processing, automated charts, custom worksheet functions and basic dashboards.

This Microsoft Excel VBA self study manual covers the basics of VBA. It covers fundamentals such as loops, variables and logic and controlling Microsoft Excel. This manual also covers data processing using Excel VBA including single sheet, multi data sheet problems and summary sheets. It also covers automated chart construction and basic dashboard topics. It uses real world examples that lets you start building macros right away. Complete Manual Outline

Price: $69.00

Advanced Microsoft Excel VBA Self Study

for Business Professionals

Covers: Excel 2000-2010

Over 1000 pages of advanced coding strategies including a VBA review, advanced data processing, advanced dashboards and controlling other programs and databases.

This Microsoft Excel VBA self study manual covers advanced topics such as multi worksheet data processing; application control like Word / PowerPoint; advanced dash board construction using charts, ActiveX controls; userform design, program navigation; database communication; running other computer languages and advanced report generation. It uses examples that lets you take your Excel applications to new heights. Complete Manual Outline

Price: $129.00

Microsoft Excel-Aided Business Self Study

Covers: Excel 2000-2010

Over 1800 pages of useful Excel VBA programming strategies including an extensive VBA overview, data processing, automated charts, custom worksheet functions and basic dashboards.

This all in one Excel and Excel VBA self study manual covers all the Excel basics that form our Beginning, Intermediate and Advanced Excel workshops. That includes basic cell operation, formula design, sorting, filtering, pivot tables, array formulas, data importation, chart creation and linking Excel with other programs. It also discusses how to turn worksheets into dashboards using ActiveX controls and drawing shapes. Also included is our complete Beginning Excel VBA and Advanced Excel VBA manuals. Complete Manual Outline

Price: $169.00

Engineering and Science Self-Study

Beginning Microsoft Excel VBA Self Study

for Engineers and Scientists

Covers: Excel 2000-2010

Over 700 pages of useful Excel VBA programming strategies including an extensive Excel VBA overview, data processing, automated charts, custom worksheet functions and basic dashboards.

This Microsoft Excel VBA self study manual covers the fundamentals of using VBA programming in the engineering and science world. From loops, variables and logic to controlling Microsoft Excel, Microsoft Word and PowerPoint to data processing. It also covers automated engineering chart construction, beginning dashboard topics, system modeling, custom worksheet functions (UDF's) and numerical analysis approaches. It uses real engineering and science examples that lets you start building useable macros in Excel right away. Complete Manual Outline

Price: $69.00

Interfacing Microsoft Excel VBA / FORTRAN DLLs Self Study

Covers: Excel 2000-2010

Over 700 pages of useful Excel VBA and FORTRAN, programming strategies including a Beginning Excel VBA review.

This FORTRAN DLL self study manual covers how to create FORTRAN DLLs that interface with Microsoft Excel Visual Basic. It discusses how to call FORTRAN from VBA procedures and worksheet formulas allowing entire FORTRAN programs to be run from a single cell. Also discussed are the essentials for communicating with FORTRAN like passing arrays, strings and scalar values. It also discusses how to convert existing FORTRAN programs to the DLL standard. It also covers Beginning Excel VBA. Complete Manual Outline

Price: $79.00

Advanced Microsoft Excel VBA Self Study

for Engineers and Scientists

Covers: Excel 2000-2010

Over 1000 pages of advanced VBA programming strategies including a VBA overview, data processing, automated charts, custom functions, advanced dashboards, userform design, events and controlling other programs and databases.

This Microsoft Excel VBA self study manual covers advanced engineering and science VBA topics such as automated engineering chart construction for multi worksheets; advanced control techniques of other applications such as Microsoft Word and Microsoft PowerPoint; advanced engineering dash board construction using charts, pictures, ActiveX controls and drawing shapes; engineering wizard construction using userforms; advanced worksheet layout including navigation; advanced system modeling; team linking; database communication using ADO and DAO and communicating with other computer languages like FORTRAN. It uses real world examples that lets you take your Excel applications to the top level. Complete Manual Outline

Price: $129.00

Microsoft Excel-Aided Engineering Self Study

Covers: Excel 2000-2010

Over 1800 pages of useful of useful Excel tips, formulas and strategies along with our complete Excel VBA write up.

This all in one Excel and Excel VBA self study manual covers basic engineering and science formula design on the worksheet to numerical techniques on the worksheet like linear systems, Runge Kutta, Newton's method, integration, differentiation and boundary value problems. It also covers complex number operations and advanced engineering and science charts and dashboards using ActiveX controls. EAE also covers system modeling, design optimization using Solver and integrating engineering teams. Also reviewed is beginning and advanced VBA programming including userform design and how to integrate FORTRAN into your coding solutions. Complete Manual Outline

Price: $169.00