Certificate in Excel 2010 Advanced Online Short Course

Provider Courses for Success
Course Outcome Certificate of Completion
Study Mode Online
Duration 6-8 hours
Start Date Anytime – start today!
Cost $199.00
  • What you'll learn


    Excel 2010 is an important resource to help you organise, maintain and visualise important data. Understanding the many advanced features in Excel empowers you to manage your data more effectively.

    This online short course is delivered by Courses for Success, and provides you with comprehensive walkthroughs of Excel features at a time and place that suits you. Learn how to manipulate data in spreadsheets without the risk of corrupting your important information.

    Learn how to visualise your data with SmartArt, Chart Tools, shapes and clip art. More advanced Excel features covered in this short course include pivot tables, macros and formula errors.

    After purchasing this course, you will be provided with unlimited, lifetime access to its materials.

  • Ideal for


    This short course is the perfect choice if you’re looking to improve your spreadsheet software knowledge and proficiency to an advanced level.

    There are no formal entry requirements for this short course, however you will need Adobe Acrobat Reader in order to access course materials.

  • Career Outcomes


    By the time you have finished this course, you will be able to confidentally:

    • Create special shapes and diagrams
    • Represent your spreadsheet data visually
    • Learn to use Chart Tools to create graphs from your numerical and non-numerical data
    • Record and run macros to automate repetitive tasks in your worksheets

    Completion of this short course will see you awarded with a Courses For Success certificate of completion.

  • Course Content


    Module 1: Getting started

    • Course objectives

    Module 2: SmartArt and objects

    • Inserting SmartArt
    • Adding text to the diagram
    • Resizing and moving the diagram
    • Resetting the diagram
    • Adding pictures from your computer
    • Adding clip art
    • Adding text boxes
    • Drawing shapes
    • About the contextual tabs

    Module 3: Auditing

    • Tracing precedent cells
    • Tracing the dependents of a cell
    • Displaying formulas within the sheet
    • Adding, displaying, editing, and removing comments

    Module 4: Creating charts

    • Inserting a chart
    • Overview of the chart tools tab
    • Understanding the parts of a chart
    • Changing the chart style
    • Resizing and moving the chart

    Module 5: Creating PivotTables

    • Inserting a PivotTable
    • Choosing fields and grouping data
    • Overview of the PivotTable tools tabs

    Module 6: Working with PivotTables and PivotCharts

    • Changing the data displayed and refreshing the PivotTable
    • Applying a style to your PivotTable
    • Creating a PivotChart from a PivotTable
    • Creating a PivotChart from data
    • Some real-life examples

    Module 7: Macros

    • Displaying the developer tab
    • Recording and running macros
    • Changing the security level
    • Customising and changing the Quick Access toolbar

    Module 8: Solving formula errors

    • Using named ranges
    • Understanding formula errors
    • Using the trace errors commands
    • Using error checking
    • Evaluating formulas

    Module 9: Using what-if analysis

    • Using goal seek
    • Using the scenario manager
    • Using a one input data table
    • Using a two input data table

    Module 10: managing your data

    • Transposing data from rows to columns
    • Using the text to columns feature
    • Checking for duplicates
    • Creating data validation rules
    • Consolidating data

    Module 11: Grouping and outlining data

    • Grouping data
    • Adding subtotals
    • Outlining data
    • Viewing grouped and outlined data

    Module 12: Wrapping up

    • Words from the wise
  • Payment Information


    Ready to get started straight away?

    Pay and enrol for this course through our quick and secure checkout system. MasterCard, Visa and PayPal accepted.

  • Why Courses for Success?

    Courses for Success

    Boasting one of the most extensive and diverse course lists on offer, Courses for Success have hundreds of online courses. With everything from accounting to art, wedding planning to web design, they are a great option for anyone with specific professional development needs or with a particular hobby to pursue – there really is a course to suit everyone.

    Courses for Success has developed its own online courses and utilises the latest technology to deliver them at affordable prices across ten countries. They have also partnered with some of Australia’s leading training providers to offer a range of accredited courses, with accessibility their main aim.

    As a student of Courses for Success, you’ll benefit from 24/7 access to your online course materials, enabling you to study whenever and wherever you want.

    You will also receive ongoing support from a tutor who is available to answer your questions and help keep you motivated as you may your way through the course material.