Basics of MS Excel

Insights Training is a pool of traning consultants offering their courses at an affordable investment.  We believe that training must be affordable but effective (and fun!) at the same time.Visit our website at www.insightsmanila.com for more details.Our office is located at 7F Finman Bldg., 131 Tordesillas St., Salcedo Village, Makati.  You may reach us at info@insightsmanila.com, 0977.103.1800.

Insights Training

Learn the basics of worksheet preparation, formulas, and tools using MS Excel and Google Sheets

Mpower Learning Manila

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:<ul><li>Develop a comprehensive understanding of Excel’s core features and essential functions for professional use</li><li>Manage datasets effectively using sorting, filtering, formatting, and validation tools to support better analysis and decision-making</li><li>Apply foundational formulas and combine functions in practical business scenarios</li><li>Create basic charts and PivotTables to summarize and present information clearly</li><li>Build the confidence to explore advanced Excel capabilities and pursue further specialization in data analysis and reporting</li></ul>Who This Course Is For<ul><li>Beginners with little to no formal Excel training</li><li>Professionals transitioning from manual processes to spreadsheet-based work</li><li>Administrative, HR, finance, and operations staff handling routine data</li><li>Employees who want stronger digital productivity skills</li></ul>Training Methodologies<ul><li>Interactive, instructor-led exercises incorporating seatwork, recitation, and structured activities to promote active participation and retention. </li><li>Scenario-based problem solving using realistic worksheets, followed by guided feedback to refine formula accuracy and workflow efficiency.</li></ul> VENUE<ul><li>Mpower Training Center</li><li>222 Vivaldi Residences, EDSA cor Aurora Blvd.., Cubao, Quezon City</li><li>Bring own laptop</li></ul> INCLUSIONSFor onsite:<ol><li>printed handout</li><li>printed certificate</li><li>AM snacks</li><li>candies and coffee</li><li>WIFI access</li></ol>For via Zoom:<ol><li>PDF handout</li><li>PDF certificate</li></ol>

<ol><li> Basic Worksheet Operations</li></ol><ul><li>Merging Cells and Wrap Text</li><li>Freezing Cells</li><li>Cell Formatting Options</li><li>Filtering and Sorting Data</li><li>Using Filter Views</li><li>Row and Column Operations (Hide, Insert, Delete, Freeze Pane)</li><li>Sheet Operations (Naming, Tab Color, Hiding Sheets)</li><li>Formatting Values</li><li>Protecting Range</li></ul> <ol><li> Essential Excel Functions</li></ol><ul><li>Basic Arithmetic Formulas: SUM, AVERAGE, etc.</li><li>Text Functions: LEFT, RIGHT, CONCATENATE, etc.</li><li>Math and Conditional Functions: SUMIFS, COUNTIF, RANK, etc.</li><li>Handling Date Problems</li><li>Basic Logical Functions: IF, Nested IFs, Series IFs</li><li>Basic Lookup Functions: VLOOKUP, Using Named Ranges</li><li>Combining Functions in Basic Scenarios</li><li>Essential Excel Shortcut Keys for Efficiency</li></ul> <ol><li> Data Tab Tools</li></ol><ul><li>Separate Texts Text-to-Columns</li><li>Applying Conditional Formatting</li><li>Data Bars, Color Scales, and Icon Sets</li><li>Processing Raw Data using Subtotal Tool</li><li>Creating Data Validation</li><li>Creating Basic Dropdown Lists</li></ul> <ol><li> Creating Basic Charts</li></ol><ul><li>Review of Basic Chart Elements: Gridlines, Axes, Data Tables, Data Labels, Legends</li><li>Choosing the Right Chart to Adapt for the Purpose</li></ul> <ol><li> Introduction to PivotTables</li></ol><ul><li>Creating PivotTables for Data Analysis</li><li>Modifying Value Field Settings for Custom Analysis</li><li>Grouping Data for Clarity</li><li>Interacting with PivotTable Data using Slicers</li></ul>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}