Certificate In Excel 2010 Essentials Online Course

Learn the Basic Features of Excel 2010

Certificate In Excel 2010 Essentials Online Course

NOW ONLY

RM799

Save RM300 (27%)
OFF RRP RM1099
Get Info Pack

Learn the Basic Features of Excel 2010

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information and better information leads to better decision making!

By the end of this Excel 2010 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
47%
4 star
42%
3 star
9%
2 star
0%
1 star
1%
(219)
Average rating 4 out of 5 stars

11 August 2019 07:18:15 PM

I commend those who conceptualized this Excel 2010 Essentials Online Short Course on the following reasons:

1. It augments my basic skills in computer.
2. It helps me study it anytime at my own pace.
3. Learning through online is very convenient.
4. I can revisit the course anytime.
5. I can gain not only computer knowledge but also A Certification at the end of the course.

2 August 2019 04:04:51 PM

This course was great for me as an introduction to excel.

1 July 2019 11:36:00 AM

clear and concise module that can be understand easily by a person who is aiming to learn the basics of excel.

12 June 2019 06:13:17 PM

I FIND THESE COURSE VERY REFRESHING AND EXPLAINED VERY WELL

11 June 2019 05:53:28 AM

The course was just what I needed to refresh my learning

11 June 2019 03:49:31 AM

helpful basics.

24 March 2019 03:23:11 AM

Great tips !

7 March 2019 05:18:06 AM

Well explained

29 January 2019 12:20:26 PM

great

5 January 2019 07:29:55 AM

very informative

15 August 2018 11:12:28 PM

Nice overview to review before going on to more advanced modules.

11 August 2018 07:27:29 PM

very good

8 August 2018 12:32:38 AM

great course for beginners

26 July 2018 08:17:00 PM

Very thorough and easy to learn. Loved the details and how easy it was for me to learn everything in this module.

13 July 2018 09:02:43 PM

Good overview

12 July 2018 04:58:14 AM

Explained very nicely and easily.

Enjoyed going through the modules, and was glad when there were step by step guides to guide me through.

29 June 2018 06:55:23 PM

excellent

27 June 2018 04:57:14 AM

This was a very good and intuitive course

22 June 2018 10:46:58 AM

Great course very helpful

22 June 2018 03:44:46 AM

Excellent!

Load more reviews Loading...
About this Course

Learn the Basic Features of Excel 2010

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information and better information leads to better decision making!

By the end of this Excel 2010 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

(219)
Average rating 4 out of 5 stars
5 star
47%
4 star
42%
3 star
9%
2 star
0%
1 star
1%

11 August 2019 07:18:15 PM

I commend those who conceptualized this Excel 2010 Essentials Online Short Course on the following reasons:

1. It augments my basic skills in computer.
2. It helps me study it anytime at my own pace.
3. Learning through online is very convenient.
4. I can revisit the course anytime.
5. I can gain not only computer knowledge but also A Certification at the end of the course.

2 August 2019 04:04:51 PM

This course was great for me as an introduction to excel.

1 July 2019 11:36:00 AM

clear and concise module that can be understand easily by a person who is aiming to learn the basics of excel.

12 June 2019 06:13:17 PM

I FIND THESE COURSE VERY REFRESHING AND EXPLAINED VERY WELL

11 June 2019 05:53:28 AM

The course was just what I needed to refresh my learning

11 June 2019 03:49:31 AM

helpful basics.

24 March 2019 03:23:11 AM

Great tips !

7 March 2019 05:18:06 AM

Well explained

29 January 2019 12:20:26 PM

great

5 January 2019 07:29:55 AM

very informative

15 August 2018 11:12:28 PM

Nice overview to review before going on to more advanced modules.

11 August 2018 07:27:29 PM

very good

8 August 2018 12:32:38 AM

great course for beginners

26 July 2018 08:17:00 PM

Very thorough and easy to learn. Loved the details and how easy it was for me to learn everything in this module.

13 July 2018 09:02:43 PM

Good overview

12 July 2018 04:58:14 AM

Explained very nicely and easily.

Enjoyed going through the modules, and was glad when there were step by step guides to guide me through.

29 June 2018 06:55:23 PM

excellent

27 June 2018 04:57:14 AM

This was a very good and intuitive course

22 June 2018 10:46:58 AM

Great course very helpful

22 June 2018 03:44:46 AM

Excellent!

Load more reviews Loading...

We provide a 7 Day Money Back Refund on all Courses

Now Only RM799 Save RM300 (27%)
OFF RRP RM1099
Delivery Method Online
Get Info Pack

Special Offer

 

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

 

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.: 020E1ES
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