Microsoft Excel Course: Level 1

Microsoft Excel Course: Level 1

Microsoft Excel courses in Sydney. Learn to work smarter with your data.

Microsoft Excel is one of the world’s most popular spreadsheeting software applications. Learn Microsoft Excel with Microsoft Excel courses in Sydney – short courses created for you by the University of Newcastle.

This Microsoft Excel course is a beginner’s Excel course and aims to give you a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel before attempting more advanced features covered in Microsoft Excel Course: Level 2. In this Microsoft Excel course, particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Learning Outcomes

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

  1. Navigate your way around Microsoft Excel.
  2. Create and work with a new workbook.
  3. Open and navigate within workbooks and worksheets.
  4. Make changes to data in a workbook.
  5. Understand and work with ranges in a worksheet.
  6. Copy and paste data in Microsoft Excel.
  7. Use the fill operations available to fill a data series.
  8. Move the contents of cells and ranges within and between workbooks.
  9. Understand, create and work with formulas and functions.
  10. Understand and use formula cell referencing.
  11. Use font formatting techniques.
  12. Align the contents of cells in a number of ways.
  13. Understand and use the number formatting features in Microsoft Excel.
  14. Format rows and columns in a worksheet.
  15. Work with elements that make up the structure of a worksheet.
  16. Sort data in a list in a worksheet.
  17. Filter data in a table.
  18. Print your workbook data.
  19. Create effective charts in Microsoft Excel.
  20. Obtain help for Microsoft Excel whenever you need it.
  21. Understand points to consider to avoid problems in your worksheets.

Course Content

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

Getting to Know Microsoft Excel

  • Starting Microsoft Excel From the Desktop.
  • Understanding the Microsoft Excel Start Screen.
  • The Microsoft Excel Workbook Screen.
  • How Microsoft Excel Works.
  • Using the Ribbon.
  • Showing and Collapsing the Ribbon.
  • Understanding the Backstage View.
  • Accessing the Backstage View.
  • Using Shortcut Menus.
  • Understanding Dialog Boxes.
  • Launching Dialog Boxes.
  • Understanding the Quick Access Toolbar.
  • Adding Commands to the QAT.
  • Understanding the Status Bar.
  • Exiting Safely From Microsoft Excel.

Creating a New Workbook in Microsoft Excel

  • Understanding Workbooks.
  • Using the Blank Workbook Template
  • Typing Text.
  • Typing Numbers.
  • Typing Dates.
  • Typing Formulas.
  • Easy Formulas.
  • Saving a New Workbook on Your Computer.
  • Checking the Spelling.
  • Making Basic Changes.
  • Safely Closing a Workbook.

Working With Microsoft Excel Workbooks

  • Opening an Existing Workbook.
  • Navigating a Workbook.
  • Navigating Using the Keyboard.
  • Using Go To.
  • Recent Files and Folders.

Editing in a Microsoft Excel Workbook

  • Understanding Data Editing.
  • Overwriting Cell Contents.
  • Editing Longer Cells.
  • Editing Formulas.
  • Clearing Cells
  • Deleting Data.
  • Using Undo and Redo.

Selecting Ranges in Microsoft Excel

  • Understanding Cells and Ranges.
  • Selecting Contiguous Ranges.
  • Selecting Non Contiguous Ranges.
  • Selecting Larger Ranges.
  • Selecting Rows.
  • Selecting Columns.

Copying Data in Microsoft Excel

  • Understanding Copying in Microsoft Excel.
  • Using Fill for Quick Copying.
  • Copying From One Cell to Another.
  • Copying From One Cell to a Range.
  • Copying From One Range to Another.

Filling Data in Microsoft Excel

  • Understanding Filling.
  • Filling a Series.
  • Filling a Growth Series.
  • Extracting With Flash Fill.

Moving Data in Microsoft Excel

  • Understanding Moving in Microsoft Excel.
  • Moving Cells and Ranges.
  • Moving by Dragging.

Microsoft Excel Formulas and Functions

  • Understanding Formulas.
  • Creating Formulas That Add.
  • Creating Formulas That Subtract.
  • Formulas That Multiply and Divide.
  • Understanding Functions.
  • Using the SUM Function to Add.
  • Summing Non-Contiguous Ranges.
  • Calculating an Average.
  • Finding a Maximum Value.
  • Finding a Minimum Value.
  • Creating More Complex Formulas.
  • What if Formulas.
  • Common Error Messages.

Microsoft Excel Formula Referencing

  • Absolute Versus Relative Referencing.
  • Relative Formulas.
  • Problems With Relative Formulas.
  • Creating Absolute References.
  • Creating Mixed References.

Font Formatting in Microsoft Excel

  • Understanding Font Formatting.
  • Working With Live Preview.
  • Changing Fonts.
  • Changing Font Size.
  • Growing and Shrinking Fonts.
  • Making Cells Bold.
  • Italicising Text.
  • Underlining Text.
  • Changing Font Colours.
  • Changing Background Colours.
  • Using the Format Painter.

Cell Alignment in Microsoft Excel

  • Understanding Cell Alignment.
  • Horizontal Cell Alignment.
  • Vertical Cell Alignment.
  • Indenting Cells.

Number Formatting in Microsoft Excel

  • Understanding Number Formatting.
  • Applying General Formatting.
  • Formatting for Money.
  • Formatting Percentages.
  • Formatting as Fractions.
  • Formatting as Dates.
  • Using the Thousands Separator.
  • Increasing and Decreasing Decimals.

Row and Column Formatting in Microsoft Excel

  • Approximating Column Widths.
  • Setting Precise Columns Widths.
  • Setting the Default Column Width.
  • Approximating Row Height.
  • Setting Precise Row Heights.

Working With a Microsoft Excel Worksheet

  • Understanding Worksheets.
  • Changing the Worksheet View.
  • Worksheet Zooming.
  • Viewing the Formula Bar.
  • Viewing Worksheet Gridlines.
  • Inserting Cells Into a Worksheet.
  • Deleting Cells From a Worksheet.
  • Inserting Columns Into a Worksheet.
  • Inserting Rows Into a Worksheet.
  • Deleting Rows and Columns.
  • Working With Multiple Worksheets.
  • Worksheet Wisdom.

Sorting Data in Microsoft Excel

  • Understanding Lists.
  • Performing an Alphabetical Sort.
  • Performing a Numerical Sort.
  • Sorting on More Than One Column.

Filtering Data in Microsoft Excel

  • Understanding Filtering.
  • Applying and Using a Filter.
  • Clearing a Filter.
  • Creating Compound Filters.
  • Multiple Value Filters.
  • Creating Custom Filters.
  • Using Wildcards.

Printing in Microsoft Excel

  • Understanding Printing.
  • Previewing Before You Print.
  • Selecting a Printer.
  • Printing a Range.
  • Printing an Entire Workbook.
  • Specifying the Number of Copies.
  • The Print Options.

Creating Microsoft Excel Charts

  • Understanding the Charting Process.
  • Choosing the Right Chart.
  • Using a Recommended Chart.
  • Creating a New Chart From Scratch.
  • Working With an Embedded Chart.
  • Resizing a Chart.
  • Repositioning a Chart.
  • Printing an Embedded Chart.
  • Creating a Chart Sheet.
  • Changing the Chart Type.
  • Changing the Chart Layout.
  • Changing the Chart Style.
  • Printing a Chart Sheet.
  • Embedding a Chart Into a Worksheet.
  • Deleting a Chart.

Intended Audience

Providing comprehensive and thorough coverage of the basics of using Microsoft Excel, this Microsoft Excel course is ideal for new or existing users seeking to learn Microsoft Excel tasks outlined in the course content.

Delivery Style

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

Course Prerequisites

This Microsoft Excel course assumes little or no knowledge of spreadsheets or Microsoft Excel. 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.

Course Features

Available course dates

No dates that suit you? Be the first to know when we schedule more. Get notified.