Excel - Adv (1 Day) 2010/2013/365

Enquire About This Course

We are currently delivering Online Excel training via our Virtual Classroom and Classroom Based training at our Belfast City Centre Premises in Amelia Street - see our websites for more info:

https://www.mullanvirtualtraining.co.uk

https://mullanittraining.co.uk/

PREREQUISITES
Experience with the fundamental use and features of Microsoft Excel, including the ability to create formulae and basic functions. 

SUMMARY

This course will give you the skills to tackle more complex data analysis.  With the use of the If Function, Vlookup and Pivot Tables you will have the necessary skills to extract information from your spreadsheets.  By completing structured exercises, this course will increase your competence in data analysis, helping you to meet targets more efficiently. 

LEARNING OUTCOMES

• 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.
• 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 VBA course.

 COURSE CONTENT

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)

Sparklines

• Inserting Sparklines
• Customizing Sparklines

 

Pivot Tables

• Create Pivot Table
• Work With Row/ Column Fields
• Data Fields
• Customise Table Display

Organising Workbooks

• Create Templates
• Protect Ranges & Worksheets

Data

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

 

Macros

• Create Macros ?€? Record & Modify the VBA Code Generated
• Relative Referencing
• Assign To Toolbars/ Keyboard
• Make Available To All New Documents/ Current Document Only

Outlines

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

Custom Views

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

Click here to download our Course Outline:

Excel Advanced 1 Day

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