

# 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 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%2Fcomprehensive-ms-excel-tickets-1979641669524
- **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 Organizer details

- **affiliate_id**: 10
- **organizer**: Mpower Learning Manila (https://allevents.in/org/mpower-learning-manila/21061446)

## Event gallery

- **Alt text**: banner
  - **Image URL**: https://cdn-az.allevents.in/events2/banners/6933ac4000357a2daa3d559a5b01f3f51610cd532805a6f7af9ef9616a6fa036-rimg-w1200-h659-dcffffff-gmir.jpg?v=1767702076
- **Alt text**: thumbnail
  - **Image URL**: https://cdn-az.allevents.in/events2/banners/7511ce0286e1512b1975def011c9c4ad136d8d23d619a295502872e3292afe5d-rimg-w400-h400-dc1dbb7e-gmir.jpg?v=1767702076

## FAQs

- **Q**: When is the event happening?
  - **A:** Tue, 14 Apr, 2026 at 10: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 2623.7 up to 5983.38 PHP
- **Q**: Who is organizing the event?
  - **A:** Mpower Learning Manila
- **Q**: What type of event is this?
  - **A:** workshops
- **Q**: Where can I find ticket details about Comprehensive MS Excel ?
  - **A:** You can find ticket details about this event on AllEvents.

## 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."
            }
        ]
    }
]
```