Microsoft Excel Making Microsoft Excel work hard for your business

19-20 Dec, 2022, Remote Online Training - Public

IPA Training is Registered with

Venue Details

Remote Online Training - Public


Contact us

FOR COURSE DETAILS

Juliany,

Office: 03 2283 6109

Mobile: +60 122281247

juliany@ipa.com.my

Phoebe,

Office: 03 2283 6100

Mobile: +60 193637822

phoebe@ipa.com.my

Bee Teng,

Office: 03 2282 6112

Mobile: +60 172566121

beeteng@ipa.com.my

FOR CUSTOMISED IN-HOUSE TRAINING

Jane,

Office: 03 2283 6101

Mobile: +60 129418251

jane@ipa.com.my

Keith,

Office: 03 2283 0000

Mobile: +60 162272735

keith@ipa.com.my

ADDRESS

A-28-5, 28th Floor, Menara UOA Bangsar,
No.5, Jalan Bangsar Utama 1,
59000 Kuala Lumpur

FOCUSING ON
  • Module 1: The Excel Reference SECRETS
  • Module 2: The Special tools in Excel
  • Module 3: Making Data Easy to Understand
  • Module 4: The Amazing Formula Secrets
  • Module 5: Getting to know what is “Get and Transform”
  • Module 6: Generating Quick but a Complex Report
  • Module 7: Visual Data Presentation using Excel Chart
  • Module 8: Secure your Excel files
COURSE OBJECTIVE
This course is specifically designed to help you work on your reports like a HERO. In this course, the participants will be given the simplest solution to solve sophisticated task within a short span of time. Mastery comes with lots of practice. There will be exercises and examples that will ignite your creativity using the Formulas and Features in Excel. Ultimately, with practice to turn the knowledge into learning, you will be a master in Microsoft Excel in no time
AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Using all the different type of Cell References Effectively & Accurately.
  2. Applying the Go to Special and Paste Special to solve complicated Task Quickly.
  3. Changing & Applying the Number Formatting Dynamically.
  4. Being able to fully understand the secrets of VLOOKUP and use it like a Pro.
  5. Using PowerQuery to Clean Up and Collect Data from Multiple Source.
  6. Designing Mini Dashboard using Pivot Table.
  7. Presenting Data Visually.
  8. Applying Worksheet and Workbook Level Protection
WHO SHOULD ATTEND
Executives, Managers, Business Owners, General Public, Individual pursuing Self Improvement
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: The Excel Reference SECRETS

  • Cell Reference and Name Range
  • Applying Names in Formulas
  • Dynamic References
  • Structured Reference
  • 3D Reference


10.45

Module 2: The Special Tools in Excel

  • Selection: Go to Special | Blank | Visible
  • Copy & Paste: Paste Special | Transpose | Operation
  • Camera Tool: Smile – One Two Three – Snap
  • Data Entry Form (Non-Coding Form) 

 

1:00 Lunch
2:00

Module 3: Making Data Easy to Understand

  • Explore the Number Formatting
  • Deep Dive into Date Formatting
  • Making Number Value Appear Dynamic
  • Apply symbols in Number Formatting
  • Insert Picture evidence in the Excel Comment/ note

 

3:45

Module 4: The Amazing Formula Secrets

  • Introducing VLOOKUP and its Accomplice
  • Why not XLOOKUP?
  • Index and Match Function is a perfect couple
  • Search Part of the Value with a HELPER column

 

5:00 End of Course
DAY 2
9:00

Module 5: Getting to know what is “Get and Transform”

  • Cleaning up messy Data
  • Collect data from multiple source
  • Merge data from 2 sets of data


10.45

Module 6: Generating Quick but a Complex Report

  • Transform a Data List (database) into an easy-to- understand Report
  • Making Right Click your Buddy in Pivot Table
  • Analyze the data by Grouping data
  • Write a Calculated Field in Pivot Table (Formula)
  • Present the Report Visually with Chart

 

1:00 Lunch
2:00

Module 7: Visual Data Presentation using Excel Chart 

  • Manipulate data to display your chart Correctly
  • Add Visual Information to make Chart easy to read
  • Apply Cosmetic Change on the Chart to WOW the Audience

 

3:45

Module 8: Secure your Excel file

  • Sheet Protection: No Editing Capability
  • Partial Sheet Protection:” Protect Locked and hidden Cells
  • File Protection: Only allow access with Password

 

5:00 End of Course