# Event Details - **Event Name**: Comprehensive MS Excel (Basic to Advanced) - **Event Start and End Date**: Mon, 22 Jun, 2026 at 08:00 am – Tue, 23 Jun, 2026 at 05:00 pm (+08:00) - **Event Description**: This training includes a thorough review of the basics and a thorough discussion of the advanced topics.About this EventThis training includes a thorough review of the basics and a thorough discussion of the advanced topics. There are more exercises and participants will be exposed to various practical and complicated scenarios.1. Basic to Advanced MS Excel FunctionsText FunctionsCombining Texts (CONCATENATE)Extracting Values from Texts (LEFT, RIGHT, MID)Changing Case (UPPER, LOWER, PROPER)Accessory Text Functions (TRIM, VALUE, SUBSTITUTE)TEXTJOIN, TEXTSPLIT, TEXTBEFORE, etc.*Logical FunctionsBasic IF StatementsNested and Series IF StatementsLogic Statements with AND and ORMath FunctionsBasic Math Functions (SUM, AVERAGE, MAX, MIN, COUNT)Named RangesConditional Math Functions (COUNTIF, SUMIF, AVERAGEIFS, etc.)Handling Date and Time ProblemsCalculating Working DaysCalculating Age and Other Date-Related ProblemsShortening Long Formulas with ArraysLookup FunctionsVLOOKUPAdvanced Usage of VLOOKUPINDEX and MATCHXLOOKUP2. Data Tab and Other ToolsWorksheet Formatting Tools (Sort, Filter, Format, Merge, etc.)Text-to-ColumnsConditional FormattingBasic Conditional FormattingFormula-Based FormatData ValidationBasic Dropdown Menus and Cell ValidationsAdvanced Dropdown MenusAdvanced Data Validation ScenariosSubtotal ToolWorksheet Security: Locking Cells and File Passwords3. Data Visualizations with ChartsBasic ChartsCombination ChartsSparklinesUsing INDIRECT to Create Dynamic ChartsSpecial Chart Types4. Analyzing and Presenting Data Using PivotTables and Pivot ChartsBasic PivotTable FeaturesRefresh and Change Data SourceCreating Calculated FieldsConstructing Reports using PivotTablesGrouping DataUsing SlicersCreating Pivot ChartsCreating Dashboards using PivotCharts4. Error HandlingUnderstanding Errors in FormulasSolving Errors in Formulas5. Introduction to MacrosUnderstanding Macro SecurityMacro RecordingAssigning Macros to Images and Buttons6. Data Modeling using PowerPivot (Combining and Analyzing Multiple Data Sources)Getting External Data using Power QueryGetting Data from FileConsolidating Files in a FolderData Modeling in PowerPivotCreating PivotTables from PowerPivot - **Event URL**: https://allevents.in/mandaluyong-city/comprehensive-ms-excel-basic-to-advanced/100001988262885814 - **Event Categories**: workshops - **Interested Audience**: - total_interested_count: 0 ## Ticket Details - **Ticket Price Range**: min: 4408.53, max: 10394.01, 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**: Comprehensive MS Excel (Basic to Advanced) - **Image URL**: https://cdn-az.allevents.in/events2/banners/146f99332ddd9591990e349f87e03241df36f9d9f04ee2d8b4c21aee242afded-rimg-w1200-h659-dcffffff-gmir.jpg?v=1777383908 ## FAQs - **Q**: When and where is Comprehensive MS Excel (Basic to Advanced) being held? - **A:** Comprehensive MS Excel (Basic to Advanced) takes place on Mon, 22 Jun, 2026 at 08:00 am to Tue, 23 Jun, 2026 at 05:00 pm at Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines. - **Q**: Who is organizing Comprehensive MS Excel (Basic to Advanced)? - **A:** Comprehensive MS Excel (Basic to Advanced) is organized by Mpower Learning Manila. - **Q**: Who is this event for? Is it right for me? - **A:** Comprehensive MS Excel (Basic to Advanced) 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 Comprehensive MS Excel (Basic to Advanced) 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": "Comprehensive MS Excel (Basic to Advanced)", "image": "https://cdn-az.allevents.in/events2/banners/146f99332ddd9591990e349f87e03241df36f9d9f04ee2d8b4c21aee242afded-rimg-w1200-h659-dcffffff-gmir.jpg?v=1777383908", "startDate": "2026-06-22T08:00:00+08:00", "endDate": "2026-06-23T17:00:00+08:00", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel-basic-to-advanced/100001988262885814", "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 training includes a thorough review of the basics and a thorough discussion of the advanced topics.", "offers": [ { "@type": "AggregateOffer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-04-28", "availabilityEnds": "2026-06-23T17:00:00+08:00", "validFrom": "2026-04-28", "lowPrice": "4408.53", "highPrice": "10394.01", "price": "4408.53", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel-basic-to-advanced/100001988262885814" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-04-28", "availabilityEnds": "", "validFrom": "2026-04-28", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel-basic-to-advanced/100001988262885814", "price": "5983.38", "name": "Join in Cubao" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-04-28", "availabilityEnds": "", "validFrom": "2026-04-28", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel-basic-to-advanced/100001988262885814", "price": "5458.43", "name": "Early Bird (Cubao)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-04-28", "availabilityEnds": "", "validFrom": "2026-04-28", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel-basic-to-advanced/100001988262885814", "price": "4933.48", "name": "Join via Zoom" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-04-28", "availabilityEnds": "", "validFrom": "2026-04-28", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel-basic-to-advanced/100001988262885814", "price": "4408.53", "name": "Early Bird (via Zoom)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-04-28", "availabilityEnds": "", "validFrom": "2026-04-28", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel-basic-to-advanced/100001988262885814", "price": "10394.01", "name": "Bundle for 2 (Join in Cubao)" } ], "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." } ] } ] ```