Microsoft Office Excel Made Easy


Microsoft Office Excel Made Easy

Excel Spreadsheet Hidden Features

and Hacks You Need to Know in 2020



Speaker: Ronaldo F. Turla, CHRP

Management Consultant

Sought-after Certified Trainer

on Emotional Intelligence

Partner Speaker, ARIVA Speakers Bureau


Wednesday, September 16, 2020

10:00 AM – 12:00 NN PHT

2:00 PM – 5:00 PM PHT

 

Webinar Desription:


Microsoft Excel is the industry leading tool to help workers work with data on the desktop. This Excel training course enables you to become more productive by allowing you to automate data processing essential to your daily work.

 

Key Benefits from Attending this Webinar:


In this online learning session, your participants and your organization will be able to:

  • Create and format workbooks
  • Summarize data using formulas and functions
  • Sort and filter data
  • Use timesaving tools such as AutoFill, AutoSum, and FlashFill
  • Visualize data using charts
 

Who Should Attend?


This online learning session is suitable to a wide range of professionals but will greatly

benefit anyone who wants to use Microsoft Excel to create spreadsheets and automate data processing.

Webinar Outline:


Module 1: The Basics 

  • Getting Started 
  • Signing In 
  • Creating a New Workbook 
  • Parts of a Workbook 
  • Saving a Workbook 
  • Opening a Workbook 

Your First Workbook 

  • Selecting Data 
  • Entering and Deleting Data 
  • Using Undo and Redo 
  • Using Cut, Copy, and Paste 


Module 2: Working with Data 

  • Inserting Rows and Columns 
  • Merging and Splitting Cells 
  • Moving Cells 
  • Using Paste Special 
  • Using Find and Replace 
  • Hiding and Unhiding Cells


Module 3: Excel Tools Using Basic Excel Tools 

  • Understanding Cell References and Formulas
  • Using Basic Formulas
  • Using Basic Functions
  • Using Advanced Functions
  • Using Spell Check
  • Using Sort and Filter

Using Timesaving Tools 

  • Using AutoFill 
  • Using Flash Fill 
  • Using AutoSum 
  • Using AutoComplete 
  • Using AutoCalculate 

Formatting Text 

  • Changing the Font Face, Size, and Color 
  • Applying Text Effects 
  • Applying Borders and Fill 
  • Using the Font Tab of the Format Cells Dialog 
  • Clearing Formatting 

Formatting Data

  • Wrapping Text 
  • Changing the Size of Rows and Columns 
  • Adjusting Cell Alignment 
  • Changing Text Direction 
  • Changing Number Format 

Formatting the Workbook 

  • Using Cell Styles 
  • Formatting Data as a Table 
  • Changing the Theme 
  • Inserting Page Breaks 
  • Adding a Background 


Module 4: Data Analysis & Pivot Table


Charting Data 

  • Creating Sparklines 
  • Inserting Charts 

Introduction to Functions:

  • Calculation Options & Display
  • Absolute & Relative referencing  
  • Function Auditing tool
  • Formula Error
  • Array Functions
  • Functions Across Workbooks

Numerical & Mathematical Functions:

  • Numerical Functions
  • Mathematical Functions

Statistical Functions


Counting & Ranking Functions:

  • Useful count functions
  • Ranking Functions

Logical Functions: 

  • Using the IF Statement in Excel
  • Conditional Functions
  • Further conditional Functions

Working with Dates, Times and Text

  • Working with Dates & Times
  • Date & Time Functions

Lookup & Reference Functions:

  • Spreadsheet Functions
  • Using Lookup Functions
  • Use the Match, Search Functions
  • The Offset Function
  • Indirect & Cell Function  
 

Learning Investment

Reserve Your Spot NOW and SAVE Php. 2,000


(Pay on or before August 17, 2020)

Best Value Rate


P 3,998 + VAT

per Participant


(Group discount is given to 3 or more participants

from same organization.)

BFF Rate


P 4,998 + VAT

per Participant


(Minimum of 2 Participants)

Super Saver Rate

P 5,998 + VAT

per Participant

Pay on or before August 17, 2020

Early Bird Rate

P 6,998 + VAT

per Participant

Pay on or before September 02, 2020

Regular Rate

P 7,998 + VAT

per Participant

Pay on or before September 03, 2020

LEARNING INVESTMENT INCLUDES:


Enjoy a “Fun-filled” e-Learning experience, complete with online session materials

and e-certificate of attendance after online course completion.


PAYMENT METHOD

  • Paypal / Gcash / Paymaya
  • Credit Cards / Debit Cards 
  • Bank Transfer / Electronic Funds / Telegraphic Transfer
  • Direct Bank Deposit: Cash and Cheque 

Click here for the PAYMENT GUIDELINES

Claiming eCertificates


An eCertificate of Attendance will be awarded to participants who successfully completed the entire Virtual MasterClass.


Survey Online Questionnaire will be emailed after the e-Learning Event for participants to give feedback.


An eCertificate of Achievement will be emailed to the registered email address of the participants upon completion of the online Feedback Form.


Please ensure email address provided during registration is accurate or eCertificates may not be received.


Online Certificates will be available 3-5 days after the e-Learning Event.



OUR LIVE WEBINAR SERIES ARE

PURE 100% HIGH VALUE CONTENT!


View the Upcoming FREE Live Webinars: Click Here…


Unlock Your Dream e-Learning Journey Now! Click Here…


Virtual MasterClass Series powered by ARIVA Academy

UNLOCK

YOUR SPECIAL ACCESS AND RESERVE YOUR SPOT TODAY!


Did You Miss Our Live Webinars?


Watch the full session of our webinars and

get unlimited access on our YouTube Channels.

Subscribe to ARIVA Academy’s

YouTube Channel

Subscribe to ARIVA Talks

YouTube Channel

GENEROUS PARTNERS AND SPONSORS

DISPRZ LOGO
SALARYJET
ILAHUI
BOSSJOB
KITTLESON & CARPO LOGO
SERT TECHNOLOGY LOGO
ENCHANTED KINGDOM LOGO
PHINMA PROPERTY LOGO
COSMOTECH
HSBC LOGO

Stay on top of our insights and updates!

Join the ARIVA ACADEMY Facebook Group

Like ARIVA ACADEMY

facebook Page

Follow ARIVA ACADEMY LinkedIn Page

Visit our Website



FacebookLinkedInInstagramTwitterYouTubeEmail Address

ARIVA! Academy Philippines, Inc.

Betterliving Subdivision Brgy. Don Bosco, Parañaque City, 1711

Telephone: +632.8832-9901 | +632.8835-9354

Mobile: +63.917-325-7870