Microsoft Excel 2013/2016 Level 2 Training Course

Managing Data

Pre-requisites:

Delegates should have knowledge of the topics from the Excel Level 1 course. It is essential that they have an understanding of and are able to use simple calculations.

Objectives:

  • Manage multiple worksheets and workbooks
  • Link data
  • Identify formulas
  • Use date and text functions
  • Utilise Excel’s database and filtering features
  • Expand your knowledge of charts
  • Create a template
  • Protect data
  • Conditional formatting techniques

Topics:

Manage Multiple Worksheets / Workbooks
  • Freeze panes and split screen
  • View several worksheets/workbooks at the same time
  • Styles
Linking Data
  • Linking data between worksheets and workbooks
  • Calculating across worksheets
  • Hyperlinks
  • Consolidate worksheets / workbooks
Working with Dates
  • Date functions
  • Date and time formats
  • Using dates in calculations
Working with Text
  • Text functions
  • Separating data from one cell into several cells
  • Flash fill
Importing and Exporting
  • Import data from another program
  • Copy and/or link data
Templates
  • Create and use a template
  • Apply cell styles
Excel’s Database & Filtering Features
  • Creating a table
  • Using table slicers
  • AutoFilter and advanced filter
  • Sorting
  • Sub totals
  • Group and outline rows/columns

Charts Expanded

  • Advanced formatting
  • Formatting
  • Adding/removing data
  • Sparklines
  • Trendlines
Documenting & Auditing
  • Comments
  • Identifying formulas
  • Auditing
Protect Data
  • Protecting data from being changed
  • Applying passwords to a workbook
Conditional Formatting
  • Apply different colours to a cell relating to its contents
  • Use icon to pick out data

Topics not what you require? More information required? Contact us to discuss.

The topics in this course can be mixed and matched with Excel Level 1 and/or Excel Level 3 if required.


Prices

1 to 1 training: £299 + VAT per day
Each additional person: £40 + VAT per day

We come to you.  Courses take place at your offices.