Support

Microsoft Excel 2007 Course | Advanced - Mackay

2 sessions available starting from $330.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

Course aim:
This course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel to an advanced level

Course outline:
ADVANCED TOPICS
- Setting Excel Options
- Excel and Windows
- Using the Excel Viewer

GETTING THE MOST FROM YOUR DATA
- Getting the Most from Your Data
- PivotTables
- More About PivotTables
- Exploring Scenarios
- What If Analysis

EXCEL AND THE INTERNET
- Excel and Hyperlinks
- Saving Workbooks as Web Pages
- Getting Data from the Internet
- Excel and Office Servers

ADVANCED EXCEL TASKS
- Creating and Using Shared Workbooks
- Using Custom AutoFill Lists
- Using the VLOOKUP Function
- Linking, Consolidating, and Combining Workbooks

ADD-INS, SMART TAGS AND DIGITAL SECURITY
- Add-ins and the Trust Center...

see more

Course aim:
This course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel to an advanced level

Course outline:
ADVANCED TOPICS
- Setting Excel Options
- Excel and Windows
- Using the Excel Viewer

GETTING THE MOST FROM YOUR DATA
- Getting the Most from Your Data
- PivotTables
- More About PivotTables
- Exploring Scenarios
- What If Analysis

EXCEL AND THE INTERNET
- Excel and Hyperlinks
- Saving Workbooks as Web Pages
- Getting Data from the Internet
- Excel and Office Servers

ADVANCED EXCEL TASKS
- Creating and Using Shared Workbooks
- Using Custom AutoFill Lists
- Using the VLOOKUP Function
- Linking, Consolidating, and Combining Workbooks

ADD-INS, SMART TAGS AND DIGITAL SECURITY
- Add-ins and the Trust Center
- Information Rights Management
- Digital Signatures
-: Smart Tags and XML

MACROS, VBA AND EXCEL PROGRAMMING
- Macros
- More Macro Tasks
- Visual Basic and Macros

EXPERT TOPICS
- Form Controls
- Advanced Functions
- Using SharePoint
- User Forms and ActiveX Controls

Pre-requisites:
This course is designed for current Microsoft Excel users who can build basic workbooks. It is assumed that the user will know how to create and save a workbook, create formulas and use functions, and perform simple formatting of the data.

see less

Choose from 2 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 1/47 Sydney St
    Mackay, QLD 4740

Price: $330.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 1/47 Sydney St
    Mackay, QLD 4740

Price: $330.00

Type

  • Class / Group Sessions



My Other Listings

Illustrator Course - CS3 & CS4 Introduction
Illustrator Course - CS3 & CS4 Introduction
1 session available for $770.00
Project 2010 Course | Introduction - Brisbane
Project 2010 Course | Introduction - Brisbane
2 sessions available starting from $850.00
Risk Management Course - Brisbane
Risk Management Course - Brisbane
2 sessions available starting from $350.00

see all listings ยป


Found In