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…