Advanced Microsoft Excel Training for Business Professionals Workshop Outline

Our "advanced solutions" Microsoft Excel workshop that focuses on creating sophisticated Excel analysis and data processing  tools using advanced formulas, ActiveX controls, dashboards, database queries, pivot tables, charts and integrating Excel with Word / PowerPoint. It also provides an introduction to macros (VBA). We teach you how to develop these advanced solutions on the worksheet then how to assemble the proper Excel tools in ways you have never thought of before. Read below and see how our 14 years of Excel training and consulting can help supercharge your Excel skills >>>

Call us at:   1.805.498.7162     1.805.558.9277--

• Onsite, Self-Study, Public, Webinar

Our "hands-on" advanced Excel training that focuses on creating sophisticated Excel  analysis and data processing  tools using advanced formulas, ActiveX controls, dashboards, database queries, pivot tables, charts and integrating Excel with MS Word and MS PowerPoint. We teach you how to develop these advanced solutions on the worksheet then how to assemble the proper Excel tools in ways you have never thought of before. It also provides an introduction to macros (VBA). In the workshop, we teach our clients how to develop a complete Excel strategy for a complex problem. In all of our workshops, we evaluate our clienteles' knowledge level, their problems and adjust our curriculum to their specific needs.

• Advanced Microsoft Excel communication strategies with databases using Microsoft Query

• Worksheet techniques for constructing business forms using ActiveX controls and form controls

• Dashboard and Advanced Formula construction

• Advanced Microsoft Excel skills for linking separate workbooks and worksheets

• Advanced Excel skills for linking with other applications (OLE)

• Advanced Microsoft Excel skills for importing text files

• Advanced Excel skills for sharing workbooks

• Advanced Microsoft Excel skills for constructing time formulas on the worksheet

• Advanced Excel pivot table construction

• Advanced Microsoft Excel use of the Macro Recorder and VBA Editor

• Advanced use of Goal Seek and Solver

* If you are looking for general formula design, try our Intermediate Microsoft Excel workshop

• 1-day workshop

• Personal examples: Covered in-class

• Excel Versions: 2000-2010

• Type: Business Professionals

• Platform: Windows or Mac

• Training Materials: Included, 1800+ page manual

• Training Method: Hands-on

In this 1-day "hands-on" workshop you will learn:

• Formula and cell name review

• Time Formulas: Working with time formulas on the Microsoft Excel worksheet

• Workbook Templates / Worksheet Templates: How to create and use Microsoft Excel workbook and worksheet templates

• Business Forms: How to use ActiveX controls and form controls to create advanced business forms on the Microsoft Excel worksheet

• Advanced Dashboards and Advanced Formulas: How to create dashboards using charts, array formulas (SumProduct, SumIF, Index, Indirect, CountIF, Row, Column, CountA, Offset, Address...etc) and dynamic ranges

• Linking Workbooks: Link workbooks and worksheets together including team and network issues

• Sharing Workbooks: How to share Microsoft Excel workbooks over a network

• OLE Automation: How to link Microsoft Excel with other applications

• Importing Text Files: Importing text files into Microsoft Excel using various file formats

• Pivot Tables: How to create and build advanced pivot tables

• Microsoft Query: How to access databases from Microsoft Excel using Microsoft Query and ODBC

• Microsoft Access: How to update Microsoft Access tables directly from Microsoft Excel

• Microsoft Excel Security: Microsoft Excel workbook and worksheet security issues

• Macro Recorder: Introduction to Microsoft Excel VBA code using the Macro recorder

Click here for Schedule, Pricing, Enrollment

• Intermediate Excel users with a basic knowledge of Excel.

• It is intended for all types of business professionals.

Public Location: Thousand Oaks,CA, Directions/Thousand Oaks Info

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, CA which is in the vicinity of Los Angeles county (LA County), Ventura county, Santa Barbara county and San Diego county. We hold all of our courses on-site nation wide. We also webcast (webinar) our public workshops, consult our webcast page for more information.

Our public workshops are a short commute for those living in:

For more information about our public workshops, visit our public workshops page our call us at 805.498.7162.

Submit a question to us via email at advexcel@emagenit.com

Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at 1.805.498.7162 or 805.558.9277 for more information about this workshop.