Data Analytics Using Microsoft Excel for Proficient Users
Live Zoom Webinar:
Duration: 2 sessions x 4 hrs
Time: AM Sched = 8:30am-12:30pm | PM Sched = 1:30-5:30pm
Schedule 2025: Apr 28 (AM/PM) | Oct 20 (AM/PM)
Live Seminar:
Duration: 2 day x 8 hrs
Time: 9am to 5pm
Schedule 2025: By Special Arrangement
Course Description
This 2-day program is designed for advanced Excel Users to take their Excel Skills to the next level. Learn how to use the set of Power BI tools for powerful data analysis and data modelling in Microsoft Excel. With PowerPivot, you can mash up large volumes of data from various sources, perform information analysis rapidly and share insights easily. Use Power View to bring your data to life with visuals such as charts, graphs, maps and tables.
Prerequisites
Participants must have advanced 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:
- Explore the Excel power tools
- Work with the power query editor
- Handle data shaping with power query editor
- Recognize Excel’s data model
- Connect multiple tables
- Create power pivot and data analysis expressions
- Use DAX syntax and operators
- Use advanced data analysis expressions
- Explore data visualization using pivot chart, power map, and power view
- Demonstrate different visuals in power view
Course Highlights
- Excel Power Tools: Set Up in COM Add-Ins
- When to Use Power Query & Power Pivot in Excel
- Power Query Editor Interface
- Data Shaping with Power Query Editor
- Text/Number/Data-specific Tools
- Creating a Rolling Calendar
- Index & Conditional Columns
- Grouping & Aggregating Data
- Pivoting & Unpivoting Data
- Advanced Power Query Editor
- Merging & Appending Queries
- Connecting Excel to Folder of Files
- Excel’s Data Model
- Creating Table Relationships
- Connecting Multiple Tables
- Power Pivot & Data Analysis Expressions
- DAX Syntax & Operators
- Advanced Data Analysis Expressions
- Data Visualization Using Pivot Chart, Power Map, and Power View
- Pivot Chart, Power Map, and Power View
- Different Visuals in Power View
- DEMO: Matrix Visuals, Date Slicers, Cards & KPIs, Text Cards, Map Visuals, Tree Maps, Line & Area Charts, Trend-lines & Forecast, Gauge Charts
Who Should Attend?
This course is intended for Data Analyst, Accountants, Excel Professionals, Business Intelligence Experts or any proficient Microsoft Excel users who want to take their skills to the next level.
Rate:
| Webinar: |
|---|
|
Php4,500 + VAT |
| Seminar: |
|---|
|
Php8,500 + VAT |
Notes:
- Live Webinars are conducted via Zoom and includes: eCertificate of Completion. Printed Certificates may be requested with minimal processing fee of Php100 plus shipping fee.
- Live Seminars will be held at Businessmaker Training Center in PSEC-Tektite, Ortigas Center, Pasig City. Regular Seminars include: Certificate of Completion, Seminar Kit, Meals and Drinks.
- Live Seminars include non-transferable one-time refresher seminar session within one year.
PAYMENT METHODS:
You may pay via check at our office or you may use any of these payment facilities:
Bank Deposit
Bank Account Name: Business Maker Academy, Inc.
Bank Account Numbers:
BPI SA# 4013-0306-64
BDO SA# 000-280-622-422
Landbank CA# 3732114830
Paypal/Credit Card
We accept paypal or credit card payments. If you wish to use this payment method, pls register and click on paypal as your mode of payment. Our representatives will contact you to provide our official paypal link and assist you in processing payment.
Dragonpay
We accept payments via e-wallets, credit card, online banking or over-the-counter payment centers via Dragonpay. Pls register and choose Dragonpay payment method. Our representative will contact and provide you with our Dragonpay link and assist in processing.
Gcash
We accept Gcash payments. Pls register and pay using this QR code.
DON'T FORGET TO CONFIRM YOUR BOOKING
CONFIRM TO ATTEND THE CLASS:
Please send your proof of payment and include your name, course & class date to:
Viber#: (0912) 2231826 or
Email: info@businessmaker-academy.com
Important Note: Business Maker Academy Inc. is a VAT-registered company. TIN# 223-672-691-000 VAT. For zero rated or VAT exempt companies, please include your Certificate of Exemption. Provide Form 2307 or Certificate of Tax Withheld if payment done with tax withheld. Please withhold only 2% as we are classified as suppliers or contractors of service.All bank payments should be directly deposited to our official company bank accounts only under account name:
Business Maker Academy, Inc. Please be advised that no other individual/personal bank account is authorized to collect payment on behalf of the company..