Microsoft Excel 2010/2013 (Intermediate)
Course Details
icon-dollar Fees: $345 + GST* icon-book Course ID: EXL006
icon-clock-o Duration: 1 Day icon-file-text Certificate: Only participation
icon-archive Delivery Type: Classroom icon-globe Language: English
icon-flag-checkered Locations: Perth

icon-pencil-square Notes:

  • Discount on multiple person bookings available. Give us a call for an obligation free quote.
  • If you would like the training to be arranged at your premises, we can do that. Please contact us via email or phone for quotation and further information.

About this course

Microsoft Excel 2010/2013 Intermediate course has been designed for people who desire to use more advanced features of Microsoft Excel 2010/2013 such as working with formulas and functions, diagrams and controls, managing tables, graphics etc. The Course Highlight section below has in detail what features you will learn in this course.

We highly recommend that the participants have done our Microsoft Excel 2010/2013 Foundation course or have knowledge of the topics before enrolling in this course.

Course Highlights

Section 1: Setup & Printing Issues

In this section you will learn:

  • Worksheet Margins
  • Worksheet Orientation
  • Worksheet Page Size
  • Headers and Footers
  • Header and Footer Fields
  • Scaling Your Worksheet to Fit a Page(S)
  • Visually Checking Your Calculations
  • Displaying Gridlines When Printing
  • Printing Titles on Every Page
  • Printing Row and Column Headings
  • Spell Checking
  • Previewing a Worksheet
  • Viewing Workbooks Side By Side
  • Zooming the View
  • Printing Options
  • Setting the Number of Copies to Print
  • Selecting a Printer
  • Selecting Individual Worksheets or the Entire Workbook
  • Selecting Which Pages to Print
  • Single or Double Sided Printing
  • Collation Options
  • Page Orientation
  • Paper Size
  • Margins
  • Scaling
  • Printing

Section 2: Functions and Formulas

In this section you will learn how to:

  • Getting Help with Functions
  • Nested Functions
  • Consolidating Data Using a 3-D Reference Sum Function
  • Mixed References within Formulas
  • Inserting the Current Time and Date
  • Today Function
  • Now Function
  • Day Function
  • Month Function
  • Year Function
  • Round Function
  • Rounddown Function
  • Roundup Function
  • If Function
  • And Function
  • Or Function
  • Sumif Function
  • Count Function
  • Counta Function
  • Countif Function
  • Countblank Function
  • Rank Function
  • Left Function
  • Right Function
  • Mid Function
  • Trim Function
  • Concatenate Function
  • Fv Function
  • Pv Function
  • Npv Function
  • Rate Function
  • Pmt Function
  • Vlookup Function
  • Hlookup Function
  • Dsum Function
  • Dmin Function
  • Dmax Function
  • Dcount Function
  • Daverage Function

Section 3: Manipulating Worksheets

In this section you will learn about:

  • Copying or Moving Worksheets between Workbooks
  • Splitting a Window
  • Hiding Rows
  • Hiding Columns
  • Hiding Worksheets
  • Un-Hiding Rows
  • Un-Hiding Columns
  • Un-Hiding Worksheets

Section 4: Named Ranges & Cell Formatting

In this section you will learn how to:

  • Naming Cell Ranges
  • Removing a Named Range
  • Named Cell Ranges and Functions
  • Applying Styles to a Range
  • Conditional Formatting
  • Custom Number Formats

Section 5: Templates

In this section you will learn how to:

  • Using Templates
  • Creating Excel Templates
  • Editing Excel Templates

Section 6: Paste Special Options

In this section you will learn how to:

  • Using Paste Special to Add, Subtract, Multiply & Divide
  • Using Paste Special ‘Values’
  • Using Paste Special Transpose Option