Microsoft Excel Essentials

Microsoft Excel Training Philippines

Course: 131

Type: Hands-On Training

Duration: 1 day

Courses Benefits:

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.

You Will Learn How 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:

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

Course Content:

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

Working with Data

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

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

Inserting Art and Objects

  • Inserting SmartArt
  • Inserting Text Boxes
  • Inserting Pictures
  • Inserting Equations
  • Drawing Shapes

Charting Data

  • Creating Sparklines
  • Inserting Charts
  • Inserting PivotTables
  • Inserting PivotCharts
  • Using Slicers

Viewing, Printing, and Sharing Your Workbook

  • Using Views
  • Saving a Workbook as PDF
  • Printing a Workbook
  • E-Mailing a Workbook
  • Sharing Your Workbook on OneDrive

Customizing the Interface

  • Changing Ribbon Display Options
  • Customizing the Quick Access Toolbar
  • Hiding and Showing Ribbon Tabs
  • Creating Custom Ribbon Tabs
  • Resetting Interface Changes

Upcoming Dates

August 22, 2017 (9:00am to 5:00pm)

Course Investment

For pricing info, call us at +632-726-8128 or Email us.
Money Saving Tuition Plans

REQUEST MORE INFO ENROLL NOW!

 

People Who Took This Course Also Took
Enrolling entitles you to...
  • Class participation
  • Team workshops
  • Use of in-class and hands-on equipment
  • Course CD
  • Comprehensive course materials
  • Lunch and refreshments
  • Course Completion Certificate