Excel 2010 Essentials Online Bundle, 3 Certificate Courses

Learn Essential Skills in Microsoft Office 2010

Excel 2010 Essentials Online Bundle, 3 Certificate Courses

NOW ONLY

AU$449

Save AU$748 (62%)
OFF RRP AU$1197
or 4 interest-free payments of $112.25 with Learn more
Get Info Pack

Get Excel 2010 Essentials, Excel 2010 Advanced, and Excel 2010 Expert in this Bundle

1. Excel 2010 Essentials: Learn the Basic Features of Excel 2010

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information and better information leads to better decision making!

By the end of this Excel 2010 Essentials Online Short Course, you will be able to:

  • Open and close Excel
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Understand the new Interface and the new Backstage View
  • Enter labels and values
  • Edit data
  • Add rows and columns
  • Check spelling
  • Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
  • Switch between Excel views and create custom views
  • Use Zoom
  • Set up, Preview and print your workbook
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Understand the new Function Names
  • Use the Formulas Tab
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Use the status bar to perform calculations
  • Use AutoFill and AutoComplete
  • Sort and filter data
  • Use sparklines
  • Format text and numbers
  • Use alignment options
  • Merge cells
  • Apply borders
  • Use cell styles
  • Use conditional formatting
  • Change the workbook theme

2. Excel 2010 Advanced: Learn Advanced Skills with Excel 2010

Learn how to use the advanced features of Excel 2010. This course is designed to teach you a basic understanding of Excel 2010 in a practical way.

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information and better information leads to better decision making!

By the end of this Course, you will be able to:

  • Insert SmartArt
  • Add text to a diagram
  • Resize and move a diagram
  • Reset a diagram
  • Understand the contextual tabs
  • Add pictures from your computer
  • Add Clip Art
  • Add text boxes
  • Draw shapes
  • Trace precedent cells
  • Trace dependents of a cell
  • Display formulas within the sheet
  • Work with comments
  • Insert a chart
  • Use the Chart Tools tab
  • Understand the parts of a chart
  • Change the chart style
  • Resize and move a chart
  • Insert a Pivot Table
  • Use the Pivot Table Tools tab
  • Choose fields and group data in a Pivot Table
  • Change Pivot Table data and refresh the view
  • Apply a Style to a Pivot table
  • Use Real-life examples in a Pivot Table
  • Create a Pivot Chart from a Pivot Table
  • Create a Pivot Chart from Data
  • Display the Developer tab
  • Record and run macros
  • Change the security level
  • Customize and Change the Quick Access Toolbar
  • Use named ranges in formulas
  • Understand formula errors
  • Trace dependents and precedents in formulas
  • Use the Trace Errors Commands
  • Evaluate formulas
  • Use Goal Seek
  • Use the Scenario Manager
  • Use a One Input Data Table
  • Use a Two Input Data Table
  • Transposing Data from rows to columns
  • Use the Text to Columns feature
  • Check for duplicates
  • Create data validation rules
  • Consolidate Data
  • Group Data
  • Add Subtotals
  • Outline Data view Grouped and Outlined Data

3. Excel 2010 Expert: Gain Skills to Become an Expert with Excel 2010

You will learn how to use the more in-depth features of Excel 2010. This course is designed to for the advanced users of Excel 2010.

Excel is the world's premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information, and better information leads to better decision making!

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

  • Mark Workbook as Final
  • Encrypt with a Password and Restrict Permissions
  • Protect the Current Sheet or the Workbook Structure
  • Add a Digital Signature
  • Set Excel Options
  • Manage Versions
  • Save a Workbook as an Excel Template
  • Inspect Documents
  • Share Workbooks
  • Edit a Shared Workbook
  • Track Changes
  • Merge Copies of a Shared Workbook
  • Use the Watch Window
  • Set Calculation Options
  • Enable or Disable Automatic Workbook Calculations
  • Use the IFERROR Function to Evaluate Formulas
  • Use Array Formulas
  • Understand a Variety of different Functions
  • Assign Macros to a Command Button on the Ribbon
  • Run a Macro by Clicking an Area of a Graphic Object
  • Configure a Macro to Run Automatically Upon Opening the Workbook
  • Change a Macro
  • Insert Form Controls
  • Use a data form
  • Use Trend Lines
  • Add a Secondary Axis
  • Use Chart Templates
  • Work with PivotTable Tools
  • Work with PivotChart Tools
  • Use the Slicer
  • Choose External Data Sets with the Slicer
  • Understand the Analysis ToolPak

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates

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.

Receive Lifetime Access to Course Materials, so you can review at any time.

The Excel 2010 Essentials 3 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Excel 2010 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Excel

  • Opening Excel
  • Understanding the Interface
  • Using Backstage View
  • Understanding Worksheets
  • Understanding Workbooks

Module Three: Your First Worksheet

  • Entering Data
  • Editing Data
  • Using the Wrap Command
  • Adding Rows and Columns
  • Checking Your Spelling

Module Four: Working with Excel Files

  • Saving Files
  • Publishing Files to PDF
  • Sending Files via E-Mail
  • Closing Files
  • Opening Files

Module Five: Viewing Excel Data

  • An Overview of Excel’s Views
  • Switching Views
  • Creating Custom Views
  • Using Zoom
  • Switching Between Open Files

Module Six: Printing Excel Data

  • An Overview of the Page Layout Tab
  • Setting Up Your Page
  • Using Print Preview
  • Printing Data

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: Using Excel Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Understanding the Formulas Tab
  • Using the Status Bar to Perform Calculations
  • Understanding the New Function Names

Module Nine: Using Time Saving Tools

  • Using AutoFill
  • Using AutoComplete
  • Sorting Data
  • Filtering Data
  • Adding Sparklines

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Using Merge
  • Removing Formatting

Module Eleven: Advanced Formatting Tools

  • Adding Borders
  • Adding Fill Color
  • Using Cell Styles
  • Using Conditional Formatting
  • Changing the Theme

Module Twelve: Wrapping Up

Course 2 - Excel 2010 Advanced 

Module One: Getting Started

  • Course Objectives

Module Two: SmartArt and Objects

  • Lesson One: Inserting SmartArt
  • Lesson Two: Adding Text to the Diagram
  • Lesson Three: Resizing and Moving the Diagram
  • Lesson Four: Resetting the Diagram
  • Lesson Five: Adding Pictures from Your Computer
  • Lesson Six: Adding Clip Art
  • Lesson Seven: Adding Text Boxes
  • Lesson Eight: Drawing Shapes
  • Lesson Nine: About the Contextual Tabs

Module Three: Auditing

  • Lesson One: Tracing Recedent Cells
  • Lesson Two: Tracing the Dependents of a Cell
  • Lesson Three: Displaying Formulas Within the Sheet
  • Lesson Four: Adding, Displaying, Editing, and Removing Comments

Module Four:  Creating Charts

  • Lesson One: Inserting a Chart
  • Lesson Two: Overview of the Chart Tools Tab
  • Lesson Three: Understanding the Parts of a Chart
  • Lesson Four: Changing the Chart Style
  • Lesson Five: Resizing and Moving the Chart

Module Five: Creating Pivot Tables

  • Lesson One: Inserting a Pivot Table
  • Lesson Two: Choosing Fields and Grouping Data
  • Lesson Three: Overview of the Pivot Tools Tabs

Module Six: Working with PivotTables and PivotCharts

  • Lesson One: Changing the Data Displayed and Refreshing the PivotTable
  • Lesson Two: Applying a Style to Your Pivot Table
  • Lesson Three: Creating a Pivot Chart from a Pivot Table
  • Lesson Four: Creating a Pivot Chart from Data
  • Lesson Five: Some Real-life Examples

Module Seven:  Macros

  • Lesson One: Displaying the Developer Tab
  • Lesson Two: Recording and Running Macros
  • Lesson Three: Changing the Security Level
  • Lesson Four: Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Lesson One: Using Named Ranges
  • Lesson Two: Understanding Formula Errors
  • Lesson Three: Using the Trace Errors Commands
  • Lesson Four: Using Error Checking

Module Nine: Using What If Analysis

  • Lesson One: Using Goal Seek
  • Lesson Two: Using the Scenario Manager
  • Lesson Three: Using a One Input Data Table
  • Lesson Four: Using a Two Input Data Table

Module Ten: Managing Your Data

  • Lesson One: Transposing Data from Rows to Columns
  • Lesson Two: Using the Text to Columns Feature
  • Lesson Three: Checking for Duplicates
  • Lesson Four: Creating Data Validation Rules
  • Lesson Five: Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Lesson One: Grouping Data
  • Lesson Two: Adding Subtotals
  • Lesson Three: Outlining Data
  • Lesson Four: Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

Course 3 - Excel 2010 Expert 

Module One: Getting Started

  • Course Objectives

Module Two: Working with Permissions and Options

  • Marking Workbook as Final
  • Encrypting with a Password and Restricting Permissions
  • 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 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 Functions

  • Working with Math and Trigonometry Functions
  • Using a SUMIF Function
  • Working with Date and Time Functions
  • Working with Financial Functions
  • Working with Text Functions
  • Working with Cube Functions
  • Working with Statistical Functions

Module Seven: 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
  • Changing a Macro

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

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

Module Ten: Working with PivotTables and PivotCharts

  • Working with PivotTable Tools
  • Working with PivotChart Tools
  • About Slicers
  • Creating a Slicer in an Existing PivotTable
  • Creating a Standalone Slicer
  • Formatting a Slicer
  • Sharing Slicers with Another PivotTable
  • Disconnect or Delete a Slicer

Module Eleven: Using the Automated Analysis Tools Add-In

  • Loading the Analysis ToolPak
  • About the Analysis ToolPak Options (I)
  • About the Analysis ToolPak Options (II)
  • About the Analysis ToolPak Options (II)

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

Adobe Acrobat Reader

1.  Who are Courses For Success?

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.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

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

4.  Are there any requirements to study this course?

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.

5.  Do I require to have finished high school to complete 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.

6.  What if English is not my first language?

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.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

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.

9.  When does this course start?

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.

10.  What is online learning like?

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.

11.  What computer skills do I need for my course?

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).

12.  How long will you have access to the online course?

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.

13.  How long will my course take?

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
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

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.

17.  What type of certificate will I receive?

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.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

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.

20.  How will this course assist me with my career?

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.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

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.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card and Bank Transfer. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

About this Course

Get Excel 2010 Essentials, Excel 2010 Advanced, and Excel 2010 Expert in this Bundle

1. Excel 2010 Essentials: Learn the Basic Features of Excel 2010

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information and better information leads to better decision making!

By the end of this Excel 2010 Essentials Online Short Course, you will be able to:

  • Open and close Excel
  • Differentiate between worksheets, workbooks, rows, columns, and cells
  • Understand the new Interface and the new Backstage View
  • Enter labels and values
  • Edit data
  • Add rows and columns
  • Check spelling
  • Open, close, and save workbooks (including publishing to PDF and sending via E-mail)
  • Switch between Excel views and create custom views
  • Use Zoom
  • Set up, Preview and print your workbook
  • Build, copy and edit formulas
  • Use absolute referencing appropriately
  • Understand the difference between Formulas and Functions
  • Understand the new Function Names
  • Use the Formulas Tab
  • Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
  • Use the status bar to perform calculations
  • Use AutoFill and AutoComplete
  • Sort and filter data
  • Use sparklines
  • Format text and numbers
  • Use alignment options
  • Merge cells
  • Apply borders
  • Use cell styles
  • Use conditional formatting
  • Change the workbook theme

2. Excel 2010 Advanced: Learn Advanced Skills with Excel 2010

Learn how to use the advanced features of Excel 2010. This course is designed to teach you a basic understanding of Excel 2010 in a practical way.

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information and better information leads to better decision making!

By the end of this Course, you will be able to:

  • Insert SmartArt
  • Add text to a diagram
  • Resize and move a diagram
  • Reset a diagram
  • Understand the contextual tabs
  • Add pictures from your computer
  • Add Clip Art
  • Add text boxes
  • Draw shapes
  • Trace precedent cells
  • Trace dependents of a cell
  • Display formulas within the sheet
  • Work with comments
  • Insert a chart
  • Use the Chart Tools tab
  • Understand the parts of a chart
  • Change the chart style
  • Resize and move a chart
  • Insert a Pivot Table
  • Use the Pivot Table Tools tab
  • Choose fields and group data in a Pivot Table
  • Change Pivot Table data and refresh the view
  • Apply a Style to a Pivot table
  • Use Real-life examples in a Pivot Table
  • Create a Pivot Chart from a Pivot Table
  • Create a Pivot Chart from Data
  • Display the Developer tab
  • Record and run macros
  • Change the security level
  • Customize and Change the Quick Access Toolbar
  • Use named ranges in formulas
  • Understand formula errors
  • Trace dependents and precedents in formulas
  • Use the Trace Errors Commands
  • Evaluate formulas
  • Use Goal Seek
  • Use the Scenario Manager
  • Use a One Input Data Table
  • Use a Two Input Data Table
  • Transposing Data from rows to columns
  • Use the Text to Columns feature
  • Check for duplicates
  • Create data validation rules
  • Consolidate Data
  • Group Data
  • Add Subtotals
  • Outline Data view Grouped and Outlined Data

3. Excel 2010 Expert: Gain Skills to Become an Expert with Excel 2010

You will learn how to use the more in-depth features of Excel 2010. This course is designed to for the advanced users of Excel 2010.

Excel is the world's premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information, and better information leads to better decision making!

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

  • Mark Workbook as Final
  • Encrypt with a Password and Restrict Permissions
  • Protect the Current Sheet or the Workbook Structure
  • Add a Digital Signature
  • Set Excel Options
  • Manage Versions
  • Save a Workbook as an Excel Template
  • Inspect Documents
  • Share Workbooks
  • Edit a Shared Workbook
  • Track Changes
  • Merge Copies of a Shared Workbook
  • Use the Watch Window
  • Set Calculation Options
  • Enable or Disable Automatic Workbook Calculations
  • Use the IFERROR Function to Evaluate Formulas
  • Use Array Formulas
  • Understand a Variety of different Functions
  • Assign Macros to a Command Button on the Ribbon
  • Run a Macro by Clicking an Area of a Graphic Object
  • Configure a Macro to Run Automatically Upon Opening the Workbook
  • Change a Macro
  • Insert Form Controls
  • Use a data form
  • Use Trend Lines
  • Add a Secondary Axis
  • Use Chart Templates
  • Work with PivotTable Tools
  • Work with PivotChart Tools
  • Use the Slicer
  • Choose External Data Sets with the Slicer
  • Understand the Analysis ToolPak

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates

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.

Receive Lifetime Access to Course Materials, so you can review at any time.

The Excel 2010 Essentials 3 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Excel 2010 Essentials

Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Excel

  • Opening Excel
  • Understanding the Interface
  • Using Backstage View
  • Understanding Worksheets
  • Understanding Workbooks

Module Three: Your First Worksheet

  • Entering Data
  • Editing Data
  • Using the Wrap Command
  • Adding Rows and Columns
  • Checking Your Spelling

Module Four: Working with Excel Files

  • Saving Files
  • Publishing Files to PDF
  • Sending Files via E-Mail
  • Closing Files
  • Opening Files

Module Five: Viewing Excel Data

  • An Overview of Excel’s Views
  • Switching Views
  • Creating Custom Views
  • Using Zoom
  • Switching Between Open Files

Module Six: Printing Excel Data

  • An Overview of the Page Layout Tab
  • Setting Up Your Page
  • Using Print Preview
  • Printing Data

Module Seven: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Relative vs. Absolute References

Module Eight: Using Excel Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using Other Basic Excel Functions
  • Understanding the Formulas Tab
  • Using the Status Bar to Perform Calculations
  • Understanding the New Function Names

Module Nine: Using Time Saving Tools

  • Using AutoFill
  • Using AutoComplete
  • Sorting Data
  • Filtering Data
  • Adding Sparklines

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Changing the Appearance of Numbers
  • Setting Alignment Options
  • Using Merge
  • Removing Formatting

Module Eleven: Advanced Formatting Tools

  • Adding Borders
  • Adding Fill Color
  • Using Cell Styles
  • Using Conditional Formatting
  • Changing the Theme

Module Twelve: Wrapping Up

Course 2 - Excel 2010 Advanced 

Module One: Getting Started

  • Course Objectives

Module Two: SmartArt and Objects

  • Lesson One: Inserting SmartArt
  • Lesson Two: Adding Text to the Diagram
  • Lesson Three: Resizing and Moving the Diagram
  • Lesson Four: Resetting the Diagram
  • Lesson Five: Adding Pictures from Your Computer
  • Lesson Six: Adding Clip Art
  • Lesson Seven: Adding Text Boxes
  • Lesson Eight: Drawing Shapes
  • Lesson Nine: About the Contextual Tabs

Module Three: Auditing

  • Lesson One: Tracing Recedent Cells
  • Lesson Two: Tracing the Dependents of a Cell
  • Lesson Three: Displaying Formulas Within the Sheet
  • Lesson Four: Adding, Displaying, Editing, and Removing Comments

Module Four:  Creating Charts

  • Lesson One: Inserting a Chart
  • Lesson Two: Overview of the Chart Tools Tab
  • Lesson Three: Understanding the Parts of a Chart
  • Lesson Four: Changing the Chart Style
  • Lesson Five: Resizing and Moving the Chart

Module Five: Creating Pivot Tables

  • Lesson One: Inserting a Pivot Table
  • Lesson Two: Choosing Fields and Grouping Data
  • Lesson Three: Overview of the Pivot Tools Tabs

Module Six: Working with PivotTables and PivotCharts

  • Lesson One: Changing the Data Displayed and Refreshing the PivotTable
  • Lesson Two: Applying a Style to Your Pivot Table
  • Lesson Three: Creating a Pivot Chart from a Pivot Table
  • Lesson Four: Creating a Pivot Chart from Data
  • Lesson Five: Some Real-life Examples

Module Seven:  Macros

  • Lesson One: Displaying the Developer Tab
  • Lesson Two: Recording and Running Macros
  • Lesson Three: Changing the Security Level
  • Lesson Four: Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Lesson One: Using Named Ranges
  • Lesson Two: Understanding Formula Errors
  • Lesson Three: Using the Trace Errors Commands
  • Lesson Four: Using Error Checking

Module Nine: Using What If Analysis

  • Lesson One: Using Goal Seek
  • Lesson Two: Using the Scenario Manager
  • Lesson Three: Using a One Input Data Table
  • Lesson Four: Using a Two Input Data Table

Module Ten: Managing Your Data

  • Lesson One: Transposing Data from Rows to Columns
  • Lesson Two: Using the Text to Columns Feature
  • Lesson Three: Checking for Duplicates
  • Lesson Four: Creating Data Validation Rules
  • Lesson Five: Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Lesson One: Grouping Data
  • Lesson Two: Adding Subtotals
  • Lesson Three: Outlining Data
  • Lesson Four: Viewing Grouped and Outlined Data

Module Twelve: Wrapping Up

Course 3 - Excel 2010 Expert 

Module One: Getting Started

  • Course Objectives

Module Two: Working with Permissions and Options

  • Marking Workbook as Final
  • Encrypting with a Password and Restricting Permissions
  • 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 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 Functions

  • Working with Math and Trigonometry Functions
  • Using a SUMIF Function
  • Working with Date and Time Functions
  • Working with Financial Functions
  • Working with Text Functions
  • Working with Cube Functions
  • Working with Statistical Functions

Module Seven: 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
  • Changing a Macro

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

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

Module Ten: Working with PivotTables and PivotCharts

  • Working with PivotTable Tools
  • Working with PivotChart Tools
  • About Slicers
  • Creating a Slicer in an Existing PivotTable
  • Creating a Standalone Slicer
  • Formatting a Slicer
  • Sharing Slicers with Another PivotTable
  • Disconnect or Delete a Slicer

Module Eleven: Using the Automated Analysis Tools Add-In

  • Loading the Analysis ToolPak
  • About the Analysis ToolPak Options (I)
  • About the Analysis ToolPak Options (II)
  • About the Analysis ToolPak Options (II)

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

Adobe Acrobat Reader

1.  Who are Courses For Success?

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.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

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

4.  Are there any requirements to study this course?

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.

5.  Do I require to have finished high school to complete 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.

6.  What if English is not my first language?

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.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

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.

9.  When does this course start?

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.

10.  What is online learning like?

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.

11.  What computer skills do I need for my course?

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).

12.  How long will you have access to the online course?

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.

13.  How long will my course take?

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
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

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.

17.  What type of certificate will I receive?

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.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

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.

20.  How will this course assist me with my career?

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.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

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.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card and Bank Transfer. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

We provide a 7 Day Money Back Refund on all Courses

Now Only AU$449 Save AU$748 (62%)
OFF RRP AU$1197
or 4 interest-free payments of $112.25 with Learn more
Delivery Method

Online - Certificate

Get Info Pack

Special Offer

 

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

 

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: 020E1ES3CB
Delivery Mode: Online
Access: Unlimited lifetime access to course material
Time: Study at your own pace
Duration: 18-22 Hours for total bundle
Assessments: Yes
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner