Microsoft® Office Excel®

2019: Part 1

Get started on your path to becoming
a Microsoft Excel expert

Get in Touch With Us
Advanced Excel


Learn to create Excel
dashboards in minutes

Take your skills to the next level with Microsoft Excel Advanced

Power Query is the recommended experience for discovering, connecting to, and importing data. Power Pivot is a powerful data analysis and data modeling tool. Use Power Query and Power Pivot to mold your data in Excel so you can explore and visualize it with PivotTables, PivotCharts and Power Map.
Course Modules Covered in the Microsoft Excel Advanced program
Module 1 - Getting Started with Excel 2019

Getting Started with Excel 2019

  1. Navigate the Excel User Interface
  2. Use Excel Commands
  3. Create and Save a Basic Workbook
  4. Enter Cell Data
  5. Use Excel Help
Module 2 - Performing Calculations

Performing Calculations

  1. Create Worksheet Formulas
  2. Insert Functions
  3. Reuse Formulas and Functions
Module 3 - Modifying a Worksheet

Modifying a Worksheet

  1. Insert, Delete, and Adjust Cells, Columns, and Rows
  2. Search for and Replace Data
  3. Use Proofing and Research Tools
Module 4 - Formatting a Worksheet

Formatting a Worksheet

  1. Apply Text Formats
  2. Apply Number Formats
  3. Align Cell Contents
  4. Apply Styles and Themes
  5. Apply Basic Conditional Formatting
  6. Create and Use Templates
Module 5 - Create and Use Templates

Printing Workbooks

  1. Preview and Print a Workbook
  2. Set Up the Page Layout
  3. Configure Headers and Footers
Module 6 - Managing Workbooks

Managing Workbooks

  1. Manage Worksheets
  2. Manage Workbook and Worksheet Views
  3. Manage Workbook Properties
Our Training Methodology
Program Key Highlights

48 hours of Remote Online Learning
Additional Coaching Hours
Live Hands-on Projects
Certified by International Body
Mentorship with Industry Experts
Designed for Beginners & Professionals

Get Professionally Certified

Upon successfully completing this program, participants will be awarded the Professional Certification in Python Data Science by International Council for Technology Certifications (ICTC).
This award is a validation to the efforts taken to master the domain expertise that will set you apart from your competition.
Be a part of the global network of data science professionals and join the community across sectors.
Get in Touch With Us Today!

This training program is suitable for anyone who intends to enter into the field of Data Science. This program is being conducted in Malaysia and can be joined by anyone, anywhere in the world remotely.
Program Fee

MYR 6800 per pax.
Funding price MYR 3700 per pax .

Funding Schemes for Companies who are claiming from their HRDF levy or from the MDEC MyWiT scheme.

Limited scholarships available for early self applying individual applicants.

Find out how you can qualify for a scholarship.

Enquire NOW on the various funding options available.

One-time fee. One year access to course materials and resources.

Please fill in the form and a Program Advisor will reach out to you. You can also reach out to us at or +60123661502
Contact us on Whatsapp for more enquiries