Introduction to Microsoft Excel

BEGINNER BEGINNER
GROUP 8 People
2+ Days
12 hours total
What you will learn
  • Create basic worksheets using Microsoft Excel 2016.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet.
  • Manage Excel workbooks.
  • Print the content of an Excel worksheet.
  • Learn how to use handy features new in 2016.
Course Description

In this course we teach people how to use Excel spreadsheet to organize information into nice, neat rows and columns, then format, sort, analyze and do math right on the sheets. Useful for financial records, address books, to do lists, too many things to mention.

Excel user interface 

  • Title bar
  • Menu bar
  • Ribbon bar
  • Formula bar
  • Data area – Columns & Rows
  • Worksheet bar
  • Status bar
  • Columns, Rows and Cells
  • Help

 

Saving your documents

  • Save
  • Save as
  • Save in a different file type

 

Formatting a Cell 

  • Overview of the User Interface
  • Formatting a cell
  • Understanding cells       
  • To select a cell
  • To select a cell range
  • Cell content       
  • Insert content
  • Delete (or clear) cell content
  • Delete cells
  • Copy and paste cell content
  • Access more paste options
  • Cut and paste cell content
  • Use the fill handle
  • Continue a series with the fill handle
  • Drag and drop cells
  • Change the font size
  • Change the font
  • Change the font color
  • Use the Bold, Italic, and Underline commands
  • Cell borders and fill colors
  • To add a fill color
  • Add a border
  • Cell styles
  • Apply a cell style
  • Text alignment
  • Change horizontal text alignment
  • Wrapping text and merging cells
  • To wrap text in cells
  • To merge cells using the Merge & Center command
  • To access more merge options
  • To center across selection

 

Managing a Workbook

  • Renaming your worksheet
  • Creating a New Worksheet
  • Re-order the Worksheets
  • Copy a Worksheet
  • Moving Quickly Around the Spreadsheet
  • Selecting Random Cells

 

Formatting a Worksheet 

  • Modifying column width
  • AutoFit column width
  • Modifying row height
  • Modifying all rows or columns
  • Inserting, deleting, moving, and hiding
  • To insert rows
  • To insert columns
  • To delete a row or column
  • To move a row or column
  • To hide and unhide a row or column