COURSE OVERVIEW
This course will familiarize participants with spreadsheet terminology and the fundamental concepts of Microsoft Excel, including navigating worksheets, customize views for worksheets and configure worksheets and workbooks. In addition, participants will learn to manage tables, utilize cell ranges and references in formulas and functions.
TARGET AUDIENCE
This course is tailored for complete beginners and for people who know the basics of Excel already. This course is for people who need to learn Microsoft Excel for work.
PREREQUISITES
No previous Excel skills are necessary.
LEARNING OUTCOME
- Create and Manage Workbooks and worksheets
- Use of Excel templates and creates of templates
- Basic Excel formulas
- Printing setting and configure printing for different purposes
- Manage Excel tables – filter and slicer function in Table
- Cell formatting
- Using Statistical Functions
COURSE OUTLINE
- Format worksheets
- Customize options and views
- Header and footer
- Freeze, quick access toolbar
- Search, create and control template
- Useful functions in creating template – data validation
- Count, counta, countif
- Sumif, averageif
- Copy paste formula
- Anchoring in formula
- Customize options and views
- Header and footer
- Configure worksheets to print or save
- Goal seek
- Scenarios manager
- Format chart, insert picture
- Textbox and smartart
Ng Eng Kiang (Alex) CA(M), MCT
Profile Synopsis
Alex Ng holds a Bachelor of Accounting from Universiti Kebangsaan Malaysia (UKM). He is a member of the Malaysian Institute of Accountants (MIA), Microsoft Certified Trainer (MCT) and PSMB Certified Trainer. Alex has more than 14 years of experience (including being attached previously in Enrst & Young, Swiss-Garden Resorts Kuantan, and FPG Oleochemicals Sdn Bhd) in handling a variety of corporate audit assignments, managing Finance team of 28 subordinates and various financial analysis and reporting.
His 14 years of working experiences includes hands-on experience as a Finance Analyst in managing financial analysis and budget/reporting system together with representatives from Asia and Europe finance team. He is also experienced in developing and customizing training manuals.
He has 4 years of experience in training as a certified HRDF and MCT trainer especially since 2016.
His mission is to help clients enhance performance, productivity and profitability by leveraging on his results-based management, accounting and Microsoft applications knowledge. He is an accomplished speaker and trainer, having conducted many seminars, workshops and speaking engagements on accounting, risk management, leadership and Microsoft Office training over the last 4 years. Alex NG is a member of CFO Club Malaysia, a non-profit organization dedicated to promoting financial management awareness to academics and younger generations.