Excel Introduction Training

PDF

Excel Introduction (2013, 2016, 2019, Office 365)

• Exploring Excel
  • Starting Microsoft Excel
  • Using Templates
  • Examining the Excel Application Window
  • Examining the Workbook Window
  • Using the Ribbon
  • Understanding the Backstage Area
  • Using Shortcut Menus
  • Working with Worksheets, Columns and Rows, and Cells
  • Closing vs. Exiting
• Basic Workbook Skills
  • Navigating in a Worksheet
  • Using the GoTo Feature
  • Entering Data
    • Entering Text into Cells
    • Entering Values into Cells
  • Using Find
  • Saving and Renaming a Workbook
  • Opening a Workbook
  • Using Data Entry Shortcuts
  • Editing Cell Entries
• Working with Columns and Rows
  • Selecting Columns and Rows
  • Changing the Width of Columns and Height of Rows
  • Adjusting Row or Column Size Automatically
  • Inserting a Column
  • Inserting a Row
  • Deleting a Column or Row
  • Inserting Selected Cells
  • Deleting Selected Cells
• Working with Ranges
  • Working with Ranges
  • Merging Cells
  • Entering Values into a Range
  • Using the AutoFill Feature
  • Creating and Navigating to a Range Name
  • Using Undo and Redo
• Creating Simple Formulas
  • Using Formulas
  • Using the AutoSum Button
  • Using Basic Functions
  • Using the AutoCorrect Feature
  • Using Insert Function
  • Using Show Formulas
  • Using the AutoCalculate Feature
• Copying and Moving Data
  
  • Copying, Cutting and Pasting Data
  • Moving and Copying Using the Mouse
  • Understanding Relative References
  • Creating an Absolute Reference
  • Using AutoFill to Copy Formulas
• Formatting Numbers
  • Using Number Formats
  • Changing Decimal Places
• Formatting a Worksheet
  • Changing Font and Font Size
  • Using Bold, Italic and Underline
  • Using Font Color and Fill Color
  • Using Borders
  • Using Workbook Themes
  • Defining Theme Colors
  • Orienting Cell Contents
  • Changing Text Indent
  • Wrapping Text
  • Changing Cell Alignment
  • Using Conditional Formatting
  • Using Format Painter
  • Clearing Formats
• Using Charts and Objects
  • Using Charts
  • Identifying Chart Objects
  • Understanding Chart Types
  • Creating a Chart
  • Changing Chart Location
  • Changing Chart Types
  • Selecting Chart Objects
  • Using Chart Tools
  • Adding and Removing Chart Elements
  • Formatting a Chart
  • Moving, Resizing and Deleting Chart Objects
  • Changing Data in an Existing Chart
  • Formatting Chart Objects
  • Drawing Shapes
  • Using Text Boxes
  • Formatting Shapes
• Printing
  • Printing a Range, Worksheet or Workbook
  • Setting Margin and Centering Options
  • Changing Page Orientation
  • Adding Headers and Footers
  • Scaling a Worksheet
  • Printing Charts

Before Taking this Class

Software/Setup For this Class

Microsoft Office 2013 or higher (2013, 2016, 2019, or Office 365)