Excel - Intermediate 2010/2013/365

Enquire About This Course

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

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 structured exercises, this course will increase your competence in day-to-data analysis making you more efficient & productive. 

 LEARNING 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

 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

• ProtectCellRanges
• 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,
• Include Hidden Rows, Columns, Filter Settings

Click here to download our Course Outline:

Excel - Intermediate 2017

Unsure what course level suits you best? Please complete our Pre-Course Questionnaire, return to us and we will contact you with our recommendations as soon as we have reviewed:

ExcelPreCourseQuestionnaire_17

Enquire About This Course