Ways to train
Live, instructor-led training in a standard, professional classroom environment
Live, instructor-led training conducted over the internet, with hands-on labs
An online, HTML5, self-paced learning experience available for all courses
Private training for your entire team, delivered at your location, a training center, or online
Video classroomLearn more about our training formats
High-definition video of our most popular courses, streamed to your laptop or personal device
All of our private classes are customized to your organization's needs.
Click on the button below to send us your details and you will be contacted shortly.
Request more information
Inquiry for: Myself My Company
Our learning consultant will get back to you in 1 business day
Microsoft Excel 2016 Advanced
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.
Basic knowledge of Microsoft Excel is essential with the following pre-requisites:
This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise
Upon completion of this program, participants should be able to:
• Create Subtotal Using The Subtotal Function
• Analyze data Using Pivot Tables
• Perform What If Analysis using:
o Goal Seek
o Input Table
• Use VLOOKUP function to extract data
• Nesting INDEX and MATCH Function
• Combining & Consolidating Data
• Record and Run a Macro
Topic A: Outlining and Grouping Data
Topic A: Using Data Analysis Tools
• Using a One or Two Input Data Table
• Using Goal Seek
Topic B: Exploring Scenarios
• What is a Scenario?
• Creating a Scenario
• Saving Multiple Scenarios
• Creating a Scenario Summary Report
Topic C: Using Solver
• Understanding Solver
• Generating Reports and Scenarios with Solver
• Changing Solver Values
• Managing Solver Constraints
• Using Solver as a Goal Seek Tool
Topic A: Working with Array Formulas
• What are Array Formulas?
• Defining Basic Array Formulas
• Using Functions within Array Formulas
• Using the IF Function in Array Formulas
• Using IFERROR with Array Formulas
Topic B: Using the VLOOKUP Function
• Understanding VLOOKUP and HLOOKUP
• Using VLOOKUP to Find Data
• How to Find an Exact Match with VLOOKUP
• Finding an Approximate Match with VLOOKUP
• Using VLOOKUP as an Array Formula
Topic C: Using the Advanced Function
• Using the INDEX Function
• Using the MATCH Function
• Combining the MATCH and INDEX functions
Topic D: Linking, Consolidating, and Combining Data
• Linking Workbooks
• Consolidating Workbooks
• Combining Worksheets
Topic A: Create Advanced Chart
• Dual Axis Charts
• Creating Custom Chart Templates
Topic A: Create a PivotTable
• Start with Questions End with Structure
• Create PivotTable Dialog Box
• PivotTable Fields Pane
• Summarize Data in a PivotTable
• Show Values As Functionality of a PivotTable
Topic B: Filter Data by Using Slicer
• Insert Slicers Dialog Box
Topic C: Analyzing Data with PivotChart
• Creating PivotChart
• Applying a Style to a PivotChart
Topic A: Customizing Workbooks
• What is a Hyperlink?
• Inserting Hyperlinks
• Editing Hyperlinks
• Formatting Hyperlinks
• Using Hyperlinks in Excel
Topic A: Macros
• Recording Macros
• Saving to Macros Enabled Workbook
• Closing and Re-Opening a Macro Workbook
• Security Warning Message
• Playing a Macro
• Assigning a Keystroke to a Macro
Topic B: Form Controls
• What is a Form Control?
• Adding a Control to a Worksheet
• Assigning a Macro to a Control
• Using Form Controls
Topic A: Finishing Workbook
• Publishing to PDF or XPS
Topic B: Protecting Worksheet and Workbook
• Protecting the Current Sheet
• Protecting an Entire Workbook
• File Protection
Anne Teoh Hui San
A rising and highly engaging trainer, Anne Teoh represents a new face for Microsoft Office training. She has been involved in training Microsoft Windows 8 and Windows Phone development and design Microsoft Student Partners (MSP) for a year. Within her first year venture into the training industry, she is now highly sought after by banking, investment firms and high-tech industries; to execute competent Microsoft Office training. She specializes in delivering Office Word, Office Excel and Office PowerPoint trainings, having most of the occasion delivering beyond client expectations of what defines a training.Focusing heavily on delivering hands-on experience to her participants, she instils a robust understanding of the fundamentals for Microsoft Office training; as she strongly views that traditional delivery of training should be phased out and delivered in a lively manner that reflects the everyday routine of a given professional.Besides training, she is also as a deeply involved the development of Windows Phone Applications, mostly handling the UI/UX portion.
Patrick Cheah Liat Hin
Patrick has been involved in the IT industry since 2002 and has exposure in both technical and non-technical area which includes customer service, marketing, web and graphic design and technical support.In IT training, Patrick started off as a course facilitator guiding users in an online E-Learning portal. He proceeded to classroom training, where he trained visually impaired students in using Access Technology and Microsoft Office; then moved on to train professionals from various manufacturing sectors in Microsoft Office; covering from basic to advanced level courses.Apart from technical training, Patrick is also involved in soft skill training. A member of the Toastmasters International since 2006 and an Advanced Communicator, he conducts public speaking courses for students as well as working professionals.
Muhamad Rezall Bin Roslan
Rezall has been in the IT training industry for about 8 years. He has trained thousands of people on the use of Microsoft Word, Excel, PowerPoint. He spent 5 year working in the IT department of a well-known retail company where he was involved in infra technologies and related areas.
Rezall comes across as not only an approachable and reliable trainer but is also liked for his warm, cheerful and pleasant personality.Read More
Azrulnizam Bin Ahmad
Azrulnizam Ahmad has been working in the business industry since 2004 and has been exposed to all the common challenges faced by business personnel. With his years of experience working with business and management, IT services and end users, he understands the importance of business value, infrastructure efficiency and user productivity.He shares his training passion in Microsoft Office 2007 Application - Excel, PowerPoint, and Word; Microsoft Office 2010 Application - Excel, PowerPoint, and Word and also emphasizes on the criticality of this aspect in any implementation.He is an energetic, independent, goal-oriented individual that has a high work standard and is committed to his work. He is also a good planner, is creative and resourceful, has great leadership charisma and works well with others. Read More
Jarina Muhamad Ismail
Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.
Sylvia Sharon Anthony
She began her career as a Corporate Trainer and her personal areas of expertise are wide; encompassing Database and Graphic applications. In addition to that; she also specializes in corporate coaching for government, multi-national companies to local SMEs.
Sylvia has acquired immense knowledge and skill in the training field. Since becoming a trainer, her work has involved design, delivery and developing training programmers. In her 16 years of experience in the training arena she has delivered and customized training programmers specifically to tailor for organization's unique training needs and to maximize the participant's learning outcomes.
As a trainer, Sylvia constantly strives to improve herself and learn new methods and skills. She is passionate about building new programs that meet the upcoming challenges of the IT industry. She is currently developing a customized Excel programme which will emphasize on the advanced features of Microsoft Excel i.e. Mastering Charts, Functions and Pivot Tables.Read More
Su-Ann has been in the IT training industry for the 20 years and has trained thousands of people on the use of Microsoft Office. As Microsoft Office application is her area of specialization, she is an expert in all versions of the software and is capable of teaching at the basic, intermediate and advanced level. She has provided training to a variety of people: bankers, IT Personnel, young and old office workers, managers, senior managers, directors and corporate C-level executives. Su-Ann is the trainer of choice for many of our Blue Chip clients. Besides training, she has also been deeply involved in courseware development. In addition to developing generic courseware on Microsoft Office Applications, she has developed customized courseware to meet the unique requirements of the clients.