Course Details close

Course Details

Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
$ 250
Application:Excel
Level:Intermediate
Version:2010
Duration:1 day
Location:
Level 2
80 Mount St
North Sydney
NSW 2060
Participants:Max 10
Length:9:00 to 16:30
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

Excel Intermediate 2010 Course

   (4.77 out of 5)
2295 Excel intermediate student evaluations

Quick links

Excel Intermediate 2010 Course

Course Overview

The Excel Intermediate course is suited to students who have either attended a basic course in Excel or spreadsheet training, or those who have been working experience with Excel and have a basic understanding of the features of Excel. Students attending this course are working with large amounts of data and are required to manipulate it to quickly locate information. They are looking for techniques to speed up their processes to manage and manipulate the lists of data they are required to work with. They are familiar with basic formulas and want to implement them more effectively.

As a result of this course students will be able to manage multiple workbooks including construction of formulas across worksheets. They will be learn how to utilise Excels advanced formatting features, manage large amounts of data and work with the sorting, filtering, outlining and subtotal tools. Competency will be gained in advanced charting, auditing techniques and templates.

Course Prerequisites

Microsoft Excel Beginner 2007 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

Every student will receive a printed course manual with step by step instructions to use as a reference guide.

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.

Course Dates

Course Date Price Add Course Qty Status
06-Mar-19 (Wed)$250.00 0
ON SALE
06-Mar-19 (Wed)$250.00 0
ON SALE
12-Mar-19 (Tue)$385.00 0
20-Mar-19 (Wed)$385.00 0
28-Mar-19 (Thu)$250.00 0
ON SALE
04-Apr-19 (Thu)$385.00 0
09-Apr-19 (Tue)$385.00 0
17-Apr-19 (Wed)$385.00 0
02-May-19 (Thu)$385.00 0
09-May-19 (Thu)$385.00 0
14-May-19 (Tue)$385.00 0
22-May-19 (Wed)$385.00 0
30-May-19 (Thu)$385.00 0
04-Jun-19 (Tue)$385.00 0
12-Jun-19 (Wed)$385.00 0
18-Jun-19 (Tue)$385.00 0
27-Jun-19 (Thu)$385.00 0
02-Jul-19 (Tue)$385.00 0
11-Jul-19 (Thu)$385.00 0
18-Jul-19 (Thu)$385.00 0
24-Jul-19 (Wed)$385.00 0
30-Jul-19 (Tue)$385.00 0
08-Aug-19 (Thu)$385.00 0
13-Aug-19 (Tue)$385.00 0
21-Aug-19 (Wed)$385.00 0
29-Aug-19 (Thu)$385.00 0
04-Sep-19 (Wed)$385.00 0
12-Sep-19 (Thu)$385.00 0
17-Sep-19 (Tue)$385.00 0
24-Sep-19 (Tue)$385.00 0
Training courses on sale now

Courses start
from $250 (inc GST).
Limited seats.
Book today!

Course Outline

MULTIPLE WORKSHEETS AND WORKBOOKS

Working With Multiple Worksheets

  • Rename A Worksheet
  • Group Adjacent Worksheets
  • Group Non-Adjacent Worksheets
  • Enter Data Into A Group Of Worksheets
  • Setup A Summary Sheet

Using A 3-D Formula Across Worksheets

  • Enter A 3-D Formula
  • Enter A 3-D Formula Using A Function

Combining Worksheets And Data From Different Workbooks

  • Consolidating Data
  • Linking Information From Multiple Workbooks
  • Managing The Formula Links
  • Moving Or Coping Worksheets Into Another Workbook

NAMING RANGES

Creating And Using Named Ranges

  • Quickly Define Named Range
  • Defining Multiple Named Ranges
  • Insert A Named Range Into A Formula
  • Entering Named Ranges Into A Formula From A List
  • Using ‘Paste Name’ To Enter Named Ranges

TABLES

General Table Setup Rules

Creating A Table

  • Create A Table
  • Change The Table Style
  • Create Your Own Table Style
  • Show / Hide Table Elements
  • Add The Total Row
  • Insert And Delete Table Rows / Columns
  • Resize An Existing Table
  • Perform A Simple Sort
  • Sort By Multiple Columns
  • Change The Sort Order
  • Use AutoFilter To Show Specific Records
  • Turning The AutoFilter On / Off
  • Appling / Removing A Filter
  • Custom Filters
  • Use A Search To Create A Filter
  • Convert A Table To A Normal Range

VLOOKUP Function

  • Range Names For The Table Array
  • Use Vlookup To Automate A Search
  • Enter A VLOOKUP Using the Insert Function Wizard
  • Enter Vlookup Functions To Assist with Data Entry
  • Return The Closest Match Using A VLOOKUP

Using Simple Database Functions

  • Sum Records Using DSUM
  • Average Records Using DAVERAGE
  • Counting Records Using DCOUNT / DCOUNTA
  • Finding The Highest And Lowest Values Using DMAX And DMIN

OUTLINING DATA IN A WORKSHEET

Data Outlining

  • Outlining Data Automatically
  • Removing An Outline Automatically
  • Auto Outlining Large Worksheets
  • Creating An Outline Manually
  • Copy The Outline Results With Visible Cells Only
  • Subtotal A Table
  • Showing And Hiding Content Using Outline Symbols
  • Removing A Subtotal From A Table

USING ADVANCED FORMATTING, STYLES AND THEMES

Advanced Number And Date Formatting

  • Built-In Number Formats
  • Advanced Custom Number Formats
  • Customising Number Formats
  • Customising Date Formats

Conditional Formatting Data

  • Highlight Cells Using A Conditional Format
  • Implementing Data Bars Into A Range Of Cells
  • Implementing Colour Scales
  • Use Icon Sets To Rank Data
  • Create New Conditional Format Rule
  • Edit Conditional Format Rules
  • Set The Precedence Of Conditional Format Rules
  • Stop A Conditional Format Rule
  • Clear Conditional Format Rules

Maintaining Format Consistency With Themes And Styles

  • Built-in Cell Styles
  • Custom Cell Styles
  • Apply Built-in Or Custom Cell Styles
  • Modifying And Deleting A Cell Style
  • Appling A Theme

CHARTING

Create A Chart

  • Insert A Chart Into A Worksheet
  • Modify The Chart Type
  • Setting The Chart Data Source
  • Change Grouping By Rows Or Columns
  • Setting The Data Series Order
  • Move An Existing Chart

Modify An Existing Chart

  • Change The Chart Layout
  • Change The Chart Style
  • Change The Chart Title
  • Add / Remove The Axis Titles
  • Change The Location Of The Legend
  • Add Data Labels To A Chart
  • Add A Data Table To A Chart
  • Add Or Remove Gridlines
  • Insert And Deleting New Chart Elements

Chart Formatting

  • Select Elements In A Chart
  • Chart Element Formatting
  • Adding WordArt To A Chart
  • Adding Pictures To A Chart
  • Combination Charts
  • Working With Pie Charts
  • Set The Rotation For 3D Charts
  • Explode A Wedge In A Pie Chart
  • Adding Sparklines in Excel
  • Modifying Sparklines

REVIEWING FORMULAS - Appendix

Using A Simple Formulas In Excel

  • Using The Keyboard To Enter A Formula
  • Using Manual Operators In A Formula
  • Relative Cell References
  • Absolute Cell References
  • Applying An Absolute Cell References To A Formula

Working With Simple Functions

  • Entering A Simple Function
  • Use The AutoSum Button To Calculate Totals
  • Using Insert Function To Enter A Formula

Student Comments

  • Excel Intermediate training course
    Was great. Looking forward to the Advanced Course.
    - Merryn
  • Excel Intermediate training course
    Craig is an excellent teacher with great patience when working with a number of clients who have a range of abilities. This course has met many of my needs as I was not sure if I was to be in the intermediate or beginners course. Definitely recommend this
    - Caroline
  • Excel Intermediate Training Course
    Excellent and friendly method
    - Maneet
  • Excel Intermediate training course
    Loved it - I wish I did it sooner!
    - Laura
  • Excel Intermediate Training Course
    The presenter is excellent
    - John
  • Excel Intermediate Training Course
    Very professional and very well presented.
    - Troy
  • Excel Intermediate Training Course
    Craig is an awesome trainer who kept the group flowing at the same pace and made sure no one left behind. Excellent trainer!
    - Sandra
  • Excel Intermediate Training Course
    Sean is a very friendly and professional trainer, very helpful! :)
    - Luke
  • Excel Intermediate Training Course
    Craig knows his stuff. Found the course to be excellent.
    - Ian
  • Excel Intermediate training course
    trainer was great and very patient !
    - Melanie
  • Excel Intermediate Training Course
    This course was excellent. It will really help with my work.
    - Seema
  • Excel Intermediate training course
    All the course was relevant and practical. Very useful my day-to-day excel use. Great course - thanks Craig!
    - Daniel
  • Excel Intermediate Training Course
    Good level of detail. I feel like an expert is excel now.
    - Felippe
  • Excel Intermediate Training Course
    The course will surely help me. Looking forward to getting the next level advanced excel.
    - Mercy
  • Excel Intermediate Training Course
    Sean was fantastic!
    - Meng
  • Excel Intermediate Training Course
    The trainer is very knowledgeable and professional. Open for questions and willing to introduce into the course subjects that not were programmed initially but were relevant to students.
    - Andres
  • Excel Intermediate Training Course
    Excellent forum for learning
    - Julie
  • Excel Intermediate training course
    Course content and trainer Sean was very helpful.
    - Jason
  • Excel Intermediate training course
    Facilitator was great and has a vast knowledge.
    - Adrian
  • Excel Intermediate Training Course
    Great atmosphere; tutor is fantastic. I am looking forward to my advanced excel course with Sean.
    - Mila
  • Excel Intermediate Training Course
    Great course I learnt a lot more than I thought I would.
    - Melanie
  • Excel Intermediate Training Course
    Excellent would recommend to others
    - Tamlyn
  • Excel Intermediate training course
    Great presenter! Made something I would normally find not so fun, actually fun!
    - Kathryn
  • Excel Intermediate training course
    the course was very helpful and I really enjoyed it
    - Stephanie
  • Excel Intermediate Training Course
    Thank you so much Craig for adapting the day to our skill level.
    - Lindsey
  • Excel Intermediate Training Course
    I found the size of the training group to be just right allowing the feel of a more personalised approach. The trainer was excellent and I will definitely be returning to complete the advanced excel course with this provider.
    - Toni
  • Excel Intermediate Training Course
    Craig was fabulous - he has made me enjoy excel !
    - Karan
  • Excel Intermediate Training Course
    Great presenter who knew her subject and carried on professionally whilst suffering personal sickness
    - Sue
  • Excel Intermediate Training Course
    Libby was absolutely fantastic. She explained everything simply and effectively. Very impressed with raising the bar - I certainly will recommend in future. Thanks again
    - Sam
  • Excel Intermediate training course
    It was thorough and informative. The refresher at the start was also helpful, Thank you!
    - Nicole

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us