Microsoft® Excel is the most widely-used spreadsheet application worldwide. Learn to create spreadsheets and workbooks to store, manipulate, and share your data. Design and create accurate professional worksheets for use in business, industry, and academic environments. Learn time saving features and tips. Gain the skills necessary to create, edit, format and print worksheets, create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. You’ll learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. Each session focuses on time-saving techniques and advanced “how-to’s.” With this practical and usable training, you’ll learn how to integrate your work within the Microsoft Office Suite for even greater results. If you’ve ever felt frustrated using Excel because you knew there had to be a better way of accomplishing your tasks, you’ll soon be on your way to getting more done – and done more efficiently – with this power-boosting workshop. If you intend to take the Microsoft Office Specialist exam for Excel, you will need to take Levels 1-3 to be fully prepared for the exam.
This course assumes that you are familiar with using personal computers and have used a mouse and keyboard (basic typing skills are recommended). You should be comfortable in the Windows environment and be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. If you intend to take the Microsoft Office Specialist exam for Excel, you will need to take Levels 1-3 to be fully prepared for the exam.
This course is designed for persons preparing for certification as a Microsoft® Office Specialist in Excel, professionals looking to enhance their resume and government and government contracted personnel requiring knowledge and certification Microsoft® Excel. If you intend to take the Microsoft Office Specialist exam for Excel, you will need to take Levels 1-3 to be fully prepared for the exam.
Level 1 (1 Day)
- Fundamentals
- Creating Worksheets
- Formatting
- Manipulating Data
- Charts
- Output
- Settings and Templates
Level 2 (1 Day)
- Managing Workbooks
- Named Ranges
- Tables
- Summarizing Data
- PivotTables
- Presentation Features
- Advanced Charts
- Collaboration
Level 3 (1 Day)
- Logical and Lookup Functions
- Advanced Formulas
- Special Functions
- Importing and Exporting
- Analysis
- Macros & Form
Level 4 Charts & PivotTables (1 Day)
- Tables
- Summarizing Dat
- PivotTables
- Advanced Charts
- Official Microsoft® Training Materials
- State-of-the-art Training and Lab Equipment
- In-class Internet Access
- Personal Computer Station for Each Student
