Help Us Spread The Word!

Mastering Microsoft Excel – Level 2 (June 5)

6,990.00 4,990.00

Prices go up when the timer hits zero

You Save: 2,000.00 (28.61%)

Do you want to learn the ADVANCED FUNCTIONS and formulas of Excel?  Do you want know how to FORMAT and ANALYZE your data quickly?  Do you want to make your graphs and charts professional-looking?

Then, attend this 1-Day Mastering Excel workshop – Level 2!

NOTE:  This Level 2 Training is meant for advanced users.  If you need more BASIC Excel Training, please click here to enroll to Level 1 Training instead.

Microsoft Excel is probably one of the MOST UNDER-UTILIZED software in our computer.  It has a lot of functionalities that can make our work FASTER and MORE EFFICIENT!

But sadly, 99% of people don’t even realize it!

So, ATTEND THIS MASTERCLASS and start harnessing the POWER OF EXCEL!

EXCLUSIVE BONUS:  Included in this course are 7 TEMPLATES (worth P3,500) such as Income Statement, Inventory, Payroll, Expense Report, ROI/Payout Analysis, etc. to be given to all participants for FREE!

So ENROLL NOW and start using Excel to make your work FASTER!

Certificate of Completion

Get a certificate from Olern when you finish this course.

Meals and Snacks Included

Meals and snacks will be provided during the live training.

Satisfaction Guaranteed!

Satisfaction Guaranteed!
We guarantee that you will learn from this training.

Description

WHAT YOU WILL LEARN

  • How use SUMIF, COUNTIF, SUMPRODUCT, and other helpful Excel Functions
  • How to use VLOOKUP and HLOOKUP to automatically search for data from another file and use it in your sheet
  • How to use Pivot Table to extract and read information in any way you want
  • How to Index and Match Functions
  • check
    How to use Conditional Formatting so that the information you need is highlighted automatically
  • check
    How protect your file with a password so that nobody can just open and access your data 
  • check
    How lock and protect your sheets and workbooks so that nobody can just ruin your data or formula 
  • check
    How to create great looking charts and format them professionally
  • How to use advanced charts such as Waterfall Chart, Bubble Chart, Treemap Chart, etc.
  • How to create and design templates that other employees can easily fill in
  • check
    How to use Forecast Sheet and Goal Seek Functions
  • check
    PLUS... many more!

Take This Program Now!

PROGRAM DESCRIPTION:

Microsoft Excel is probably one of the MOST UNDER-UTILIZED software sitting in our computers. It has a lot of functionalities that can make our work FASTER and MORE EFFICIENT!

But sadly, most employees and entrepreneurs just know the very basic things like entering of data, auto-sum functions, font/color formatting, etc.  They never realize that Excel is so much more capable to help them!

For example, they can use Pivot Table to easily extract and read information in any way they want...  Conditional Formatting can highlight information automatically...  Using VLOOKUP() and HLOOKUP(), they can read data from another file and return it to the worksheet...  They can create and design templates that other employees can easily fill in...

The list goes on and on...

So, do you want to learn the ADVANCED FUNCTIONS and formulas of Excel? Do you want know how to FORMAT and ANALYZE your data quickly and easily? Do you want to learn advanced charts like Bubble Chart, Waterfall Chart, and Treemap Chart?

This 1-Day Mastering Excel workshop - Level 2 is the answer!

NOTE:  This Level 2 Training is meant for advanced users.  We HIGHLY RECOMMEND that you start with the LEVEL 1 Training first because the things we will teach there will already help you tremendously 

EXCLUSIVE BONUS:  Included in this course are 7 TEMPLATES (worth P3,500) such as Income Statement, Inventory, Payroll, Expense Report, ROI/Payout Analysis, etc. to be given to all participants for FREE!

So ENROLL NOW and start using Excel to make your work FASTER!

WHO SHOULD ATTEND:

  • Entrepreneurs and business owners of who want to know how to use Excel for their business
  • Accounting staffs and managers who need to master Excel to help them become more efficient in their work 
  • Anyone who work with data and needs to update their skills on Excel
  • check
    Anyone who is interested in learning how to use Excel for their work or business

PROGRAM OUTLINE:

Module 1:  Creating Fomulas and Utilizing Advanced Excel Functions
      a.  The PEMDAS Principle
      b.  Creating Formulas in Excel
      c.  Absolute and Relative Cell Referencing
      d.   Working with the SUMIF() Function
      e.  Working with the AVERAGEIF() Function
      f.  Working with COUNTIF() Function
      g.  Working with SUMPRODUCT() Function
      h.  Working with Multiple Conditions

Module 2:  Working With Huge Data and Extracting Info
      a.  Using Conditional Formatting
      b.  Working with VLOOKUP() and HLOOKUP() Functions
      c.  Using Index Functions
      d.  Using Match Functions
      e.  Locking and Protecting Your Cells or Sheets

Module 3:  Forecasting and Goal Seek
      a.  Using Forecast Sheet
      b.  Using Goal Seek

Module 4:  Advanced Charts and Pivot Table
      a.  Using Pivot Table and Data Slicer
      b.  Creating Charts and Formatting Them
      c.  Using Clustered Graphs and Secondary Axis
      d.  Using Scatter and Bubble Chart
      e.  Using Waterfall Chart
      f.  Using Treemap Chart
      g.  Using Pareto

Module 5:  Creating Templates
      a.  When is it useful to make a template
      b.  Qualities of a Good Template
      c.  Guidelines in Making a Template
      d.  Let's Make a Template Together
      e.  Sample Templates

NOTE: We HIGHLY RECOMMEND that you start with the LEVEL 1 Training first because the things we will teach there will already help you tremendously  However, if you are CONFIDENT that you know those topics already or you have already taken Level 1, you can enroll in Level 2.

VENUE AND LEARNING INVESTMENT:

VENUE:  Olern Hub, Unit 905 Citystate Centre Bldg., 709 Shaw Boulevard, Pasig (near Capitol Commons)
DATE:  June 5 (Wednesday), 9am - 5pm

LEARNING INVESTMENT:
Super Saver Rate: 6,990.00 4,990.00

Prices go up when the timer hits zero

HOW TO ENROLL:

1.)  Click on the "ENROLL NOW" Button
2.)  In the cart, click on "Proceed To Checkout"
3.)  Kindly fill-up your details
4.)  Choose between "Bank Deposit" or "Credit Card/Paypal"
5.)  Click the "Place Order" Button

If you choose BANK DEPOSIT, we will email you the bank details right after you register.

3 + 1 Group Rate!

Want to attend with your team?  No problem!

Register and pay for three (3) persons and we'll give you a fourth seat for FREE!  To avail, simply enroll three (3) persons and email us the name of the fourth attendee and we'll take care of the rest!

Take This Program Now!

ABOUT THE MENTOR:

Rio Ilao is the Founder and CEO of MobileOptima, Inc., a Technology company which provides enterprise solutions to some of the biggest companies here in the Philippines, including Abenson, Bounty Chooks-To-Go, Uratex, Otis Elevators, etc. 

Established in 2012, MobileOptima aims to help companies in the Philippines revolutionize the way they do business through secure, easy-to-use and affordable mobile cloud solutions. It has a solid portfolio of enterprise solutions that drive productivity, efficiency and revenues, ranging from sales and inventory to timekeeping to automated SMS systems.

She has exceptional abilities in analysis, problem-solving, creative thinking, finding logical patterns, and relating these to real-world scenarios, particularly in the areas of customer validation and product and business model iteration.

Before jumping into entrepreneurship, she was the Global Finance Manager of Procter & Gamble’s (P&G) super premium skin care brand, SK-II, where she was responsible for managing the overall supply chain of the brand and ensuring that the brand’s target profitability was delivered.

Working with huge data as a Finance Manager, she used Excel regularly to make her work faster and more efficient.  In one occasion, she was able to cut a particular task from 12 hours to 2 hours processing (over 80% reduction) simply by AUTOMATING things using Excel!

In this powerful 1-Day training, she will share her experience and insights on how you too, can use Excel to make your work faster and more efficient!

Enroll In This Program Now!

Prices go up when the timer hits zero


6,990.00 4,990.00

WHAT OLERN STUDENTS HAVE TO SAY:

profile-pic
Elisa Cruz Startup Blueprint Masterclass

Designed to fit the need of every aspiring FIlipino entrepreneur.

“Sir Jerry epitomizes the true meaning of a mentor. He teaches not only the knowledge, but also the wisdom with a sincere & generous heart.

The modules and lessons are well-thought out and well-designed to fit the need of every aspiring FIlipino entrepreneur regardless of age and experience.”

profile-pic
John Alson Eliseo Startup Blueprint Masterclass

The Masterclass is an excellent guide for Business Start-Up.

"Very Attentive to details, Sir Jerry can create an environment that students and mentor are both learning through class discussion.

The Masterclass is an excellent guide for Business Start-Up."

profile-pic
Tin Aberia Janiola eCommerce Workshop

Super sulit ang kada piso na ibabayad mo!

Superb info, superb mentors, superb workshop! Super sulit ang kada piso na ibabayad mo! Good job and more power mga masters!

>