ADVANCED MICROSOFT EXCEL TRAINING
A Corporate EnterTRAINment on Advanced Microsoft Excel – a 2-day Advanced Microsoft Excel Training in the Philippines
ENTERTRAINMENT OVERVIEW:
This 2-day Advanced Microsoft Excel Training in the Philippines is designed to provide participants with a comprehensive understanding of advanced Excel functions and features.
The training covers a wide range of topics, from data management and formula tasks to pivot tables, charts, dashboards, macros, and workbook protection.
Participants will engage in interactive discussions, trainer demonstrations, and hands-on exercises to enhance their proficiency in using Excel for complex data analysis and reporting tasks.
ENTERTRAINMENT GOAL:
The overall training goal of this 2-day Advanced Microsoft Excel Training in the Philippines is to empower participants with advanced Excel skills, enabling them to efficiently manage and analyze data, create sophisticated reports and dashboards, and automate repetitive tasks through macros.
By the end of the training, participants should be able to leverage Excel’s advanced capabilities to improve their productivity and decision-making processes.
ENTERTRAINMENT OBJECTIVES:
To achieve the goal above, this 2-day learning experience shall make the trainees master:
- Mastery of Advanced Excel Functions: Participants will acquire in-depth knowledge of advanced Excel functions, including array formulas, financial functions, lookup functions, logical functions, text functions, and nested functions, allowing them to perform complex calculations and data manipulations.
- Proficient Data Management: Participants will learn effective data management techniques such as data consolidation, validation, transposition, and removal of duplicates. They will also gain skills in organizing data and importing data from external sources.
- Pivot Table Expertise: Participants will become proficient in creating, customizing, and analyzing pivot tables, as well as summarizing data and creating pivot charts. They will learn to add calculated fields, sort and filter data, and utilize the PivotTable Fields Pane.
- Dashboard Creation and Macro Automation: Participants will understand the principles of dashboard design and be able to create interactive dashboards that link control buttons to worksheets and charts. Additionally, they will learn how to record, edit, and run macros to automate repetitive tasks, improving their overall efficiency.
ENTERTRAINMENT OUTLINE:
DAY ONE (1)
SESSION ONE (1): QUICK REVIEW OF EXCEL BASIC FUNCTIONS AND FEATURES
SESSION TWO (2): MANAGING DATA
- Organizing Data
- Importing Data from External Sources
- Outlining and Grouping Data
- Consolidating Information
- Removing Duplicates
- Configuring Data Validation
- Transposing Data
- Converting Text to Columns
SESSION THREE (3): ADVANCED FORMULA TASKS
- Understanding Relative and Absolute Cell References
- Using Multiple Cell References
- Using Array Formulas
SESSION FOUR (4): WORKING WITH NAMED RANGES
- Understanding Named Ranges
- Defining Named Ranges
- Editing Named Ranges
- Deleting Named Ranges
- Using Named Ranges in Formulas
SESSION FIVE (5): USING ADVANCED FUNCTIONS
- PMT Function
- FV Function
- VLOOKUP and HLOOKUP Functions
- IF, AND, OR Functions
- TODAY, NOW, DATE and TIME Functions
- TRIM Functions
- LEN and SUBSTITUTE Functions
- LEFT, RIGHT, and MID Functions
- CONCATENATE Function
- SUMIF, COUNTIF, and AVERAGEIF Functions
- NESTED Functions
SESSION SIX (6): USING CONDITIONAL AND CUSTOM FORMATS
SESSION SEVEN (7): RESOLVING FORMULA ERRORS
- Tracing Formula Precedents and Dependents
- Showing Formulas
- Evaluating Formulas
- Setting Error Checking Options
- Using Error Option Buttons
- Running and Error Check
DAY TWO (2)
SESSION EIGHT (8): REVIEW OF DAY 1
SESSION NINE (9): ADVANCED PIVOT TABLE FEATURES
- Creating Basic Pivot Table
- Creating Basic Pivot Chart
- Using PivotTable Fields Pane
- Adding Calculated Fields
- Sorting Pivoted Data
- Filtering Pivoted Data
SESSION TEN (10): SUMMARIZING RESULTS OF CALCULATIONS (WORKING WITH GRAPHICS AND CHARTS)
- Creating charts from data tables and pivot tables
- Modifying chart types
- Formatting chart properties
- Formatting cells
SESSION ELEVEN (11): DASHBOARDS
- Creating dashboard
- Linking control buttons to worksheets and charts
SESSION TWELVE (12): USING MACROS
- Recording a Macro
- Editing a Macro
- Running a Macro
FINAL SESSION: SHARING AND PROTECTING WORKBOOKS
- Co-authoring
- Sharing a workbook
- Protecting a worksheet
- Protecting Cells
- Protecting a Workbook
ENTERTRAINMENT METHODS:
- Interactive Discussions
- Trainer Demonstrations
- Hands-on Exercises
NOTE: This is just our off-the-shelf or ready-made training outline. This program can be customized to meet the learning expectations of the learners and the goal this training is called for.
To know more about MSS Business Solutions, visit and like our Facebook Page at: