Certificate In Excel 2013 Advanced Online Course

Get Ahead with Advanced Skills in Excel 2013

Certificate In Excel 2013 Advanced Online Course

NOW ONLY

RM799

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

Get Ahead with Advanced Skills 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!

Learn how to use the advanced features of Excel 2013. This course is designed to get into the more advanced features of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013.

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

  • Use SmartArt and other objects in worksheets
  • Trace precedent cells and dependent cells, as well as use other auditing tools
  • Create and work with charts
  • Create Pivot Tables and Pivot Charts
  • Record and run macros
  • Solve formula errors
  • Use What If Analysis tools
  • Use tools to manage rows, columns, duplicates, and validation
  • Group and outline 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.

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

  • Inserting SmartArt
  • Editing the Diagram
  • Adding Pictures
  • Adding Textboxes
  • Drawing Shapes
  • About the Contextual Tabs

Module Three: Auditing

  • Tracing Precedent Cells
  • Tracing the Dependents of a Cell
  • Displaying Formulas Within the Sheet
  • Adding, Displaying, Editing, and Removing Comments

Module Four: Creating Charts

  • Using Recommended Charts
  • Inserting a Chart
  • Overview of the Chart Tools Tabs
  • Understanding Chart Elements
  • Resizing and Moving the Chart

Module Five: Working with Charts

  • Using Chart Elements
  • Using Chart Styles and Colors
  • Using Chart Filters
  • Working with Data Labels

Module Six: Creating Pivot Tables and Pivot Charts

  • Inserting a PivotTable using Excel Recommendations
  • Choosing Fields and Grouping Data
  • Overview of the Pivot Table Tools Tabs
  • Changing the Data Displayed and Refreshing the PivotTable
  • Creating a Pivot Chart from a Pivot Table or Data
  • Some Real-life Examples

Module Seven: Macros

  • Displaying the Developer Tab
  • Recording and Running Macros
  • Changing the Security Level
  • Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Using Named Ranges
  • Understanding Formula Errors
  • Using Error Checking
  • Using the Trace Errors Commands
  • Evaluating Formulas

Module Nine: Using What If Analysis

  • Using Goal Seek
  • Using the Scenario Manager
  • Using a One Input Data Table
  • Using a Two Input Data Table

Module Ten: Managing Your Data

  • Transposing Data from Rows to Columns
  • Using the Text to Columns Feature
  • Checking for Duplicates
  • Creating Data Validation Rules
  • Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Grouping Data
  • Adding Subtotals
  • Outlining Data
  • Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

  • Words from the Wise

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
48%
4 star
31%
3 star
14%
2 star
6%
1 star
2%
(3269)
Average rating 4 out of 5 stars

15 September 2019 05:46:33 PM

I enjoyed completing this.

15 September 2019 02:54:17 PM

It was a good refresher for me and gave me a few tips to improve my own workspace.

12 September 2019 03:47:49 PM

Excellent Course, thoroughly enjoyed it.

12 September 2019 02:21:35 PM

cool

9 September 2019 08:35:35 PM

Awesome course

9 September 2019 02:40:01 AM

I found the course very helpful and it was presented well. I enjoyed it very much

8 September 2019 09:15:59 PM

I found the course an eye opener, inspiring and I found that personal success is halted by fear. But fear is merely a story about the future that has not been told yet.

8 September 2019 02:01:29 PM

i finish my personal success,and about this course is very good they gave me alot of idea how to be success of supervisor.

7 September 2019 12:40:10 PM

The greatest course around

5 September 2019 03:59:51 AM

This course is a true resource to apply in any field. Persoanally or professionally, the organizational skills that I received help to improve the quality of my life regarding to the time and energy invested in each activity. It is an usefull tool to kkep in mind always.

4 September 2019 10:23:14 PM

I HIGHLY RECOMEND THIS COURSE TO EVERYONE THAT COME ACROSS IT. IT HELPS BRING YOU BACK ON FOCUS.

4 September 2019 10:15:50 PM

IT IS AN ESSENTIAL COURSE FOR EVERYONE TO SET YOU ON THE RIGHT TRACK.
I RECOMMEND IT FOR EVERYONE TO BRING YOU BACK TO FOCUS

4 September 2019 09:16:27 PM

My review is very good. I love this course to many things that I can learn to be a good supervisor and leadership

4 September 2019 05:21:01 PM

Course material was good - content was kept light, but relevant. made the course easy to manage

3 September 2019 04:27:33 PM

thankyou very much.

2 September 2019 07:36:45 AM

I think it was a very inspiring type of course. It helped me realize certain things that I do that are obvious obstacles once I think about it, but I'm rarely conscious of, especially the part of emotion-managing. Thank you!

28 August 2019 09:19:38 PM

Great course

27 August 2019 12:22:52 AM

I've found the content of this course useful for improving my organization skills

26 August 2019 09:59:44 PM

This was very inspiring and has really got me excited about studying again

26 August 2019 01:05:37 PM

Very thorough and complete.

Load more reviews Loading...
About this Course

Get Ahead with Advanced Skills 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!

Learn how to use the advanced features of Excel 2013. This course is designed to get into the more advanced features of Excel 2013. You will get a chance to experience some of the new features that are offered in Excel 2013.

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

  • Use SmartArt and other objects in worksheets
  • Trace precedent cells and dependent cells, as well as use other auditing tools
  • Create and work with charts
  • Create Pivot Tables and Pivot Charts
  • Record and run macros
  • Solve formula errors
  • Use What If Analysis tools
  • Use tools to manage rows, columns, duplicates, and validation
  • Group and outline 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.

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

  • Inserting SmartArt
  • Editing the Diagram
  • Adding Pictures
  • Adding Textboxes
  • Drawing Shapes
  • About the Contextual Tabs

Module Three: Auditing

  • Tracing Precedent Cells
  • Tracing the Dependents of a Cell
  • Displaying Formulas Within the Sheet
  • Adding, Displaying, Editing, and Removing Comments

Module Four: Creating Charts

  • Using Recommended Charts
  • Inserting a Chart
  • Overview of the Chart Tools Tabs
  • Understanding Chart Elements
  • Resizing and Moving the Chart

Module Five: Working with Charts

  • Using Chart Elements
  • Using Chart Styles and Colors
  • Using Chart Filters
  • Working with Data Labels

Module Six: Creating Pivot Tables and Pivot Charts

  • Inserting a PivotTable using Excel Recommendations
  • Choosing Fields and Grouping Data
  • Overview of the Pivot Table Tools Tabs
  • Changing the Data Displayed and Refreshing the PivotTable
  • Creating a Pivot Chart from a Pivot Table or Data
  • Some Real-life Examples

Module Seven: Macros

  • Displaying the Developer Tab
  • Recording and Running Macros
  • Changing the Security Level
  • Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Using Named Ranges
  • Understanding Formula Errors
  • Using Error Checking
  • Using the Trace Errors Commands
  • Evaluating Formulas

Module Nine: Using What If Analysis

  • Using Goal Seek
  • Using the Scenario Manager
  • Using a One Input Data Table
  • Using a Two Input Data Table

Module Ten: Managing Your Data

  • Transposing Data from Rows to Columns
  • Using the Text to Columns Feature
  • Checking for Duplicates
  • Creating Data Validation Rules
  • Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Grouping Data
  • Adding Subtotals
  • Outlining Data
  • Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

  • Words from the Wise

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

(3269)
Average rating 4 out of 5 stars
5 star
48%
4 star
31%
3 star
14%
2 star
6%
1 star
2%

15 September 2019 05:46:33 PM

I enjoyed completing this.

15 September 2019 02:54:17 PM

It was a good refresher for me and gave me a few tips to improve my own workspace.

12 September 2019 03:47:49 PM

Excellent Course, thoroughly enjoyed it.

12 September 2019 02:21:35 PM

cool

9 September 2019 08:35:35 PM

Awesome course

9 September 2019 02:40:01 AM

I found the course very helpful and it was presented well. I enjoyed it very much

8 September 2019 09:15:59 PM

I found the course an eye opener, inspiring and I found that personal success is halted by fear. But fear is merely a story about the future that has not been told yet.

8 September 2019 02:01:29 PM

i finish my personal success,and about this course is very good they gave me alot of idea how to be success of supervisor.

7 September 2019 12:40:10 PM

The greatest course around

5 September 2019 03:59:51 AM

This course is a true resource to apply in any field. Persoanally or professionally, the organizational skills that I received help to improve the quality of my life regarding to the time and energy invested in each activity. It is an usefull tool to kkep in mind always.

4 September 2019 10:23:14 PM

I HIGHLY RECOMEND THIS COURSE TO EVERYONE THAT COME ACROSS IT. IT HELPS BRING YOU BACK ON FOCUS.

4 September 2019 10:15:50 PM

IT IS AN ESSENTIAL COURSE FOR EVERYONE TO SET YOU ON THE RIGHT TRACK.
I RECOMMEND IT FOR EVERYONE TO BRING YOU BACK TO FOCUS

4 September 2019 09:16:27 PM

My review is very good. I love this course to many things that I can learn to be a good supervisor and leadership

4 September 2019 05:21:01 PM

Course material was good - content was kept light, but relevant. made the course easy to manage

3 September 2019 04:27:33 PM

thankyou very much.

2 September 2019 07:36:45 AM

I think it was a very inspiring type of course. It helped me realize certain things that I do that are obvious obstacles once I think about it, but I'm rarely conscious of, especially the part of emotion-managing. Thank you!

28 August 2019 09:19:38 PM

Great course

27 August 2019 12:22:52 AM

I've found the content of this course useful for improving my organization skills

26 August 2019 09:59:44 PM

This was very inspiring and has really got me excited about studying again

26 August 2019 01:05:37 PM

Very thorough and complete.

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