Byron Employment

Byron Employment. Over 71,639 Jobs Australia Wide.

Delivery Method

  • Online
  • Price: $66.00

Course Overview

Click here to see an example courseMicrosoft Excel provides powerful tools that enable you to analyse, share, and manage information in order to make more informed decisions. InterAction courses are packed with practical lessons and simulation that were developed in Australia - so yes you will be listening to Australian voices! Now you can access the same self-paced learning InterAction has been delivering to Corporate and Government organisations across the world for 25 years. Up to 85% of our screens are interactive, ensuring that you are constantly involved and thus motivated to learn. You can also start by completing an optional interactive pre-test which identifies any skills gaps you may have, and then recommends the most appropriate modules that you need to concentrate on to round off your knowledge. If you are an intermediate or advanced user, you will be directed to the specific topics that will supplement your existing knowledge.

Audience

You might be a new, intermediate or power user, or a user migrating from an earlier version. We assume that you also have the basics of operating your PC and Windows.

Delivery Method

Online Delivery

Language Options

English and Spanish

Total Learning Time

5 to 6 hours

Learn To

    Importing Data
  • Import Text Files
  • Use the Text Import Wizard
  • Save an Imported Worksheet
  • Import Using Drag and Drop
  • Query Databases
  • Import from HTML Files
  • Export Files
    Data Validation
  • Apply Data Validation
  • Set Validation Criteria
  • Enter Input Messages
  • Enter Error Alert
    Filtering Data
  • Add Automatic Filters
    Creating a Workspace
  • Select Consecutive Files
  • Select Non-consecutive Files
  • Open Multiple Files
  • Move between Workbooks
  • Arrange Workbooks
  • Save the Excel Workspace
  • Edit a Workspace File
  • Close Multiple Workbooks
    Consolidating Data
  • Consolidate Data
  • Select Destination Area
  • Consolidate Workbooks
  • Update Links
    Linking Workbooks
  • Link Data in Workbooks
  • Use Paste Special
    Share and Protect Worksheets
  • Group Edit
  • View User Name
  • Protect Worksheets
  • Remove Protection
  • Share Workbooks
  • Change File Properties
    Working with Comments
  • Use the Comments Feature
  • Insert Comments
  • Edit Comments
  • Display Comments
  • Move to Comments
    Tracking Changes
  • Track Changes in a Workbook
  • Highlight Tracking Changes
  • Shared Workbook Revisions
  • Hide Highlighting
  • Accept or Reject Revisions
  • Remove Tracking
    Auditing Tools
  • Use Auditing Tools
  • Trace Dependents
  • Trace Errors in Formulas
  • Correct Formula Errors
    The Scenario Manager
  • Name Scenario Cells
  • Name the Result Cell
  • Create a Scenario
  • Set Scenario Manager Options
  • Create Summary Reports
    Custom Views
  • Define Custom Views
  • Prepare a Custom View
  • Hide Rows for Custom View
  • Apply Custom Views

Subscription Period

This course is available in 3, 6 and 12 month subscriptions. Please call Interaction Training for respective prices.

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 9948 0455
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 9948 0455 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search