Thanks for adding:

Proceed to Checkout

Continue browsing

X
Microsoft Excel Course: Level 2

Microsoft Excel Course: Level 2

Share on

Microsoft Excel courses in Sydney. Insights are all in your data.

Learn Microsoft Excel with Microsoft Excel courses in Sydney at NEWCourse – created for you by the University of Newcastle.

The skills and knowledge acquired in this Microsoft Excel course enable users to expand their knowledge beyond content covered in Microsoft Excel Course: Level 1 and learn how to create more productive Excel workbooks. This Excel course covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking. Completion of this Microsoft Excel course provides sufficient knowledge for learners to proceed to Microsoft Excel Course: Level 3.

Learning Outcomes

At the completion of this Microsoft Excel training course you should be able to:

  1. Use the fill operations available to fill a data series.
  2. Use a range of techniques to work with worksheets.
  3. Apply a variety of page setup techniques.
  4. Apply borders to cells and ranges in a worksheet.
  5. Use common worksheet functions.
  6. Create more complex formulas and functions.
  7. Create and use defined names in a workbook.
  8. Apply a range of number formatting techniques to Excel worksheet cells.
  9. Apply conditional formatting to ranges in a worksheet.
  10. Use goal seeking to determine the values required to reach a desired result.
  11. Understand and use Excel’s Quick Analysis tools.
  12. Create and work with tables.
  13. Use a range of elements and features to enhance charts.
  14. Select and change the format of objects in a chart.

Course Content

The following content will be covered in this Microsoft Excel course:

Filling Data in Microsoft Excel

  • Understanding Filling.
  • Filling a Series.
  • Filling a Growth Series.
  • Filling a Series Backwards.
  • Filling Using Options.
  • Creating a Custom Fill List.
  • Modifying a Custom Fill List.
  • Deleting a Custom Fill List.
  • Extracting With Flash Fill.
  • More Complex Flash Fill Extractions.
  • Extracting Dates and Numbers.

Microsoft Excel Worksheet Techniques

  • Inserting and Deleting Worksheets.
  • Copying Worksheet.
  • Renaming a Worksheet.
  • Moving a Worksheet.
  • Hiding a Worksheet.
  • Unhiding a Worksheet.
  • Copying a Sheet to Another Workbook.
  • Changing Worksheet Tab Colours.
  • Hiding Rows and Columns.
  • Unhiding Rows and Columns.
  • Freezing Rows and Columns.

Microsoft Excel Page Setup

  • Strategies for Printing Worksheets.
  • Understanding Page Layout.
  • Using Built in Margins.
  • Setting Custom Margins.
  • Changing Margins by Dragging.
  • Centering on a Page.
  • Changing Orientation.
  • Specifying the Paper Size.
  • Setting the Print Area.
  • Clearing the Print Area.
  • Inserting Page Breaks.
  • Using Page Break Preview.
  • Removing Page Breaks.
  • Settings Rows as Repeating Print.
  • Titles.
  • Clearing Print Titles.
  • Printing Gridlines.
  • Printing Headings.
  • Scaling to a Percentage.
  • Fit to a Specific Number of Pages.

Applying Borders in Microsoft Excel

  • Understanding Borders.
  • Applying a Border to a Cell.
  • Applying a Border to a Range.
  • Applying a Bottom Border.
  • Applying Top and Bottom Borders.
  • Removing Borders.

Essential Microsoft Excel Functions

  • Key Worksheet Functions.
  • Using IF With Text.
  • Using IF With Numbers.
  • Nesting IF Functions.
  • The LOOKUP Function.
  • Using Counting Functions.
  • The ROUND Function.
  • Rounding Up and Rounding Down.
  • The TODAY Function.
  • The NOW Function.
  • The DATE Function.

Complex Microsoft Excel Formulas

  • Scoping a Formula.
  • Long-Hand Formulas.
  • Preparing for Complex Formulas.
  • Creating the Base Formula.
  • Adding More Operations.
  • Editing a Complex Formula.
  • Adding More Complexity.
  • Copying Nested Functions.
  • Pasting Values From Formulas.

Defined Names in Microsoft Excel

  • Understanding Defined Names.
  • Defining Names From Worksheet Labels.
  • Using Names in Typed Formulas.
  • Applying Names to Existing Formulas in Excel.
  • Creating Names Using the Name Box.
  • Using Names to Select Ranges.
  • Pasting Defined Names Into Formulas.
  • Defining Names for Constant Values.
  • Creating Names From a Selection.
  • Scoping Names to a Worksheet.
  • Using the Name Manager.
  • Documenting Defined Names.

Microsoft Excel Number Formatting Techniques

  • Applying Alternate Currencies.
  • Applying Alternate Date Formats.
  • Formatting Clock Time.
  • Understanding Number Formatting in Excel.
  • Understanding Format Codes.
  • Creating Descriptive Custom Formats.
  • Custom Formatting Large Numbers.

Microsoft Excel Conditional Formatting

  • Understanding Conditional Formatting.
  • Formatting Cells Containing Values.
  • Clearing Conditional Formatting.
  • More Cell Formatting Options.
  • Top Ten Items.
  • Working With Data Bars.
  • Working With Icon Sets.
  • Understanding Sparklines.
  • Creating Sparklines.
  • Editing Sparklines.

Microsoft Excel Goal Seeking

  • Understanding Goal Seeking.
  • Using Goal Seek.

The Quick Analysis Tools in Excel

  • Understanding Quick Analysis.
  • Quick Formatting.
  • Quick Charting.
  • Quick Totals.
  • Quick Sparklines.
  • Quick Tables.

Microsoft Excel Worksheet Tables

  • Understanding Tables.
  • Creating a Table From Scratch.
  • Working With Table Styles.
  • Inserting Table Columns.
  • Removing Table Columns.
  • Converting a Table to a Range.
  • Creating a Table From Data.
  • Inserting or Deleting Table Records.
  • Sorting Tables.
  • Filtering Tables.
  • Renaming a Table.
  • Deleting a Table.

Microsoft Excel Chart Elements

  • Understanding Chart Elements.
  • Adding a Chart Title.
  • Adding Axes Titles.
  • Repositioning the Legend.
  • Showing Data Labels.
  • Showing Gridlines.
  • Formatting the Chart Area.
  • Adding a Trendline.
  • Adding a Data Table.

Microsoft Excel Chart Object Formatting

  • Understanding Chart Formatting.
  • Selecting Chart Objects.
  • Using Shape Styles.
  • Changing Column Colour Schemes.
  • Changing the Colour of a Series.
  • Changing Line Chart Colours.
  • Using Shape Effects.
  • Colouring the Chart Background.
  • Understanding the Format Pane.
  • Using the Format Pane.
  • Exploding Pie Slices.
  • Changing Individual Bar Colours.
  • Formatting Text.

Intended Audience

This Microsoft Excel training course provides a comprehensive and thorough coverage of formulas and function techniques, advanced formatting and charting features and data manipulation tools. It is ideal for anyone who has completed Microsoft Excel Course: Level 1 or for existing users seeking to expand their knowledge of Excel.

Delivery Style

This Microsoft Excel course is presented as a practical, instructor-led computer-based training course in a Microsoft Windows environment. In this course you’ll have dedicated access to a computer exclusively for your use so you can follow instructor training and work through examples in an application-focused teaching environment.

Course Prerequisites

This Microsoft Excel course assumes the learner has the knowledge required to create, edit, print and chart simple worksheets. Understanding ranges and copying is also important. You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending the Basic Computer Skills Course before attempting this course.

    Free repeat course (conditions apply)

    Free USB Flash drive

    Face to face with expert trainers

    Dedicated computer for every student

    Small class sizes

    Course materials – yours to keep

    Certificate of completion

  • A great facility offering good courses. The campus was clean, modern and well appointed. The classroom size for the Excel level 2 course was spacious. Our trainer was excellent, engaging and personable.

Classes

Microsoft Excel Course: Level 2
$348 GST free
Finished
Microsoft Excel Course: Level 2
Sydney CBD (Venue TBA)
$348 GST free
$348 GST free
Enrol Now
There are places available
Microsoft Excel Course: Level 2
$348 GST free
Enrol Now
There are places available
Microsoft Excel Course: Level 2
Sydney CBD (Venue TBA)
$348 GST free
$348 GST free
Enrol Now
There are places available
Microsoft Excel Course: Level 2
Sydney CBD (Venue TBA)
$348 GST free
$348 GST free
Enrol Now
There are places available
Microsoft Excel Course: Level 2
Sydney CBD (Venue TBA)
$348 GST free
$348 GST free
Enrol Now
There are places available

No classes that suit you? Please join our waitlist and we will notify you when we have places available. Join Waitlist

What others say about this course