Why Select Our Microsoft Excel Training?

• We have been providing Excel training in the Thousand Oaks, Simi Valley, Oxnard and Ventura, CA areas for over 14 years

• Our Microsoft Excel training is designed around the real world issues facing professionals in the work place

• We develop software in Microsoft Excel for the government and private industry. All of our instructors both develop software and train so you get practical experience and solutions that are tested and actually work

• We have taught our classes over 1000 times for companies like Pfizer, Anthem, General Dynamics and NASA so we know what problems you are facing

• Our workshops are never taught from a standard "canned" outline. We tailor the training experience to those who are in attendance. No two workshops are the same.

• We answer personal Excel questions in class

 

 

Microsoft Excel Training - Business

Beginning Microsoft Excel for Business Professionals

Learn vital Microsoft Excel skills and strategies that you can immediately apply to your everyday Excel problems.

Our 1-day "hands-on" beginning Microsoft Excel workshop trains you on the basics of Microsoft Excel and also presents the thinking and mechanics of how to apply it to your everyday problems. Topics like program interface usage, workbook and worksheet control, data entry, copying and pasting, cell formatting, basic formula construction, printing and basic worksheet functions like SUM are covered. Complete Outline and Signup

 

 

Intermediate Microsoft Excel for Business Professionals

Learn real world Microsoft Excel skills that will save you time and effort in your Excel business tasks.

Our 1-day  "hands-on" intermediate Microsoft Excel workshop trains you on how to process worksheet data as well as build traditional analysis problems on the worksheet. It covers how to construct useful formulas and how to use worksheet functions like VLOOKUP, SUMIFS, IF, MATCH and INDEX to process and analyze worksheet data. Cell naming, nesting worksheet functions in formulas and using text functions like LEFT, RIGHT and SUBSTITUTE are also covered as well. In addition, our workshop also covers how to design pivot tables, build business charts and analyze worksheet table data using autofilter, advanced filter and the text to columns features. The workshop also discusses how to build basic dashboards from Excel's built-in features like data validation, conditional formatting and charts. Also included in the discussion is how to construct proper data tables on the worksheet, build formulas that adapt to changing data size and header positions, and how to link Excel with Word and PowerPoint. Complete Outline and Signup

 

 

Advanced Microsoft Excel for Business Professionals

Learn how to create the advanced Microsoft Excel tools that you need to succeed in your business.

Our 1-day "hands-on" advanced Microsoft Excel workshop trains you on how to create sophisticated Excel solutions and dashboards using advanced formulas, array formulas, shapes, conditional formatting, data validation, charts, pivot tables and database queries. It demonstrates the strategy behind developing these adaptive worksheet solutions that think for themselves using different Excel elements in ways you have never thought possible. Our advanced Excel class also provides an introduction to Excel macros better know as VBA. Complete Outline and Signup

 

 

 

 

Microsoft Excel Training - Engineering and Science

Microsoft Excel Training for Engineers and Scientists

Our 1-day "hands-on" Microsoft Excel workshop for engineering and science trains you on useful formula design in the areas of technical data processing, analysis and modeling. It discusses general formula and worksheet function design along with advanced array formula design and how they pertain to sophisticated technical tool development. Included in the formula discussion is how to use important worksheet functions like VLOOKUP, MATCH, INDEX, IF, AND, OR, INDIRECT...that allow "smart" worksheets that think to be developed. Our workshop also stresses analyzing worksheet text including cleaning text and parsing it using Excel's built-in data tools and functions like SUBSTITUTE, LEFT and MID. In addition, our workshop also discusses modeling fundamentals in Excel including naming worksheet cells, organizing model information and creating your own custom worksheet functions in VBA for real modeling punch. How to construct dashboards using ActiveX controls, data validation, conditional formatting and charts is also covered. Rounding out the discussion is how to build reports in Excel using pivot tables and linking Excel with Word and PowerPoint. Complete Outline and Signup

 

 

 

Public Training Location

Public Classes Location: Thousand Oaks, CA

Directions: Hotel and Activities

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, CA which is in the vicinity of Simi Valley, Oxnard and Ventura areas. We hold all of our workshops onsite nation wide. We also webcast (webinar) our public workshops, consult our webcast page for more information.

Our public workshops are also a short commute for those living in the following areas: