# Event Details - **Event Name**: Advanced MS Excel (Level 2) - **Event Start and End Date**: Mon, 28 Sep, 2026 at 07:00 pm – Sat, 21 Nov, 2026 at 04:30 pm (+08:00) - **Event Description**: Designed for users who already know the basic and intermediate features of Excel but need to handle more complex reporting and analysis.About this EventAdvanced Excel Training Level 2 is designed for users who already know the basic and intermediate features of Excel but need to handle more complex reporting, analysis, automation, and data preparation tasks. This course focuses on strengthening formula logic, improving lookup and criteria-based calculations, using modern MS365 functions, building better PivotTable reports, preparing data through PowerQuery and PowerPivot, and introducing macros for task automation. The training is practical and output-based, with emphasis on solving real workplace spreadsheet problems more efficiently and accurately.By the end of the training, participants should be able to:Troubleshoot common Excel errors and solve complex spreadsheet problems.Build advanced logical formulas using nested IFs, AND, OR, and formula-based conditional formatting.Apply advanced lookup techniques using XLOOKUP, INDEX/MATCH, INDIRECT, OFFSET, and wildcards.Create advanced criteria-based calculations using SUMIFS, COUNTIFS, date formulas, and wildcard conditions.Use arrays and modern MS365 functions to shorten and simplify long formulas.Prepare, clean, and combine data using PowerQuery and PowerPivot.Create advanced PivotTable reports, dashboards, and alternative summary outputs.Understand macro security and record basic macros for task automation.​Who This Training Is ForThis training is ideal for Excel users who regularly prepare reports, consolidate data, analyze transactions, monitor performance, or build reusable spreadsheet templates. It is best suited for staff, supervisors, analysts, finance personnel, HR personnel, operations personnel, administrative professionals, and team leaders who already know basic Excel and want to improve speed, accuracy, and confidence in handling complex workbooks.MethodologiesGuided Demonstration and Formula WalkthroughsThe trainer will demonstrate each major function, tool, and technique using sample workplace scenarios. Participants will see how formulas are built step by step, how errors are diagnosed, and how different solutions can be compared.Hands-On Spreadsheet ExercisesParticipants will complete practical exercises involving lookup problems, criteria-based summaries, date calculations, arrays, PivotTables, PowerQuery, PowerPivot, dashboards, and macro recording. Activities will focus on realistic Excel tasks that participants can adapt to their own work.OutlinePart 1. Review of Excel FunctionsReview of Excel FunctionsQuick Review of Excel FunctionsTroubleshooting Excel Error MessagesSolving Complex Problems in ExcelPart 2. Advanced Logical StructuresAdvanced Logical StructuresCombining AND and OR in One FormulaComplex Nested IFsAdvanced Conditional Formatting (Formula-Based)Part 3. Advanced Lookup ScenariosAdvanced Lookup Scenarios for XLOOKUP, INDEX/MATCH, INDIRECTLooking Up Matrices using OFFSETUsing INDIRECT Function to Lookup Several TabsCreating Advanced Dropdowns using INDIRECTUsing Wildcards to Deal with Inconsistent Arguments/Lookup ValuesPart 4. Advanced FormulasAdvanced Criteria in SUMIFS, COUNTIFS, etc.Dealing with Intermediate to Advanced Date Problems (Tenure, Ageing, etc.)Using Wildcards with SUMIFSPart 5. Using Arrays to Shorten FormulasUsing Arrays to Shorten FormulasArray 1: Merging Ranges within a FormulaArray 2: Merging Formulas into one FormulaArray 3: Combining Criteria in SUMIFSPart 6. Using New MS365 Functions and Features in ExcelUsing MS365 Functions in ExcelShortening Formulas using LET and LAMBDA FunctionUsing Modern Functions: TEXTSPLIT, IFS, XLOOKUP, etc.Maximizing the FILTER FunctionVSTACK and HSTACK and Their ApplicationsWRAPCOLS and WRAPROWS FunctionsExploring New Charts in ExcelMap ChartsWaterfall ChartsPart 7. PowerPivot Data Modeling and Data Cleaning ToolsConnecting Data to Power PivotPowerPivot to Combine Tables into One Pivot TableIntroduction: Using PowerQuery to Extract and Fix Data from Other SourcesPart 8. Advanced PivotTable CustomizationCreating Advanced Calculations in PivotTablesCreating DashboardsUsing PIVOTBY and GROUPBY Alternative to PivotTablesPart 9. Introduction to MacrosIntroduction to MacrosUnderstanding Macro Security:Exploring Macro Security SettingsMacro Recording:Recording and Implementing Macros for Task Automation and Efficiency. - **Event URL**: https://allevents.in/mandaluyong-city/advanced-ms-excel-level-2/100001994125488015 - **Event Categories**: workshops - **Slot details of has slots**: - **Interested Audience**: - total_interested_count: 0 - **Event Highlights**: - Duration: 21 hours 30 minutes - Location: Mpower Learning Manila - Languages: English ## Ticket Details - **Ticket Price Range**: min: 1888.77, max: 5248.45, 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 gallery - **Alt text**: Advanced MS Excel (Level 2) - **Image URL**: https://cdn-az.allevents.in/events3/banners/75d21a0b2776727f2561aca6b699659333f74963120a267231d614d2c65a19a5-rimg-w1200-h669-dc178a1d-gmir.jpg?v=1784216011 ## FAQs - **Q**: When and where is Advanced MS Excel (Level 2) being held? - **A:** Advanced MS Excel (Level 2) takes place on Mon, 28 Sep, 2026 at 07:00 pm to Sat, 21 Nov, 2026 at 04:30 pm at Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines. - **Q**: Who is organizing Advanced MS Excel (Level 2)? - **A:** Advanced MS Excel (Level 2) is organized by Mpower Learning Manila. - **Q**: Who is this event for? Is it right for me? - **A:** Advanced MS Excel (Level 2) is ideal for curious learners, students, and skill-builders looking to gain hands-on knowledge and practical expertise in a focused, interactive setting. Whether you're a first-time attendee or a longtime enthusiast in Mandaluyong City, this event is thoughtfully curated to deliver a standout experience worth every moment. If Advanced MS Excel (Level 2) sounds like your kind of event, don't wait - spots fill up fast. ## Structured Data (JSON-LD) ```json [ { "@context": "https://schema.org", "@type": "Event", "name": "Advanced MS Excel (Level 2)", "image": "https://cdn-az.allevents.in/events3/banners/75d21a0b2776727f2561aca6b699659333f74963120a267231d614d2c65a19a5-rimg-w1200-h669-dc178a1d-gmir.jpg?v=1784216011", "startDate": "2026-09-28T19:00:00+08:00", "endDate": "2026-11-21T16:30:00+08:00", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-level-2/100001994125488015", "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": "Designed for users who already know the basic and intermediate features of Excel but need to handle more complex reporting and analysis.", "offers": [ { "@type": "AggregateOffer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "2026-11-21T16:30:00+08:00", "validFrom": "2026-07-16", "lowPrice": "1888.77", "highPrice": "5248.45", "price": "1888.77", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-level-2/100001994125488015" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-level-2/100001994125488015", "price": "2728.69", "name": "Join in Cubao" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-level-2/100001994125488015", "price": "2098.75", "name": "Join via Zoom" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-level-2/100001994125488015", "price": "2308.73", "name": "Join in Cubao (Early Bird)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-level-2/100001994125488015", "price": "1888.77", "name": "Join via Zoom (Early Bird)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-level-2/100001994125488015", "price": "5248.45", "name": "Bundle for 2 (Join in Cubao)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-07-16", "availabilityEnds": "", "validFrom": "2026-07-16", "url": "https://allevents.in/mandaluyong-city/advanced-ms-excel-level-2/100001994125488015", "price": "3988.57", "name": "Bundle for 2 (Join via Zoom)" } ], "organizer": [ { "@type": "Organization", "name": "Mpower Learning Manila", "url": "https://allevents.in/org/mpower-learning-manila/21061446", "description": "We are the latest training center in the Philippines offering value-focused training services." } ] } ] ```