Excel 2013 Expert Online Certificate Course
Acquire Expert Skills in Excel 2013
NOW ONLY
AU$249
Save AU$150 (38%)OFF RRP AU$399
Learn more
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:
- Easy to follow and understand
- Only 6 to 8 hours of study is required
- Unlimited, lifetime access to online course
- Delivered 100% on-line and accessible 24/7 from any computer or smartphone
- You can study from home or at work, at your own pace, in your own time
- 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
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 | 52% | |
| 4 star | 29% | |
| 3 star | 13% | |
| 2 star | 5% | |
| 1 star | 2% |
NAOMI KANSWEN
23 January 2021 04:54:56 AM
AMAZING! Thank you for going into depth with each point that was made. You also gave amazing examples!
Barbara Foster
23 January 2021 01:57:04 AM
The SMART goals resounded most strongly with me. Breaking goals down this way makes them more achievable.
Alysha Schafer
22 January 2021 12:59:04 PM
E
ibsa
22 January 2021 12:45:44 PM
this coarse was amazing helped open up a new perpective about my career
Andrey Porras
20 January 2021 09:51:21 AM
The course was helpful and straigtforward. Will recommend to friends in the future.
Yasmin Arthur
19 January 2021 12:46:59 PM
N/A
Donna Nguyen
19 January 2021 01:38:25 AM
Great
Donna Nguyen
19 January 2021 01:28:11 AM
Good
Donna Nguyen
16 January 2021 07:35:12 AM
Very interesting.
Donna Nguyen
16 January 2021 07:20:30 AM
Test3
Rania Saba
15 January 2021 11:57:24 PM
Detailed course, liking it so far!
Donna Nguyen
15 January 2021 01:38:26 PM
Test1
Hormat Gulamova
15 January 2021 05:04:14 AM
very informative
Francine Marie Cerne
13 January 2021 05:12:42 PM
Good resources
Mohd Shukri Bin Abd Rahman
12 January 2021 03:55:21 PM
Systematic. Simple, easy to understand explanations.
Ana Fernandez
12 January 2021 08:59:52 AM
Grateful for all the things I have learned with this course.
Madeline Massie
7 January 2021 01:59:44 PM
I truly enjoyed this course it was encouraging and helpful. It allowed me to put emotions into a sense of vocabulary.
Kristy Gear
7 January 2021 11:23:01 AM
some interesting topics covered. A good self reflective course
Emily Fausel
7 January 2021 05:02:23 AM
Decent introduction. Focuses on you as an individual more than an EA Course so far. Still not bad.
Michelle Henry
4 January 2021 12:29:42 PM
very good course
Loading...
Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.
Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.
Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.
The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews
No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.
No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.
This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.
All our courses are accessible online on any device. You may complete them at your own pace and at your own time.
After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.
Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.
Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.
You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).
There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.
Individual courses are designed to be completed within 6-8 hours.
If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:
- 2 course bundle is 2 x 6-8 hours = 12-16 hours
- 3 course bundle is 3 x 6-8 hours = 18-24 hours
- 5 course bundle is 5 x 6-8 hours = 30-40 hours
- 10 course bundle is 10 x 6-8 hours = 60-80 hours
All the required material for your course is included in the online system, you do not need to buy anything else.
Yes, all our courses are interactive.
Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.
You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.
Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"
Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.
No, it is not equivalent to a college or university credit.
This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.
Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.
The Certificates are valid for life and do not need renewing.
Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.
We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at , to pay via bank transfer.
 |
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:
- Easy to follow and understand
- Only 6 to 8 hours of study is required
- Unlimited, lifetime access to online course
- Delivered 100% on-line and accessible 24/7 from any computer or smartphone
- You can study from home or at work, at your own pace, in your own time
- 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
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
| 5 star | 52% | |
| 4 star | 29% | |
| 3 star | 13% | |
| 2 star | 5% | |
| 1 star | 2% |
NAOMI KANSWEN
23 January 2021 04:54:56 AM
AMAZING! Thank you for going into depth with each point that was made. You also gave amazing examples!
Barbara Foster
23 January 2021 01:57:04 AM
The SMART goals resounded most strongly with me. Breaking goals down this way makes them more achievable.
Alysha Schafer
22 January 2021 12:59:04 PM
E
ibsa
22 January 2021 12:45:44 PM
this coarse was amazing helped open up a new perpective about my career
Andrey Porras
20 January 2021 09:51:21 AM
The course was helpful and straigtforward. Will recommend to friends in the future.
Yasmin Arthur
19 January 2021 12:46:59 PM
N/A
Donna Nguyen
19 January 2021 01:38:25 AM
Great
Donna Nguyen
19 January 2021 01:28:11 AM
Good
Donna Nguyen
16 January 2021 07:35:12 AM
Very interesting.
Donna Nguyen
16 January 2021 07:20:30 AM
Test3
Rania Saba
15 January 2021 11:57:24 PM
Detailed course, liking it so far!
Donna Nguyen
15 January 2021 01:38:26 PM
Test1
Hormat Gulamova
15 January 2021 05:04:14 AM
very informative
Francine Marie Cerne
13 January 2021 05:12:42 PM
Good resources
Mohd Shukri Bin Abd Rahman
12 January 2021 03:55:21 PM
Systematic. Simple, easy to understand explanations.
Ana Fernandez
12 January 2021 08:59:52 AM
Grateful for all the things I have learned with this course.
Madeline Massie
7 January 2021 01:59:44 PM
I truly enjoyed this course it was encouraging and helpful. It allowed me to put emotions into a sense of vocabulary.
Kristy Gear
7 January 2021 11:23:01 AM
some interesting topics covered. A good self reflective course
Emily Fausel
7 January 2021 05:02:23 AM
Decent introduction. Focuses on you as an individual more than an EA Course so far. Still not bad.
Michelle Henry
4 January 2021 12:29:42 PM
very good course
Loading...
Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.
Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.
Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.
The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews
No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.
No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.
This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.
All our courses are accessible online on any device. You may complete them at your own pace and at your own time.
After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.
Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.
Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.
You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).
There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.
Individual courses are designed to be completed within 6-8 hours.
If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:
- 2 course bundle is 2 x 6-8 hours = 12-16 hours
- 3 course bundle is 3 x 6-8 hours = 18-24 hours
- 5 course bundle is 5 x 6-8 hours = 30-40 hours
- 10 course bundle is 10 x 6-8 hours = 60-80 hours
All the required material for your course is included in the online system, you do not need to buy anything else.
Yes, all our courses are interactive.
Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.
You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.
Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"
Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.
No, it is not equivalent to a college or university credit.
This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.
Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.
The Certificates are valid for life and do not need renewing.
Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.
We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at , to pay via bank transfer.
We provide a 7 Day Money Back Refund on all Courses
Special Offer
|
Training 2 Or More People?
| Empower your business with access to 500+ job & soft skills online training courses. |
|
SUCCESS PRO - For Business |
Course Summary
| Course ID: | 020E13EX |
|---|---|
| Delivery Mode: |
Online |
| Access: | Lifetime Course Access |
| Time: | Study at your own pace |
| Duration: | 6-8 Hours |
| Qualification: | Certificate |
- Call 1300 478 223
- Chat to us live
- Send us an enquiry
- Print this course page
