Microsoft Excel for Advanced Users - Course by Businessmaker Academy
Online Learning: Live Webinar

Mastering Microsoft Excel
for Advanced Users

Zoom Webinar Schedule:  Jul 17-18  (1:30-5:30 pm | 2 sessions: 4 hrs = Total 8 hrs.)
Live Seminar Schedule 2020:
  Aug 17-18  |  Oct  29-30  |  Dec  17-18
(9am-5pm | 2-day seminar)
Course Description

Conducted by a Certified Microsoft Trainer, this course will give you a deep understanding of the Advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. We teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. This course also gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts.

Pre-requisites
  • Basic – Intermediate Microsoft Office Excel
  • Participants must use their own laptop to apply lessons and work on exercises.
Hardware/Software Requirements
  • Microsoft Excel 2016 / 2019 version
  • Mac laptop/ Mac book version is not applicable
What you'll learn

At the end of the course, participants will be able to:

  • Simplify complex formulas using Name Manager
  • Apply different Excel formulas like Text, Date, Logical and Lookup Functions
  • Join datasets from multiple sources with Excel’s LOOKUP, INDEX & MATCH functions
  • Create Dynamic Reports and Dashboards using Pivot Tables and Charts
  • Automate Reports using Macro Recording Tools
Course Outline

TRACK 1: IDENTIFY AND DEFINE THE ESSENTIAL COMPONENTS OF EXCEL FORMULAS
a. Define Names on Cell References
b. Using Create from Selection Method in Name Manager
c. Application of Indirect formula with Name Manager
d. Simplify the ff. Number Functions SUM, COUNT AVERAGE, MAX MIN with Name Manager

TRACK 2: PERFORMING ADVANCED FORMULAS
a. Create Solutions in TEXT data using the ff. text functions Change Case, Trim Case, Combine Case and Find and Replace text methods.
b. Formulate Date and Time functions to streamline aging report
c. Using IF condition and Logical functions like SUMIFS, COUNTIFS, AVERAGEIFS to create dynamic reporting in Excel
d. Use Lookup Functions to simplify IF condition formulas.
e. Application for Lookup functions with Name Manager and Data Validation.

TRACK 3: PERFORM DATA SECURITY AND VALIDATION
a. Create user input validation using data validation method
b. Create a user-friendly drop-down tool for data validation
c. Manage a read-only worksheet using Protect Sheet and Protect Workbook capabilities
d. Add security passwords to your excel file using file protection method.

TRACK 4: MANAGING BIG DATA IN EXCEL
a. Creating Reports using Subtotal
b. Application of Advanced filter

Who Should Attend?

This course is intended for novice information workers who want to learn advanced-level Excel skills.

Rate:
live webinar only:
Php3,500 + VAT
webinar + seminar:
Php8,500 + VAT
Notes:
  • Live Webinars are conducted via Zoom and includes: eCertificate of Completion, Access for Recorded Webinar, Supplementary materials.
  • 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.
  • Live Seminar Enrollees who have not yet attended their live seminars due to ECQ are automatically enrolled in Live Webinar + Seminar program. Please contact us to book your slot.
REGISTER NOW!
Choose your registration & payment method below
Online Enrollment & Payment Process:
Bank Deposit
  1. Choose Your Online Course(s)
    >Register Online or
    >Book via our ECQ Hotline:
    Landline: (632) 7957-7937, | 7219-1039
    Cel / Viber: (0912) 2231826, (0917) 6372471
  2. Remit Payment via Bank Deposit:
    Account Name: Business Maker Academy, Inc.
    BPI SA Acct#: 4013-0306-64
    BDO SA Acct#: 000-280-622-422
  3. Confirm & Attend:
    Please send deposit slip/bank transaction confirmation with your name and course to:
    Viber#: (0912) 2231826 or
    Email: info@businessmaker-academy.com
    We will send you the Online Learning link wthin 24 hrs.
Paypal/Credit Card
    1. Choose Your Online Course
      Click & pay via Paypal/Credit Card Button.  Upon successful payment, you will be directed to our Online Registration Page.
    2.  Fill in and submit the Online Registration Form
      This will be the basis for your eCertificate.
    3. Confirm & Attend
      A BMA Representative will contact you and we will send you the Online Learning link within 24 hrs.  You may also contact us at:
      ECQ Hotline:
      Landline: (632) 7957-7937, | 7219-1039
      Cel / Viber: (0912) 2231826, (0917) 6372471
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..
Scroll to Top