DATA ANALYTICS USING MICROSOFT EXCEL

For Proficient Microsoft Excel Users
Download Registration Form

Click here for all class schedules

Venue:  Suite 1503A, West Tower, Philippine Stock Exchange Bldg., Exchange Road, Ortigas Center, Pasig City

Schedule 2020: Jun 15-16  |  Sep 1-2  |  Nov 16-17

Course Description

Conducted by a Certified Microsoft Trainer, 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 attended the Advanced Microsoft Office Excel
Hardware/Software Requirements
  • Microsoft Excel 2016 / 2019 Office 365 version 
  • At least 8GB RAM (Memory)
  • Mac laptop/ Mac book version is not allowed

What to Bring

  • Your laptop.
What You will Learn

At the end of the course, participants will 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 Powerpivot and Data Analysis Expressions
  • Use DAX syntax and operators
  • Use Advance Data Analysis Expressions
  • Explore Data Visualization Using Pivot Chart, Power Map and Power View
  • Demonstrate Different Visuals in Power View
Course Highlights
  1. Introduction to Excel Power Tools
  2. The Power Excel Workflow
  3. When to Use Power Query and Power Pivot in Excel
  4. The Query Editor Interface
  5. Options for Loading Data in Excel
  6. Basic Power Query Table Transformations
  7. Data Shaping with Power Query Editor
  8. Merging and Appending Queries
  9. Connecting Excel to Folder of Files
  10. Data vs Diagram Views
  11. Data Tables vs Lookup Tables
  12. Relationships vs Merge Tables
  13. Creating, Modifying Table Relationships
  14. Relationship Cardinality
  15. Connecting Multiple Tables
  16. Filter Direction
  17. Defining Hierarchies
  18. Powerpivot and data analysis expressions
  19. Power Pivot Best Practices
  20. Common DAX Functions and Categories
  21. Advance DATA Analysis Expressions
  22. The Calculate Function
  23. Time Intelligence Functions
  24. Speed and Performance Configuration
  25. Exploring Pivot Chart, Map, View
  26. DEMO: Matrix Visuals, Date Slicers, Cards and KPI’s, Text Cards, Map Visuals, Tree Maps, Line and Area Charts, Trend-lines and Forecast, Gauge Charts
Who Should Attend?

Data Analyst, Accountants, Excel Professionals, Business Intelligence Experts

Rates and Discounts
Early Bird Rate Regular Rate
Php8,500 +VAT per pax
Php9,500+VAT per pax
Notes
  • Seminar is inclusive of handout, Certificate of Completion, Lunch, Snacks & Drinks.
  • Plus: Free 1 time refresher session within 1 year (with minimal fee = Php500/day for food & handout)
  • Registration Required. Seminar schedule may change without prior notice.
  • Early Bird Rate is applicable for payments made 8 days before the seminar date.
  • Bring-a-friend promo is not applicable with other promos.
  • Pay Parking is available on a first-come, first-served basis
  • Please read our cancellation and refund policy.
Register Now!
How to Enroll in 3 Easy Steps

1

Choose Your Seminar(s)
Book a slot thru:
>Online Registration
>Download Registration Form
>Visit our Office
>Phone Booking at
Tel#: (632) 6874445|6874645
Cel / Viber: (0917) 8643416

2

Remit Payment
You may settle payment:
>at our office
>via Paypal
>via Bank Deposit:
Savings Account Name:
Businessmaker Academy, Inc.
BPI SA Acct#: 4013-0306-64
BDO SA Acct#: 000-280-622-422

3

Confirm & Attend
Please send deposit slip with your name and course via:
Fax#: 6874445 loc. 814
Viber#: (0917) 8643416
Email: info@businessmaker-academy.com
Bring deposit slip or receipt on your class
day
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..