Excel Intermediate Class teaches PivotTables, Advanced Functions, and Charts
An Excel Intermediate Class takes your skills to the next level by utilizing some of the advanced tools Excel has to offer. In Microsoft Excel for Beginners, you became more comfortable with Excel and how it can help you be more productive.
Throughout this excel training course, you will learn how to write advanced functions to manipulate and calculate data in creative and time-saving ways. We focus on the most commonly used functions for productivity including text, date, statistical and conditional functions.
In addition, you will learn about Excel PivotTables and how they can provide flexibility when analyzing large amounts of data. Other topics in this class include working with graphic objects, printing options, and using charts. This class will open your eyes to the real potential of Excel and how it can save you amazing amounts of time and frustration!
Class Objectives
Upon successful completion of Microsoft Excel Intermediate, 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
Class Includes:
- 7 hours of training
- Professional Textbook
- Download materials with practice data files
- Free access to CoWorking space on class days (FC Only)
- One month of technical support
- One year for a free re-take (for attended students of public classes only)
- Certificate of Completion
General Info:
- Target student: Beginner to Intermediate
- Coursework may be assigned outside of class
- Computer & software provided in class
- Class size limited
Pre-requisites:
Microsoft Excel for beginners class (Level 1) or equivalent knowledge
