Microsoft Excel 2016 Beginner
-
Getting Familiar with the Interface
-
Understanding the worksheet structure
-
Entering and editing data
- Entering data
- Entering data using the Formula Bar
- Entering dates
- Understanding how text data behaves
- Understanding how numbers and dates behave
- Adjusting the column width and row height
- Autofitting the column width and row height
- Replacing data in a cell
- Canceling data entry
- Editing data in a cell
- Editing data using the Formula Bar
- Deleting data / Clearing contents
- Copy and paste using the Ribbon
- Copy and paste using right click on the mouse
- Copy and paste using keyboard shortcuts
- Cut and paste using the Ribbon
- Cut and paste using right click on the mouse
- Cut and paste using keyboard shortcuts
- Moving data within a worksheet
-
Modifying worksheets
- Inserting new columns and rows using the Ribbon
- Inserting new columns and rows using right click on the mouse
- Inserting new cells using the Ribbon
- Inserting new cells using right click on the mouse
- Inserting a new worksheet
- Renaming a worksheet
- Navigating through worksheets
- Moving and reordering worksheets
- Creating a copy of a worksheet using right click
- Creating a copy of a worksheet by dragging
-
Saving and closing a workbook
-
Working with the Auto Fill tool
-
Using formulas and functions
- Understanding and entering formulas
- Understanding functions and function syntax
- Understanding the SUM function
- Using the SUM function
- Using AutoSUM
- Editing formulas or functions
- Using Auto Fill with formulas or functions
- Understanding relative cell referencing (must-know!)
- Understanding absolute cell referencing (must-know!)
- Using the Insert Function command
-
Formatting data
- Applying the thousands separator and decimal places to numbers
- Applying the accounting or currency format to numbers
- Applying the percentage format to numbers
- Applying or changing a date format
- Changing the font
- Changing the font size
- Applying the bold effect
- Applying the italic effect
- Applying the underline or double underline effect
- Hiding and unhiding columns or rows
- Changing the fill color of cells or the font color of text
- Creating a custom fill color for cells or a custom font color for text
- Applying borders to a cell or range
- Applying borders using the Draw Border option
- Applying borders using the Border dialog box
- Using the Mini toolbar to format your data and cells
-
Essential keyboard shortcuts
