Microsoft Excel 2013 Beyond Basics

Course code: MSEXC2013BB
Duration: 1 day
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.
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
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
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
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
Using find and replace
Freezing panes
Split screen
Creating a simple chart
Modifying a simple chart
Printing charts
Refresher on printing and previewing options
Print Pane
Page setup options