Microsoft Excel Training Course – Level 3

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.

Download course informationGet a Quote for this Course

Microsoft Excel Training – Level 3 Course Contents - Duration: 1 day

Naming Cells and Ranges

  • Correctly create named cells and use names in formulas accurately.

The IF Function

  • How to correctly construct an IF function and enter data into cells based on a test’s result
  • How to use nested IF

Using an Excel Analysis Table

  • How to format large amounts of data for readability using Table Styles.
  • How to analyse data with Table Styles.
  • How to use implicit names.

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.
  • Using Tables as the data source for Vlookup.

Pivot Tables and the Data Model

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

Concatenation

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

Flash Fill

  • How you can use Flash Fill to automatically populate columns of data modified from existing columns.

Overview of Quick Analysis*

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

Data Validation

  • Prevent invalid data being entered into a cell.
  • Create “dropdown” lists.

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*

Data Consolidation

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

Bried Overview of Power Pivot

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

*Only applicable in an Excel 2013 training course

Speak to a trainer now

0800 0199 746
for any questions about the courses we offer