Basics of MS Excel

This training program is designed for novice Excel users who want to develop a solid working knowledge of Microsoft Excel and confidently perform everyday data tasks. The course focuses on building strong foundational skills—from worksheet navigation and essential formulas to data organization, visualization, and introductory analysis—so participants can operate Excel efficiently in a professional setting. By strengthening core competencies early, learners become better prepared for more advanced Excel applications such as reporting, dashboards, and data analytics.​
By the end of this training, participants will be able to:

• Develop a comprehensive understanding of Excel’s core features and essential functions for professional use
• Manage datasets effectively using sorting, filtering, formatting, and validation tools to support better analysis and decision-making
• Apply foundational formulas and combine functions in practical business scenarios
• Create basic charts and PivotTables to summarize and present information clearly
• Build the confidence to explore advanced Excel capabilities and pursue further specialization in data analysis and reporting

Who This Course Is For

• Beginners with little to no formal Excel training
• Professionals transitioning from manual processes to spreadsheet-based work
• Administrative, HR, finance, and operations staff handling routine data
• Employees who want stronger digital productivity skills

Training Methodologies

• Interactive, instructor-led exercises incorporating seatwork, recitation, and structured activities to promote active participation and retention.
  
• Scenario-based problem solving using realistic worksheets, followed by guided feedback to refine formula accuracy and workflow efficiency.

VENUE

• Mpower Training Center
• 222 Vivaldi Residences, EDSA cor Aurora Blvd.., Cubao, Quezon City
• Bring own laptop

INCLUSIONS

For onsite:

1. printed handout
2. printed certificate
3. AM snacks
4. candies and coffee
5. WIFI access

For via Zoom:

1. PDF handout
2. PDF certificate

1. Basic Worksheet Operations

• Merging Cells and Wrap Text
• Freezing Cells
• Cell Formatting Options
• Filtering and Sorting Data
• Using Filter Views
• Row and Column Operations (Hide, Insert, Delete, Freeze Pane)
• Sheet Operations (Naming, Tab Color, Hiding Sheets)
• Formatting Values
• Protecting Range

1. Essential Excel Functions

• Basic Arithmetic Formulas: SUM, AVERAGE, etc.
• Text Functions: LEFT, RIGHT, CONCATENATE, etc.
• Math and Conditional Functions: SUMIFS, COUNTIF, RANK, etc.
• Handling Date Problems
• Basic Logical Functions: IF, Nested IFs, Series IFs
• Basic Lookup Functions: VLOOKUP, Using Named Ranges
• Combining Functions in Basic Scenarios
• Essential Excel Shortcut Keys for Efficiency

1. Data Tab Tools

• Separate Texts Text-to-Columns
• Applying Conditional Formatting
• Data Bars, Color Scales, and Icon Sets
• Processing Raw Data using Subtotal Tool
• Creating Data Validation
• Creating Basic Dropdown Lists

1. Creating Basic Charts

• Review of Basic Chart Elements: Gridlines, Axes, Data Tables, Data Labels, Legends
• Choosing the Right Chart to Adapt for the Purpose

1. Introduction to PivotTables

• Creating PivotTables for Data Analysis
• Modifying Value Field Settings for Custom Analysis
• Grouping Data for Clarity
• Interacting with PivotTable Data using Slicers