Centre for Continuing Education

Microsoft Excel Course: Level 2

Microsoft Excel. Open to everyone.

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

Aims

Provides you with skills and knowledge to produce more effective and productive workbooks. Completion provides sufficient knowledge to progress on to Microsoft Excel Course: Level 3.

Outcomes

  1. Move the contents of cells and ranges within and between workbooks.
  2. Apply a range of number formatting techniques to worksheet cells.
  3. Apply borders to cells and ranges in a worksheet.
  4. Apply a variety of page setup techniques.
  5. Work with elements that make up the structure of a worksheet.
  6. Use a range of techniques to work with worksheets.
  7. Use a range of find and replace techniques.
  8. Use a range of elements and features to enhance charts.

Content

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.

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.

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.

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

Designed for existing users who would like to expand their skills and knowledge and learn more of the techniques associated with creating better and more productive workbooks. 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.

Features

  • 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

Enrol Now
There are 5 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
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.