# Event Details - **Event Name**: Comprehensive MS Excel - **Event Start and End Date**: Tue, 14 Apr, 2026 at 10:00 am – Wed, 15 Apr, 2026 at 12: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/100001979641669524 - **Event Categories**: workshops - **Interested Audience**: - total_interested_count: 0 ## Ticket Details - **Ticket Price Range**: min: 2623.7, max: 5983.38, 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 - **Image URL**: https://cdn-az.allevents.in/events2/banners/6933ac4000357a2daa3d559a5b01f3f51610cd532805a6f7af9ef9616a6fa036-rimg-w1200-h659-dcffffff-gmir.jpg?v=1767702076 ## FAQs - **Q**: When and where is Comprehensive MS Excel being held? - **A:** Comprehensive MS Excel takes place on Tue, 14 Apr, 2026 at 10:00 am to Wed, 15 Apr, 2026 at 12:00 pm at Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines. - **Q**: How much do tickets cost for Comprehensive MS Excel? - **A:** Ticket prices for Comprehensive MS Excel range from PHP 2,624 to PHP 5,983 depending on the ticket type. Here's a full breakdown of available ticket types:Ticket TypePriceAvailabilityJoin in CubaoPHP 5,983 + PHP 284 feeAvailableEarly Bird (Cubao)PHP 5,458 + PHP 259 feeAvailableJoin via ZoomPHP 4,933 + PHP 234 feeAvailableEarly Bird (via Zoom)PHP 4,409 + PHP 210 feeAvailable2 for 1 Admission (via Zoom)PHP 2,624 + PHP 125 feeAvailable - **Q**: Who is organizing Comprehensive MS Excel? - **A:** Comprehensive MS Excel is organized by Mpower Learning Manila. - **Q**: Who is this event for? Is it right for me? - **A:** Comprehensive MS Excel 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 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", "image": "https://cdn-az.allevents.in/events2/banners/6933ac4000357a2daa3d559a5b01f3f51610cd532805a6f7af9ef9616a6fa036-rimg-w1200-h659-dcffffff-gmir.jpg?v=1767702076", "startDate": "2026-04-14T10:00:00+08:00", "endDate": "2026-04-15T12:00:00+08:00", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel/100001979641669524", "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-01-05", "availabilityEnds": "2026-04-15T12:00:00+08:00", "validFrom": "2026-01-05", "lowPrice": "2623.70", "highPrice": "5983.38", "price": "2623.70", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel/100001979641669524" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-01-05", "availabilityEnds": "", "validFrom": "2026-01-05", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel/100001979641669524", "price": "5983.38", "name": "Join in Cubao" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-01-05", "availabilityEnds": "", "validFrom": "2026-01-05", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel/100001979641669524", "price": "5458.43", "name": "Early Bird (Cubao)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-01-05", "availabilityEnds": "", "validFrom": "2026-01-05", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel/100001979641669524", "price": "4933.48", "name": "Join via Zoom" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-01-05", "availabilityEnds": "", "validFrom": "2026-01-05", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel/100001979641669524", "price": "4408.53", "name": "Early Bird (via Zoom)" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "PHP", "availabilityStarts": "2026-01-05", "availabilityEnds": "", "validFrom": "2026-01-05", "url": "https://allevents.in/mandaluyong-city/comprehensive-ms-excel/100001979641669524", "price": "2623.70", "name": "2 for 1 Admission (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." } ] } ] ```