Microsoft Excel Self Study Manuals and Microsoft Excel VBA Self Study Manuals

Business, Engineering and Science

Microsoft Excel Self Study Manuals and Microsoft Excel VBA Self Study Manuals

Microsoft Excel Self Study Manuals and Microsoft Excel VBA Self Study Manuals

EMAGENIT Microsoft Excel self study manuals and Microsoft Excel VBA self study manuals contain the vital information that you need to start using Microsoft Excel and Microsoft Excel VBA in a productive manner.

Our Microsoft Excel Self Study Manuals are based on our 19 + years of Microsoft Excel training, consulting and software development for top companies. They contain extensive "how to do" Microsoft Excel and Microsoft Excel VBA knowledge that we use when companies ask us to design software for them in Microsoft Excel.

EMAGENIT Excel Manuals?
Our complete Excel manuals are called Microsoft Excel-Aided Engineering and Science and Microsoft Excel-Aided Business. They each have over 2000 + pages of Excel documentation, methods and strategies. All of our other manuals are derived from these manuals.

Why Choose Our Microsoft Excel Manuals?

Our new Microsoft Excel Self Study Manuals cover Excel 2007 to 2016 need to know topics like basic Excel operation, worksheet formatting, worksheet organization, formula construction, cell naming, using Excel's data tools, worksheet functions, pivot tables, Excel tables, workbook linking and graphics for starts. They also cover advanced Excel topics like professional chart development, Solver, ActiveX controls, data processing, modeling, external data access (databases), text file manipulation, advanced formulas, array formulas and dashboard design.

Our self-study manuals for Microsoft Excel and Microsoft Excel VBA contain the same methods and strategies that we use when we construct Excel software for companies like Caterpillar and Apple. They also contain our 19+ years of training experience.

Our manuals also discuss Excel VBA programming in depth providing industry proven know how that we use in our own software projects for our customers. We are talking thousands of lines of useful code and actually more importantly how to think when programming, how to write the code, how to read the code and how to look it up all laid out in precise detail. They provide the tips, strategies and methods just not found in other manuals. We go in depth in these manuals showing you exactly how to do things step by step.

Business Professionals - Self Study Manuals

Microsoft Excel Business Essentials
Self Study Manual

Microsoft Excel Business Essentials Self Study Manual
Over 1000 + pages of useful Excel tips, formulas and strategies derived from our 19+ years of General Excel training. It shows you everything you really need to know about using Excel in the business world.
View Manual Details

Microsoft Excel Business Essentials Self Study Manual Information

Manual Overview
Overview: This Microsoft Excel self study manual covers all the fundamental Microsoft Excel skills you will use in an office environment. Our manual is a combo of our beginning, intermediate and advanced Excel training. It covers general Excel topics like formula construction, worksheet functions, chart construction, copying and pasting, worksheet formatting, sorting, filtering...etc. When you are done with the basics, it then shows you how to build pivot tables and Excel tables, perform data processing, use logic and arrays in formulas, use data validation and conditional formatting, build dashboards, use ActiveX controls, link Excel with Word and PowerPoint, link Excel with databases and much much more.
Manual Details
For: Business Professionals
Format: ADOBE PDF and Excel Files as zip file download
Covers: Covers beginning to advanced general Excel topics, VBA macros are not covered in this manual
Manual: 1000 + pages with Excel examples
Platform: Windows 7 - Windows 10
Sent: Sent within 3 hr after purchase Mon-Fri 8:30 AM - 5:00 PM PT
Excel Versions: Excel for Windows 2007-2016, Mac version coming soon

Price: $89.00

Beginning Microsoft Excel VBA
Business Self Study Manual

Beginning Excel VBA Self Study Manaual
Over 800 + pages of useful Excel VBA topics covering the VBA fundamentals, controlling key Excel elements, data processing, automated charts, custom worksheet functions, modeling and basic dashboards.
View Manual Details

Beginning Microsoft Excel VBA Self Study Manual Information

Manual Overview
Overview: 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. Our 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 Excel VBA macros right away.
Manual Details
For: Business Professionals
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning to intermediate Excel VBA topics
Manual: 800 + pages with examples
Platform: Windows 7 - Windows 10
Sent: Sent within 3 hr after purchase Mon-Fri 8:30 AM - 5:00 PM PT
Excel Versions: Excel for Windows 2007-2016, Mac version coming soon

Price: $99.00

Advanced Microsoft Excel VBA
Business Self Study Manual

Advanced Excel VBA Self Study Manaual
Over 1000 + pages of advanced Excel VBA topics covering data processing, charts, multi workbook data storage, text files, modeling, dashboards, userforms, events, ActiveX controls, database linking and the Windows file system.
View Manual Details

Advanced Microsoft Excel VBA Self Study Manual Information

Manual Overview
Overview: This Microsoft Excel VBA self study manual covers advanced topics such as multi worksheet/workbook data processing; commanding text files; commanding and controlling Windows folder and file system; application control like Word / PowerPoint; advanced dashboard construction using charts, ActiveX controls, worksheets and drawing shapes; userform design; database communication; running other computer languages from VBA; and advanced report generation. It uses examples that lets you take your Excel applications to new heights.
Manual Details
For: Business Professionals
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning to advanced Excel VBA topics
Manual: 1000 + pages with examples
Platform: Windows 7 - Windows 10
Sent: Sent within 3 hr after purchase Mon-Fri 8:30 AM - 5:00 PM PT
Excel Versions: Excel for Windows 2007-2016, Mac version coming soon

Price: $119.00

Microsoft Excel-Aided Business
Self Study Manual

Microsoft Excel Aided Business Self Study Manual Self Study Manual
Over 2000+ pages of useful general Excel tips, formulas and strategies along with our complete Excel VBA write up. It is everything we know and use in Microsoft Excel. It is all of our other business manuals in one.
View Manual Details

Advanced Microsoft Excel VBA Self Study Manual Information

Manual Overview
Overview: This all in one Excel and Excel VBA self study manual covers all the topics found in our Excel Business Essentials manual. That includes basic cell operation, worksheet formatting, formula design, sorting, filtering, pivot tables, array formulas, data importation, modeling, chart creation and linking Excel with other programs like Word and PowerPoint. It also discusses how to turn worksheets into dashboards using ActiveX controls, charts and drawing shapes. Also included in our manual is our complete Beginning Excel VBA and Advanced Excel VBA manuals.
Manual Details
For: Business Professionals
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning general Excel to advanced Excel VBA topics
Manual: 2000 + pages with examples
Platform: Windows 7 - Windows 10
Sent: Sent within 3 hr after purchase Mon-Fri 8:30 AM - 5:00 PM PT
Excel Versions: Excel for Windows 2007-2016, Mac version coming soon

Price: $169.00

Engineers & Scientists - Self Study Manuals

Beginning Microsoft Excel VBA
Eng/Sci Self Study Manual

Beginning Microsoft Excel VBA Self Study Manual
Over 800+ pages of useful Excel VBA programming topics covering the VBA fundamentals, Excel element control, data processing, automated charts, custom worksheet functions, modeling and basic dashboards.
View Manual Details

Beginning Microsoft Excel VBA Self Study Manual Information

Manual Overview
Overview: This Microsoft Excel VBA self study manual covers the fundamentals of using VBA programming in the engineering and science world. From the VBA programming basics like loops, variables and logic to using VBA to control workbooks, worksheets and cells it has you covered. The main topics covered include various key Excel element control, data processing, automated chart construction, beginning dashboards, system modeling, custom worksheet functions (UDF's) and numerical analysis approaches. It uses real engineering and science examples that lets you start building useable VBA macros in Excel right away.
Manual Details
For: Engineers and Scientists
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning to intermediate Excel VBA topics
Manual: 800 + pages with examples
Platform: Windows 7 - Windows 10
Sent: Sent within 3 hr after purchase Mon-Fri 8:30 AM - 5:00 PM PT
Excel Versions: Excel for Windows 2007-2016, Mac version coming soon

Price: $99.00

Advanced Microsoft Excel VBA
Eng/Sci Self Study Manual

Advanced Microsoft Excel VBA Self Study Manual
Over 1000+ pages of advanced Excel VBA topics covering data processing, text files, multi workbook data storage,  charting, dashboards, userforms, events, ActiveX controls, system modeling, databases and Windows file control.
View Manual Details

Advanced Microsoft Excel VBA Self Study Manual Information

Manual Overview
Overview: This Microsoft Excel VBA self study manual covers advanced engineering and science VBA topics such as advanced data processing using multiple workbooks, worksheets and text files; automated engineering chart construction and formatting on multiple 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; engineering form construction using userforms and ActiveX controls; 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 next level.
Manual Details
For: Engineers and Scientists
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning to advanced Excel VBA topics
Manual: 1000 + pages with examples
Platform: Windows 7 - Windows 10
Sent: Sent within 3 hr after purchase Mon-Fri 8:30 AM - 5:00 PM PT
Excel Versions: Excel for Windows 2007-2016, Mac version coming soon

Price: $119.00

Interfacing Excel VBA with FORTRAN
Eng/Sci Self Study Manual

Interfacing Microsoft Excel VBA / FORTRAN DLLs Self Study Manual
Over 1000+ pages of useful Excel VBA and FORTRAN. This manual contains our beginning and advanced Excel VBA manuals with how to control FORTRAN included.
View Manual Details

Interfacing Microsoft Excel VBA with FORTRAN Self Study Manual Information

Manual Overview
Overview: This Excel VBA/FORTRAN 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 and advanced Excel VBA topics covered in our other two manuals.
Manual Details
For: Engineers and Scientists
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning to advanced Excel VBA topics including FORTRAN
Manual: 1000 + pages with examples
Platform: Windows 7 - Windows 10
Sent: Sent within 3 hr after purchase Mon-Fri 8:30 AM - 5:00 PM PT
Excel Versions: Excel for Windows 2007-2016, Mac version coming soon

Price: $139.00

Microsoft Excel-Aided Engineering and Science
Self Study Manual

Microsoft Excel Aided Engineering and Science Self Study Manual
Over 2000 + pages of useful of useful Excel tips, formulas and strategies along with our complete Excel VBA write up. It is everything we know and use in Microsoft Excel. I is all of our manuals rolled into one.
View Manual Details

Advanced Microsoft Excel VBA Self Study Manual Information

Manual Overview
Overview: This all in one general Excel and Excel VBA self study manual (E.A.E) covers all the basics needed for solving engineering and science problems in Excel. The basics discussed include cell operation, worksheet formatting, formula design, cell naming, worksheet functions, sorting, filtering, pivot tables, Excel tables, array formulas, data importation, chart creation and linking Excel with other programs like Word and PowerPoint. Our EAE manual  also covers solving numerical techniques on the worksheet like linear systems, Runge Kutta, Newton's method, integration, differentiation and boundary value problems. EAE also discusses how to create sophisticated system models, perform design optimization using Solver and engineering team integration. Our manual also discusses how to turn create dashboards using ActiveX controls, charts, formulas and drawing shapes. Also included in our manual is our complete beginning and advanced Excel VBA manuals discussed previously in this section.
Manual Details
For: Engineers and Scientists
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning general Excel to advanced Excel VBA topics
Manual: 2000 + pages with examples
Platform: Windows 7 - Windows 10
Sent: Sent within 3 hr after purchase Mon-Fri 8:30 AM - 5:00 PM PT
Excel Versions: Excel for Windows 2007-2016, Mac version coming soon

Price: $169.00

LinkedIn
Facebook
Information
Need Help? Please call us at 1.866.924.6244

Copyright © 2002-2017

EMAGENIT All Rights Reserved