×
×
×
×
×

Certificate in Excel 2013 Expert 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

     

    Learn how to use the many powerful tools available in Excel 2013 to help you manipulate your worksheet data. Excel 2013 is designed to provide you with advanced tools that enable you to graphically represent your important information.

    The online short course is offered by Courses For Success and targets the expert tools available in Excel 2013. Learn how to work with forms and advanced controls in this Excel 2013 Expert Online Short Course.

    Use Excel 2013 to its potential by mastering the skills you’ll learn in this online short course. You can learn how to use Excel 2013 from the comfort of your home or any computer.

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

  • Ideal for

     

    This online short course is a perfect resource for anyone looking to acquire expert skills in Microsoft 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 completing this course, you will be able to:

    • Track your workbook changes
    • Share workbooks with other people
    • Create charts with trend lines, axes and templates
    • Graphically represent your information
    • Analyse data from multiple tables
    • Manipulate PowerView and PivotTables

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

  • Course Content

     

    Module one: getting started

    • Course objectives

    Module two: working with permissions and options

    • Marking a workbook as final
    • Encrypting with a password
    • Protecting the current sheet or the workbook structure
    • Adding a digital signature
    • Setting Excel options
    • Managing versions
    • Saving a workbook as an excel template

    Module three: sharing workbooks

    • Inspecting a document
    • Sharing a workbook
    • Editing a shared workbook
    • Tracking changes
    • Merging copies of a shared workbook

    Module four: performing advanced formula and function tasks

    • Using the watch window
    • About the Excel calculation process
    • Setting calculation options
    • Enabling or disabling automatic workbook calculations
    • Using the IFERROR function to evaluate formulas

    Module five: working with array formulas

    • About array formulas
    • Creating one-dimensional and two-dimensional constants
    • Creating a simple array
    • Creating an advanced array

    Module six: working with macros

    • Assigning a macro to a command button
    • Running a macro by clicking an area of a graphic object
    • Configuring a macro to run automatically upon opening the workbook

    Module seven: working with forms

    • About Excel forms, form controls, and active x controls
    • Using a data form
    • Using a list box control
    • Using a combo box control
    • Using a spin button control
    • Using a scroll bar control

    Module eight: applying advanced chart features

    • About trend lines
    • Add a trend line
    • Using secondary axes
    • Using chart templates

    Module nine:  working with slicers and timelines

    • About slicers and timelines
    • Creating a slicer in an existing table
    • Formatting a slicer
    • Using a timeline

    Module ten: working with multiple tables, relationships and external data

    • Connecting to a new external data source
    • Creating a pivot table using an external data connection
    • Working with pivot tables based on multiple tables

    Module eleven: working with Power View

    • About Power View
    • Creating a Power View sheet
    • Add a table to the data model
    • Adding a map to a power view report

    Module twelve: 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.

×