# Event Details - **Event Name**: Advanced MS Excel with Copilot Training - **Event Start and End Date**: Sat, 25 Apr, 2026 at 08:00 am – Sat, 25 Apr, 2026 at 05:00 pm (+08:00) - **Event Description**: This interactive live training includes a thorough discussion of advanced functions and tools in MS Excel.About this EventIF FULL DAY CLASS, JOIN IN CUBAOlunch (fast food)1 AM snack1 PM snackprinted handoutprinted certificateoverflowing coffeeWIFI accessBRING OWN LAPTOPIF VIA ZOOMPDF certificatePDF handoutWhere in Cubao:Mpower Learning Manila222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon CityThis 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 versionsBy the end of this course, participants will be able to:Apply text, logical, math, and lookup functions from basic to advanced levels to clean, transform, and analyze datasetsUse Excel tools such as Conditional Formatting, Data Validation, Subtotals, and PivotTables to manage and summarize data effectivelyBuild and interpret PivotTables and PivotCharts to extract insights from structured datasetsLeverage Copilot to accelerate formula creation, explain existing formulas, suggest data analysis approaches, and reduce manual trial-and-error—while still validating results independentlyWho This Course Is ForOffice professionals, analysts, supervisors, and managers who work with Excel regularlyHR, finance, operations, sales, and admin staff handling reports and datasetsUsers with basic Excel knowledge who want to move toward structured analysis and smarter workflowsTeams transitioning to Microsoft 365 and beginning to use Copilot alongside ExcelMethodologiesHands-on, scenario-based exercises using realistic business datasets to reinforce practical application of formulas, tools, and PivotTables.Guided Copilot-assisted workflows, where participants compare manual Excel solutions with AI-supported suggestions to build speed without sacrificing accuracy.Course OutlinePart 1: Basic to Advanced MS Excel FunctionsText FunctionsConcatenating textsExtracting values from text (LEFT, RIGHT, MID)Changing case (UPPER, LOWER, PROPER)Accessory text functions (TRIM, VALUE, SUBSTITUTE)Logical FunctionsBasic IF statementsNested and series IF statementsCombining conditions using AND and ORMath FunctionsCore math functions (SUM, AVERAGE, MAX, MIN, COUNT)Named Ranges for readability and controlConditional math functions (COUNTIF, SUMIF, AVERAGEIFS, etc.)Shortening long formulas using arraysLookup FunctionsUnderstanding VLOOKUPAdvanced VLOOKUP usage and limitationsUsing XLOOKUP, INDEX and MATCH for flexible lookupsPart 2: Managing Data Using Excel ToolsFormula-based conditional formattingData ValidationDropdown listsNumeric, date, and text validationSubtotal ToolUnderstanding subtotals vs totalsGrouping and summarizing datasetsPart 3: Using Copilot with ExcelWhat Copilot can and cannot do in ExcelUsing Copilot to:Explain existing formulasSuggest formulas based on business questionsSummarize tables and PivotTablesIdentify patterns and trends in datasetsPart 4: Analyzing and Presenting Data Using PivotTablesPivotTable FundamentalsCreating and modifying PivotTablesRefreshing data and changing sourcesGrouping dates, text, and numeric fieldsEnhancing AnalysisUsing slicers for interactive filteringCreating PivotCharts for reporting and presentationsPart 5: Introduction to Macros (If Time Permits)Understanding macro security and risksRecording simple macros for repetitive tasksIdentifying tasks suitable for basic automation - **Event URL**: https://allevents.in/mandaluyong-city/advanced-ms-excel-with-copilot-training/100001982102862017 - **Event Categories**: workshops - **Interested Audience**: - total_interested_count: 0 ## Ticket Details - **Ticket URL**: https://consumer.pxf.io/c/1339408/3151484/39691?partnerpropertyid=1191892&MediaPartnerPropertyId=1191892&svlink=14105511&level=1&u=https%3A%2F%2Fwww.eventbrite.com%2Fe%2Fadvanced-ms-excel-with-copilot-training-tickets-1982102862017 - **Ticket Price Range**: min: 262.48, max: 2623.7, currency: PHP ## Event venue details - **city**: Mandaluyong City - **state**: MM - **country**: Philippines - **location**: Mpower Learning Manila - **lat**: 14.6210878 - **long**: 121.0505905 - **full address**: Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines ## Event Organizer details - **affiliate_id**: 10 - **organizer**: Insights Training (https://allevents.in/org/insights-training/22581225) ## Event gallery - **Alt text**: banner - **Image URL**: https://cdn-az.allevents.in/events5/banners/2ab8355f0fc5d97dcf7ccbc18812bdc997d5ba8d38dd1c45d917785caffba4bb-rimg-w1200-h665-dc17881c-gmir.jpg?v=1771828240 - **Alt text**: thumbnail - **Image URL**: https://cdn-az.allevents.in/events5/banners/5dcef0bd2faa035e2a99a88c832bf9de254b20222427f680651d90d4e6e6e3f7-rimg-w400-h400-dcc9f4d1-gmir.jpg?v=1771828239 ## FAQs - **Q**: When is the event happening? - **A:** Sat, 25 Apr, 2026 at 08:00 am (+08:00) - **Q**: Where is the event happening? - **A:** Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines - **Q**: What is the ticket price? - **A:** starting from 262.48 up to 2623.7 PHP - **Q**: Who is organizing the event? - **A:** Insights Training - **Q**: What type of event is this? - **A:** workshops - **Q**: Where can I find ticket details about Advanced MS Excel with Copilot Training ? - **A:** You can find ticket details about this event on AllEvents. ## Structured Data (JSON-LD) ```json [ { "@context": "https://schema.org", "@type": "Event", "name": "Advanced MS Excel with Copilot Training", "image": "https://cdn-az.allevents.in/events5/banners/2ab8355f0fc5d97dcf7ccbc18812bdc997d5ba8d38dd1c45d917785caffba4bb-rimg-w1200-h665-dc17881c-gmir.jpg?v=1771828240", "startDate": "2026-04-25T08:00:00+08:00", "endDate": "2026-04-25T17:00:00+08:00", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-with-copilot-training/100001982102862017", "eventStatus": "https://schema.org/EventScheduled", "location": { "@type": "Place", "name": "Mpower Learning Manila", "address": { "@type": "PostalAddress", "streetAddress": "222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd", "postalCode": "1109", "addressLocality": "Mandaluyong City", "addressRegion": "MM", "addressCountry": "PH" }, "geo": { "@type": "GeoCoordinates", "latitude": "14.6210878", "longitude": "121.0505905" } }, "eventAttendanceMode": "https://schema.org/OfflineEventAttendanceMode", "description": "This interactive live training includes a thorough discussion of advanced functions and tools in MS Excel.", "offers": [ { "@type": "AggregateOffer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-02-23", "availabilityEnds": "2026-04-25T17:00:00+08:00", "validFrom": "2026-02-23", "lowPrice": "262.48", "highPrice": "2623.70", "price": "262.48", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-with-copilot-training/100001982102862017" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-02-23", "availabilityEnds": "", "validFrom": "2026-02-23", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-with-copilot-training/100001982102862017", "price": "2599.00", "name": "Join in Cubao" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-02-23", "availabilityEnds": "", "validFrom": "2026-02-23", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-with-copilot-training/100001982102862017", "price": "2308.73", "name": "Join in Cubao (Early Bird)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-02-23", "availabilityEnds": "", "validFrom": "2026-02-23", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-with-copilot-training/100001982102862017", "price": "2308.73", "name": "Join via Zoom (Early Bird)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-02-23", "availabilityEnds": "", "validFrom": "2026-02-23", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-with-copilot-training/100001982102862017", "price": "2623.70", "name": "Join via Zoom" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-02-23", "availabilityEnds": "", "validFrom": "2026-02-23", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-with-copilot-training/100001982102862017", "price": "1363.82", "name": "Buy 1 Take 1 (Join via Zoom)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-02-23", "availabilityEnds": "", "validFrom": "2026-02-23", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-with-copilot-training/100001982102862017", "price": "1799.00", "name": "Buy 1 Take 1 (Join in Cubao)" }, { "@type": "Offer", "availability": "https://schema.org/SoldOut", "priceCurrency": "PHP", "availabilityStarts": "2026-02-23", "availabilityEnds": "", "validFrom": "2026-02-23", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-with-copilot-training/100001982102862017", "price": "262.48", "name": "Optional Courier Service" } ], "organizer": [ { "@type": "Organization", "name": "Insights Training", "url": "https://allevents.in/org/insights-training/22581225", "description": "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." } ] } ] ```