Microsoft Excel for Basic and Intermediate Users - Course by Businessmaker Academy
Online Learning: Live Webinar

Maximizing Microsoft Excel
for Basic & Intermediate Users

Live Zoom Webinar: 2 sessions x 4 hrs | AM =8:30am-12:30pm | PM =1:30-5:30pm
Schedule 2021: Jan 14-15 (PM) | Apr 22-23 (AM) | Jul 27-28 (AM) | Oct 14-15 (PM)
Course Description

Conducted by a Certified Microsoft Trainer, this Microsoft Excel Basic to Intermediate training course is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles.

Pre-requisites
  • Participants must have basic computer skills.
  • Participants use own laptop to apply lessons and work on exercises.
Hardware/Software Requirements
  • Microsoft Excel 2016 / 2019 version 
  • Mac laptop/ Mac book version is not allowed
What you'll learn

By the end of the course you’ll be writing robust, elegant formulas and functions from scratch, allowing you to:

  • Manipulate dates, times, text, logical functions
  • Go rogue and design your own formula-based Excel formatting rules
  • Create Dynamic Dashboards and reports using Excel Chart tools
  • Analyze and consolidate your data using Excel reporting tools
Course Outline

TRACK 1: EXCEL DATA REFERENCE
a. Introduction to Excel Spreadsheet Intermediate Level
b. Defining Names in Excel

TRACK 2: APPLYING EXCEL FUNCTIONS
a. Functions within Excel
b. Text Related Functions
c. Understanding Date and Time Function
d. Logical Functions
e. Database Functions

TRACK 3: EXCEL FORMATTING TOOLS
a. The Format Cells Dialogue Box
b. Conditional Formatting
c. Formula Based formatting

TRACK 4: DATA VISUALIZATION
a. Principles of Data Visualization
b. Creating Basic Charts and Dashboard
c. Application of Different Chart Types in Microsoft Excel

TRACK 5: REPORT CONSOLIDATION IN MS EXCEL
a. Using Basic Sort and Filter Methods
b. Application of Basic Subtotal
c. Consolidate Feature of Microsoft Excel

TRACK 6: WHAT IF ANALYSIS METHODS
a. The use of Goal Seek
b. Creating Scenario Manager
c. Applying Data Tables

Who Should Attend?

This course is intended for novice information workers who want to learn intermediate-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