Certificate In Excel 2013 Expert Online Course
Acquire Expert Skills in Excel 2013
NOW ONLY
AU$199
Save AU$70 (26%)OFF RRP AU$269
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 | 49% | |
| 4 star | 31% | |
| 3 star | 13% | |
| 2 star | 5% | |
| 1 star | 2% |
JaCynthia Russell Swann
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.
sara davis
13 October 2019 03:56:37 AM
Enjoying learning this necessary information for personal success.
Julian Lim
11 October 2019 05:42:28 PM
It has helped me learn self conr-wwwwwwwwwww'
Jon Briere
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.
Julian Lim
9 October 2019 08:49:39 PM
It has helped me overcome procrastination and helped me get tasks done efficiently.
Jo O'Leary
9 October 2019 01:40:08 PM
Excellent, Need I say any more.
Cecilia Leha
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.
Cecilia Leha
5 October 2019 04:54:24 PM
The course helped me re-visit some forgotten techniques
corallee yeo
5 October 2019 10:08:51 AM
great
corallee yeo
5 October 2019 10:07:53 AM
awesome
corallee yeo
5 October 2019 10:06:02 AM
awesome
corallee yeo
4 October 2019 12:19:59 PM
excellent
corallee yeo
3 October 2019 08:16:25 PM
awesome
Margaret Mary Vukici
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.
Lerine Meyer
1 October 2019 04:28:40 AM
This course helps me a lot and I understand more clearly.
Thank you!
JOSUE SALGADO
1 October 2019 03:34:46 AM
Great course, I fell like I will improve my organizational skills on a 100%
Nico van den Berg
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
Kurt Whyte
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.
Kurt Whyte
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.
Josue David Salgado garcia
30 September 2019 06:11:15 AM
Very Interesting and Useful
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:
- 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 | 49% | |
| 4 star | 31% | |
| 3 star | 13% | |
| 2 star | 5% | |
| 1 star | 2% |
JaCynthia Russell Swann
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.
sara davis
13 October 2019 03:56:37 AM
Enjoying learning this necessary information for personal success.
Julian Lim
11 October 2019 05:42:28 PM
It has helped me learn self conr-wwwwwwwwwww'
Jon Briere
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.
Julian Lim
9 October 2019 08:49:39 PM
It has helped me overcome procrastination and helped me get tasks done efficiently.
Jo O'Leary
9 October 2019 01:40:08 PM
Excellent, Need I say any more.
Cecilia Leha
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.
Cecilia Leha
5 October 2019 04:54:24 PM
The course helped me re-visit some forgotten techniques
corallee yeo
5 October 2019 10:08:51 AM
great
corallee yeo
5 October 2019 10:07:53 AM
awesome
corallee yeo
5 October 2019 10:06:02 AM
awesome
corallee yeo
4 October 2019 12:19:59 PM
excellent
corallee yeo
3 October 2019 08:16:25 PM
awesome
Margaret Mary Vukici
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.
Lerine Meyer
1 October 2019 04:28:40 AM
This course helps me a lot and I understand more clearly.
Thank you!
JOSUE SALGADO
1 October 2019 03:34:46 AM
Great course, I fell like I will improve my organizational skills on a 100%
Nico van den Berg
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
Kurt Whyte
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.
Kurt Whyte
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.
Josue David Salgado garcia
30 September 2019 06:11:15 AM
Very Interesting and Useful
Loading...
We provide a 7 Day Money Back Refund on all Courses
Email to a friend
Special Offer
|
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 |
- Call 1300 478 223
- Chat to us live
- Send us an enquiry
- Print this course page
Learn More With Course Bundles
Popular Courses and Bundles
Payment Methods
