Microsoft Excel 2016

BEGINNING

Beginning Microsoft Excel 2016 - Session 1
​Creating a Worksheet and a Chart

OBJECTIVES:
  • ​Describe the Excel worksheet
  • Enter text and numbers
  • Use the Sum button to sum a range of cells
  • Enter a simple function
  • Copy the contents of a cell to a range of cells using the fill handle
  • Apply cell styles
  • Format cells in a worksheet
  • Create a 3-D pie chart
  • Change a worksheet name and sheet tab color
  • Change document properties
  • Preview and print a worksheet
  • Use the AutoCalculate area to display statistics
  • Correct errors on a worksheet

Beginning Microsoft Excel 2016 - Session 2
​Formulas, Functions and Formatting

OBJECTIVES:
  • Use Flash Fill
  • Enter formulas using the keyboard
  • Enter formulas using Point mode
  • Apply the MAX, MIN, and AVERAGE functions
  • Verify a formula using Range Finder
  • Apply a theme to a workbook
  • Apply a date format to a cell or range
  • Add conditional formatting to cells
  • Change column width and row height
  • Check the spelling on a worksheet
  • Change margins and headers in Page Layout view
  • Preview and print versions and sections of a worksheet

Beginning Microsoft Excel 2016 - Session 3
​Working with Large Worksheets, Charting and What-If Analysis

OBJECTIVES:
  • Rotate text in a cell
  • Create a series of month names
  • Copy, paste, insert, and delete cells
  • Format numbers using format symbols
  • Enter and format the system date
  • Use absolute and mixed cell references in a formula
  • Use the IF function to perform a logical test
  • Create and format sparkline charts
  • Change sparkline chart types and styles
  • Use the Format Painter button to format cells
  • Create a clustered column chart on a separate chart sheet
  • Use chart filters to display a subset of data in a chart
  • Change the chart style and type
  • Reorder worksheet tabs
  • Change the worksheet view
  • Freeze and unfreeze rows and columns
  • Answer what-if questions
  • Goal seek to answer what-if questions
  • Use the Smart Lookup insight
  • Understand accessibility features

Beginning Microsoft Excel 2016 - Session 4
​Financial Functions, Data Tables and Amortization Schedules

OBJECTIVES:
  • Assign a name to a cell and refer to the cell in a formula using the assigned name
  • Determine the monthly payment of a loan using the financial function PMT
  • Use the financial functions PV (present value) and FV (future value)
  • Create a data table to analyze data in a worksheet
  • Create an amortization schedule
  • Control the color and thickness of outlines and borders
  • Add a pointer to a data table
  • Analyze worksheet data by changing values
  • Use names and print sections of a worksheet
  • Set print options
  • Protect and unprotect cells in a worksheet
  • Hide and unhide worksheets and workbooks
  • Use the formula checking features of Excel