EXL16 L2 – Microsoft Excel 2016 Level 2

Price: $416.00 (ex. GST)
Code: EXL16 L2
Duration: 1 day
Location: Virtual Classroom (AEST)
Schedule: Virtual Classroom (AEST)
  • 07/06/2022 - 07/06/2022
  • 02/08/2022 - 02/08/2022
Enquire Now
Book Your Course
Clear
    Attendees
    Reset options

General Description

The skills and knowledge acquired in Microsoft Excel 2016 Level 2 are sufficient to be able to produce more effective and productive workbooks.

Outcomes

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

  • Use a range of techniques to work with worksheets
  • Use a range of find and replace techniques
  • Apply a variety of page setup techniques
  • Sort data in a list in a worksheet
  • Filter data in a table
  • Use the fill operations available to fill a data series
  • Understand and use formula cell referencing
  • Use data linking to create more efficient workbooks
  • Create and use defined names in a workbook
  • Use logical functions to test whether a statement is true or false
  • Apply conditional formatting to ranges in a worksheet
  • Use a range of elements and features to enhance charts
  • Select and change the format of objects in a chart
  • Understand and create simple PivotTables

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

  • 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
  • Changing Worksheet Tab Colours
  • Grouping Worksheets
  • Hiding Rows and Columns
  • Unhiding Rows and Columns
  • Freezing Rows and Columns
  • Splitting Windows
  • 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
  • Understanding Page Layout
  • Using Built in Margins
  • Setting Custom Margins
  • Changing Margins by Dragging
  • Centring on a Page
  • Changing Orientation
  • Specifying the Paper Size
  • Setting the Print Area
  • Clearing the Print Area
  • Inserting Page Breaks
  • Using Page Break Preview
  • Removing Page Breaks
  • Setting a Background
  • Clearing the Background
  • Settings Rows as Repeating Print Titles
  • Clearing Print Titles
  • Printing Gridlines
  • Printing Headings
  • Scaling to a Percentage
  • Fit to a Specific Number of Pages
  • Strategies for Printing Worksheets
  • Understanding Lists
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Sorting on More Than One Column
  • Sorting Numbered Lists
  • Sorting by Rows
  • Understanding Filtering
  • Applying and Using a Filter
  • Clearing a Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards
  • 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
  • Absolute Versus Relative Referencing
  • Relative Formulas
  • Problems With Relative Formulas
  • Creating Absolute References
  • Creating Mixed References
  • Understanding Data Linking
  • Linking Between Worksheets
  • Linking Between Workbooks
  • Updating Links Between Workbooks
  • Understanding Defined Names
  • Defining Names From Worksheet Labels
  • Using Names in Typed Formulas
  • Applying Names to Existing Formulas
  • Creating Names Using the Name Box
  • Using Names to Select Ranges
  • Pasting Defined Names Into Formulas
  • Defining Names for Constant Values
  • Creating Names From a Selection
  • Scoping Names to a Worksheet
  • Using the Name Manager
  • Documenting Defined Names
  • 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
  • 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 Chart Elements
  • Adding a Chart Title
  • Adding Axes Titles
  • Repositioning the Legend
  • Showing Data Labels
  • Adding a Data Table
  • Showing Gridlines
  • Formatting the Chart Area
  • Adding a Trendline
  • Adding Error Bars
  • 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
  • Understanding Sparklines
  • Creating Sparklines
  • Editing Sparklines

Reviews

There are no reviews yet.

Enquire now

Enquire now

    Cart
    Unfortunately, Your Cart Is Empty
    Please Add Something In Your Cart