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

Business, Engineering and Science

Microsoft Excel Self Study Books and Microsoft Excel VBA Self Study Books

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

EMAGENIT Microsoft Excel self study books and Microsoft Excel VBA self study books 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 Books 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.
Godaddy SSL Godaddy
VERIFIED &SECURED

Why Choose Our Microsoft Excel Books?

Our new Microsoft Excel Self Study Books 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.

EMAGENIT Excel Manuals?

Our complete Excel books 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 books are derived from these books.

Our self-study books 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 books 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 books. We go in depth in these books showing you exactly how to do things step by step.

Business Professionals - Self Study Books

Microsoft Excel Business Essentials
Self Study Book

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

Microsoft Excel Business Essentials Self Study Book Information
Book Overview
Overview: This Microsoft Excel self study book covers all the fundamental Microsoft Excel skills you will use in an office environment. Our book 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.
Book 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 book
Book: 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 Book

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

Beginning Microsoft Excel VBA Self Study Book Information
Book Overview
Overview: This Microsoft Excel VBA self study book covers the basics of VBA. It covers fundamentals such as loops, variables and logic and controlling Microsoft Excel. Our book 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.
Book Details
For: Business Professionals
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning to intermediate Excel VBA topics
Book: 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 Book

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

Advanced Microsoft Excel VBA Self Study Book Information
Book Overview
Overview: This Microsoft Excel VBA self study book 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.
Book Details
For: Business Professionals
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning to advanced Excel VBA topics
Book: 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 Book

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 books in one.
View Book Details

Advanced Microsoft Excel VBA Self Study Book Information
Book Overview
Overview: This all in one Excel and Excel VBA self study book covers all the topics found in our Excel Business Essentials book. 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 book is our complete Beginning Excel VBA and Advanced Excel VBA books.
Book Details
For: Business Professionals
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning general Excel to advanced Excel VBA topics
Book: 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 Books

Beginning Microsoft Excel VBA
Eng/Sci Self Study Book

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

Beginning Microsoft Excel VBA Self Study Book Information
Book Overview
Overview: This Microsoft Excel VBA self study book 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.
Book Details
For: Engineers and Scientists
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning to intermediate Excel VBA topics
Book: 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 Book

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

Advanced Microsoft Excel VBA Self Study Book Information
Book Overview
Overview: This Microsoft Excel VBA self study book 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.
Book Details
For: Engineers and Scientists
Format: ADOBE PDF and Excel Files as zip file download
Details: Covers beginning to advanced Excel VBA topics
Book: 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 Book

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

Interfacing Microsoft Excel VBA with FORTRAN Self Study Book Information
Book Overview
Overview: This Excel VBA/FORTRAN self study book 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 books.
Book 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
Book: 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 Book

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 books rolled into one.
View Book Details

Advanced Microsoft Excel VBA Self Study Book Information
Book Overview
Overview: This all in one general Excel and Excel VBA self study book (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 book  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 book also discusses how to turn create dashboards using ActiveX controls, charts, formulas and drawing shapes. Also included in our book is our complete beginning and advanced Excel VBA books discussed previously in this section.
Book 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
Book: 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

Excel Training Services

- Excel Training Schedule

- Excel Public Training

- Excel Online Training

- Excel Onsite Training

- Excel Class Comparison/Skills

- Excel Tip of the Week

- Key Excel Concepts

- Key Excel Functions

Excel Software Design/Consulting

- Microsoft Excel Software Design

- Microsoft Excel Consulting

Microsoft Excel Products

- Excel Self-Study Manuals

EMAGENIT Company Information

- Our Customers

- Contact EMAGENIT

- About EMAGENIT (Imagine-It)

- Site Map

Copyright © 2002-2018

EMAGENIT All Rights Reserved