Course Program
Maximizing Microsoft Excel
for Basic & Intermediate Users
Live Zoom Webinar:
Duration: 2 sessions x 4 hrs
Time: AM Sched = 8:30am-12:30pm | PM Sched =1:30-5:30pm
Schedule 2024: Jan 18-19 (PM) | Apr 18 (AM+PM) | Jul 11 (AM+PM) | Oct 10 (AM+PM)
Live Seminar:
Duration: 2 days x 8 hrs
Time: 9am to 5pm
Schedule 2024: Feb 1-2 | May 2-3 | Aug 22-23 | Nov 7-8
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:
| 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..