Practical Basic Excel For Business Applications

18 Jul, 2017, Vistana Kuala Lumpur

Register Now
PDF Brochure

IPA Training is Registered with

Learn from the Best

KEN CHOO is a US trained engineer with more than 15 years experience in managing business, consultancy and training. He has been an advanced user of many application software and has over 15 years of practical experience in Microsoft applications. He has developed many Excel models for various applications such as production planning, sales management, vendors management for manufacturing and service industries.

 

He has strong track record in managing performance and improvement by using Excel as a monitoring and analysis tool. Ken is also experienced in implementing management system such as ISO 22K Information security system and he is also a PSMB registered trainer.

Venue Details

Vistana Kuala Lumpur
9 Jalan Lumut, Off Jalan Ipoh, 50400 Kuala Lumpur - 50400
Phone : (603) 4042 8000
Fax : (603) 4041 1400

Click For Hotel Location

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
  • Quick Overview Of Excel Essentials
  • Using Formulas & Basic Functions
  • Formatting
  • Presenting Reports
INTRODUCTION

Microsoft Excel is one of the most commonly used spreadsheet programmes, This course introduces attendees to the power of Excel. Having practical, hands-on skills in this software gives you full confidence in your ability to navigate your way around the software with ease.

OBJECTIVE

The course is being designed in order for participants to build up their confident level in going beyond the basic features in Excel. For example using multiple sheets, linking them to create formulae across sheets, use common functions such as Average and If statements. During the course of these exercises and examples attendees will also learn the important fundamentals of the Excel package to ensure robust spreadsheet development and maintenance including stunning Excel charts.

AFTER ATTENDING THIS COURSE, YOU WILL RETURN TO YOUR JOB…
  • Leveraging on Excel functions & capability
  • Preparing, editing, analyzing and printing data or report effectively
  • Applying the functions and techniques onto day-to-day works
  • Using tips and tricks to prepare data efficiently
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.
  • Useful class manual are provided for each participant.
  • Participants will be given the opportunity to work on solutions to real life Excel.
DAY 1
9:00 QUICK OVERVIEW OF EXCEL ESSENTIALS
  • Excel 2010 Interface
  • Entering Data
  • Functions Overview
  • Working with Multiple Worksheets
  • Understand Common Excel Applications
10:45 USING FORMULAS & BASIC FUNCTIONS
  • Relative / Absolute Cell Refreence
  • Using Text / Number Functions
  • Understanding Arrays
  • Calculating using Date Function
  • Manipulating Text and Numbers
  • Counting and Summing Techniques
1:00 Lunch

2:00

FORMATTING

  • Using Basic Conditional Fomatting
  • Format and Print
  • Page Setup
3:45 PRESENTING REPORTS
  • Understand Charts
  • Preparing Various Type of Charts
  • Formatting Charts
  • Basic Table
5:00 End of Course