Intermediate Excel Course
Lenght
1
Price
$123
Version
22
About This Course
The Excel Intermediate is an instructor-led, hands-on training course. This course extends knowledge of Excel beyond Microsoft Excel and provides candidates with the skills and knowledge to develop more efficient and productive workbooks. Candidates learn how to manage list data, formulas and function methods, PivotTables, complex formatting, setting up complex print options, and using complex chart functions.
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 completed Excel Basic course
There is no exam associated with this training course
- Course material for Excel Intermediate 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)
- Use the available fill operations to fill the data series
- use different methods to work with worksheets
- Protect data in worksheets and workbooks
- Use the normal functions of worksheets
- Understand and create simple PivotTables
- Create more complex formulas and functions
- Apply a range of number formatting techniques to worksheet cells
- Apply conditional formatting to worksheet ranges
- Use Goal Search to determine the values needed to achieve the desired result
- Understand and use Excel’s quick analysis tools
- Create and work with tables
- Use different elements and functions to enhance charts
- For anyone who uses Microsoft Excel at work and wants to improve their skills and knowledge
- Filling Data
- Creating a Custom Fill List
- Modifying a Custom Fill List
- Deleting a Custom Fill List
- Extracting With Flash Fill
- More Complex Flash Fill Extractions
- Extracting Dates and Numbers
- Worksheet Techniques
- 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
- Protecting Data
- Understanding Data Protection
- Providing Total Access to Cells
- Protecting a Worksheet
- Working With a Protected Worksheet
- Disabling Worksheet Protection
- Providing Restricted Access to Cells
- Password Protecting a Workbook
- Opening a Password Protected Workbook
- Removing a Password from a Workbook
- Essential Functions
- Key Worksheet Functions
- Using IF With Text
- Using IF With Numbers
- Nesting IF Functions
- The LOOKUP Function
- Using Counting Functions
- The Round Function
- Rounding Up and Rounding Down
- Manipulative Functions
- The MOD Function
- The TODAY Function
- The NOW Function
- The DATE Function
- Using VLOOKUP
- Using VLOOKUP for Exact Matches
- Using HLOOKUP
- PivotTables
- Understanding PivotTables
- Recommended PivotTables
- Creating Your Own PivotTable
- Defining the PivotTable Structure
- Filtering a PivotTable
- Clearing a Report Filter
- Switching PivotTable Fields
- Formatting a PivotTable
- Complex Formulas
- Scoping a Formula
- Long-Hand Formulas
- Preparing for Complex Formulas
- Creating the Base Formula
- Adding More Operations
- Editing a Complex Formula
- Adding More Complexity
- Copying Nested Functions
- Switching to Manual Recalculation
- Pasting Values from Formulas
- Documenting Formulas
- 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
- Conditional Formatting
- 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 Sparklines
- Creating Sparklines
- Editing Sparklines
- Goal Seeking
- Understanding Goal Seeking
- Using Goal Seek
- The Quick Analysis Tools
- Understanding Quick Analysis
- Quick Formatting
- Quick Charting
- Quick Totals
- Quick Sparklines
- Quick Tables
- Worksheet Tables
- Understanding Tables
- Creating a Table from Scratch
- Working With Table Styles
- Inserting Table Columns
- Removing Table Columns
- Converting a Table to a Range
- Creating a Table from Data
- Inserting or Deleting Table Records
- Removing Duplicates
- Sorting Tables
- Filtering Tables
- Renaming a Table
- Splitting a Table
- Deleting a Table
- 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
- Chart Object Formatting
- 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
- Exploding Pie Slices
- Changing Individual Bar Colours
- Formatting Text