Microsoft Excel 2013 Beyond Basics

Course code: MSEXC2013BB
Duration: 1 day
 
Overview           
This course recaps the basic functions and features of Microsoft Excel 2013 and covers methods to work more efficiently.  It is particularly suited to anyone who is self taught or who has previously received basic training on an earlier release of Excel.  It is also ideal for those currently inputting on existing worksheets that are now faced with creating their own spreadsheets.  Throughout the course there will be a focus on applying the topics covered efficiently within a business context.
At the end of the course the delegates will be confident with formulae and basic functions, be able to manipulate and chart data, and work with multiple sheet workbooks.
 
Pre-requisites
Prior use of Excel or another spreadsheet package is necessary.  Delegates must be able to open and save a workbook, add data and print.
 
Delegates will learn how to:
Use shortcuts to move around and select within a worksheet
Move and copy rows, columns or ranges easily
Be able to format data
Understand, use, edit and correct formulae
Use basic functions including IF
Work with Excel Tables
Sort and filter data
Create and modify a simple chart
Preview and print the worksheet and change printing options
 
COURSE CONTENT
 
Basics
Working with the Excel 2013 user interface
 
Inputting Data
Using AutoFill
Creating custom lists
Flash Fill
Inputting shortcuts
 
Editing Data
Navigation and selection shortcuts
Refresher on basic editing
Using spell check
Refresher on moving and copying data
 
Formatting
Refresher on basic formatting
Using Format Painter
Quick Analysis Tool
 
Working with multiple sheets
Naming sheets and changing the colour of sheet tabs
Moving and copying sheets
 
Formulae
Refresher on formulae
Understanding and avoiding circular references
Order of precedence
Understanding relative and absolute references
Using dates in formulae
Creating a formula with data from other sheets and workbooks
Using a 3D formula to calculate across multiple sheets
 
Using Excel functions
Refresher on basic functions; SUM, AVERAGE, MAX, MIN, COUNT
Creating basic IF functions
 
Excel tables
Creating a table
Using table features
Formatting with options and styles
Filtering using Slicers
 
Working with data
Linking cells
Sorting lists
Filter
Using find and replace
Freezing panes
Split screen
 
Charts
Creating a simple chart
Modifying a simple chart
Printing charts
 
Printing
Refresher on printing and previewing options
Print Pane
Page setup options