Byron Employment

Byron Employment. Over 71,625 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $280.00

Level

Intermediate

Duration

7 Hours

Frequency

Monthly

Course Contents

Editing and Formatting Techniques

  • Finding and Replacing
  • Creating and Applying a New Style
  • Using Workbook Templates
  • Alignment Options in Format Cells Dialog Box

Absolute Cell References
Absolute Column and Row References
Financial Functions
Logical Functions (The IF Statement)
Date/Time Functions
Creating a Chart

  • Plotting a Basic Chart
  • Modifying and Enhancing Charts
  • Previewing and Printing Charts
  • Plotting No-Contiguous Data in a Chart
  • Plotting Pie Charts
  • Adding New Data to and Existing Chart

Linking Worksheets within a Workbook

  • Setting up Related Worksheets
  • Navigating Between Worksheets
  • Copying Data between Worksheets
  • Editing Data on Several Worksheets
  • Using a Formula to Link Worksheet Data
  • Formatting Multiple Worksheets in One Operation

Controlling Worksheet Display

  • Split Workbook and Freeze Panes
  • Hiding Rows and Columns
  • Adjusting Zoom Levels

Excel and the Web

  • Accessing the Internet From Within Excel
  • Linking an Excel Workbook to a Web Page
  • Saving Excel Data as a Web Page

Using the Paste Special Commands
Creating and Using Drawings In Excel
Inserting Pictures into a Worksheet
Sending Excel Data Via Email

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search