Advanced MS Excel with Copilot Training

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

This interactive live training includes a thorough discussion of advanced functions and tools in MS Excel.

Mpower Learning Manila

IF FULL DAY CLASS, JOIN IN CUBAO <ul><li>lunch (fast food)</li><li>1 AM snack</li><li>1 PM snack</li><li>printed handout</li><li>printed certificate</li><li>overflowing coffee</li><li>WIFI access</li><li>BRING OWN LAPTOP</li></ul> IF VIA ZOOM<ul><li>PDF certificate</li><li>PDF handout</li></ul> Where in Cubao:Mpower Learning Manila222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City

This course is designed to build strong, practical Excel skills for professionals who regularly handle data but want to work faster, cleaner, and with more confidence. Participants move from core Excel functions to structured data analysis, while also learning how Microsoft Copilot can support formula building, data interpretation, and productivity—without replacing fundamental Excel thinking. Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365, Microsoft 365 *Copilot only available to certain versions By the end of this course, participants will be able to:<ul><li>Apply text, logical, math, and lookup functions from basic to advanced levels to clean, transform, and analyze datasets</li><li>Use Excel tools such as Conditional Formatting, Data Validation, Subtotals, and PivotTables to manage and summarize data effectively</li><li>Build and interpret PivotTables and PivotCharts to extract insights from structured datasets</li><li>Leverage Copilot to accelerate formula creation, explain existing formulas, suggest data analysis approaches, and reduce manual trial-and-error—while still validating results independently</li></ul> Who This Course Is For<ul><li>Office professionals, analysts, supervisors, and managers who work with Excel regularly</li><li>HR, finance, operations, sales, and admin staff handling reports and datasets</li><li>Users with basic Excel knowledge who want to move toward structured analysis and smarter workflows</li><li>Teams transitioning to Microsoft 365 and beginning to use Copilot alongside Excel Methodologies</li></ul><ol><li>Hands-on, scenario-based exercises using realistic business datasets to reinforce practical application of formulas, tools, and PivotTables.</li><li>Guided Copilot-assisted workflows, where participants compare manual Excel solutions with AI-supported suggestions to build speed without sacrificing accuracy.</li></ol> Course Outline Part 1: Basic to Advanced MS Excel Functions<ul><li>Text Functions</li><li>Concatenating texts</li><li>Extracting values from text (LEFT, RIGHT, MID)</li><li>Changing case (UPPER, LOWER, PROPER)</li><li>Accessory text functions (TRIM, VALUE, SUBSTITUTE)</li><li>Logical Functions</li><li>Basic IF statements</li><li>Nested and series IF statements</li><li>Combining conditions using AND and OR</li><li>Math Functions</li><li>Core math functions (SUM, AVERAGE, MAX, MIN, COUNT)</li><li>Named Ranges for readability and control</li><li>Conditional math functions (COUNTIF, SUMIF, AVERAGEIFS, etc.)</li><li>Shortening long formulas using arrays</li><li>Lookup Functions</li><li>Understanding VLOOKUP</li><li>Advanced VLOOKUP usage and limitations</li><li>Using XLOOKUP, INDEX and MATCH for flexible lookups</li></ul> Part 2: Managing Data Using Excel Tools<ul><li>Formula-based conditional formatting</li><li>Data Validation</li><li>Dropdown lists</li><li>Numeric, date, and text validation</li><li>Subtotal Tool</li><li>Understanding subtotals vs totals</li><li>Grouping and summarizing datasets</li></ul> Part 3: Using Copilot with Excel<ul><li>What Copilot can and cannot do in Excel</li><li>Using Copilot to:</li><li>Explain existing formulas</li><li>Suggest formulas based on business questions</li><li>Summarize tables and PivotTables</li><li>Identify patterns and trends in datasets</li></ul> Part 4: Analyzing and Presenting Data Using PivotTables<ul><li>PivotTable Fundamentals</li><li>Creating and modifying PivotTables</li><li>Refreshing data and changing sources</li><li>Grouping dates, text, and numeric fields</li><li>Enhancing Analysis</li><li>Using slicers for interactive filtering</li><li>Creating PivotCharts for reporting and presentations</li></ul> Part 5: Introduction to Macros (If Time Permits)<ul><li>Understanding macro security and risks</li><li>Recording simple macros for repetitive tasks</li><li>Identifying tasks suitable for basic automation</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}

Advanced MS Excel with Copilot Training

More events from Insights Training

Discover more events from Insights Training, from Business to other experiences you might love.

Advanced MS Excel with Copilot Training

More events from Insights Training

Discover more events from Insights Training, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.