Microsoft Excel – Intermediate

"Data Alchemist in the Making: Unleash the Magic of Excel Intermediate!"

Join Online training on

Date: 12 / 08 / 2023

Day: Saturday

Duration

1 Days

Time

8am-6pm

rest on 1pm-2pm

Fee

RM 159

• PRE-REQUISITES

Basic Excel Familiarity & understanding how to use cell references and perform basic calculations is crucial.

• VENUE / PLATFORM

• APPLY NOW

About this programme

Use Excel more effectively for workplace data and reporting. Explore additional features that improve productivity, support accurate calculations and help you communicate the important messages in your information.

Learning goals

At the end of the course, you will be able to

• Use Paste Options and Paste Special Commands
• Create and Manage Conditional Formatting
• Use Functions such as IF, AND and OR, Nested IF and Vlookup Functions
• Use of Database Functions such as DSUM()
• Learn the Protection of Workbook, Worksheet & Element

• Create a Custom AutoFill List and Custom Number Format
• Sort by Multiple Columns, Custom List and use of Advanced Filter
• Work with Tables and Total Row, remove Duplicate Rows of Data
• Introduction to basic use of PivotTable
• Creating and Working with Charts

Course Outline & Module

• Working with List

• List functions

• Data validation

• Importing and exporting

• PivotTables and PivotCharts

• 3D Formulas & Consolidating Data

Who Should Attend Microsoft Excel Intermediate?

Suitable for people who work extensively with data and want more efficient ways to organise, manipulate and analyse it in Excel.

Students

Office Workers

Entrepreneurs and Small Business Owners

Administrative Staff

Training Packages

Certificate of Completion Provided

Participants will receive a Certificate of Completion on the last day of training.

Personalised Mentorship

Get a knowledgeable mentor who guides your learning and is focused on answering your questions, motivating you and keeping you on track.

Follow Up Training

Participants are entitled to one free follow-up training session, scheduled later to reinforce their learning.