Certificate In Excel 2010 Expert Online Course

Gain Skills to Become an Expert with Excel 2010

Certificate In Excel 2010 Expert Online Course

NOW ONLY

US$199

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

Gain Skills to Become an Expert with Excel 2010

You will learn how to use the more in-depth features of Excel 2010. This course is designed to for the advanced users 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 usable information, and better information leads to better decision making!

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

  • Mark Workbook as Final
  • Encrypt with a Password and Restrict Permissions
  • Protect the Current Sheet or the Workbook Structure
  • Add a Digital Signature
  • Set Excel Options
  • Manage Versions
  • Save a Workbook as an Excel Template
  • Inspect Documents
  • Share Workbooks
  • Edit a Shared Workbook
  • Track Changes
  • Merge Copies of a Shared Workbook
  • Use the Watch Window
  • Set Calculation Options
  • Enable or Disable Automatic Workbook Calculations
  • Use the IFERROR Function to Evaluate Formulas
  • Use Array Formulas
  • Understand a Variety of different Functions
  • Assign Macros to a Command Button on the Ribbon
  • Run a Macro by Clicking an Area of a Graphic Object
  • Configure a Macro to Run Automatically Upon Opening the Workbook
  • Change a Macro
  • Insert Form Controls
  • Use a data form
  • Use Trend Lines
  • Add a Secondary Axis
  • Use Chart Templates
  • Work with PivotTable Tools
  • Work with PivotChart Tools
  • Use the Slicer
  • Choose External Data Sets with the Slicer
  • Understand the Analysis ToolPak

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.

Please Note: We have included reviews from our Personal Success Program as we provide this free program with every course.

Module One: Getting Started

  • Course Objectives

Module Two: 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 Three: Sharing Workbooks

  • Inspecting Document
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Tracking Changes
  • Merging Copies of a Shared Workbook

Module Four: 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 Five: Working with Array Formulas

  • About Array Formulas
  • Creating One-Dimensional and Two-Dimensional Constants
  • Creating a Simple Array
  • Creating an Advanced Array

Module Six: 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 Seven: 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 Eight: 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 Nine: Applying Advanced Chart Features

  • About Trend Lines
  • Add a Trend Line
  • Using Secondary Axes
  • Using Chart Templates

Module Ten: 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 Eleven: 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 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
49%
4 star
31%
3 star
13%
2 star
5%
1 star
2%
(3271)
Average rating 4 out of 5 stars

14 October 2019 05:12:39 AM

This course was most beneficial. I learned tips on becoming a more organized individual. The course was easily accessible. It offered opportunities to review materials and information that may have been unclear on a first read. The videos of case studies were excellent! The length of each video was great. I will use many of these organizational
tools in other areas of my personal life, such as creating a schedule for my pet. This course will help anyone who is willing to use the helpful hints and willing to exercise good organizational habits.

13 October 2019 03:56:37 AM

Enjoying learning this necessary information for personal success.

11 October 2019 05:42:28 PM

It has helped me learn self conr-wwwwwwwwwww'

10 October 2019 09:27:40 PM

The course is very informative and helped me to be more aware of goals,how to build confidence to achieve the goals and to be positive with every situation to get resolve.

9 October 2019 08:49:39 PM

It has helped me overcome procrastination and helped me get tasks done efficiently.

9 October 2019 01:40:08 PM

Excellent, Need I say any more.

5 October 2019 07:54:10 PM

I enjoyed this course, it is always good to look back and re-visit what was once learned and see where you can improve. Easy to follow and to the point.

5 October 2019 04:54:24 PM

The course helped me re-visit some forgotten techniques

5 October 2019 10:08:51 AM

great

5 October 2019 10:07:53 AM

awesome

5 October 2019 10:06:02 AM

awesome

4 October 2019 12:19:59 PM

excellent

3 October 2019 08:16:25 PM

awesome

1 October 2019 02:36:20 PM

This course has assisted me in identifying areas i need to work on a practical measures to instantly become more organised.

1 October 2019 04:28:40 AM

This course helps me a lot and I understand more clearly.

Thank you!

1 October 2019 03:34:46 AM

Great course, I fell like I will improve my organizational skills on a 100%

1 October 2019 02:01:12 AM

I must be honest here. I have learnt so much from this course, even in my own personal life I have learnt to apply this training course.
Thank you for this.
Regards
Nico van den Berg

30 September 2019 06:45:46 PM

This course gives fantastic information about overcoming procrastination, setting goals,getting organized and staying motivated! I reccomend this course to anyone wanting to improve themselves and their work.

30 September 2019 09:59:02 AM

This is a great course that gives ideas to stay motivated and organized. I recommend this course to anyone who wants to better themselves.

30 September 2019 06:11:15 AM

Very Interesting and Useful

Load more reviews Loading...
About this Course

Gain Skills to Become an Expert with Excel 2010

You will learn how to use the more in-depth features of Excel 2010. This course is designed to for the advanced users 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 usable information, and better information leads to better decision making!

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

  • Mark Workbook as Final
  • Encrypt with a Password and Restrict Permissions
  • Protect the Current Sheet or the Workbook Structure
  • Add a Digital Signature
  • Set Excel Options
  • Manage Versions
  • Save a Workbook as an Excel Template
  • Inspect Documents
  • Share Workbooks
  • Edit a Shared Workbook
  • Track Changes
  • Merge Copies of a Shared Workbook
  • Use the Watch Window
  • Set Calculation Options
  • Enable or Disable Automatic Workbook Calculations
  • Use the IFERROR Function to Evaluate Formulas
  • Use Array Formulas
  • Understand a Variety of different Functions
  • Assign Macros to a Command Button on the Ribbon
  • Run a Macro by Clicking an Area of a Graphic Object
  • Configure a Macro to Run Automatically Upon Opening the Workbook
  • Change a Macro
  • Insert Form Controls
  • Use a data form
  • Use Trend Lines
  • Add a Secondary Axis
  • Use Chart Templates
  • Work with PivotTable Tools
  • Work with PivotChart Tools
  • Use the Slicer
  • Choose External Data Sets with the Slicer
  • Understand the Analysis ToolPak

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.

Please Note: We have included reviews from our Personal Success Program as we provide this free program with every course.

Module One: Getting Started

  • Course Objectives

Module Two: 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 Three: Sharing Workbooks

  • Inspecting Document
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Tracking Changes
  • Merging Copies of a Shared Workbook

Module Four: 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 Five: Working with Array Formulas

  • About Array Formulas
  • Creating One-Dimensional and Two-Dimensional Constants
  • Creating a Simple Array
  • Creating an Advanced Array

Module Six: 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 Seven: 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 Eight: 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 Nine: Applying Advanced Chart Features

  • About Trend Lines
  • Add a Trend Line
  • Using Secondary Axes
  • Using Chart Templates

Module Ten: 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 Eleven: 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 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

(3271)
Average rating 4 out of 5 stars
5 star
49%
4 star
31%
3 star
13%
2 star
5%
1 star
2%

14 October 2019 05:12:39 AM

This course was most beneficial. I learned tips on becoming a more organized individual. The course was easily accessible. It offered opportunities to review materials and information that may have been unclear on a first read. The videos of case studies were excellent! The length of each video was great. I will use many of these organizational
tools in other areas of my personal life, such as creating a schedule for my pet. This course will help anyone who is willing to use the helpful hints and willing to exercise good organizational habits.

13 October 2019 03:56:37 AM

Enjoying learning this necessary information for personal success.

11 October 2019 05:42:28 PM

It has helped me learn self conr-wwwwwwwwwww'

10 October 2019 09:27:40 PM

The course is very informative and helped me to be more aware of goals,how to build confidence to achieve the goals and to be positive with every situation to get resolve.

9 October 2019 08:49:39 PM

It has helped me overcome procrastination and helped me get tasks done efficiently.

9 October 2019 01:40:08 PM

Excellent, Need I say any more.

5 October 2019 07:54:10 PM

I enjoyed this course, it is always good to look back and re-visit what was once learned and see where you can improve. Easy to follow and to the point.

5 October 2019 04:54:24 PM

The course helped me re-visit some forgotten techniques

5 October 2019 10:08:51 AM

great

5 October 2019 10:07:53 AM

awesome

5 October 2019 10:06:02 AM

awesome

4 October 2019 12:19:59 PM

excellent

3 October 2019 08:16:25 PM

awesome

1 October 2019 02:36:20 PM

This course has assisted me in identifying areas i need to work on a practical measures to instantly become more organised.

1 October 2019 04:28:40 AM

This course helps me a lot and I understand more clearly.

Thank you!

1 October 2019 03:34:46 AM

Great course, I fell like I will improve my organizational skills on a 100%

1 October 2019 02:01:12 AM

I must be honest here. I have learnt so much from this course, even in my own personal life I have learnt to apply this training course.
Thank you for this.
Regards
Nico van den Berg

30 September 2019 06:45:46 PM

This course gives fantastic information about overcoming procrastination, setting goals,getting organized and staying motivated! I reccomend this course to anyone wanting to improve themselves and their work.

30 September 2019 09:59:02 AM

This is a great course that gives ideas to stay motivated and organized. I recommend this course to anyone who wants to better themselves.

30 September 2019 06:11:15 AM

Very Interesting and Useful

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