Excel Interm

Excel - Intermediate

Our 1 day Microsoft Excel Intermediate course is suitable for those with a sound working knowledge of Microsoft Excel 2007, Excel Microsoft 2010 and Excel Microsoft 2013 and who wish to progress to the more complicated functions and features.

PREREQUISITES

A working knowledge of Excel or our Introduction to MS Excel course

BENEFITS

At the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications. You will then 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