Microsoft Excel 2007 or 2010: Advanced - Formulae & Functions

Course Overview

By the end of this course you will be proficient in the use of advanced formulae and functions, you will have gained an understanding of Formula referencing and be able to create multi function calculations.

CourseMonster have thousands of the latest IT, Technical, Sales, Marketing, HR, Finance, Project Management, Legal, Health & Safety, Management and Leadership training courses to choose from. Use our quick search bar to find the ideal Microsoft course for you. Alternatively call or email us.

Related Courses

• Microsoft Excel 2007: Upgrade New Features
• Microsoft Excel 2007: Introduction for Beginners (1 day)
• Microsoft Excel 2007: Visual Basic for Applications (VBA) Programming (2 day)
• Microsoft Excel 2007: Advanced (1 day)
• Microsoft Excel 2007: Intermediate (1 day)
• Microsoft Excel 2007: Intermediate (2 day)
• Microsoft Excel 2007: Advanced
• Microsoft Excel 2007: Formulae & Functions
• Microsoft Excel 2007: Charts, Pivot Tables & Macros
• Microsoft Excel 2007: Intermediate and Advanced Training Course

Audience

Designed for existing users of Excel.

Prerequisites

It is assumed that the participant will have either attended an Excel Intermediate course or has equivalent knowledge.

Course Outline

Formulae

• Refresh on Formulae
• Absolute referencing
• Mixed referencing

Named Ranges

• Add & delete a named range
• Use named ranges in a formula
• Natural Language

Set Display Options

• Customise Quick Access
• Toolbar
• Options

Advanced Autofill

• Fill Weekdays
• Fill Values Only
• Growth Trend

Format Worksheets

• Apply accounting, currency & scientific formats
• Create custom number formats
• Conditional formatting

Multiple Workbooks

• Link workbooks
• Use multiple workbooks
• Save a workspace
• Consolidate information

Forecasting

• Goal Seek
• Scenario Manager
• Solver

Advanced Functions

• String functions
• Logical functions
• Random numbers and rounding
• Nesting If's
• CountIfs
• SumIfs
• Handling errors
• HLookups
• VLookups
• Date Functions
• Subtotals

Auditing a Worksheet

• Check and review data
• Finding cells that refer to a specific formula
• Finding formulas that refer to a specific cell
• Finding errors