Help Us Spread The Word!

Mastering Microsoft Excel (May 24)

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 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 to use VLOOKUP 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 organize your data and format cells to 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 use simple functions such as SUM, COUNT, MIN, MAX, and other helpful Excel Functions
  • How to create great looking data bars, sparklines, charts, etc.
  • 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. Organizing Data
      a.  Automatically filling up data vs. manually encoding
      b.  Splitting Your Data Into Several Cells Automatically
      c.  Combining Your Data Into 1 Cell Automatically
      d.  Transpose Data Automatically
      g.  Creating Drop-down List
      h.  Removing Duplicates

Module 2:  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 3:  Working With Helpful Excel Functions
      a.  Introduction To Formulas
      b.  Basic Operations
      c.  Working with the SUM() Functions
      d.  Working with the MIN() Functions
      e.  Working with the AVERAGE()
      f.  Working with COUNT() Functions
      g.  Working with VLOOKUP() Functions

Module 4:  Analyzing Data
      a.  Using Sort and Filter Functions
      b.  Using Freeze Panes
      c.   Taking Advantage of Pivot Table
      d.  Creating Data Bars
      e.  Creating Sparklines
      f.  Creating Charts
      g.  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:  May 24 (Friday), 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
Aya Bonalos Startup Blueprint Masterclass

The lessons are really not by the book so we're very lucky!

"I really wished that I knew about this Masterclass before I launched my first business to save me from failures.

The lessons are really not by the book so we're very lucky!"

profile-pic
April Estacio Villamor eCommerce Workshop

Salamat po sa unselfish desires nyo to help others.

Unang una salamat po sa super humble mentors/coaches po namin. Salamat sa continuous support. Salamat po sa unselfish desires nyo to help others. Winner!

profile-pic
Janet Treyes Startup Blueprint Masterclass

The tips and bonuses were definitely worth my money

"It is definitely is easier to understand compared to other online courses. The tips and bonuses were definitely worth my money. They are so helpful!"

>