Non-Certification Course

Microsoft Excel Intermediate

This intermediate level Microsoft Excel course is perfect for those who want to advance their Excel skills. Learn how to use formulas, advanced functions, formatting, sorting, filtering, graphics, and workbook protection. The course offers personalized instruction based on your version of Excel, ensuring you receive the most up-to-date knowledge. Suitable for both students and professionals, the course provides practical exercises and real-world examples that you can apply to your everyday work.

RM 1,299.00

per person

Level

Intermediate

Duration

1 Day

Training Delivery Format

Face-to-face / Virtual Class

RM 1,299.00

per person

Level

Intermediate

Duration

1 Day

Training Delivery Format

Face-to-face (F2F) / Virtual Class

Class types

Public Class

Private Class

In-House Training

Bespoke

If you’re ready to take your Microsoft Excel skills to the next level, our intermediate level course is the perfect fit for you. With this course, you’ll learn how to use formulas and advanced functions to create complex workbooks, format tables, sort and filter data, add and format graphics, and protect and finalize a workbook. Our experienced instructors provide personalized instruction that is tailored to your version of Excel. This ensures that you’ll receive the most relevant and up-to-date knowledge and skills.

The intermediate course is suitable for anyone looking to enhance their Excel proficiency, including business professionals and students. You’ll receive hands-on training through practical exercises and real-world examples, which will enable you to apply your new knowledge and skills to your everyday work. Don’t miss out on this opportunity to become an Excel master. Enroll now and take your Excel skills to new heights.

This Excel course is suitable for students who possess foundational knowledge and skills in the software and want to leverage advanced features to analyze and present data effectively.

Upon completing this course successfully,

  • you’ll be able to harness the power of data calculations and presentation to make informed decisions that benefit your organization.
  • You’ll learn to work with functions and lists, create advanced formulas, protect spreadsheets, and customize views.

Prior to enrolling in this course, students should have completed an introductory Excel course or possess an equivalent level of proficiency in the software. This may include our Microsoft Excel Essentials course or similar coursework.

Module 1: Creating Advanced Formulas

  • Apply Range Names
  • Use Specialized Functions

Module 2: Analyzing Data with Logical and Lookup Functions

  • Use Text Functions
  • Use Logical Functions
  • Use Lookup Functions
  • Use Data Functions
  • Use Financial Functions

Module 3: Organizing Worksheet Data with Tables

  • Create and Modify Tables
  • Sort and Filter Data
  • Subtotal and Database Functions in Calculate Data

Module 4: Visualization Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts

Module 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Topic A: Create a PivotTable
  • Topic B: Filter Data Using Slicers
  • Topic C: Analyze Data with PivotCharts

Module 6: Working with Graphical Objects

  • Topic A: Insert and Modify Graphic Objects
  • Topic B: Layer and Group Graphic Objects
  • Topic C: Incorporate SmartArt

Module 7: Enhancing Workbooks

  • Topic A: Customize Workbooks
  • Topic B: Manage Themes
  • Topic C: Protect Files
  • Topic D: Preparing a Workbook for Multiple Audiences

Classroom Live Labs:

  • Range Names
  • Specialized Functions
  • Lookup Functions
  • Working with Tables
  • Create and Customize Tables
  • Virtualizing Data with Charts
  • How to Create and Modify Charts
  • Working with Trendlines
HRD Corp Claimable Course

At this time, this course is available for private class and in-house training only. Please contact us for any inquiries. 

Contact form

Get the Project Charter Guide now!

Just enter your email address to access the FREE Project Charter guide and template.