Microsoft Excel Intermediate

19 Nov, 2021, Virtual Classroom Training

IPA Training is Registered with

Learn from the Best

Kelvin Ng
Microsoft Office 2016 Master Specialist
Microsoft Certified Trainer

 

Kelvin Ng Choo Kent is a highly experienced digital arts instructor and master trainer with more than 17 years of experience in the office automation consultation, graphic design, animation and print production arena. He is a graduate of Malaysian Institute of Art (MIA) And holds the distinction of being certified as Adobe Certified Expert (ACE), Microsoft Office 2016 Master Specialist MCP & MCT, Certified practitioner of Neuro-Semantics, Certified practitioner of Neuro-Linguistic programming & Certified practitioner of Hypnosis & Time-Lines.


 

Microsoft Certification

  • MICROSOFT CERTIFIED TRAINER (MCT) SINCE 2012
  • MICROSOFT OFFICE 2016 MASTER SPECIALIST (MOS)
  • MICROSOFT OFFICE EXCEL 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE WORD 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE POWERPOINT 2016 SPECIALIST (MOS)
  • MICROSOFT OFFICE ACCESS 2016 SPECIALIST (MOS)

Professional Qualifications

  • PSMB APPROVED TRAINER
  • CERTIFIED ETHICAL HACKER (CEH)
  • ADOBE CERTIFIED EXPERT (ACE)
  • CERTIFIED PRACTITIONER OF NEURO-SEMANTICS
  • CERTIFIED PRACTITIONER OF NEURO-LINGUISTIC PROGRAMMING
  • CERTIFIED PRACTITIONER OF HYPNOSIS & TIME- LINES


AREA OF EXPERTISE
Office Tools
Microsoft Office Suite (2003, 2007, 2010, 2013, 2016), Adobe Acrobat, Microsoft Visio


Soft Skill
Effective Presentation, Train The Trainer, Microsoft Office Business Application Coaching, Effective Communication


Graphic Design

Adobe Photoshop, Adobe Illustrator, Adobe Indesign, Quarkxpress, Adobe Pagemaker, Corel Draw, Corel Photo Paint

His Clientele



Venue Details

Virtual Classroom Training

Contact us

Juliany,
M - 012 2281 247
juliany@ipa.com.my

Michelle,
M - 019 363 7822
michelle@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Yvonne,
M - 012 201 1247
yvonne@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
  • References & Names | COUNT Functions
  • Text Functions | Date Functions
  • Logical Functions | Lookup Functions
  • Database Functions | Paste Special | Print Setup
COURSE OVERVIEW

Microsoft Excel is a software for storing numerical data and analyzing them. It is one of the most flexible and commonly used applications in Office. Whatever career path you choose, you will probably have to use Excel to achieve your professional goals, some of which may happen every day. For one way or the other, we all work with numbers. When we want to record, analysis and save such numeric data, Microsoft Excel comes in handy. At this intermediary level, it provides an overview of the Excel forms and features used every day for preparing reports and analytics for our managers.

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Understanding Excel Data thoroughly & preventing common mistakes in Excel Reports.
  2. Performing accurate and consistent Reports using the right Formula or Functions.
  3. Applying Logic in the Formula by using Logical Functions to automate outcome.
  4. Getting information & Summarizing Data accurately quick and easy.
  5. Printing final report in proper setup and presenting professionally.
WHO SHOULD ATTEND
Personnel who use Microsoft Excel to analyse and prepare management reports, especially Administrative, Operational and Middle Management Staff.
METHODOLOGY
  • Guided Learning, group-paced, hands-on classroom 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.
COURSE OUTLINE
9:00

Excel References

  • Consolidating Data Using a 3-D Reference Sum Function
  • Mixed References within Formulas
 

Excel Named Ranges

  • Naming Cell Ranges
  • Removing a Named Range
  • Named Cell Ranges and Functions
 

Excel Statistical Functions

  • COUNT Function
  • COUNTA Function
  • COUNTIF Function
  • COUNTBLANK Function
10.45

Excel Text Functions

  • Left function
  • RIGHT Function
  • MID Function
  • TRIM Function
 

Excel Time & Date Functions

  • Inserting the Current Time and Date
  • TODAY Function
  • WORKDAY Function
  • Functions
  • EDATE & EOMONTH Functions
1.00 Lunch
2:00

Excel Logical Functions

  • IF Function
  • AND Function
 

Excel Lookup Functions

  • VLOOKUP Function
  • HLOOKUP Function
3.45

Excel Database Functions

  • DSUM Function
  • DAVERAGE Function
  • DMAX Function
  • DMIN Function
  • DCOUNT Function
 

Paste Special Options within Excel

  • Using Paste Special to Add, Subtract, Multiply & Divide
  • Using Paste Special ‘Values’
  • Using Paste Special Transpose Option
 

Excel Setup & Printing Issues

  • Worksheet Margins
  • Worksheet Orientation
  • Worksheet Page Size
  • Headers and Footers
  • Scaling Your Worksheet to Fit a Page(S)
  • Printing Titles on Every Page
  • Previewing a Worksheet
5.00 End of Course