# Event Details - **Event Name**: Comprehensive MS Excel (Basic to Advanced) - **Event Start and End Date**: Mon, 24 Aug, 2026 at 08:00 am – Tue, 25 Aug, 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 program develops participants’ ability to use Microsoft Excel as a powerful analytical and reporting tool rather than just a spreadsheet. Starting with essential functions and progressing toward advanced tools such as PivotTables, macros, and PowerPivot, the course equips learners with practical techniques for cleaning data, automating calculations, and presenting insights effectively. Participants will work through real-world examples to strengthen their ability to transform raw data into meaningful information for decision-making.Training Duration: 2 daysObjectivesStrengthen participants’ mastery of Excel formulas and functions for solving common business problems.Develop skills in organizing, cleaning, and validating datasets using Excel tools.Enable participants to analyze large datasets using PivotTables, charts, and dashboards.Introduce automation techniques using macros to improve efficiency.Provide foundational knowledge of data modeling and external data connections using Power Query and PowerPivot.​Who the Topic Is ForThis course is intended for professionals who regularly work with spreadsheets and want to improve their ability to analyze and present data. It is particularly suitable for analysts, supervisors, finance staff, operations personnel, administrative professionals, and anyone responsible for reporting, tracking, or decision support using Excel.MethodologiesInstructor-Led Demonstration and Guided PracticeThe facilitator demonstrates techniques step-by-step while participants replicate them using prepared datasets. Concepts are immediately reinforced through guided exercises and short challenges.Hands-On Data Analysis ActivitiesParticipants apply Excel tools to realistic business scenarios such as sales tracking, performance reporting, and data consolidation. Exercises emphasize problem-solving, interpretation of results, and best practices in spreadsheet design.Inclusions:Join in Cubao: The training includes fast food lunch, AM and PM snacks, printed handout, printed certificate, unlimited coffee and biscuitsJoin via Zoom: The training includes PDF certificate and PDF handout.Outline1. 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 MATCHXLOOKUP*2. 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 PivotCharts5. Error HandlingUnderstanding Errors in FormulasSolving Errors in Formulas6. Introduction to MacrosUnderstanding Macro SecurityMacro RecordingAssigning Macros to Images and Buttons7. 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 - **Event Highlights**: - Duration: 9 hours - Location: Mpower Learning Manila - Languages: English ## 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, 24 Aug, 2026 at 08:00 am to Tue, 25 Aug, 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-08-24T08:00:00+08:00", "endDate": "2026-08-25T17: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-08-25T17: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/SoldOut", "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/SoldOut", "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." } ] } ] ```