×
×
×
×
×

Certificate in Excel 2010 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

     

    Spreadsheet software is a valuable resource that can help you or your organisation manage data more efficiently. Learn how to use the expert features of Excel 2010 to simplify your ability to manage and manipulate spreadsheet data.

    This online short course, offered by Courses For Success, helps you to understand the many higher-level capabilities of Excel 2010.

    Extend your knowledge of automated tasks in Excel using macros to help you expertly track and analyse data and manipulate worksheets. Learn to use functions that can help you calculate your data more efficiently, and create perfect diagrams by adding a trend line or custom axis to your charts.

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

  • Ideal for

     

    This short course will equip you with the tools you need to become an expert in spreadsheet management using advanced Excel functionalities. This is ideal for anyone required to use Excel in order to perform their job, or even just to better manage home finances or small business operations.

    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

     

    Upon completion of this short course, you will be able to:

    • Automate calculations by creating macros
    • Run macros automatically when you open your workbook
    • Manage different workbook versions
    • Share workbooks with others
    • Calculate data with advanced formulas and functions
    • Use form controls to help standardise data entry
    • Learn to work with chart templates, PivotTables, PivotCharts and much more

    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: Working with permissions and options

    • Marking workbook as final
    • Encrypting with a password and restricting permissions
    • 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 3: Sharing workbooks

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

    Module 4: 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 5: Working with array formulas

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

    Module 6: Working with functions

    • Working with math and trigonometry functions
    • Using a SUMIF function
    • Working with date and time functions
    • Working with financial functions
    • Working with text functions
    • Working with cube functions
    • Working with statistical functions

    Module 7: 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
    • Changing a macro

    Module 8: 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 9: Applying advanced chart features

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

    Module 10: Working with PivotTables and PivotCharts

    • Working with PivotTable tools
    • Working with PivotChart tools
    • About slicers
    • Creating a slicer in an existing PivotTable
    • Creating a standalone slicer
    • Formatting a slicer
    • Sharing slicers with another PivotTable
    • Disconnect or delete a slicer

    Module 11: Using the automated analysis tools add-in

    • Loading the analysis ToolPak
    • About the analysis ToolPak options (I)
    • About the analysis ToolPak options (II)
    • About the analysis ToolPak options (II)

    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.

×