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 2025: Jan 20 (AM/PM) | Apr 7 (AM/PM) | Jul 21 (AM/PM) |
Oct 6 (AM/PM)
Live Seminar:
Duration: 2 days x 8 hrs
Time: 9am to 5pm
Schedule 2025: Feb 10-11 | May 19-20 | Aug 18-19 | Nov 4-5
Course Description
This training program provides you with the fundamental competencies for Microsoft Excel.
Basic Microsoft Excel teaches you how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Basic skill sets are discussed in more detail, exploring at a higher-level different options that can be applied for that skill set.
Intermediate Microsoft Excel is designed for learners who want to expand their knowledge in Improving, Formatting, Organizing Data and Highlighting Key Information and Key Formulas / Links between sheets. The course advances the user’s knowledge of functions, demonstrate how to manage data with excel and explore the dashboard feature of Excel.
Prerequisites
Learning Objectives
By the end of this course, the participants shall be able to:
- Operate basic and intermediate functions of Microsoft Excel
- Navigate user interface & tools with ease
- Perform Calculations in Excel
- Create, modify, format and print worksheets or workbooks
- Use Excel Data reference
- Create Charts and Dashboards
- Consolidate data and manage Excel content
- Audit Workbooks and Trace Error for corrections
Course Topic Highlights
- Creating a Basic Worksheet
- Explore User Interface & Ribbon
- Customize the Quick Access Toolbar
- Performing Calculations
- Basic Formulas & Functions
- Modifying a Worksheet
- Search for Data in a Worksheet
- Spell Check a Worksheet
- Formatting a Worksheet
- Cell Styles
- Print Options & Page Breaks
- Managing Large Workbooks
- Excel Data Reference
- Defining Names in Excel
- Using Functions: Info, Date & Database
- Creating Charts & Dashboards
- Design Options & Chart Format Tools
- Data Consolidation: Sorting & Filtering
- Managing Excel Content
- Conditional Formatting
- Auditing Workbooks
- Formula Auditing and Error Tracing
- Error Checking
- Track Changes
Who Should Attend?
This course is intended for novice information workers who want to learn beginning to 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..