Certificate In Excel 2010 Advanced Online Course

Learn Advanced Skills with Excel 2010

Certificate In Excel 2010 Advanced Online Course

NOW ONLY

₩167449

Save ₩56150 (25%)
OFF RRP ₩223599
Get Info Pack

Learn Advanced Skills with Excel 2010 

Learn how to use the advanced features of Excel 2010. This course is designed to teach you a basic understanding of Excel 2010 in a practical way.

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 Course, you will be able to:

  • Insert SmartArt
  • Add text to a diagram
  • Resize and move a diagram
  • Reset a diagram
  • Understand the contextual tabs
  • Add pictures from your computer
  • Add Clip Art
  • Add text boxes
  • Draw shapes
  • Trace precedent cells
  • Trace dependents of a cell
  • Display formulas within the sheet
  • Work with comments
  • Insert a chart
  • Use the Chart Tools tab
  • Understand the parts of a chart
  • Change the chart style
  • Resize and move a chart
  • Insert a Pivot Table
  • Use the Pivot Table Tools tab
  • Choose fields and group data in a Pivot Table
  • Change Pivot Table data and refresh the view
  • Apply a Style to a Pivot table
  • Use Real-life examples in a Pivot Table
  • Create a Pivot Chart from a Pivot Table
  • Create a Pivot Chart from Data
  • Display the Developer tab
  • Record and run macros
  • Change the security level
  • Customize and Change the Quick Access Toolbar
  • Use named ranges in formulas
  • Understand formula errors
  • Trace dependents and precedents in formulas
  • Use the Trace Errors Commands
  • Evaluate formulas
  • Use Goal Seek
  • Use the Scenario Manager
  • Use a One Input Data Table
  • Use a Two Input Data Table
  • Transposing Data from rows to columns
  • Use the Text to Columns feature
  • Check for duplicates
  • Create data validation rules
  • Consolidate Data
  • Group Data
  • Add Subtotals
  • Outline Data view Grouped and Outlined Data

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: SmartArt and Objects

  • Lesson One: Inserting SmartArt
  • Lesson Two: Adding Text to the Diagram
  • Lesson Three: Resizing and Moving the Diagram
  • Lesson Four: Resetting the Diagram
  • Lesson Five: Adding Pictures from Your Computer
  • Lesson Six: Adding Clip Art
  • Lesson Seven: Adding Text Boxes
  • Lesson Eight: Drawing Shapes
  • Lesson Nine: About the Contextual Tabs

Module Three: Auditing

  • Lesson One: Tracing Recedent Cells
  • Lesson Two: Tracing the Dependents of a Cell
  • Lesson Three: Displaying Formulas Within the Sheet
  • Lesson Four: Adding, Displaying, Editing, and Removing Comments

Module Four:  Creating Charts

  • Lesson One: Inserting a Chart
  • Lesson Two: Overview of the Chart Tools Tab
  • Lesson Three: Understanding the Parts of a Chart
  • Lesson Four: Changing the Chart Style
  • Lesson Five: Resizing and Moving the Chart

Module Five: Creating Pivot Tables

  • Lesson One: Inserting a Pivot Table
  • Lesson Two: Choosing Fields and Grouping Data
  • Lesson Three: Overview of the Pivot Tools Tabs

Module Six: Working with PivotTables and PivotCharts

  • Lesson One: Changing the Data Displayed and Refreshing the PivotTable
  • Lesson Two: Applying a Style to Your Pivot Table
  • Lesson Three: Creating a Pivot Chart from a Pivot Table
  • Lesson Four: Creating a Pivot Chart from Data
  • Lesson Five: Some Real-life Examples

Module Seven:  Macros

  • Lesson One: Displaying the Developer Tab
  • Lesson Two: Recording and Running Macros
  • Lesson Three: Changing the Security Level
  • Lesson Four: Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Lesson One: Using Named Ranges
  • Lesson Two: Understanding Formula Errors
  • Lesson Three: Using the Trace Errors Commands
  • Lesson Four: Using Error Checking

Module Nine: Using What If Analysis

  • Lesson One: Using Goal Seek
  • Lesson Two: Using the Scenario Manager
  • Lesson Three: Using a One Input Data Table
  • Lesson Four: Using a Two Input Data Table

Module Ten: Managing Your Data

  • Lesson One: Transposing Data from Rows to Columns
  • Lesson Two: Using the Text to Columns Feature
  • Lesson Three: Checking for Duplicates
  • Lesson Four: Creating Data Validation Rules
  • Lesson Five: Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Lesson One: Grouping Data
  • Lesson Two: Adding Subtotals
  • Lesson Three: Outlining Data
  • Lesson Four: Viewing Grouped and Outlined Data

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
40%
4 star
39%
3 star
14%
2 star
5%
1 star
1%
(235)
Average rating 3.5 out of 5 stars

20 July 2019 07:03:33 PM

Excellent. Informative and easy to use

12 July 2019 04:09:14 AM

excellent course full of useful info and tips definitely recommend!

19 April 2019 04:51:39 PM

very detailed course

13 April 2019 02:15:51 AM

It was really comprehensive for beginners.

29 January 2019 01:48:25 PM

Awesome

10 January 2019 10:18:36 AM

very good

23 December 2018 10:39:45 PM

good course

10 August 2018 02:49:22 PM

Really easy to follow

6 August 2018 07:48:37 PM

Good

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.

31 July 2018 06:50:00 PM

good

3 July 2018 07:14:51 PM

GOOD TO REVIEW OLD SOFTWARE AGAIN

28 June 2018 05:35:58 AM

This was an excellent course

22 June 2018 04:12:08 AM

Excellent!

22 June 2018 04:03:44 AM

Excellent!

31 May 2018 09:17:28 PM

excellent

31 May 2018 09:04:37 PM

excellent

14 May 2018 11:38:23 AM

This is an amazing course!

2 May 2018 10:29:08 PM

helpful course

17 April 2018 10:23:01 PM

Very informative.

Load more reviews Loading...
About this Course

Learn Advanced Skills with Excel 2010 

Learn how to use the advanced features of Excel 2010. This course is designed to teach you a basic understanding of Excel 2010 in a practical way.

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 Course, you will be able to:

  • Insert SmartArt
  • Add text to a diagram
  • Resize and move a diagram
  • Reset a diagram
  • Understand the contextual tabs
  • Add pictures from your computer
  • Add Clip Art
  • Add text boxes
  • Draw shapes
  • Trace precedent cells
  • Trace dependents of a cell
  • Display formulas within the sheet
  • Work with comments
  • Insert a chart
  • Use the Chart Tools tab
  • Understand the parts of a chart
  • Change the chart style
  • Resize and move a chart
  • Insert a Pivot Table
  • Use the Pivot Table Tools tab
  • Choose fields and group data in a Pivot Table
  • Change Pivot Table data and refresh the view
  • Apply a Style to a Pivot table
  • Use Real-life examples in a Pivot Table
  • Create a Pivot Chart from a Pivot Table
  • Create a Pivot Chart from Data
  • Display the Developer tab
  • Record and run macros
  • Change the security level
  • Customize and Change the Quick Access Toolbar
  • Use named ranges in formulas
  • Understand formula errors
  • Trace dependents and precedents in formulas
  • Use the Trace Errors Commands
  • Evaluate formulas
  • Use Goal Seek
  • Use the Scenario Manager
  • Use a One Input Data Table
  • Use a Two Input Data Table
  • Transposing Data from rows to columns
  • Use the Text to Columns feature
  • Check for duplicates
  • Create data validation rules
  • Consolidate Data
  • Group Data
  • Add Subtotals
  • Outline Data view Grouped and Outlined Data

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: SmartArt and Objects

  • Lesson One: Inserting SmartArt
  • Lesson Two: Adding Text to the Diagram
  • Lesson Three: Resizing and Moving the Diagram
  • Lesson Four: Resetting the Diagram
  • Lesson Five: Adding Pictures from Your Computer
  • Lesson Six: Adding Clip Art
  • Lesson Seven: Adding Text Boxes
  • Lesson Eight: Drawing Shapes
  • Lesson Nine: About the Contextual Tabs

Module Three: Auditing

  • Lesson One: Tracing Recedent Cells
  • Lesson Two: Tracing the Dependents of a Cell
  • Lesson Three: Displaying Formulas Within the Sheet
  • Lesson Four: Adding, Displaying, Editing, and Removing Comments

Module Four:  Creating Charts

  • Lesson One: Inserting a Chart
  • Lesson Two: Overview of the Chart Tools Tab
  • Lesson Three: Understanding the Parts of a Chart
  • Lesson Four: Changing the Chart Style
  • Lesson Five: Resizing and Moving the Chart

Module Five: Creating Pivot Tables

  • Lesson One: Inserting a Pivot Table
  • Lesson Two: Choosing Fields and Grouping Data
  • Lesson Three: Overview of the Pivot Tools Tabs

Module Six: Working with PivotTables and PivotCharts

  • Lesson One: Changing the Data Displayed and Refreshing the PivotTable
  • Lesson Two: Applying a Style to Your Pivot Table
  • Lesson Three: Creating a Pivot Chart from a Pivot Table
  • Lesson Four: Creating a Pivot Chart from Data
  • Lesson Five: Some Real-life Examples

Module Seven:  Macros

  • Lesson One: Displaying the Developer Tab
  • Lesson Two: Recording and Running Macros
  • Lesson Three: Changing the Security Level
  • Lesson Four: Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Lesson One: Using Named Ranges
  • Lesson Two: Understanding Formula Errors
  • Lesson Three: Using the Trace Errors Commands
  • Lesson Four: Using Error Checking

Module Nine: Using What If Analysis

  • Lesson One: Using Goal Seek
  • Lesson Two: Using the Scenario Manager
  • Lesson Three: Using a One Input Data Table
  • Lesson Four: Using a Two Input Data Table

Module Ten: Managing Your Data

  • Lesson One: Transposing Data from Rows to Columns
  • Lesson Two: Using the Text to Columns Feature
  • Lesson Three: Checking for Duplicates
  • Lesson Four: Creating Data Validation Rules
  • Lesson Five: Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Lesson One: Grouping Data
  • Lesson Two: Adding Subtotals
  • Lesson Three: Outlining Data
  • Lesson Four: Viewing Grouped and Outlined Data

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 
(235)
Average rating 3.5 out of 5 stars
5 star
40%
4 star
39%
3 star
14%
2 star
5%
1 star
1%

20 July 2019 07:03:33 PM

Excellent. Informative and easy to use

12 July 2019 04:09:14 AM

excellent course full of useful info and tips definitely recommend!

19 April 2019 04:51:39 PM

very detailed course

13 April 2019 02:15:51 AM

It was really comprehensive for beginners.

29 January 2019 01:48:25 PM

Awesome

10 January 2019 10:18:36 AM

very good

23 December 2018 10:39:45 PM

good course

10 August 2018 02:49:22 PM

Really easy to follow

6 August 2018 07:48:37 PM

Good

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.

31 July 2018 06:50:00 PM

good

3 July 2018 07:14:51 PM

GOOD TO REVIEW OLD SOFTWARE AGAIN

28 June 2018 05:35:58 AM

This was an excellent course

22 June 2018 04:12:08 AM

Excellent!

22 June 2018 04:03:44 AM

Excellent!

31 May 2018 09:17:28 PM

excellent

31 May 2018 09:04:37 PM

excellent

14 May 2018 11:38:23 AM

This is an amazing course!

2 May 2018 10:29:08 PM

helpful course

17 April 2018 10:23:01 PM

Very informative.

Load more reviews Loading...

We provide a 7 Day Money Back Refund on all Courses

Now Only ₩167449 Save ₩56150 (25%)
OFF RRP ₩223599
Delivery Method Online
Get Info Pack

Special Offer

 

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

 

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