Intermediate Excel Training
Course Description
The Intermediate Excel Training Course is the second of three parts of MS Excel offered by Advanced Learning Programs. In this course, we concentrate on making sure participants know how we can combine multiple worksheets, using 3D formulas, charts, and other helpful topics that will definitely appreciate Excel.
More often than not, we invest a great deal of effort into sorting out all our workbook data and calculations. The course will help in ensuring your workbook has an impact on the audience. Some of Excel’s most powerful but least obvious features can help you turn an unremarkable set of figures into a graphical presentation. These reports will be beneficial to your stakeholders and leadership to make informed decisions.
The Intermediate Excel Training Course helps participants understand the functions and features available and elevates the participants’ skills.
Course Objectives
At the end of this course, participants are expected to learn the following:
- Moving from one workbook to another
- Calculating multiple sheets using 3-D Formulas
- Monitoring formulas using Watch Window
- Using Workspace
- Formatting Texts using Functions
- Transposing Data
- Add backgrounds & watermarks
- Naming Cells and Worksheets
- Sorting and Filtering
- Using Tables
- Using structured references on Tables
- Using COUNT, SUM, AVERAGE in filtered tables
- Using Hyperlinks
- Sending Worksheets via Email
- Combination Charts
- Using and Inserting Sparklines
- Using Audit Features
- Protecting a worksheet
- Using Ribbons
- Using Templates
- Create PivotCharts