Intermediate Excel Training Course

Intermediate Excel Training Course

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

Course Modules

Lesson 1 – Worksheets and Workbooks

• Moving from one workbook to another
• Calculating multiple sheets using 3-D Formulas

Lesson 2 – Advanced formatting

• Number formats
• Using functions to format text
• Styles and themes
• Advanced formatting

Lesson 3 – Outlining and subtotals

• Outlining and consolidating data
• Using subtotals

Lesson 4 – Cell and range names

• Creating Cell names
• Creating Range names

Lesson 5 – Tables

• Table Sorting and Filtering
• Exploring with tables

Lesson 6 – Hyperlinks and Web features

• Inserting Hyperlinks
• Using Web features

Lesson 7 – Advanced charting

• Chart options
• Combining Charts

Lesson 8 – Protecting Workbooks and auditing

• Auditing features
• Adding comments
• Protecting Workbooks

Lesson 9 – Templates and settings

• Changing settings
• Using templates
• Creating and managing templates

Lesson 10 – Pivot Tables and Pivot Charts

• Using Pivot Tables
• Using Pivot Charts