Certificate In Excel 2013 Expert Online Course

Acquire Expert Skills in Excel 2013


NOW ONLY

Rp1986699

Save Rp666650 (25%)
OFF RRP Rp2653349
Get Info Pack

Acquire Expert Skills in Excel 2013

You will learn how to use the advanced features of Excel 2013. This course is designed to provide an in-depth understanding of Excel 2013. You will 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!

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

  • Understand permissions, versions, and Excel Options
  • Track changes and share workbooks
  • Perform advanced formula auditing and calculation
  • Create arrays
  • Create additional ways to run a macro
  • Create a form using a variety of controls
  • Use trend lines, secondary axes and chart templates
  • Work with slicers in PivotTables
  • Create and manipulate a PowerView sheet
  • Analyze data using multiple tables

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 a Workbook as Final
  • Encrypting with a Password
  • 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 a 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 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

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

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

Module Nine:  Working With Slicers and Timelines

  • About Slicers and Timelines
  • Creating a Slicer in an Existing Table
  • Formatting a Slicer
  • Using a Timeline

Module Ten: Working With Multiple Tables, Relationships and External Data

  • Connecting to a New External Data Source
  • Creating a PivotTable Using an External Data Connection
  • Working with PivotTables Based on Multiple Tables

Module Eleven: Working With PowerView

  • About Power View
  • Creating a Power View Sheet
  • Add a Table to the Data Model
  • Adding a Map to a Power View Report

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 to the following applications:

Adobe Acrobat Reader

Customer Reviews

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

24 July 2019 12:31:45 AM

easy and straight forward

20 July 2019 10:26:23 PM

I thoroughly enjoyed this course. I found it easy to understand, gained confidence in applying it's advice in my daily life, and am always attempting to adopt the many great principles it teaches. Thank you very much David for delivering a very valuable course. And congratulations on the successes you and your family have had in business. And many more successes to you all in future. God Bless.

20 July 2019 12:19:49 PM

Great Course

19 July 2019 12:56:02 PM

Great Course

19 July 2019 09:08:54 AM

VERY USEFUL INFORMATION I LEARNED ALOT

18 July 2019 11:32:30 AM

The course was clear and helpful. A suggested improvement is to enable the course summary to be downloaded to support later review and reflection.

17 July 2019 05:35:22 AM

Great course! Really helped me.

17 July 2019 03:21:36 AM

Very informative with great tips for the future

17 July 2019 03:18:35 AM

Very helpful and informative

14 July 2019 04:24:13 PM

Outstanding lessons on organization! Much needed.

12 July 2019 08:09:24 AM

Amazing course!

12 July 2019 08:04:19 AM

Simply amazing gained so much knowledge!

10 July 2019 09:41:24 PM

Your course is really good but it is really hard to. Thanks for giving me a chance to complete it.

10 July 2019 07:51:05 PM

Excellent

9 July 2019 01:17:11 PM

This course forced me to think through many personal struggles in my life and helped me in pressing through them.

7 July 2019 05:55:14 AM

VERY GOOD

29 June 2019 03:48:16 PM

Easy to follow and understand with clear language and case studies

28 June 2019 12:53:36 AM

Thanks for all the tips for organizational skills!

27 June 2019 11:58:55 PM

Great training program. Really learned a lot over the 3 weeks. Very informativ3 qnd helpful. Amazing life skills and tips

24 June 2019 07:36:25 AM

I enjoyed this course. It is very informative and helpful. Th only thing I would like to have seen is different examples of schedules (paper vs computer) and how to create them.

Load more reviews Loading...
About this Course

Acquire Expert Skills in Excel 2013

You will learn how to use the advanced features of Excel 2013. This course is designed to provide an in-depth understanding of Excel 2013. You will 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!

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

  • Understand permissions, versions, and Excel Options
  • Track changes and share workbooks
  • Perform advanced formula auditing and calculation
  • Create arrays
  • Create additional ways to run a macro
  • Create a form using a variety of controls
  • Use trend lines, secondary axes and chart templates
  • Work with slicers in PivotTables
  • Create and manipulate a PowerView sheet
  • Analyze data using multiple tables

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 a Workbook as Final
  • Encrypting with a Password
  • 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 a 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 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

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

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

Module Nine:  Working With Slicers and Timelines

  • About Slicers and Timelines
  • Creating a Slicer in an Existing Table
  • Formatting a Slicer
  • Using a Timeline

Module Ten: Working With Multiple Tables, Relationships and External Data

  • Connecting to a New External Data Source
  • Creating a PivotTable Using an External Data Connection
  • Working with PivotTables Based on Multiple Tables

Module Eleven: Working With PowerView

  • About Power View
  • Creating a Power View Sheet
  • Add a Table to the Data Model
  • Adding a Map to a Power View Report

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 to the following applications:

Adobe Acrobat Reader

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

24 July 2019 12:31:45 AM

easy and straight forward

20 July 2019 10:26:23 PM

I thoroughly enjoyed this course. I found it easy to understand, gained confidence in applying it's advice in my daily life, and am always attempting to adopt the many great principles it teaches. Thank you very much David for delivering a very valuable course. And congratulations on the successes you and your family have had in business. And many more successes to you all in future. God Bless.

20 July 2019 12:19:49 PM

Great Course

19 July 2019 12:56:02 PM

Great Course

19 July 2019 09:08:54 AM

VERY USEFUL INFORMATION I LEARNED ALOT

18 July 2019 11:32:30 AM

The course was clear and helpful. A suggested improvement is to enable the course summary to be downloaded to support later review and reflection.

17 July 2019 05:35:22 AM

Great course! Really helped me.

17 July 2019 03:21:36 AM

Very informative with great tips for the future

17 July 2019 03:18:35 AM

Very helpful and informative

14 July 2019 04:24:13 PM

Outstanding lessons on organization! Much needed.

12 July 2019 08:09:24 AM

Amazing course!

12 July 2019 08:04:19 AM

Simply amazing gained so much knowledge!

10 July 2019 09:41:24 PM

Your course is really good but it is really hard to. Thanks for giving me a chance to complete it.

10 July 2019 07:51:05 PM

Excellent

9 July 2019 01:17:11 PM

This course forced me to think through many personal struggles in my life and helped me in pressing through them.

7 July 2019 05:55:14 AM

VERY GOOD

29 June 2019 03:48:16 PM

Easy to follow and understand with clear language and case studies

28 June 2019 12:53:36 AM

Thanks for all the tips for organizational skills!

27 June 2019 11:58:55 PM

Great training program. Really learned a lot over the 3 weeks. Very informativ3 qnd helpful. Amazing life skills and tips

24 June 2019 07:36:25 AM

I enjoyed this course. It is very informative and helpful. Th only thing I would like to have seen is different examples of schedules (paper vs computer) and how to create them.

Load more reviews Loading...

We provide a 7 Day Money Back Refund on all Courses

Now Only Rp1986699 Save Rp666650 (25%)
OFF RRP Rp2653349
Delivery Method Online
Get Info Pack

Special Offer

 

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

 

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