Excel courses for beginners
Lenght
1
Price
$123
Version
22
About This Course
The Excel Beginners is an instructor-led, hands-on training course. This course includes the best Excel shortcuts, tips, and tricks, delivered from the start. These basic Excel skills can be used to create budgets, graphs, lists, simple reports, and more to efficiently perform a variety of tasks in the workplace.
Candidates learn how to set up Microsoft Excel, navigate through workbooks, save and close documents, create basic spreadsheets, and select and format cell ranges. Candidates also practise basic Excel formulas and learn how to use functions such as SUM, AVERAGE, and COUNT to perform quick calculations.
This training course is available in Melbourne, Sydney, Brisbane, Adelaide, Canberra, Perth, Hobart, Australia and can be attended live virtually from anywhere.
Register Now
- Candidates must have basic understanding of computer operating system
There is no exam associated with this training course
- Course material for Excel Beginners provided
- Instructor-led Classroom Training at our premises
- Live Virtual Online Training attend in real-time from anywhere
- In-House Training at your premises (4+ participants)
- Create, edit and save workbooks and spreadsheets
- Selecting workbook cell ranges
- Create formulas that perform calculations in the workbook
- Copy and fill data in the workbook
- Format cells in the workbook
- Print workbook data
- Create various charts and graphs in Excel.
- 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