E-learning Excel 2016 Basic UK 1yr pre

Excel 2016 Course Basic

Course content

Basic

You need to know: About your spreadsheet application
Opening a workbook
Overview of the environment
Moving around a workbook
You need to know: Text made easy
Entering data
You need to know: Selecting, copying, moving
Selecting and deleting cells
Undoing and redoing an action
Column width/row height
You need to know: Saving files
Saving a workbook
Modifying the contents of a cell
Creating a new workbook
Entering a calculation formula
Calculating a sum and other basic functions
Calculating a percentage
Reproducing data in adjacent cells
Simple numerical formats
Applying a theme
You need to know: Formatting characters
Formatting characters
Character font and size
Aligning cell content
Cell colour
Cell borders
Page layout
Print preview and printing
Page breaks
Print areas
You need to know: Headers and footers
Headers and footers
Using Microsoft Excel Help
Checking spelling
Find and replace
Zoom
Inserting/deleting rows columns and cells
Moving cells
Copying to non-adjacent cells
Copying cell format quickly
Merging cells
Orientation of cell content
Cell styles
Sorting data
Sheet name, tab colour
Inserting and deleting sheets, sheet background
Moving, copying, hiding sheets
Splitting the window, freeze a column/row
Repeating rows/columns on printed pages
Hiding elements of a sheet
Summarising data with an outline