Basic 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.

JOIN IN CUBAO

• Snacks
• fastfood lunch (for full day classes only)
• printed handout
• printed certificate
• overflowing coffee
• WIFI access
• Bring own laptop

IF VIA ZOOM

• PDF certificate
• PDF handout

Outline

• 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

• 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

• 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

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

• 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

Where in Cubao:

Mpower Learning Manila

222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City