Microsoft Excel Essentials

Microsoft Excel Training Philippines

Download PDF
Microsoft Excel Essentials

COURSE CODE

131

DURATION

1 day

Overview

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 Investment

Course Outline

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

Printing Your Workbook

  • Using Excel's Different Views
  • Using Print Preview
  • Specifying Number of Copies to Print
  • Selecting a Printer
  • Other Printing Settings
  • Specifying Page Orientation
  • Specifying Page Size
  • Changing Margins
  • Centering on Page
  • Adding Headers and Footers
  • Printing Portions of a Worksheet
  • Scaling to Fit Page

Customizing the Interface

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

Schedule

Jan 7, 2019 (9:00am to 5:00pm)

Reviews

"The instructor is knowledgeable on the topic. He entertains questions and queries with definite answers."

Microsoft Excel Essentials

Grace Norbe

DSWD Central Office

"Very helpful to me, will encourage my friends to enroll here."

Microsoft Excel Essentials

Ma. Dorothy Bermundo

"It's organized and very good."

Microsoft Excel Essentials

Angeline Mendoza

Edeska LLC

Request More Info