Maximizing Microsoft Excel for Basic & Intermediate Users

Download Registration Form

Click here for all class schedules

Venue:  Suite 1503A, West Tower, Philippine Stock Exchange Bldg., Exchange Road, Ortigas Center, Pasig City

Manila Schedule 2020: Feb 6-7  |  Mar 26-27  |  May 25-26  | Jul 20-21  |  Sep 21-22  |  Nov  26-27

Cebu Schedule 2020: May 4-5

Course Description
Conducted by a Certified Microsoft Trainer, this 2-day hands-on seminar provides you with the fundamental know-how and 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. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher-level different options that can be chosen or 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.
Pre-requisites
  • Participants must have basic computer skills.
  • Participants must bring 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 allowed
What you'll learn
At the end of the course, participants will be able to:
  • Operate basic and intermediate functions of Microsoft Excel
  • Navigate user interface and 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 Highlights
  1. Creating Basic Worksheet
  2. Explore User Interface & Ribbon
  3. Navigate and Select in Excel
  4. Customize the Quick Access Toolbar
  5. Create, Modify, Format Basic Worksheets
  6. Calculate with Formulas and Functions
  7. Printing Workbook Contents
  8. Managing Large Workbooks
  9. Format Worksheet Tabs
  10. Managing and Viewing Large Worksheets in a Workbook
  11. Excel Data Reference
  12. Defining Names in Excel
  13. Using Functions with Excel
  14. Creating Charts and Dashboards
  15. Chart Desgin options, Format Tools & Combo Charts
  16. Data Consolidation
  17. Conditional Formatting
  18. Formula Auditing
  19. Change Tracking
  20. Error Tracing
Who Should Attend?
This course is intended for novice information workers who want to learn beginning to intermediate level Excel skills. Administrative Officers, Finance Officers, Department Managers, Assistants and all office workers who want to learn essential functions of Microsoft Excel program must attend this course.
Rates and Discounts
Early Bird Rate Regular Rate
Php8,500 +VAT per pax
Php9,500+VAT per pax
Notes
  • Seminar is inclusive of handout, Certificate of Completion, Lunch, Snacks & Drinks.
  • Plus: Free 1 time refresher session within 1 year (with minimal fee = Php500/day for food & handout)
  • Registration Required. Seminar schedule may change without prior notice.
  • Early Bird Rate is applicable for payments made 8 days before the seminar date.
  • Bring-a-friend promo is not applicable with other promos.
  • Pay Parking is available on a first-come, first-served basis
  • Please read our cancellation and refund policy.
Register Now!

1

Choose Your Seminar(s)
Book a slot thru:
>Online Registration
>Download Registration Form
>Visit our Office
>Phone Booking at
Tel#: (632) 8687-4445 | 8687-4645
Cel / Viber: (0917) 8643416

2

Remit Payment
You may settle payment:
>at our office
>via Paypal
>via Bank Deposit:
Savings 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 with your name and course via:
Fax#: (632) 8687-4445 loc. 814
Viber#: (0917) 8643416
Email: info@businessmaker-academy.com
Bring deposit slip or receipt on your class day

How to Enroll in 3 Easy Steps
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