Excel 2013 Expert Online Certificate Course
Learn How To Excel in Excel
NOW ONLY
AU$249
Save AU$150 (38%)OFF RRP AU$399
Learn more
Learn How To Excel in Excel
Using Conditional Formatting
This course delves into Conditional Formatting in a way that users can grasp and exploit this feature. It covers how to apply conditional formatting, apply multiple rule sets, create custom rule sets, view and manage rules, and clear custom formatting rules.
Working with Slicers
Slicers allow you to quickly filter any data that is displayed within a PivotTable. In this course students are shown how to insert and use a slicer, rename a slicer, change slicer settings, format a slicer, and clear a slicer.
Using Power View, Part One
Power View has many applications for upper-level users of Excel 2013. Students will learn in this course how to enable Power View, create a Power View, add and remove fields, arrange fields, and filter and sort data.
Using Power View, Part Two
Power View is such a useful tool that it deserves an extra-close look which takes place here in Part Two. This course looks at how to: refresh data, choose a visualization, change tile display, and set display options.
Using the Inquire Add-In
The Inquire Add-In is only available in the Office Professional Plus 2013 and Office 365 Professional Plus editions. This course shows students how to install the Inquire add-in, generate a workbook analysis report, view a relationship diagram or report, view cell relationships, and compare two workbooks.
Working with Tables
Tables are efficient for dealing with ranges of data. Students will get the most from the course as they learn what tables are and how to create, resize, and clear tables, as well as how to choose a table style.
Working with Records and Fields
Records and fields are the building blocks of data. Covered in this course is what they actually are and how to add fields by inserting columns, add records by inserting rows, and delete records or fields.
Using Excel as a Database
Databases are an assemblage of data which can be manipulated in many ways. This course takes a look at how to filter data with wildcard characters, validate data with lists or formulas, and how to use database functions.
Using Custom AutoFill Lists
An AutoFill list is a series or sequence of numbers or text strings that can be filled into cells automatically when you drag your mouse pointer down a column or across a row. This course will show users how to create and use a custom AutoFill list, and how to modify and delete a custom AutoFill list.
Using Comments
Comments allow users to engage with the material and each other through making messages added to Excel files. This course gives students the knowledge how to insert, edit, navigate, and delete comments.
Tracking Changes
When changes are made to a file it’s very handy to know what has been changed and when and by who. This course touches upon how to track and review changes, set options for tracking changes, and stop tracking changes.
Linking, Consolidating, and Combining Data
When working with multiple files with interrelated data it’s handy to make the most of linking. This course covers how to link and consolidate workbooks, consolidate worksheets, and pivot consolidated data.
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.
Using Conditional Formatting
- Applying Conditional Formatting
- Applying Multiple Rule Sets
- Creating Custom Rule Sets
- Viewing and Managing Rules
- Clearing Custom Rules
Working with Slicers
- Inserting and Using a Slicer
- Renaming the Slicer
- Changing Slicer Settings
- Formatting a Slicer
- Clearing the Slicer
Using Power View, Part One
- Enabling Power View
- Creating a Power View
- Adding and Removing Fields
- Arranging Fields
- Filtering Data
- Sorting Data
Using Power View, Part Two
- Refreshing Data
- Choosing a Visualization
- Changing Tile Display
- Setting Display Options
Using the Inquire Add-In
- Installing Inquire
- Generating a Workbook Analysis Report
- Viewing Workbook and Worksheet Relationships
- Viewing Cell Relationships
- Comparing Two Workbooks
Working with Tables
- What is a Table?
- Creating Tables
- Resizing the Table
- Choosing a Table Style
- Clearing the Table
Working with Records and Fields
- What are Records and Fields?
- Adding Fields by Inserting Columns
- Adding Records by Inserting Rows
- Deleting Records or Fields
Using Excel as a Database
- Filtering with Wildcard Characters
- Validating Your Data
- Data Validation Using Lists
- Data Validation Using Formulas
- Using Database Functions
Using Custom AutoFill Lists
- Creating a Custom AutoFill List
- Using a Custom AutoFill List
- Modifying a Custom AutoFill List
- Deleting a Custom AutoFill List
Using Comments
- Inserting Comments
- Editing Comments
- Navigating Through Comments
- Deleting Comments
Tracking Changes
- Tracking Changes
- Reviewing Changes
- Setting Options for Tracking Changes
- Stopping Tracking Changes
Linking, Consolidating, and Combining Data
- Linking Workbooks
- Consolidating Workbooks
- Consolidating Worksheets
- Pivoting Consolidated Data
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
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 |
 |
Learn How To Excel in Excel
Using Conditional Formatting
This course delves into Conditional Formatting in a way that users can grasp and exploit this feature. It covers how to apply conditional formatting, apply multiple rule sets, create custom rule sets, view and manage rules, and clear custom formatting rules.
Working with Slicers
Slicers allow you to quickly filter any data that is displayed within a PivotTable. In this course students are shown how to insert and use a slicer, rename a slicer, change slicer settings, format a slicer, and clear a slicer.
Using Power View, Part One
Power View has many applications for upper-level users of Excel 2013. Students will learn in this course how to enable Power View, create a Power View, add and remove fields, arrange fields, and filter and sort data.
Using Power View, Part Two
Power View is such a useful tool that it deserves an extra-close look which takes place here in Part Two. This course looks at how to: refresh data, choose a visualization, change tile display, and set display options.
Using the Inquire Add-In
The Inquire Add-In is only available in the Office Professional Plus 2013 and Office 365 Professional Plus editions. This course shows students how to install the Inquire add-in, generate a workbook analysis report, view a relationship diagram or report, view cell relationships, and compare two workbooks.
Working with Tables
Tables are efficient for dealing with ranges of data. Students will get the most from the course as they learn what tables are and how to create, resize, and clear tables, as well as how to choose a table style.
Working with Records and Fields
Records and fields are the building blocks of data. Covered in this course is what they actually are and how to add fields by inserting columns, add records by inserting rows, and delete records or fields.
Using Excel as a Database
Databases are an assemblage of data which can be manipulated in many ways. This course takes a look at how to filter data with wildcard characters, validate data with lists or formulas, and how to use database functions.
Using Custom AutoFill Lists
An AutoFill list is a series or sequence of numbers or text strings that can be filled into cells automatically when you drag your mouse pointer down a column or across a row. This course will show users how to create and use a custom AutoFill list, and how to modify and delete a custom AutoFill list.
Using Comments
Comments allow users to engage with the material and each other through making messages added to Excel files. This course gives students the knowledge how to insert, edit, navigate, and delete comments.
Tracking Changes
When changes are made to a file it’s very handy to know what has been changed and when and by who. This course touches upon how to track and review changes, set options for tracking changes, and stop tracking changes.
Linking, Consolidating, and Combining Data
When working with multiple files with interrelated data it’s handy to make the most of linking. This course covers how to link and consolidate workbooks, consolidate worksheets, and pivot consolidated data.
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.
Using Conditional Formatting
- Applying Conditional Formatting
- Applying Multiple Rule Sets
- Creating Custom Rule Sets
- Viewing and Managing Rules
- Clearing Custom Rules
Working with Slicers
- Inserting and Using a Slicer
- Renaming the Slicer
- Changing Slicer Settings
- Formatting a Slicer
- Clearing the Slicer
Using Power View, Part One
- Enabling Power View
- Creating a Power View
- Adding and Removing Fields
- Arranging Fields
- Filtering Data
- Sorting Data
Using Power View, Part Two
- Refreshing Data
- Choosing a Visualization
- Changing Tile Display
- Setting Display Options
Using the Inquire Add-In
- Installing Inquire
- Generating a Workbook Analysis Report
- Viewing Workbook and Worksheet Relationships
- Viewing Cell Relationships
- Comparing Two Workbooks
Working with Tables
- What is a Table?
- Creating Tables
- Resizing the Table
- Choosing a Table Style
- Clearing the Table
Working with Records and Fields
- What are Records and Fields?
- Adding Fields by Inserting Columns
- Adding Records by Inserting Rows
- Deleting Records or Fields
Using Excel as a Database
- Filtering with Wildcard Characters
- Validating Your Data
- Data Validation Using Lists
- Data Validation Using Formulas
- Using Database Functions
Using Custom AutoFill Lists
- Creating a Custom AutoFill List
- Using a Custom AutoFill List
- Modifying a Custom AutoFill List
- Deleting a Custom AutoFill List
Using Comments
- Inserting Comments
- Editing Comments
- Navigating Through Comments
- Deleting Comments
Tracking Changes
- Tracking Changes
- Reviewing Changes
- Setting Options for Tracking Changes
- Stopping Tracking Changes
Linking, Consolidating, and Combining Data
- Linking Workbooks
- Consolidating Workbooks
- Consolidating Worksheets
- Pivoting Consolidated Data
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
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: | 002EX13EXOC |
|---|---|
| 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
