Microsoft Excel Self Study and Microsoft Excel VBA Self Study Manuals

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

Format: ADOBE PDF, Excel Files, Download Access Sent Within 3 hr After Purchase Mon-Fri 8:00 AM-4:30 PM PST

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.

Price: $40.00

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

Format: ADOBE PDF, Excel Files, Download Access Sent Within 3 hr After Purchase Mon-Fri 8:00 AM-4:30 PM PST

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. What is VBA?

Price: $79.00

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

Format: ADOBE PDF, Excel Files, Download Access Sent Within 3 hr After Purchase Mon-Fri 8:00 AM-4:30 PM PST

This Microsoft Excel VBA self study manual covers the fundamentals of using VBA programming. It covers VBA fundamentals such as loops, variables and logic and controlling Microsoft Excel, Microsoft Word and PowerPoint using VBA. This workshop also covers data processing using Excel and VBA including single data sheet, multi data sheet problems and summary sheets. It also covers automated chart construction and beginning dashboard topics. It uses real world examples that lets you start building macros in Excel right away. What is VBA?

Price: $69.00

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

Format: ADOBE PDF, Excel Files, Download Access Sent Within 3 hr After Purchase Mon-Fri 8:00 AM-4:30 PM PST

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. What is VBA?

Price: $69.00

Over 1000 pages of advanced Excel VBA programming strategies including an Excel VBA overview, data processing, automated charts, custom worksheet functions, advanced dashboards, userform design, events, database communication and commanding Word and PowerPoint for report generation

Format: ADOBE PDF, Excel Files, Download Access Sent Within 3 hr After Purchase Mon-Fri 8:00 AM-4:30 PM PST

This Microsoft Excel VBA self study manual covers advanced VBA topics such as advanced data processing, automated chart construction for multi worksheets; advanced control techniques of other applications such as Microsoft Word and Microsoft PowerPoint; advanced dash board construction using charts, pictures, ActiveX controls and drawing shapes; wizard construction using userforms; advanced worksheet layout including navigation; database communication using ADO and DAO; communicating with other computer languages and advanced report generation. It uses real world examples that lets you take your Excel applications to the top level. What is VBA?

Price: $89.00

Over 1000 pages of advanced Excel VBA programming strategies including an Excel VBA overview, data processing, automated charts, custom worksheet functions, advanced dashboards, userform design, events, database communication and commanding Word and PowerPoint for report generation

Format: ADOBE PDF, Excel Files, Download Access Sent Within 3 hr After Purchase Mon-Fri 8:00 AM-4:30 PM PST

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. What is VBA?

Price: $89.00

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

Format: ADOBE PDF, Excel Files, Download Access Sent Within 3 hr After Purchase Mon-Fri 8:00 AM-4:30 PM PST

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 (macros) write ups. What is VBA?

Price: $169.00

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

Format: ADOBE PDF, Excel Files, Download Access Sent Within 3 hr After Purchase Mon-Fri 8:00 AM-4:30 PM PST

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. What is VBA?

Price: $169.00