Excel Intermediate NI

Summary

This course will give you the skills to perform simple data analysis in Excel. You will learn how to use formulas, conditional formatting, filtering and sorting and many more data analysis features. By completing practical 'hands-on' structured exercises, this course will increase your competence in day-to-data analysis making you more efficient & productive.

Venue details:  
Belfast, 8-10 Amelia Street, Belfast
Start date & time:  
02 November 2019 09:30
End date & time:  
02 November 2019 16:30
Price: €200.96  (€190.92 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
7.00
CPD hours:  
7.00
Speaker details
First nameLast name
Mullan Training

Description

Product type:  
CPD course
Category:  
Information technology

Who should attend?

Those who have working knowledge of creating/formatting simple spreadsheets, basic formulas and functions e.g. AutoSum. Or our Excel Introduction Course.

Course Content

  • Sheet Operations
  • Copy/ Move Within Current File And To External Files
  • Group Sheets (Select Adjacent & Non-Adjacent Sheets)
  • Link Worksheets Within A Single File
  • Link Worksheets to External Files

Security

  • Protect Cell Ranges
  • Password Protect Files
  • Advanced Functions
  • IF Function & Nested IF Statements
  • And & Or Functions
  • Lookup Functions (Horizontal And
  • Vertical Lookup
  • Subtotals
  • Conditional Formatting
  • 3D Ranges
  • Create & Maintain (Within Worksheets In a Single File & Between External Files)
  • Consolidate Data (via 3D Ranges & Using The Consolidate Tool)

Data

  • Enter & Select Records Using The Input Form
  • Sort Data Into Lists
  • Filter Data - Autofilter, Advanced Filter
  • Validation Rules

Outlines

  • Group Row/ Column Data To Create Outline Levels Based On Worksheet Formulae
    Display Summary Rows And Summary Styles

Custom Views

  • Create, Modify, Delete
  • Include Hidden Rows, Columns, Filter Settings

Key Leanring outcomes

  • At the end of this course you will have an understanding of some of the higher functions of Excel
  • You will be able to perform calculations and functions such as H&V Lookups & Conditional Formatting
  • Having practiced all of these new skills extensively during the course; on your return to the office you will be able to put into practice what you have learnt and complete your Excel work more efficiently.
  • You will be qualified to progress to our Excel Advanced course