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
Working with Multiple Worksheets
Using Paste Special & Flash Fill
Using Range Names |
Using Multiple Workbooks
Creating Charts
o Using the ‘Quick Analysis button” to create a chart or add a SparkLine
Working with Excel Data Tables
Analysing Data Tables |
Next Learning Step
The next course in this series is: |