Excel 2013 Essentials Online Course

Course Curriculum

1: Getting Acquainted With Excel

2: Techniques For Easier Data Entry

3: Managing Lists With Excel

4: Basic Calculations With Formulas

5: Calculating With Functions

6: Functions That Make Decisions

7: Math, Statistical & Financial Functions

8: Formatting Worksheets

9: Managing Workbooks

10: Data Analysis Techniques

11: Creating Charts In Excel

12: Pivottables & Power Views

13: Printing A Worksheet

14: Collaboration

15: Automating Tasks

16: Customizing Excel 2013

What skills will I gain?

• Templates are easier to use than ever before, and it’s faster to find one that suits your needs
• Flash Fill can save you a lot of typing, and it works automatically. You don’t even have to remember to use it
• The Inquire add-in gives you several ways of comparing two worksheets, so you’ll know how they differ just by looking at them
• The GeoFlow add-in turns your data into an animated, 3D map. This is the coolest thing Excel has ever done!
• Using tight connectivity with the cloud, Excel 2013 helps you collaborate with others, or just with multiple computers of your own

What careers can I get with this qualification?
With this course, you are able to fulfil various roles, such as:

• Administration
• Reception
• Accounting
• Bookkeeping
• Business ownership
• PA professionals