Microsoft Excel: Intermediate

Course Overview

A natural progression from our introductory courses that provides expert guidance through more complex functions and plenty of practice and examples to build confidence using them

Microsoft is an increasing popular career choice. This Microsoft training course will help accelerate your job prospects.

Related Courses

• Microsoft Excel: Introduction for Beginners (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (1 day)
• Microsoft Excel: Visual Basic For Applications (VBA) Programming (2 day)
• Microsoft Excel: Formulae & Functions (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (2 day)
• Microsoft Excel: Visual Basic for Applications (VBA) Programming (4 day)
• Microsoft Excel: Charts, Pivot Tables & Macros (1 day)
• Microsoft Excel: Financial Modelling (2 day)
• Microsoft Excel: Business Modelling for Telecoms (2 day)
• Microsoft Office: Word, Excel & PowerPoint: Introduction for Beginners (1 day)

Audience

Suitable for people who have attended the introduction course or have sufficient knowledge and understanding of the basics of Excel and are looking to expand this

Skills Gained

• Know how to protect your data using the security features
• Achieve automation of worksheets using excel look up features
• Improved interpretation of data by learning to create and customise graphs, including plotting trend lines
• Learn how Excel can make decisions using the 'If' function and conditional formatting

Course Outline

• Review of Excel fundamentals
• Building 3-dimensional worksheets
• Worksheet templates
• Protection and security
• Grouping worksheets
• Data tables and lookup functions
• Introduction to the 'If' function
• Group and outline functions
• Building graphs and using trend lines
• Database features including sorting and filtering data
• Methods to validate data
• Colours based on values (getting Excel to change the formatting characteristics based on the cell contents)