Experienced Beginning to Intermediate Level Excel Users, General Managers, Database Managers, Report Designers, and Presentation Speakers.
User Knowledge of Microsoft Windows XP.
As an experienced user of Microsoft Excel, you now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with advanced features such as pivot tables, formula functions, and charts.
You will also learn how create Pivot Tables from layout and formatting of source Table Data, to inventorying Data and using proven design strategies, understand advanced Pivot Table features in detail and depth, understand and customize Excel charts in depth, as well as gain knowledge of and exposure to powerful and sophisticated real-world business examples of advanced formulas.
Navigate and effectively enter and organize worksheet and table data using various tips & techniques.
Analyze data using Pivot Tables and Pivot Charts.
Create complex calculations using advanced formulas and functions.
Create and modify line, pie, bar, and column charts to suit conventional business situations and scenarios.
Customize the Microsoft Office Excel environment.
Great course, great instructor; very impressed.
I am more than satisfied. I have put much of my training into practice and it has made me more efficient in my work."
"Just wanted to take this opportunity to say THANK YOU and let you know that I really enjoyed to course…and secretly I do get very excited when I learn new shortcuts and tricks in Excel - I have attended other Excel courses in the past and I must say you have truly have found your calling"
"Excellent, really enjoyed the course. Integrated with class and explained the material very well. [The instructor was] very personable."
"Very good at explaining the material and using practical examples. Great at answering questions from the class."
"The presentation style and information were excellent."