×
×
×
×
×

Certificate in Excel 2013 Advanced Online Short Course

$199.00
AT A GLANCE
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 2013 supports many new features, which can help you or your organisation track your important data. Learn how the advanced features of Excel 2010 can help you manage your data more efficiently.

    The Excel 2013 Advanced Online Short Course is provided by Courses For Success to help you better understand Excel’s capabilities. Many of the tools offered by Excel can help you analyse numbers and graphically represent information in its workbooks, affording you greater control over your data.

    Learn how to navigate the new interface with ease, and work with more advanced features of charts, formulas and macros. The course even covers how Excel integrates with SkyDrive, so that you can access your spreadsheets from any computer.

    The modules contained within this online short course enable you to progress through the material at your own pace.

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

  • Ideal for

     

    This short course is a great resource to help you learn how to better manage spreadsheets with advanced tools in Excel 2013.

    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

     

    After working through each of the modules in this course, you will be able to:

    • Use SmartArt and objects in your worksheets
    • Use auditing tools to help track changes
    • Record and run macros which can help you automate actions in your workbooks
    • Create charts to help you graphically represent your data in a variety of styles
    • Analyse your data using the what-if analysis tool

    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
    • Editing the diagram
    • Adding pictures
    • Adding textboxes
    • 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

    • Using recommended charts
    • Inserting a chart
    • Overview of the chart tools tabs
    • Understanding chart elements
    • Resizing and moving the chart

    Module 5: Working with charts

    • Using chart elements
    • Using chart styles and colours
    • Using chart filters
    • Working with data labels

    Module 6: Creating PivotTables and PivotCharts

    • Inserting a PivotTable using Excel recommendations
    • Choosing fields and grouping data
    • Overview of the PivotTable tools tabs
    • Changing the data displayed and refreshing the PivotTable
    • Creating a PivotChart from a PivotTable or 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 error checking
    • Using the trace errors commands
    • 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.

×