Microsoft Excel - Level 3Download Course Outline

This is the outline of our Microsoft Excel Level 3 course - Duration: 1 day

Although you’re a competent user of Excel, you’re still finding some aspects challenging and you feel frustrated because your existing knowledge keeps letting you down. This course will give the skills to tackle more complex data analysis. With the use of the If function, Vlookup and Pivot Tables, you will have the necessary skills to extract information from your spreadsheets.  This course will increase your competence in data analysis helping you meet those targets more efficiently and also prepares you for moving on to the Microsoft Excel Level 4 Course.

To get the most from this course you will have attended the Burningsuit Microsoft Excel Level 2 Course.

Or you have been using Excel for a reasonable length of time and you are competent in basic spreadsheet analysis work and have used formulae and functions.  You now need to know how to use more complex functions and data analysis.

We specialise on on-site training and can come to you to run our course either on your PC's or provide our own high specification equipment. If you want specific training for your staff, we're happy to customise this course to your requirements, adding or removing topics as necessary.


 Call us on 0800 0199 746  


Microsoft Excel - Level 3 course content

Download a PDF course outline using the link on the right.

Naming Cells and Ranges

  • Correctly create named cells and use names iformulas accurately.

The IF Function

  • Construct an IF function correctly to enter data into cells based on the result of a test.

Countifs and Sumifs Functions

  • Correctly construct the Countifs function to count up specific values in a range of values.
  • Correctly construct the SumIfs function to add up up specific values in a range of values.

VLookup

  • Correctly construct the Vlookup function to find data based on a lookup value.

Concatenation 

  • In a single cell, accurately string together cell values, text and formulas into a single value. 

Overview of Quick Analysis*

  • How to use the Quick Analysis feature
  • Turning off this feature.

Pivot Tables 

  • Construct and work with a Pivot Table to analysis your data.
  • Drilldown on the Data Area
  • Use the Layout Options
  • Drilldown on the Data Area
  • Use Layout Options
  • Use Group and Outline
  • Change the Subtotal Function
  • Use different functions in the Data Area
  • Use the “Show Data As” Option

 

 Pivot Tables and the Data Model*

  • How you can use the Data Model to create Pivot Tables for multiple data sources.

Data Consolidation

  • Automatically and quickly, add up data on source sheets onto a totals sheet.

Text to Columns

  • Separate the contents of one cell into separate columns.

Data Validation

  • Prevent invalid data being entered into a cell.

Using Outlining and Custom Views

  • Tie a range of cells together so they can be collapsed or expanded.
  • Save your Outline as a Custom View.

Inserting Comments

  • Insert a Comment and work with comments.

Protecting Worksheets and Workbooks

  • Lock and unlock Cells.
  • Apply the Hidden format to formulas.
  • Apply protection to a worksheet so users can’t edit it.
  • Apply protection to a workbook so that users can’t add, move or delete worksheets.

Creating Charts

  • Create a chart to analyse database information
  • Work with custom charts and templates
  • Construct a Chart by selecting your data source.
  • Create secondary axes

Use SparkLines (Excel 2010 and 2013 only)

  • Create Sparklines as an alternative to charts.
  • Quick Sparklines*

* Only applicable in an Excel 2013 training course

We also offer this course as Live Online Learning - follow this link to learn more.


 Call us on 0800 0199 746