Microsoft Excel Intermediate (Level 2)
Improve productivity in Excel with advanced functions, PivotTables, charts & more
Description
Microsoft Excel Intermediate class (Level 2) will introduce you to time-saving you features like PivotTables, advanced functions, and charts. Learn to manipulate and calculate data in new ways that can save you incredible amounts of time and frustration. Add high demand job skills to your resume or be more productive in your daily workflow in Excel. Learn more about our most popular Excel class today.
Throughout this Excel training course, you will learn how to write advanced functions including text, date, statistical and conditional functions. You will be confident creating Excel PivotTables & PivotCharts so you can analyze your data like never before. And add visual elements like charts to impress your audience as well.
As you work through the sessions of Microsoft Excel Intermediate, each class will be a hands-on and intensive workshop, designed to help make difficult topics easier to understand. Your instructor, a Microsoft expert, will work with you closely to make sure that you avoid common mistakes in Excel and apply best practices when possible.
Includes
- 7 hours of classroom training | Additional assignments outside of class
- Professional Textbook
- Download materials with practice data files
- One month of technical support
- One year for a free re-take (for attended students of public classes only)
- Certificate of Completion
Prerequisites
- Basic digital literacy including file management is required.
- Microsoft Excel Beginners (Level 1) or equivalent knowledge is required.
- It is required you install the latest Microsoft Office software before starting class.
Talk to a student advisor to ensure you have the right pre-requisites for each class or program.
Objectives
Upon successful completion of Microsoft Excel Intermediate class, students will be able to:
- Understand how to write and use advanced formulas with functions including text, date, logical, conditional, and lookup functions
- Organize worksheet and table data using various techniques
- Create and modify charts
- Analyze data using PivotTables, Slicers, and PivotCharts
- Insert and modify graphic objects in a worksheet
- Customize and enhance workbooks and the Microsoft Office Excel environment
FAQ
Still have questions? Visit our FAQ page for more help.