Microsoft Excel - Intermediate to Advanced

By getting the most from your software, you can save time, improve business efficiency and produce professionally presented data. This course is designed to give users an understanding of some of the more advanced features and functions within Excel and the advantages of using a powerful electronic spreadsheet. Being entirely ‘hands on’, delegates will practice using Excel to manage, automate and customise workbooks.

Key Objectives

After attending this course delegates will understand:

• Having a refresher to Excel
• Creating more advanced formulae
• Working with more advanced functions
• Automating procedures with basic mactos
• Using multiple worksheets and linking data
• Nesting and Mixing Functions
• Workbook and Worksheet protection

Course Outline

• Linking and Grouping sheets
• Linking files
• Workspaces
• Named Ranges
• Sorting Lists
• Subtotals
• Filters
• Analysing data with Pivot Tables
• Data Validation
• Database functions
• The IF Functions
• Nested IF Functions
• AND, OR Functions
• Date Functions
• Text Functions
• HLOOKUP and VLOOKUP
• Database Functions
• Recording Macros
• Absolute and Relative Referencing in Macros
• Assigning Macros to tool bar icons, keyboard shortcuts and buttons

Key Benefits

• Better trained staff using more advanced functionality
• Presenting complex information to support business needs
• Logical structured approach to reporting information
• Improved techniques for communicating and evaluating data
• Consistent and reliable approaches to data collection