Intermediate Microsoft Excel Training for Business (1-day)

Our "data processing and formulas" Microsoft Excel business workshop that shows you how to build power formulas using VLOOKUP, IF, SUMIF...etc, build pivot tables, process text files, process and analyze worksheet data, link to Word and PowerPoint and more. Public and Webcast enrollment and schedule below>>>

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Newsletter	Contact Us	Self-Study	Training Help

Intermediate Excel Training Focus

Our "hands-on" intermediate Excel training focuses on useful formula design for data processing and modeling, using Excel's built-in range features like Data Validation, useful worksheet functions like VLookup and applying Excel's built-in data processing tools and worksheet functions to analyze and clean text files and worksheet tables. We teach you how to develop analysis and data processing problems on the worksheet then how to determine the proper Excel tools to create a unique solution. In all of our workshops, we evaluate our clienteles' knowledge level, their problems and adjust our curriculum to their specific needs. For a complete outline, click the Workshop Outline button below.

Workshop Details

• About EMAGENIT. Our Customers.

• Personal examples: Covered in-class

• Excel Versions: 2000-2007

• Type: Business Professionals

• Platform: Windows or Mac

• Training Materials: Included, 1600+ page manual including our Excel Add-Ins

• Training Method: Hands-on, interactive

• Repeat this workshop for free as many times as you want. View offer details

What You Learn at a Glance

• Filtering data using Auto Filter and  Advanced Filter

• Working with text files using Text Wizard and Text to Columns

• Cleaning and restoring text in files using the Left, Right, Mid, Substitute, Clean and Trim worksheet functions

• Using Data Validation and Conditional Formatting

• Perform table lookups using VLookup and HLookup, Match, Index and Indirect

• Build summary/pricing worksheets

• Build pricing sheets that can toggle between pricing tables

• Build array formulas using VLookup, HLookup, CountIf, Match and SumIf...etc

• Use logic in formulas (IF, And, Or)

• Name cells and ranges

• Create dynamic ranges in formulas that adjust to data

• Link Excel to Word and PowerPoint for reports

• Build basic pivot tables

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

Intermediate Microsoft Excel Training for Business Public Meeting Signup

Beginning Microsoft Excel VBA Training for Engineers & Scientists (2-days)

Our "workhorse" Microsoft Excel VBA workshop for engineering and science that shows you the basics of using VBA to command Excel, process and reconcile data, create charts, create functions, build powerful models, build dashboards and more.  Public and webcast enrollment and schedule below>>>

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Newsletter	Contact Us	Self-Study	Training Help

Beginning Excel VBA Training Focus

Visual Basic for Applications (VBA) can be used in conjunction with Microsoft Excel to construct automated engineering and science tools. VBA, a general purpose programming language, comes standard with Excel or Office. Using VBA with Excel, engineers and scientists can develop analysis tools quickly with minimum cost. VBA can be used for engineering and scientific tasks like analyzing data, automating chart construction, building report generation tools, communicating with databases, constructing dashboards, system models the list is endless. This workshop discusses the basics of using Excel VBA in the engineering and science disciplines. For a complete outline, click the Workshop Outline button below.

Workshop Details

• About EMAGENIT. Our Customers.

• Personal examples: Covered in-class

• Excel Versions: 2000-2007

• Type: Engineers and Scientists

• Platform: Windows

• Training Materials: Included, 1600+ page manual including our Excel Add-Ins

• Training Method: Hands-on, taught by an engineer / software developer

• Repeat this workshop for free as many times as you want. View offer details

• What is VBA?

• How engineers and scientists can use the Microsoft Excel Visual Basic Editor's debugging tools for their purposes

• How to use Visual Basic for Applications (VBA) for engineering and scientific purposes

• How to use the VBA language including variables, loops, logic, arrays, functions...etc

• How to control key Microsoft Excel program elements using VBA (Visual Basic)

• How engineers and scientists cans use VBA to analyze engineering and scientific data on the Microsoft Excel worksheet

• Basic dashboards design for engineers and scientists using Excel and VBA

• How engineers and scientists can construct their own worksheet functions (UDF's) using Excel Visual Basic (numerical analysis techniques discussion included)

• How engineers and scientists can automate chart construction using Excel VBA

• How to use the Macro Recorder to record engineering and scientific tasks in Microsoft Excel

Self-Study Manual Purchase

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

EMAGENIT staff will contact you within one business day of enrollment. If you have any questions, please call us at 1.805.498.7162. Also, military and government discounts available. Contact us directly for more details.

Advanced Microsoft Excel VBA Training for Engineers & Scientists (3-days)

Our "premier" Microsoft Excel VBA workshop for engineering and science that shows you how to create amazing software that can save your company ten's of thousands of dollars and countless wasted hours.  Public and webcast enrollment and schedule below>>>

Questions? Call us at:   1.805.498.7162     1.805.558.9277--

Newsletter	Contact Us	Self-Study	Training Help

Advanced Excel VBA Training Focus

The capability exists within Microsoft Excel VBA to construct sophisticated engineering and scientific tools that integrate seamlessly with the Microsoft Excel environment. Using advanced Microsoft Excel VBA programming techniques, sophisticated applications can be constructed in Microsoft Excel that command, organize and analyze engineering and scientific data, automatically chart engineering and scientific data, generate reports, talk to other applications integrating their data, perform engineering and scientific modeling, integrate FORTRAN routines... the list is endless. Many companies are turning to constructing engineering and scientific applications in Excel due to the lower cost, lower development time and because of Excel's exceptional abilities. This workshop discusses the advanced uses of Excel VBA in the engineering and science disciplines.

Workshop Details

• About EMAGENIT. Our Customers.

• Personal examples: Covered in-class

• Excel Versions: 2000-2007

• Type: Engineers and Scientists

• Platform: Windows

• Training Materials: Included, 1600+ page manual including our Excel Add-Ins

• Training Method: Hands-on, taught by an engineer / software developer

• Repeat this workshop for free as many times as you want. View offer details

• What is VBA?

• Advanced data analysis techniques for engineers and scientists using VBA and Excel

• Advanced Excel VBA programming techniques for automated chart construction in Microsoft Excel

• Advanced dashboards using Excel and VBA for engineers and scientists

• Advanced interface construction using ActiveX controls and userforms

• Advanced Microsoft Excel VBA programming techniques for creating event driven engineering and scientific applications in Microsoft Excel

• Advanced VBA error trap construction for engineers and scientists

• How to create Excel menu bars and toolbars

• Advanced Excel VBA programming tips for communicating with FORTRAN, VB ActiveX DLLs, PERL and C

• System modeling discussion including how to use Solver with VBA

• Advanced VBA programming strategies for communicating with engineering and science oriented databases

Self-Study Manual Purchase

Our Microsoft Excel manuals support business, engineering and science professionals depending on the version ordered. We design our Excel self study and Excel Visual Basic self study manuals around real world problems facing business professionals, engineers and scientists.