ExpiredExcel 2013 Level 1

Rosalina Legaspi

  • July 6, 2018
    8:30 am - 4:00 pm
  • July 13, 2018
    8:30 am - 4:00 pm
  • July 19, 2018
    8:30 am - 4:00 pm
  • August 2, 2018
    8:30 am - 4:00 pm
  • August 31, 2018
    8:30 am - 4:00 pm

Course Length: 1 day (8:30 a.m. – 4:00 p.m.)                            Instructor Led Training

Course Overview
This course covers all the essentials of Microsoft Excel 2013. Topics covered include the new Flash Fill feature, using formulas and functions, inserting PivotTables and Pivot Charts, and customizing the interface. Material is also included on how to format text, data, and workbooks; insert art and objects; and chart data.

Course Content

Module 1: The Basics 
Getting Started
Signing In
Creating a New Workbook
Saving a Workbook
Opening a Workbook
Module 2: Your First Workbook
Selecting Data
Entering and Deleting Data
Using Undo and Redo
Using Cut, Copy, and Paste
Module 3: 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 4: 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
Module 5: Using Timesaving Tools 
Using AutoFill
Using Flash Fill
Using AutoSum
Using AutoComplete
Using AutoCalculate
Module 6: 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
Module 7: Formatting Data
Wrapping Text
Changing the Size of Rows and Columns
Adjusting Cell Alignment
Changing Text Direction
Changing Number Format
Module 8: Formatting the Workbook
Using Cell Styles
Formatting Data as a Table
Changing the Theme
Inserting Page Breaks
Adding a Background
Module 9: Inserting Art and Objects
Inserting SmartArt
Inserting Text Boxes
Inserting Pictures
Inserting Equations
Drawing Shapes
Module 10: Charting Data
Creating Sparklines
Inserting Charts
Inserting PivotTables
Inserting PivotCharts
Using Slicers
Creating Timelines
Module 11: Viewing, Printing, and Sharing your Workbook
Using Views
Saving a Worksheet as PDF or XPS
Printing a Workbook
Emailing a Workbook
Sharing your Workbook on SkyDrive
Module 12: Customizing the Interface
Changing Ribbon Display Options
Customizing the Quick Access Toolbar
Hiding and Showing the Ribbon Tabs
Creating Custom Ribbon Tabs
Resetting Interface Changes
Rosalina LegaspiExpiredExcel 2013 Level 1