Microsoft Excel: Beginner to Intermediate

16-17 May, 2024, Wyndham Grand Bangsar Kuala Lumpur

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

Morgan holds a Degree in IT & Tech Management from UTM, he has 20 years working experience as a trainer in the field of Information Technology. He has obtained ITIL Certification and also PSMB approved trainer (TTT). He has conducted various trainings. His key expertise are:

 

·          - Conducting IT Training in the area of Basic Networking, PC Repairing, PC Troubleshooting & Microsoft Office Training

·          - Conducting research on the latest development and requirement for training based on customer request       Developing & Maintaining a sound marketing strategy

- Ensure KPI and Customer Satisfaction are meet

 

As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia.

 

As a qualified professional educator, he has personally designed and delivered many specialized training courses including the validation and management of over 10 other trainers, operating nationwide in Malaysia. He's also a well sought after consultant and works on several key IT projects each year, with leading brands in the region.

Venue Details

Wyndham Grand Bangsar Kuala Lumpur
Jalan Pantai Baharu, Jaya Tower 3,
Phone : 03-2298 1888

Contact us

Juliany,
03 2283 6109
juliany@ipa.com.my

Phoebe,
03 2283 6100
phoebe@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Jane,
03 2283 6101
Jane@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON
  • Module 1: Introductions to the Excel Components
  • Module 2: Spreadsheet
  • Module 3: Data
  • Module 4: Diagrams
  • Module 5: Calculation
  • Module 6: Calculating With Formulas
  • Module 7: Conditional Formatting
  • Module 8: Sparklines
  • Module 9: Charts
  • Module 10: Date Functions
  • Module 11: VLOOKUP
OBJECTIVE

This course is designed to allow the participants to understand the base of Excel, how it functions, and the essential knowledge needed before going into usage of functions & formulas. The course also shows how to utilize the functions, formulas and how to manage data with Excel.

The objective of this course is to provide participants with Microsoft Excel tools and in-depth formulas and functions that are available in Excel to reduce redundant tasks, increase productivity, and create powerful reports and summaries.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Working On Sample Spreadsheets Doing Basic Math, Adding And Deleting Columns And Rows, And Preparing The Worksheet For Printing.
  2. Learning The Importance Of Using Table In Data Management.
  3. Presenting Your Data Visually Showing Trends, Patterns And Comparisons Between The Data In A Chart, Table Or Other Templates.
  4. Learning How Excel Will Automatically Do All The Calculations For You Once You Add In The Formula.
  5. Applying Proper Formula And Function.
  6. Troubleshooting Errors.
WHO SHOULD ATTEND
  • This course is suitable for all corporate users in involved in Sales, HR, Admin, Operations, Finance, Project Management, Engineers, Supervisors, Business Executives who need to do reports with Microsoft Excel.
  • All Professionals who want to expand their knowledge and skills in Microsoft Excel.
METHODOLOGY
  • Guided Learning, group-paced, hands-on classroom training with real life examples for business applications.
  • Challenging exercises are set based on practical applications for typical organizational functions such as HR, Admin, Production, Sales etc.
DAY 1
9:00

MODULE 1: INTRODUCTIONS TO THE EXCEL COMPONENTS

  • What functions are available in excel.
  • Brief on shortcuts and buttons.
10.45

MODULE 2: SPREADSHEET

  • How to create spreadsheets.
  • Rename the spreadsheet.
  • How to save worksheet.
  • Open the saved worksheet.
12.00

MODULE 3: DATA

  • Insert raw data to the cells.
  • Choosing proper format for the data.
  • Create tables.
  • Setup title for the data.
1:00 Lunch
2:00

MODULE 4: DIAGRAMS

  • How to create diagram based on data entered.
  • Choosing proper diagram.
  • Edit settings of the diagram.
  • How to present diagram.
3:45

MODULE 5: CALCULATION

  • Introduction to functions available in excel.
  • Basic functions: plus, minus, subtraction, division
  • Formula: how to create formulas
5:00 End of Day 1
DAY 2
9:00

MODULE 6: CALCULATING WITH FORMULAS

  • How formulas work
  • Using “$” in formulas
  • SUM function
  • MAX and MIN function
  • AVERAGE and AVERAGEA function
  • COUNT and COUNTA function
  • COUNTIF & SUMIF function
  • COUNTIFS & SUMIFS function
10.45

MODULE 7: CONDITIONAL FORMATTING

  • How to use conditional formatting
  • Using conditional formatting presets
  • Managing and prioritizing rules
  • Using top bottom rules
  • Customizing data bars
  • Using formulas in conditional formatting
12.00

MODULE 8: SPARKLINES

  • Inserting sparklines
  • Formatting sparklines
1:00 Lunch
2:00

MODULE 9: CHARTS

  • Creating a chart
  • Using Excel’s recommended charts
  • Formatting charts
  • Changing chart data
  • Filtering chart data
  • Creating a dual axis line chart
  • Saving a chart template
3:45

MODULE 10: DATE FUNCTIONS

  • TODAY
  • DATEDIFF
  • WORKDAY / WORKDAY.INTL
  • NETWORKDAYS / NETWORKDAYS.INTL
 

MODULE 11: VLOOKUP

  • VLookup Techniques
  • VLookup with Tables
5:00 End of Course