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