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

    Formatting Data
  • Introduction
  • Formatting Data and Cells
  • Formatting Numeric Data
  • Changing Fonts
  • Changing Font Size
  • Automatic Row Height Adjustment
  • Changing Text Colour
  • Aligning Data
  • Centring Titles across columns
  • Aligning Data in Cells
  • Bold, Italic and Underline
  • Bolding Data
  • Adding Borders
  • Adding Background Colour
  • Using the Format Painter
    Formatting Menu Options
  • Introduction
  • Use the Clear Command
  • Align Data Vertically
  • Rotate Text
  • Apply Border Styles
  • Use Number Format Options
  • Add Patterns
  • Indent Cell Entries
    Additional Formatting Features
  • Introduction
  • Insert Columns and Rows
  • Delete Columns and Rows
  • Adjust Column Widths
  • Change Row Heights
  • Undo and Redo Actions
  • AutoFormat a Worksheet
  • Create and Apply Styles
  • Extend Formatting and Formulas
    Custom and Conditional Formatting
  • Introduction
  • Custom and Conditional Formatting
  • Changing Numeric Formats
  • Number Format Options
  • Currency Format Options
  • Accounting Format Options
  • Custom Number Formats
  • Conditional Formatting
    Customising the Ribbon and Quickstart
  • Introduction
  • Working with the Ribbon
  • Minimising the Ribbon
  • Restoring the Ribbon
  • Keyboard Shortcuts
  • Adding commands to the Quick Access Toolbar
  • Assigning a Macro
  • Moving the Quick Access Toolbar
  • Removing commands from Quick Access Toolbar
  • Resetting Toolbars
    3D Workbooks
  • Introduction
  • Using Multiple Worksheets
  • Naming Sheet Tabs
  • Moving Worksheets
  • Copying Worksheets
  • Copying Between Worksheets
  • Editing Data
  • Clearing Cells
  • Selecting 3D Ranges
  • Ungrouping Worksheets
  • Inserting, Deleting and Ungrouping
  • Deselecting Cells
  • Multiple Sheet Formulas
  • Copying with AutoFill
  • Saving Workbooks
    Splitting Freezing and Hiding
  • Introduction
  • Working with Large Spreadsheets
  • Using Zoom
  • Using Full Screen View
  • Exiting Full Screen View
  • Hiding Rows in a Worksheet
  • Unhiding Rows
  • Hiding Columns
  • Unhiding Columns
  • Splitting Windows
  • Freezing Panes
  • Unfreezing Panes
    Pivot Tables
  • Introduction
  • Creating a PivotTable
  • The PivotTable Outline
  • PivotTable Layout
  • Rearranging a PivotTable
  • Updating PivotTable Data
  • Displaying all PivotTable Records
  • Customising a Field
  • PivotTable Report Options
    Pivot Tables on the Web
  • PivotTables on the Web
  • Saving a Web Page
  • Selecting Web Page Items
  • Publishing the PivotTable List
    Working with Macros
  • Introduction
  • Macros
  • Writing Macros
  • Recording Macros
  • Running Macros
  • Running Macros
  • Editing a Macro
    Outlining
  • Introduction
  • What is Outlining?
  • Automatic Outline Feature
  • Hiding Outline Details
  • Showing Outline Details
  • Print Preview an Outline
  • Using Row Level Buttons
  • Selecting all Rows
  • Removing Outline Options
  • Manually Grouping Data
  • Removing Group Outline
    Sorting and Subtotals
  • Introduction
  • Sort and Subtotal
  • Sort on One Column
  • Multiple Column Sort
  • Report using Subtotals
  • Sort Data for Subtotals
  • Add Subtotals
    Goal Seeker and Solver
  • Introduction
  • Goal Seek and Solver
  • Working with Goal Seek
  • Working with Solver
  • Setting the Solver Target Cell
  • Selecting Adjustable Cells
  • Applying Constraints
  • Solver Results
    Creating a Web Page
  • Introduction
  • Web Tools
  • What is the Internet?
  • Services on the Internet
  • Accessing the World Wide Web
  • Workbook Web Pages
  • Previewing as a Web Page
  • Saving a Workbook Web Page
  • Opening in Web Browser
  • Editing a Web Page
  • Creating a Hyperlink
  • Activating a Hyperlink
    Worksheets and Email
  • Introduction
  • E-mailing a Worksheet
  • Adding Send to Mail Recipient
  • E-mailing a Worksheet
  • Entering Header Details
  • Sending a Message
  • Opening a Sent Message

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