Centre for Continuing Education

Microsoft Excel Course: Level 2

Microsoft Excel. Unlock insights and tell the story in your data.

Learn Microsoft Excel the smart way with Microsoft Excel courses at the University of Sydney.


This short course extends the learner’s knowledge of Excel beyond Microsoft Excel Course: Level 1 and provides you with skills and knowledge to produce more effective and productive workbooks. The short course covers formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features and working more effectively with existing worksheets and workbooks. Completion of this course provides sufficient knowledge to progress on to Microsoft Excel Course: Level 3.


Upon completion of this short course, you should be able to:

  1. Use the fill operations available to fill a data series.
  2. Move the contents of cells and ranges within and between workbooks.
  3. Work with logical functions.
  4. Create more complex formulas and functions.
  5. Apply a range of number formatting techniques to worksheet cells.
  6. Apply conditional formatting to ranges in a worksheet.
  7. Apply borders to cells and ranges in a worksheet.
  8. Apply a variety of page setup techniques.
  9. Work with elements that make up the structure of a worksheet.
  10. Use a range of techniques to work with worksheets.
  11. Use a range of find and replace techniques.
  12. Sort data in a list in a worksheet.
  13. Filter data in a table.
  14. Use a range of elements and features to enhance charts.
  15. Select and change the format of objects in a chart.


Filling data

  • 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.

Logical functions

  • Understanding Logical Functions.
  • Using IF With Text.
  • Using IF With Numbers.
  • Nesting IF Functions.
  • Using IFERROR.
  • Using TRUE And FALSE.
  • Using AND.
  • Using OR.
  • Using NOT.

Complex 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.
  • Switching To Manual Recalculation.
  • Pasting Values From Formulas.
  • Documenting Formulas.

Number formatting techniques

  • Applying Alternate Currencies.
  • Applying Alternate Date Formats.
  • Formatting Clock Time.
  • Formatting Calculated Time.
  • Understanding Number Formatting.
  • Understanding Format Codes.
  • Creating Descriptive Custom Formats.
  • Custom Formatting Large Numbers.
  • Custom Formatting For Fractions.
  • Padding Numbers Using Custom Formatting.
  • Aligning Numbers Using Custom Formats.
  • Customising The Display Of Negative Values.

Conditional formatting

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

Working with a worksheet

  • Understanding Worksheets.
  • Changing The Worksheet View.
  • Worksheet Zooming.
  • Viewing The Formula Bar.
  • Viewing Worksheet Gridlines.
  • Viewing The Ruler.
  • Inserting Cells Into A Worksheet.
  • Deleting Cells From A Worksheet.
  • Inserting Columns Into A Worksheet.
  • Inserting Rows Into A Worksheet.
  • Deleting Rows And Columns.
  • More Than One Worksheet.
  • Worksheet Wisdom.

Worksheet techniques

  • Inserting And Deleting Worksheets.
  • Copying A Worksheet.
  • Renaming A Worksheet.
  • Moving A Worksheet.
  • Hiding A Worksheet.
  • Unhiding A Worksheet.
  • Copying A Sheet To Another Workbook.
  • Moving A Sheet To Another Workbook.
  • Changing Worksheet Tab Colours.
  • Grouping Worksheets.
  • Hiding Rows And Columns.
  • Unhiding Rows And Columns.
  • Freezing Rows And Columns.
  • Splitting Windows.

Finding and replacing

  • Understanding Find And Replace Operations.
  • Finding Text.
  • Finding Cell References In Formulas.
  • Replacing Values.
  • Using Replace To Change Formulas.
  • Replacing Within A Range.
  • Finding Formats.
  • Finding Constants Using Go To Special.
  • Finding Formulas Using Go To Special.
  • Finding The Current Region.
  • Finding The Last Cell.

Sorting data

  • Understanding Lists.
  • Performing An Alphabetical Sort.
  • Performing A Numerical Sort.
  • Sorting On More Than One Column.
  • Sorting Numbered Lists.
  • Sorting By Rows.

Filtering data

  • Understanding Filtering.
  • Applying And Using A Filter.
  • Clearing A Filter.
  • Creating Compound Filters.
  • Multiple Value Filters.
  • Creating Custom Filters.
  • Using Wildcards.

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 Error Bars.
  • Adding A Data Table.

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.
  • Formatting With WordArt.
  • Changing WordArt Fill.
  • Changing WordArt Effects.

Delivery Style

Delivered as presenter-taught computer-based training in a Microsoft Windows environment. Please note that teaching instructions and materials are specifically tailored to Windows PC users.

Intended Audience

This short course is designed for existing users of Excel who would like to expand their skills and knowledge and learn more of the techniques associated with creating better and more productive workbooks. This short course assumes the learner has the skills and knowledge required to create, edit, print and chart simple worksheets. Understanding ranges and the copying process is 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 Basic Computer Skills Course and Effective Internet Use before attempting this course.


  • Free repeat class - Conditions apply
  • Free USB flash drive
  • Expert trainer
  • Dedicated computer for every student
  • Small class size
  • Student notes – yours to keep
  • Statement of completion

What others say.

  • I felt the tutor was an excellent presenter, was very informative and went out of their way to answer questions to ensure everyone had the correct understanding.

Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
Enrol Now
There are places available
If there isn't a class to suit you, please join the waiting list.