# Event Details

- **Event Name**: Live Seminar: Mastering Microsoft Excel for Advanced Users
- **Event Start and End Date**: Mon, 22 Jun, 2026 at 09:00 am – Tue, 23 Jun, 2026 at 05:00 pm
- **Event Description**: Course Description
This 2-day hands on course will provide you with the knowledge of more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Prerequisites
-Participants must have basic Excel knowledge and must bring their own laptop to apply the lessons and work on exercises.

Learning Objectives
By the end of this course, the participants shall be able to:
- Identify & define the essential components of Excel formulas
- Perform advanced formulas
- Identify how to format financial statements & other Excel-based reports effectively
- Perform data security & validation
- Create Excel-based charts and dashboards to aid in communicating financial data information
- Manage big data in Excel
- Use data analysis tools & pivot features
- Get introduced to macro functions & features

Course Topic Highlights
1. Essential Components of Excel Formulas
2. Relative Value & Absolute Value
3. Calculate Data Across Worksheets
4. Performing Advanced Formulas
5. Simplify Number Functions
6. Create Solutions Using Text Methods
7. Streamline Aging Report
8. Using IF Condition & Logical Functions: SUMIF, COUNTIF, AVERAGEIF
9. Lookup Functions
10. How to Format Financial Statements & Other Excel-based Reports
11. Advanced Conditional Formatting & Filtering
12. Custom Data Formats, Styles & Templates
13. Perform Data Security & Validation
14. Using Input & Drop-down Tool for Validation
15. Read-only Protected Sheet & Workbook
16. File Protection Method
17. Excel-based Charts & Dashboards for Communicating Financial Data Info
18. Application of Subtotal per Data Category
19. Managing Big Data in Excel
20. Advanced Filter with Name Manager and Logical Symbols
21. Data Analysis Tools Using Pivot Features
22. Introduction to Visual Basic & Macro Settings

Here are the rates:
Webinar Rate
Php4500 +12%VAT = Php5040
Seminar Rate
Php8500 +12%VAT = Php9520

Full details & Registration:
https://businessmaker-academy.com/live-webinar-microsoft-excel-advanced-training/

For more inquiries, you may contact us at:
Landline: (632) 8687-4645, 8687-341
Mobile/Viber: (0917) 6372471, (0912) 2231826, (0917) 1357279
Email: info@businessmaker-academy.com
www.businessmaker-academy.com
- **Event URL**: https://allevents.in/pasig/live-seminar-mastering-microsoft-excel-for-advanced-users/200030147850039
- **Event Categories**: workshops, virtual, webinar, performances, entertainment
- **Interested Audience**: 
  - total_interested_count: 0

## Ticket Details


## Event venue details

- **city**: Pasig
- **state**: MM
- **country**: Philippines
- **location**: Suite 1503a, 15th floor, West Tower, Tektite Bldg (PSEC), Exchange Road, Ortigas Center, 1605 Pasig, Philippines
- **lat**: 14.58301
- **long**: 121.0618
- **full address**: Suite 1503a, 15th floor, West Tower, Tektite Bldg (PSEC), Exchange Road, Ortigas Center, 1605 Pasig, Philippines, Pasig, Philippines

## Event gallery

- **Alt text**: Live Seminar: Mastering Microsoft Excel for Advanced Users
  - **Image URL**: https://cdn-az.allevents.in/events7/banners/9826ec30fbd82c3c65a97d12b0399d1f64a2b3980b8d14ee6403f6b5a1df5763-rimg-w596-h500-dc037673-gmir?v=1782124183

## FAQs

- **Q**: When and where is Live Seminar: Mastering Microsoft Excel for Advanced Users being held?
  - **A:** Live Seminar: Mastering Microsoft Excel for Advanced Users takes place on Mon, 22 Jun, 2026 at 09:00 am to Tue, 23 Jun, 2026 at 05:00 pm at Suite 1503a, 15th floor, West Tower, Tektite Bldg (PSEC), Exchange Road, Ortigas Center, 1605 Pasig, Philippines, Pasig, Philippines.
- **Q**: Who is organizing Live Seminar: Mastering Microsoft Excel for Advanced Users?
  - **A:** Live Seminar: Mastering Microsoft Excel for Advanced Users is organized by Business Maker Academy.
- **Q**: Who is this event for? Is it right for me?
  - **A:** Live Seminar: Mastering Microsoft Excel for Advanced Users 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 Pasig, this event is thoughtfully curated to deliver a standout experience worth every moment. If Live Seminar: Mastering Microsoft Excel for Advanced Users 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": "Live Seminar: Mastering Microsoft Excel for Advanced Users",
        "image": "https://cdn-az.allevents.in/events7/banners/9826ec30fbd82c3c65a97d12b0399d1f64a2b3980b8d14ee6403f6b5a1df5763-rimg-w596-h500-dc037673-gmir?v=1782124183",
        "startDate": "2026-06-22",
        "endDate": "2026-06-23",
        "url": "https://allevents.in/pasig/live-seminar-mastering-microsoft-excel-for-advanced-users/200030147850039",
        "location": {
            "@type": "Place",
            "name": "Suite 1503a, 15th floor, West Tower, Tektite Bldg (PSEC), Exchange Road, Ortigas Center, 1605 Pasig, Philippines",
            "address": {
                "@type": "PostalAddress",
                "name": "Suite 1503a, 15th floor, West Tower, Tektite Bldg (PSEC), Exchange Road, Ortigas Center, 1605 Pasig, Philippines, Pasig, Philippines",
                "addressLocality": "Pasig",
                "addressRegion": "MM",
                "addressCountry": "PH"
            },
            "geo": {
                "@type": "GeoCoordinates",
                "latitude": "14.58301",
                "longitude": "121.0618"
            }
        },
        "eventAttendanceMode": "https://schema.org/OfflineEventAttendanceMode",
        "description": "Course Description\nThis 2-day hands on course will provide you with the knowledge of more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data w",
        "organizer": [
            {
                "@type": "Organization",
                "name": "Business Maker Academy",
                "url": "https://allevents.in/org/business-maker-academy/2441896",
                "description": "www.businessmaker-academy.com"
            }
        ]
    }
]
```