MICROSOFT EXCEL FOR INTERMEDIATE LEARNERS
A 2-day Corporate EnterTRAINment on Intermediate Microsoft Excel
INTERMEDIATE MICROSOFT EXCEL TRAINING IN THE PHILIPPINES
TARGET AUDIENCE:
This Intermediate Microsoft Excel Training in the Philippines is designed for individuals who have basic Microsoft Excel skills and want to improve their proficiency in Excel.
The course is ideal for professionals who work with large data sets, perform data analysis, create reports, and automate tasks using MS Excel.
Participants should have a basic understanding of Excel features and functions including formulas, charts, and data management.
PREREQUISITE:
Participants should have basic MS Excel skills including familiarity with Excel features and functions such as formulas, charts, and data management.
Participants should bring their laptops with Microsoft Excel installed.
ENTERTRAINMENT OBJECTIVES:
The objective of this intermediate Microsoft Excel training is to equip participants with intermediate skills and knowledge in Excel that will enable them to perform complex tasks and solve real-life problems using MS Excel.
Participants will learn how to use Intermediate MS Excel features and functions to work with large data sets, perform data analysis, create dynamic charts, and automate routine tasks.
ENTERTRAINMENT OUTLINE:
SESSION ONE (1): INTRODUCTION TO INTERMEDIATE EXCEL FEATURES
- Review of Basic Excel Features
- Understanding Excel Ribbons and Toolbars
- Introduction to Intermediate Excel Features
SESSION TWO (2): INTERMEDIATE DATA MANAGEMENT
- Sorting and Filtering Data
- Using Conditional Formatting
- Removing Duplicates
- Data Validation
SESSION THREE (3): INTERMEDIATE FORMULAS AND FUNCTIONS
- SUMIF, COUNTIF, AVERAGEIF Functions
- VLOOKUP and HLOOKUP Functions
- IF Function and Nested IF Statements
- Pivot Tables
SESSION FOUR (4): INTERMEDIATE CHARTING TECHNIQUES
- Creating Dynamic Charts
- Formatting Charts
- Adding Trend Lines
- Charting Tips and Tricks
SESSION FIVE (5): DATA ANALYSIS TECHNIQUES
- Working with Data Tables
- Creating Scenarios
- Goal Seek and Solver
- What-If Analysis
SESSION SIX (6): MACROS AND AUTOMATION
- Introduction to Macros
- Creating and Running Macros
- Automating Tasks with Macros
- Macro Security
SESSION SEVEN (7): ADVANCED EXCEL TIPS AND TRICKS
- Keyboard Shortcuts
- Advanced Formatting Techniques
- Using Excel Templates
- Troubleshooting Excel Issues
ENTERTRAINMENT METHODOLOGY:
The training will be conducted using a mix of lectures, demonstrations, and hands-on exercises.
Participants will be provided with training materials, including step-by-step guides and practice exercises.
The training will be conducted in a computer lab and participants will have access to their own computers to practice the skills taught during the training.
The trainer will provide individual assistance to participants as needed.
Check out our other Computer-related training programs below:
Computer Training in the Philippines
To know more about MSS Business Solutions, visit as well our Facebook Page at: