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

Download the course PDF now!

Download Course PDF

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.