×
×
×
×
×

Certificate in Excel 2013 Essentials 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 offers an infinite array of powerful tools to help you manage your data better – whether that’s in the home or office. This online short course is a great place to start if you’d like to learn the basics of what this popular spreadsheet software has to offer.

    Delivered by Courses for Success, the course teaches you how to manipulate and track your data, analyse numbers and visually represent information. You’ll be instructed in how to navigate the Excel 2013 interface, and learn how to get the most out of this version’s increased worksheet and workbook size.

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

  • Ideal for

     

    This short course is ideal for anyone who is interested understanding the basic features of Excel 2013. This knowledge will come in handy in just about any business setting, or help streamline your home budgeting and finance.

    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 end of this course, you’ll be able to:

    • Open and close workbooks in Excel
    • Enter data into cells
    • Differentiate between rows and columns
    • Save notebooks in publishing formats such as PDF files
    • Understand how formulas and functions operate in your worksheet
    • Merge cells and apply cell styles to help you visualise your data

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

  • Course Content

     

    Module 1: Getting dtarted

    • Course objectives

    Module 2: Opening and closing Excel

    • Opening Excel
    • Understanding the interface
    • Using Backstage View
    • Understanding worksheets
    • Understanding workbooks

    Module 3: Your first worksheet

    • Entering data
    • Editing data
    • Using the wrap command
    • Adding rows and columns
    • Checking your spelling

    Module 4: Working with Excel files

    • Saving files
    • Publishing files to PDF
    • Sending files via email
    • Closing files
    • Opening files

    Module 5: viewing Excel data

    • An overview of Excel’s views
    • Switching views
    • Creating custom views
    • Using zoom
    • Switching between open files

    Module 6: Printing Excel data

    • An overview of the page layout tab
    • Setting up your page
    • Using print preview
    • Printing data

    Module 7: Building formulas

    • The math basics of Excel
    • Building a formula
    • Editing a formula
    • Copying a formula
    • Relative vs. absolute references

    Module 8: Using Excel functions

    • Formulas vs. functions
    • Using the sum function
    • Using other basic Excel functions
    • Understanding the formulas tab
    • Using the status bar to perform calculations
    • Understanding the new function names

    Module 9: Using time saving tools

    • Using Autofill
    • Using Autocomplete
    • Sorting data
    • Filtering data
    • Adding sparklines

    Module 10: Formatting your data

    • Changing the appearance of text
    • Changing the appearance of numbers
    • Setting alignment options
    • Using merge
    • Removing formatting

    Module 11: Advanced formatting tools

    • Adding borders
    • Adding fill colour
    • Using cell styles
    • Using conditional formatting
    • Changing the theme

    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.

×