Help Us Spread The Word!

Mastering Microsoft Excel (April 30)

5,990.00

Do you want to learn the IMPORTANT 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!

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 TRAINING 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 Pivot Table to extract and read information in any way you want
  • How to format cells and make it look professional
  • 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 use VLOOKUP to automatically search for data from another file and use it in your sheet
  • check
    How to create great looking charts and format them professionally
  • How to create and design templates that other employees can easily fill in
  • check
    How to limit the entry to drop-down choices only
  • 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(), 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 IMPORTANT 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?

This 1-Day Mastering Excel workshop is the answer!

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. Entering Text and Basic Formula
      a.  Understanding the PEMDAS principle
      b.  Working with Numeric Data in Excel
      c.  Entering Date Values in Excel
      d.  Working with Cell References
      e.  Creating Basic Formulas in Excel
      f.  Relative Versus Absolute Cell References in Formulas
      g.  Hiding and Protecting Your Formula
      h.  Limiting cell entries to drop-down choices

Module 2:  Working With Helpful Excel Functions
      a.  Working with the SUM() and SUMIF () Functions
      b.  Working with the MIN() and MAX() Functions
      c.  Working with the AVERAGE()
      d.  Working with COUNT() and COUNTIF() Functions
      e.  Working with VLOOKUP() and HLOOKUP() Functions
      f.   Working with SUMPRODUCT() Functions

Module 3:  Formatting Data
      a.  Changing the Background Color of a Cell, Adding Borders, etc.
      b.  Formatting as Currency, Numbers, Percentage or Date
      c.   Using Excel's Format Painter
      d.  Merging and Centering Cells
      e.  Hiding and Grouping Cells
      f.  Using Conditional Formatting
      g.  Locking and Protecting Your Cells or Sheets

Module 4:  Analyzing Data and Creating Charts
      a.  Using Sort and Filter Functions
      b.  Using Freeze Panes
      c.   Taking Advantage of Pivot Table
      d.  Creating Charts
      e.  Formatting Charts

Module 5:  Putting It All Into Action
      a.  Sample Income Statement Template
      b.  Sample Invoice Template
      c.  Sample Inventory Template
      d.  Sample Payroll Template
      e.  Sample Management Report
      f.  Sample Expense Report Template
      g. Sample ROI/Payout Analysis Template

VENUE AND LEARNING INVESTMENT:

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

LEARNING INVESTMENT:
Super Saver Rate: 5,990.00

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!


5,990.00

WHAT OLERN STUDENTS HAVE TO SAY:

profile-pic
Dra. Ivy Sapanghila Startup Blueprint Masterclass

Very practical and easy to understand than boring traditional seminars.

"It exceeded my expectations! This is my first online course yet I found it very practical and easy to understand than boring traditional seminars!"

profile-pic
Christian Noble eCommerce Workshop

The training was worth more than any other mastermind groups in the Philippines!

The value in the training and overall was worth more than any other mastermind groups in the Philippines. Balance in all aspects; advertising, content, golden nuggets everywhere. They maximize the full potential of each material they can produce to help us starting ecom business.

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."

>