Certificate In Excel 2013 Essentials Online Course

Learn the Basic Features of Excel 2013

Certificate In Excel 2013 Essentials Online Course

NOW ONLY

US$199

Save US$70 (26%)
OFF RRP US$269
Get Info Pack

Learn the Basic Features of Excel 2013

You will learn how to use the basic features of Excel 2013. This course is designed to provide a basic understanding of Excel 2013. You will also get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive, and better information leads to better decision making!

By the end of this Excel 2013 Essentials Online Short Course, you will be able to:

  • Open and close Excel
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Understand the new Interface and the new Backstage View
  • Enter labels and values
  • Edit data
  • Add rows and columns
  • Check spelling
  • Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
  • Switch between Excel views and create custom views
  • Use Zoom
  • Set up, Preview and print your workbook
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Understand the new Function Names
  • Use the Formulas Tab
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Use the status bar to perform calculations
  • Use AutoFill and AutoComplete
  • Sort and filter data
  • Use sparklines
  • Format text and numbers
  • Use alignment options
  • Merge cells
  • Apply borders
  • Use cell styles
  • Use conditional formatting
  • Change the workbook theme

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Other Microsoft Excel Courses

Want to learn about Microsoft Excel? Whether you're a beginner or an expert, Courses For Success has a range of Microsoft Excel courses to suit your needs.

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Excel

  • Opening Excel
  • Understanding the Interface
  • Using Backstage View
  • Understanding Worksheets
  • Understanding Workbooks

Module Three: Your First Worksheet

  • Entering Data
  • Editing Data
  • Using the Wrap Command
  • Adding Rows and Columns
  • Checking Your Spelling

Module Four: Working with Excel Files

  • Saving Files
  • Publishing Files to PDF
  • Sending Files via E-Mail
  • Closing Files
  • Opening Files

Module Five: Viewing Excel Data

  • An Overview of Excel’s Views
  • Switching Views
  • Creating Custom Views
  • Using Zoom
  • Switching Between Open Files

Module Six: Printing Excel Data

  • An Overview of the Page Layout Tab
  • Setting Up Your Page
  • Using Print Preview
  • Printing Data

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: 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 Nine: Using Time Saving Tools

  • Using AutoFill
  • Using AutoComplete
  • Sorting Data
  • Filtering Data
  • Adding Sparklines

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Using Merge
  • Removing Formatting

Module Eleven: Advanced Formatting Tools

  • Adding Borders
  • Adding Fill Color
  • Using Cell Styles
  • Using Conditional Formatting
  • Changing the Theme

Module Twelve: Wrapping Up

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

Customer Reviews

5 star
42%
4 star
40%
3 star
14%
2 star
4%
1 star
0%
(128)
Average rating 4 out of 5 stars

20 July 2019 07:03:33 PM

Excellent. Informative and easy to use

13 April 2019 02:15:51 AM

It was really comprehensive for beginners.

23 December 2018 10:39:45 PM

good course

10 August 2018 02:49:22 PM

Really easy to follow

6 August 2018 03:44:13 PM

I found the course easy to follow and learnt some things I didn't know or that there is more than one way to edit the worksheet.

22 June 2018 04:03:44 AM

Excellent!

31 May 2018 09:17:28 PM

excellent

14 May 2018 11:38:23 AM

This is an amazing course!

17 April 2018 10:23:01 PM

Very informative.

5 April 2018 11:35:45 AM

-

30 March 2018 06:17:59 AM

Loved it, not done an excel course in a while and there was some stuff here that I didn't know before.

13 March 2018 11:37:26 AM

Great course thankyou

28 February 2018 09:19:10 AM

This was handy, although I am quite familiar with Excel I learnt some new things in this course.

12 February 2018 11:44:16 PM

Excellent course, very informative and easy to understand.

4 September 2017 09:22:47 PM

I enjoyed this short course

4 September 2017 02:54:58 AM

Very useful. especially the section on formulas

1 September 2017 12:21:21 PM

good basic training.

31 August 2017 02:59:06 PM

Great place to start or go back to if not using Excel all the time.

28 August 2017 09:20:45 PM

greatcourse helped a lot

14 August 2017 12:54:16 PM

Good

Load more reviews Loading...
About this Course

Learn the Basic Features of Excel 2013

You will learn how to use the basic features of Excel 2013. This course is designed to provide a basic understanding of Excel 2013. You will also get a chance to experience some of the new features that are offered in Excel 2013.

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive, and better information leads to better decision making!

By the end of this Excel 2013 Essentials Online Short Course, you will be able to:

  • Open and close Excel
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Understand the new Interface and the new Backstage View
  • Enter labels and values
  • Edit data
  • Add rows and columns
  • Check spelling
  • Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
  • Switch between Excel views and create custom views
  • Use Zoom
  • Set up, Preview and print your workbook
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Understand the new Function Names
  • Use the Formulas Tab
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Use the status bar to perform calculations
  • Use AutoFill and AutoComplete
  • Sort and filter data
  • Use sparklines
  • Format text and numbers
  • Use alignment options
  • Merge cells
  • Apply borders
  • Use cell styles
  • Use conditional formatting
  • Change the workbook theme

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Other Microsoft Excel Courses

Want to learn about Microsoft Excel? Whether you're a beginner or an expert, Courses For Success has a range of Microsoft Excel courses to suit your needs.

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Excel

  • Opening Excel
  • Understanding the Interface
  • Using Backstage View
  • Understanding Worksheets
  • Understanding Workbooks

Module Three: Your First Worksheet

  • Entering Data
  • Editing Data
  • Using the Wrap Command
  • Adding Rows and Columns
  • Checking Your Spelling

Module Four: Working with Excel Files

  • Saving Files
  • Publishing Files to PDF
  • Sending Files via E-Mail
  • Closing Files
  • Opening Files

Module Five: Viewing Excel Data

  • An Overview of Excel’s Views
  • Switching Views
  • Creating Custom Views
  • Using Zoom
  • Switching Between Open Files

Module Six: Printing Excel Data

  • An Overview of the Page Layout Tab
  • Setting Up Your Page
  • Using Print Preview
  • Printing Data

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: 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 Nine: Using Time Saving Tools

  • Using AutoFill
  • Using AutoComplete
  • Sorting Data
  • Filtering Data
  • Adding Sparklines

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Using Merge
  • Removing Formatting

Module Eleven: Advanced Formatting Tools

  • Adding Borders
  • Adding Fill Color
  • Using Cell Styles
  • Using Conditional Formatting
  • Changing the Theme

Module Twelve: Wrapping Up

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

(128)
Average rating 4 out of 5 stars
5 star
42%
4 star
40%
3 star
14%
2 star
4%
1 star
0%

20 July 2019 07:03:33 PM

Excellent. Informative and easy to use

13 April 2019 02:15:51 AM

It was really comprehensive for beginners.

23 December 2018 10:39:45 PM

good course

10 August 2018 02:49:22 PM

Really easy to follow

6 August 2018 03:44:13 PM

I found the course easy to follow and learnt some things I didn't know or that there is more than one way to edit the worksheet.

22 June 2018 04:03:44 AM

Excellent!

31 May 2018 09:17:28 PM

excellent

14 May 2018 11:38:23 AM

This is an amazing course!

17 April 2018 10:23:01 PM

Very informative.

5 April 2018 11:35:45 AM

-

30 March 2018 06:17:59 AM

Loved it, not done an excel course in a while and there was some stuff here that I didn't know before.

13 March 2018 11:37:26 AM

Great course thankyou

28 February 2018 09:19:10 AM

This was handy, although I am quite familiar with Excel I learnt some new things in this course.

12 February 2018 11:44:16 PM

Excellent course, very informative and easy to understand.

4 September 2017 09:22:47 PM

I enjoyed this short course

4 September 2017 02:54:58 AM

Very useful. especially the section on formulas

1 September 2017 12:21:21 PM

good basic training.

31 August 2017 02:59:06 PM

Great place to start or go back to if not using Excel all the time.

28 August 2017 09:20:45 PM

greatcourse helped a lot

14 August 2017 12:54:16 PM

Good

Load more reviews Loading...

We provide a 7 Day Money Back Refund on all Courses

Now Only US$199 Save US$70 (26%)
OFF RRP US$269
Delivery Method Online
Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value $600)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID No.: 020E13ES
Delivery Mode: Online
Course Access: Lifetime Course Access
Time required: Study at your own pace
Course Duration: 6-8 Hours
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner