Course Overview
Expand your Excel skills through the AverNoble Virtual Instructor-led Course, delving into the creation of charts and tables, while mastering time-saving formatting techniques and validation tools. Throughout the program, you'll navigate Microsoft® Office Excel®, gaining expertise in formatting for efficiency and error prevention, manipulating formulas with built-in functions for in-depth analysis, as well as acquiring the ability to generate shared workbooks and oversee modifications within collaborative workbook settings.
Course Modules
- Module 1: Working with Worksheets
- Module 2: Working with Functions
- Module 3: Working with Charts
- Module 4: Using Table Features
- Module 5: Working with Formatting and Data Validation
- Module 6: Using Protection and Shared Workbook Features
- Module 7: Using Styles and Templates
- Action Plans
Learning Objectives
Participants will learn, understand and practice:
- On worksheets, charts, formatting and functions
- On formatting and tools for error checking
- To create formulas using built in functions
- To shared workbooks and track changes in shared workbooks
- To explore various styles and templates available
Course Methodology
Interactive Online Learning (using Quizzes, White Board, etc.) | |
Role-Plays | |
Storytelling | |
Mini-Lectures | |
Practical Works | |
Video Based Learning | |
Group Activities, Discussion & Presentation |
Mini Projects | |
Problem-Based Learning (PBL) | |
Demo | |
Recap Sessions | |
Ice Breaking / Games | |
Pre-Assessment & Post-Assessment |
The exercises and activities incorporate “FUN” elements are thoughtfully selected to best suit the general corporate culture. Our expert trainer will ensure the exercises used are highly applicable to your industry in order to enable participants to apply the knowledge, skills and behaviour which they have obtained through this learning session.
Who Should Attend
This course is designed for participants with basic Excel Introduction or equivalent skills. Participants must be able to create, open, save, format and print a worksheet. Should be able to use formulas and the SUM function. The ability to copy, move and delete values and formulas is required.
This course is designed for New Hires, Executives, Team Leads, Supervisors, Managers and Senior Management Team and identified individuals in the organisation, integral to the business objectives and targets.
Course Duration
Two (2) Days
Important Note: Course Outline and Duration can be customised according to client's requirements
Things you would like to highlight or CTA
Elevate your Excel proficiency with Microsoft Excel Intermediate 2016, mastering advanced functions, formulas, and data analysis techniques. Discover the power of creating dynamic charts and tables, implementing time-saving formatting and validation features, and cultivating skills in error checking and prevention. Learn to navigate shared workbooks, track changes seamlessly, and unlock the collaborative potential of Excel. Join us in this comprehensive journey to boost your productivity and efficiency in data management and analysis.