We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?


Online Training by  OTC Training Centre Sdn Bhd
Inquire Now
Online / Training


In this course, you will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. You will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, you will also understand PivotTables, PivotCharts and slicers.
  • Learn the building blocks of Intermediate Excel functionality.
  • Link Workbooks and Worksheets.
  • Work with Range Names and Sort and Filter Range Data.
  • Analyze and Organize with Tables.
  • Use Conditional Formatting and Display Data Graphically.
  • Outline with Subtotals and Groups.
  • Understand PivotTables, PivotCharts, and Slicers



  • Linking Workbooks and Worksheets
    • Linking Workbooks and Worksheets
    • Linking Worksheets with 3D References
    • Understanding the Consolidate Feature


  • Working with Range Names
    • Using the Name Box and Define Name
    • Using Create from Selection


  • Sorting and Filtering Range Data
    • Differences Between Sorting and Filtering
    • Sorting Lists
    • Filtering Lists
    • Creating Subtotals


  • Analyzing and Organizing with Tables
    • Creating Tables and Understand the Benefits
    • Understanding the Elements of a Table
    • Formatting a Table
    • Sorting and Filtering Tables
    • Filtering with Slicers
    • Calculating with Tables


  • Using Conditional Formatting
    • Highlight Cells and Top Bottom Rules
    • Data Bars, Icon Sets, and Color Scales
    • Using Custom Fonts and Colors
    • Using Custom Conditional Formatting
    • Modifying or Removing Conditional Formatting


  • Displaying Data Graphically
    • Creating Charts
    • Understanding Chart Elements
    • Formatting Charts
    • Creating Dual Axis Charts
    • Creating a Chart Template
    • Displaying Trends with Slicers


  • Understanding PivotTables, PivotCharts and Slicers
    •  Creating a PivotTable
    • Working with PivotTable Fields Pane
    • Formatting PivotTable
    • Creating a PivotChart
    • Formatting PivotChart
    • Using Slicers and Timeline Slicers

Special Offer

Register 3 Participants From Your Organization And Get The 4th Participant For Free!

The promotion expiry date for each programmes differs. For more information on the exact expiry date of the promotion, feel free to contact us.

OTC Training Centre Sdn Bhd may at any time in its sole and absolute discretion withdraw, amend and/or alter the terms and conditions of the stated promotions without prior notice.


May 20, 2024 - May 21, 2024
Mon, Tue 09:00 AM — 05:00 PM
Online Live
Platform: Zoom
No. of Days: 2
Total Hours: 14
Be the first to write a review about this course.
Write a Review

OTC Training Centre Sdn Bhd is an innovation leader in the development and delivery of practical outsourcing training programs for the past 17 years. Since then, OTC has supported thousands of companies to upskills their employees with personalized content and learning solutions. Today, we have evolved to provide a full suite of outsourcing services in the learning and development field.

Our training programs are entitled to HRDCorp claim, with our trainers being certified by HRDCorp as well. As a training provider, we aspire to keep providing the best training to our respected clients to ensure their satisfaction while using our service as the training provider.

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.