Microsoft Excel for Advanced Users
Live Zoom Webinar:
Duration: 2 sessions x 4 hrs
Time: AM Sched = 8:30am-12:30pm | PM Sched = 1:30-5:30pm
Schedule 2025: Jan 21 (AM/PM) | Apr 8 (AM/PM) | Jul 22 (AM/PM) | Oct 7 (AM/PM)
Live Seminar:
Duration: 2 days x 8 hrs
Time: 9am to 5pm
Schedule 2025: Mar 3-4 | Jun 23-24 | Sep 8-9 | Dec 9-10
Course Description
This 2-day hands on course will provide you with the knowledge of more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
Prerequisites
Participants must have basic Excel knowledge and must bring their own laptop to apply the lessons and work on exercises.
Learning Objectives
By the end of this course, the participants shall be able to:
- Identify & define the essential components of Excel formulas
- Perform advanced formulas
- Identify how to format financial statements & other Excel-based reports effectively
- Perform data security & validation
- Create Excel-based charts and dashboards to aid in communicating financial data information
- Manage big data in Excel
- Use data analysis tools & pivot features
- Get introduced to macro functions & features
Course Topic Highlights
- Essential Components of Excel Formulas
- Relative Value & Absolute Value
- Calculate Data Across Worksheets
- Performing Advanced Formulas
- Simplify Number Functions
- Create Solutions Using Text Methods
- Streamline Aging Report
- Using IF Condition & Logical Functions: SUMIF, COUNTIF, AVERAGEIF
- Lookup Functions
- How to Format Financial Statements & Other Excel-based Reports
- Advanced Conditional Formatting & Filtering
- Custom Data Formats, Styles & Templates
- Perform Data Security & Validation
- Using Input & Drop-down Tool for Validation
- Read-only Protected Sheet & Workbook
- File Protection Method
- Excel-based Charts & Dashboards for Communicating Financial Data Info
- Application of Subtotal per Data Category
- Managing Big Data in Excel
- Advanced Filter with Name Manager and Logical Symbols
- Data Analysis Tools Using Pivot Features
- Introduction to Visual Basic & Macro Settings
Who Should Attend?
This course is intended for novice information workers who want to learn advanced level Excel skills. Administrative Officers, Finance Officers, Department Managers, Assistants and all office workers who want to learn advanced functions of Microsoft Excel program must attend this course.
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..