Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
This course aims to provide new Excel users with a foundation knowledge of Excel’s core features such as formulas, formatting, navigation, printing and creating charts.
This Microsoft Excel short course will help you improve the way you manage and present information, and take the legwork out of calculations and data manipulation. It provides the skills and knowledge necessary to create and manage workbooks and covers topics including adding data, editing data, working with formulas, printing and charting.
This is an ideal introductory course before progressing onto Intermediate Microsoft Excel Course
By attending this ICL training course, delegates will be able to:
Create and work with a new workbook
Open and navigate within workbooks and worksheets
Understand and work with ranges in a worksheet
Understand, create and work with formulas and functions used to perform calculations
Copy and paste data
Understand and use formula cell referencing
Use font formatting techniques
Align the contents of cells in a number of ways
Format rows and columns in a worksheet
Understand and use the number formatting features
Print workbook data
Create effective charts.
Presenter-taught training in a computer lab
Online training via the platform Zoom or MS Teams
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.
Additional information
Please bring a USB flash drive to class if you would like to make a copy of your work or any relevant class materials. Alternatively, you can save these to a cloud storage space or email them to your personal email address.
Software
Recommended operating system: Windows or Mac
Recommended software for PC: MS Excel 2013, 2016, 2019, 365
Recommended software for Mac OS: MS Excel 2016, 2019, 365
Recommended browser: Chrome
Suitable for beginners. Assumes little or no knowledge of Microsoft Excel.
Getting to know Excel
Starting from the desktop
Understanding the start screen
The workbook screen
How 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 quick access toolbar
Understanding the status bar
Exiting safely
Creating a new workbook
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
Printing a worksheet
Safely closing a workbook
Working with workbooks
Opening an existing workbook
Navigating a workbook
Navigating using the keyboard
Using go to
Recent files and folders
Editing in a workbook
Understanding data editing
Overwriting cell contents
Editing longer cells
Editing formulas
Clearing cells
Deleting data
Using undo and redo
Selecting ranges
Understanding cells and ranges
Selecting contiguous ranges
Selecting non-contiguous ranges
Using special selection techniques
Selecting larger ranges
Selecting rows
Selecting columns
Copying data
Understanding copying
Using fill for quick copying
Copying from one cell to another
Copying from one cell to a range
Copying from one range to another
Copying relative formulas
Copying to a non-contiguous range
Copying to another worksheet
Copying to another workbook
Formulas and functions
Understanding formulas
Creating formulas that add
Creating formulas that subtract
Formulas that multiply and divide
Understanding functions
Using the sum function
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
Formula referencing
Absolute versus relative referencing
Relative formulas
Problems with relative formulas
Creating absolute references
Creating mixed references
Font formatting
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
Applying strikethrough
Subscripting text
Superscripting text
Practice exercise
Cell alignment
Understanding cell alignment
Horizontal cell alignment
Vertical cell alignment
Rotating text
Indenting cells
Number formatting
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
Approximating column widths
Setting precise columns widths
Setting the default column width
Approximating row height
Setting precise row heights
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
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
Printing
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 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