Excel Intermediate 2013 Course
(4.79 out of 5)
2872 Excel intermediate student evaluations
Location: |
Level 2 80 Mount St North Sydney NSW 2060 |
Break Times: (approx) |
10:30 (15mins) 12:30 (1hr) 14:45 (15mins) |
Duration: |
1 day |
Participants: |
Max 10 |
Course Length: |
9:00 to 16:30 |
Price: (inc GST) |
$
385
|
|
|
Sale Price: (inc GST) |
$
250
|
Quick links
Course Overview
The Excel Intermediate course is suited to students who have either attended an Excel Basic course or those who are experienced in working with Excel spreadsheets and have a fairly good understanding of the features and tools of Excel. Students attending this course are generally working with large amounts of data and are required to summarise and manipulate the information quickly. They are looking for tools and/or techniques to speed up their processes to manage and manipulate their work related data utilised within their current workflows. These students are familiar with creating basic formulas and want to implement them more effectively.
As a result of this course students will be able to manage multiple worksheets and workbooks including construction of formulas across worksheets. They will learn how to utilise Excel’s advanced formatting features, manage large amounts of data, sort data, filter data, outline and subtotal their spreadsheets. Competency will also be gained in advanced charting, auditing techniques and greater understanding of constructing formulas.
Course Prerequisites
Microsoft Excel Beginner 2013 or equivalent
Course Inclusions
FREE Course Re-sit
8 months
When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.
FREE Email Support
12 months
Free email support for up to 12 months from the scheduled course date.
Small Class Sizes
10 students
All of our courses are capped at a maximum of 10 students to maximise your learning experience.
Classroom Training
All of our courses are face to face, hands on, classroom based training delievered by
.
Course Manual
With each course we provide you with a comprehensive course manual for you to practice post course.
Computer Lab
No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.
Course Certificate
Every student receives a certificate of completion at the end of course to recognise your new
skills.
Public Course Dates
25-Aug-22 (Thu) | $250.00 |
|
0
|
ON SALE
|
07-Sep-22 (Wed) | $385.00 |
|
0
|
|
20-Sep-22 (Tue) | $385.00 |
|
0
|
|
11-Oct-22 (Tue) | $385.00 |
|
0
|
|
26-Oct-22 (Wed) | $385.00 |
|
0
|
|
Virtual Course Dates (via Zoom)
There are currently no virtual course dates scheduled for this course.
Call us today to discuss - 1300 937 782.
Courses start
from
$250
(inc GST).
Limited seats.
Book today!
Course Outline
MANAGING MULTIPLE WORKSHEETS AND WORKBOOKS
Managing Data Across Multiple Worksheets
- Renaming Worksheets In A Workbook
- Selecting Adjacent Worksheets
- Selecting Non-Adjacent Worksheets
- Simultaneously Enter Data Into Multiple Worksheets
- Creating And Preparing A Summary Sheet
Creating 3-D Formulas
- Entering A 3-D Formula Across Worksheets
- Enter A 3-D Formula Using A Sum Function
Combining Data From Different Worksheets Or Workbooks
- Consolidating Data In a Worksheet
- Consolidating Data Across Multiple Workbooks
- Manage Linked Workbooks
- Move / Copy Worksheets To Another Workbook
NAMED RANGES
Using Range Names
- Define A Named Range Quickly
- Define Multiple Named Ranges Using The Ribbon
- Pasting A Named Range In A Formula
- Selecting a Named Range From A List
- Using The ‘Paste Name’ Dialogue Box
WORKING WITH EXCEL TABLES
Introducing General Table Rules
Applying The Table Tool
- Creating A Table
- Changing The Style Applied To A Table
- Create Your Own Table Style
- Showing Or Hiding Table Features
- Adding The Total Row To A Table
- Inserting Table Rows
- Deleting Table Rows
- Resizing The Table
- Performing A Simple Sort
- Sorting By More Than One Column
- Customising The Default Sort Order
- Enable And Disable The AutoFilter In A Table
- Applying A Filter
- Clearing A Filter
- Custom Number And Date Filters
- Use A Search To Filter A Table
- Removing The Table Tool
THE VLOOKUP FUNCTION
- Setting Up Named Ranges
- Entering A VLOOKUP Function
- Using the Insert Function Wizard To Enter A VLOOKUP
- Use A VLOOKUP Function To Automate Data Entry
- Use A VLOOKUP Function To Find The Closest Match
OUTLINING DATA
- Creating An Outline Automatically
- Removing An Outline
- Outlining Large Worksheets
- Manually Creating An Outline
- Copying Outlined Results Using Visible Cells Only
- Subtotalling A Table And Outlining The Results
- Managing The Outline Using Outline Levels
- Removing A Subtotal
ADVANCED FORMATTING, STYLES AND THEMES
Customise The Appearance Of Dates And Numbers Using Advanced Formatting
- Formatting Numbers Overview
- Custom Number Format Syntax And Examples
- Customise The Number Format Using Format Cells
- Customise The Date Format Using Format Cells
Conditional Formatting
- Using Conditional Formatting To Highlight Cells
- Adding Data Bars To A Range
- Using Colour Scales
- Rank Data Using Icon Sets
- Creating A New Rule
- Edit An Existing Rule
- Setting The Precedence Of The Rules
- Stopping A Rule
- Clearing A Rule
Maintaining Consistency With Styles Or Themes
- Apply An In-Built Cell Style
- Create Your Own Cell Style
- Applying A Custom Cell Style
- Modifying A Cell Style
- Deleting A Cell Style
- Applying A Theme To A Workbook
CHARTS
Creating A Chart
- Inserting A Chart
- Changing The Existing Chart Type
- Manipulating The Chart Data Source
- Swap Rows/Columns
- Change The Data Series Order
- Moving A Chart
Modify A Chart
- Change A Chart Layout
- Change The Existing Chart Style
- Adding And Editing The Chart Title
- Adding Axis Titles
- Moving The Legend
- Adding Data Labels
- Showing A Data Table
- Add / Remove Gridlines
- Inserting A New Chart Element
- Delete An Existing Chart
Format The Chart
- Selecting Chart Elements
- Formatting Chart Elements
- Using WordArt In A Chart
- Using Pictures In A Chart
- Create A Combination Chart
- Creating A Pie Chart
- Rotating A 3D Chart Type
- Exploding A Wedge In A Pie Chart
- Sparklines in Excel
- Changing Sparkline Options
REVIEWING FORMULAS - Appendix
Simple Formulas In Excel
- Entering Formulas Using The Keyboard
- Manually Entering Formulas
- Working With Relative References
- Working With Absolute References
- Applying Absolute Cell Reference
Using Simple Functions In Excel
- Entering A Function To Perform A Calculation
- Using AutoSum To Calculate Row/Column Totals
- Using the Insert Function Wizard