Live Webinar: Data Analytics Using Microsoft Excel for Proficient Users
Live Webinar: Data Analytics Using Microsoft Excel for Proficient Users
Mon
01:30 PM - 05:30 PM
Online
Mon
08:30 AM - 12:30 PM
Online
×
Rates
Select ticket type and number of attendees.
Live Webinar: Data Analytics Using Microsoft Excel for Proficient Users
sale ends on 10/19/25
2,520.00
×
 You've been added to the Waitlist. We'll email you once a slot becomes available.
Live Webinar: Data Analytics Using Microsoft Excel for Proficient Users
sale ends on 10/19/25
2,520.00
×
 You've been added to the Waitlist. We'll email you once a slot becomes available.
Join the Waitlist to be notified when a slot opens for this schedule.  You've been added to the Waitlist.
We'll email you once a slot becomes available.
Selection Summary
Total Amount
Credit/Debit Card
Credit/Debit Card
Online Banking
OTC Bank
Remittance
Training Details
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. 

Pre-requisites
Participants must have advanced Excel knowledge and must bring their own laptop to apply the lessons and work on exercises.

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


Outline
  1. Excel Power Tools: Set Up in COM Add-Ins
  2. When to Use Power Query & Power Pivot in Excel
  3. Power Query Editor Interface
  4. Data Shaping with Power Query Editor
  5. Text/Number/Data-specific Tools
  6. Creating a Rolling Calendar
  7. Index & Conditional Columns
  8. Grouping & Aggregating Data
  9. Pivoting & Unpivoting Data
  10. Advanced Power Query Editor
  11. Merging & Appending Queries
  12. Connecting Excel to Folder of Files
  13. Excel’s Data Model
  14. Creating Table Relationships
  15. Connecting Multiple Tables
  16. Power Pivot & Data Analysis Expressions
  17. DAX Syntax & Operators
  18. Advanced Data Analysis Expressions
  19. Data Visualization Using Pivot Chart, Power Map, and Power View
  20. Pivot Chart, Power Map, and Power View
  21. Different Visuals in Power View
  22. DEMO: Matrix Visuals, Date Slicers, Cards & KPIs, Text Cards, Map Visuals, Tree Maps, Line & Area Charts, Trend-lines & Forecast, Gauge Charts
404 Courses • 2 Events
Business maker Academy, Inc. is an Education Center for Business, Finance, Human Resources and Corporate Skills Development. We offer a simple, direct and practical approach to business training.

Our primary purpose is to teach people how to improve their professional, personal and financial lives through experience-based learning.

We are an Accredited Training Provider for the Civil Service Commission (CSC) & Philippine Government E-Procurement System (Philgeps). Since 2003, Business Maker Academy has conducted numerous seminars and has served over 100,000++ highly satisfied clients and counting…
Contact Us
1503A PSEC, West Tower, Ortigas Center Pasig City,
Pasig, Metro Manila, Philippines 1605
86874445
Sending Message
Please wait...
Loading...