Duration: 1 day(s)
Course Code: XL13L2
Early Bird Courses
London 18th Jan 2018 £191.75 Book
London 12th Feb 2018 £191.75 Book
London 22nd Mar 2018 £191.75 Book
London 17th Apr 2018 £191.75 Book
London 22nd May 2018 £191.75 Book
London 20th Jun 2018 £191.75 Book
Click to view further dates
For dates or any further enquiries please call 01344 830100
Price: P.O.A

Microsoft Excel 2013 Level 2

Course Aims

This Microsoft Excel 2013 Level 2 course is aimed at people who want expand their basic knowledge of Microsoft Excel to work with larger spreadsheets and workbooks, create charts and manage tables of data.

Course Prerequisites

Students who wish to attend this course must have a basic knowledge of Excel and feel comfortable with creating, saving, editing and formatting spreadsheets, and creating simple formulas and functions.

On completion of this course you will be able to:

• Manage and enhance large Excel worksheets
• Create formulas across multiple worksheets
• Copy formats and values across multiple worksheets
• Create range names and use range names in formulas
• Copy and link information across multiple workbooks
• Represent data graphically using charts
• Understand the concepts an Excel database and create and modify data tables
• Sort lists and filter information
 

Programme Focus

Recap of Basic Formulas and Functions
Using Large Excel Worksheets

o Increasing & decreasing the magnification
o Splitting the window,
o Freezing & unfreezing panes

Working with Multiple Worksheets
o Navigating between and selecting worksheets
o Renaming worksheets
o Selecting multiple worksheets
o Colouring worksheet tabs
o Copying & moving worksheets
o Copying and moving data between worksheets
o Using grouped worksheets
o Creating formulas across sheets
o Creating aggregate functions across sheets
o Referencing cells across sheets
o Hyperlinking between sheets

Using Paste Special & Flash Fill
o Working with Paste Special
o Copying values & formulas between worksheets
o Performing mathematical operations
o Creating data sequences using ‘Flash Fill’

Using Range Names
o Jumping to a named range
o Assigning names to ranges
o Using range names in formulas
o Editing and deleting named ranges
o Creating range names from headings
o Applying range names to existing formulas
o Creating named ranges across sheets

Appendix - Using Graphics in a Workbook (if time)
o Drawing and formatting ‘Shapes’
o Inserting SmartArt

Using Multiple Workbooks
o Opening, activating & tiling workbooks
o Copying data between workbooks
o Linking cells between workbooks
o Managing and troubleshooting workbook links

Creating Charts
o Creating, moving, resizing, printing & deleting charts
o Using built-in chart styles and ‘Quick Layouts’
o Formatting chart objects & data series
o Adding & removing chart elements (eg. titles, data labels, legend)
o Changing the data source
o Changing chart type and location
o Filtering chart categories and data series
o Creating chart templates
o Using ‘Recommended Charts’
o Advanced charting

  • Creating a combination chart
  • Using a secondary axis
  • Adding a trendline
  • ‘Sparklines’ (mini charts in a single cell)

o Using the ‘Quick Analysis button” to create a chart or add a SparkLine

Working with Excel Data Tables
o Creating & modifying a data table
o Working with the data form
o Creating an Excel table
o Using the ‘Quick Analysis button” to create an Excel table

Analysing Data Tables
o Sorting tables
o Sorting a table by multiple fields
o Filtering data in a table
o Creating a custom filter
o The SUBTOTAL function
o Using the ‘Quick Analysis button” to add totals to a table
o Use the Slicer to filter an Excel table

Click to expand...

Next Learning Step

The next course in this series is: