Advanced Microsoft Excel 2010 (Self-paced Tutorial) Online Certificate Course

Discover the advanced features and functions of Microsoft Excel 2010

Advanced Microsoft Excel 2010 (Self-paced Tutorial) Online Certificate Course

NOW ONLY

US$149

Save US$550 (79%)
OFF RRP US$699
Get Info Pack

Master the Fuctions of Microsoft Excel 2010

Any proficient Microsoft Excel user will agree that this program is a very powerful analytical tool. Wouldn't it be great to learn how to effectively use all the advanced Excel features?

In this practical and information-packed course, you'll see how to maximize this program's functions and capabilities.

Most organizations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization.

You'll see how to work with the additional analytical tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. Become adept at consolidating and importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.  

Learn how Excel 2010 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!

Course Fast Facts:

  • Only 6 weeks to complete this online course
  • Approximately only 2 to 4 hours per week of study is required
  • This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone
  • Instructors lead each course and you will be able to interact with them and ask questions
  • You can study from home or at work at your own pace in your own time
  • You can download printer friendly course material or save for viewing off line
  • You will be awarded a certificate at completion of this course

Course Delivery

Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand.

Recognition & Accreditation

All students who complete The Advanced Microsoft Excel 2013 Online Course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email.

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.

 

There are 12 units of study

Lesson 01: Customizing Excel

Over the next six weeks, we're going to explore Microsoft Excel 2010's new and advanced features. You'll learn how to use data analysis tools and techniques to improve your decision making, and you'll practice generating accurate data more quickly. By the end of this course, you'll be well prepared to contribute more value to your organization with your advanced understanding of Excel. To kick things off, we'll spend this first lesson exploring how you can modify Excel to streamline processes and make your work easier. You'll use the Excel Options dialog box to customize some of Excel's behind-the-scenes behavior, set up your Quick Access Toolbar, and take a look at the new and improved status bar and its customizable features. Mastering these processes will lay the foundation for our exploration of advanced topics throughout the course.

Lesson 02: Table Management

Today we'll explore some new table management features in Excel 2010, discuss how to use data forms with Excel databases, and look at a few alternative database techniques. You'll be glad to know that formatting and working with tables has gotten much easier in this latest version of Excel. Now, instead of applying filters, total rows, and formats separately, you can perform these actions through a single user interface. We'll delve into how it's done. You'll also learn how data forms provide a more user-friendly method for adding, deleting, and editing records in a table, and you'll practice using a data form to search for and view records that match specific criteria. We'll wrap things up with a brief look at some of the practical applications for data forms.

Lesson 03: Data Validation

In this lesson, we'll tackle data validation techniques—your first line of defense against incorrect or missing data and the logical next step after data forms. You'll practice using whole number, decimal, date, time, list, and other forms of validation. After that, we'll explore the possibilities of custom validation, which allows you to apply validation on a cell or range of cells based on a formula you create. The possibilities for using it are limitless! You'll also learn how to create input messages and error alerts to guide the user's data entry, how to keep track of validation rules, and how to apply a custom validation rule to other cells so that you don't have to create it all over again.

Lesson 04: Custom Controls

In the first three lessons, we covered what you might call intro-level advanced Excel topics, and now it's time to head into more complex territory. So, today, let's start working with custom controls—graphical objects that help facilitate data input and are sure to impress users. We'll start by getting your Ribbon set up to work with custom controls, and then we'll walk through some practice exercises. You'll learn how to create standard and drop-down list boxes, check boxes, option buttons, and group boxes. You'll also master the process of creating a dynamic list box, which allows you to control the values in one list box based on the values chosen by your user in a separate custom control.

Lesson 05: Conditional Formatting

Today you'll discover how to use conditional formatting. And I'm not just talking about creating validation based on cell values. We'll do a quick review of that process, just as a refresher, but after that we're going to focus on formula conditional formatting. We'll work through nine different practice exercises that explore row conditional formatting, and we'll briefly discuss how the formula works after each exercise. You'll see how to use conditional formatting to hide errors, to highlight records based on multiple criteria, to track and alert you about due dates, to find the differences between two lists, to shade every other row (my personal favorite), and more. I think you'll especially enjoy learning how to set up a scorecard, which will show you problem areas in red, possible problems in yellow, and everything running smoothly in green. (Your manager will love this.)

Lesson 06: Consolidating and Outlining

In this lesson, you'll learn how to use Excel's consolidation function to efficiently summarize data from multiple sources. A lot of people do this the hard way, but with Excel's automatic consolidation feature, you'll no longer need to develop a web of formula links to multiple sources. Goodbye, potential for human error! We'll begin with an exercise on consolidating data within the same workbook, and after that, you'll practice consolidating using an advanced technique with category labels and wildcards. Next, we'll step things up with a practice exercise on consolidating from multiple workbooks. You'll also learn how to use automatic and manual outlining to view or hide different levels or sections of your information.

Lesson 07: Excel Functions and Nesting

Excel's functions (or predefined calculations) are too numerous to completely cover in one lesson, so today we'll just focus on a few important ones spanning four categories: Logical, Database, Math & Trig, and Lookup & Reference. We'll start today with an overview of functions, take a look at the Insert Function dialog box, and then practice working with the IF function, nesting functions, the DSUM function, and the VLOOKUP function—all of which will come in handy when you need to perform a quick, thorough analysis of your data.

Lesson 08: Import External Data

In this lesson, you'll find out all about importing external data. We'll begin with a practice exercise to get you comfortable with importing data from another Excel file, during which you'll see how to use the Microsoft Query Wizard. You'll test two methods for refreshing the target area for the imported data and find out how to edit an Excel query. After that, you'll do an import from an external database. Finally, you'll learn how to perform a Web query, which—you guessed it—allows you to import data from the Internet. The Web query feature is another fantastic feature in Excel 2010.

Lesson 09: Data Tables

It's time to look at data tables, which let you compare the outcomes of different versions of the same formula without slogging through the process of calculating each of them. Data tables are very powerful what-if analysis tools that are great for analyzing potential outcomes of personal or business financial decisions. In this lesson, you'll learn how to use two types of data tables: a one-variable data table (which lets you substitute just one variable into the formula calculation) and the two-variable data table (which allows you to change multiple aspects of the formula).

Lesson 10: What-If Analysis Tools

Today we'll explore three more of Excel's what-if analysis tools: Goal Seek, Scenario Manager, and Solver. You'll find out how to use Goal Seek to solve formulas backward—for example, you might want to do this if you knew the result you wanted but needed to determine how to change a single input cell in order to get that desired result. After that, we'll practice using Scenario Manager to create and save different input values and their results as scenarios (great for working on budgets). And finally, you'll put Excel's Solver to work to discover the optimal solution to models that have multiple variables and constraints.

Lesson 11: Advanced PivotTables, Analysis ToolPak, Advanced

In this lesson, you'll discover how to use PivotTables, which are excellent for summarizing massive amounts of data and viewing different cuts of the information quickly. There are two methods for creating PivotTables, and you'll practice using both. You'll also learn how to edit a PivotTable, how to filter the table to create individual reports, how to format a PivotTable to make it reader-friendly, and how to create and use calculated fields and items. After this, you'll create a PivotChart based on the data fields in your PivotTable. We may not be quite done with the course, but after mastering PivotTables and PivotCharts, you'll certainly be able to count yourself an advanced Excel user.

Lesson 12: Filter, Array Formulas, and More!

We'll begin our final lesson with a look at the functions available in the Analysis ToolPak, including two of my favorites: the Moving Average and Sampling tools. You'll complete an exercise using advanced filters, and then I'll show you some of my favorite Excel tips and tricks. You'll find out how to work with the View Side by Side tool and how to use the Watch Window to keep tabs on your data when you're updating a workbook. We'll wrap things up with practice exercises using array formulas and the AutoSum Tool. When you're done with this lesson—and the course—you'll want to pass along the techniques you've learned to friends and colleagues who are still wrestling with Excel!

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)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome)

Students will also need access the following applications:

Adobe Acrobat Reader

Note: This course is not suitable for Macintosh users.

Customer Reviews


I would definitely recommend this course to my friends and co-workers. I really appreciated the way the instructor explained and taught the class. I feel I learned tremendously about using Excel and look forward to putting it to use!

I have learned so much from taking this course, and my new skills will make me a better Excel teacher!

This was by far the best Excel class I have taken. Of course, the others were one-day, 8-hour classes and more expensive and much less detailed information. The course workbook provided was excellent.

I thoroughly enjoyed the class and received a solid understanding combined with a practical ability to use Excel 2010. I enjoyed the instructor. He has a good sense of humor and explains the processes in a step-by-step way which is easy to understand.

This was a great course. Even though I have been using Excel for years I learned lots of new tips. I have already started using many of these in my day to day job.

I loved this course, easy to understand from beginning to end. I was wary of taking an online course in Excel due to prior experience, but this far surpassed my expectations!

This course was perfect for the skills I wanted to develop. It was fun and practical. I would highly recommend this course. A lot of content was delivered in a short amount of time. Kudos for the course design!

I have already recommended this course to several of my coworkers. The material presented will be useful and touches on many capabilities of Excel, but presented it in a way that was not overwhelming.

This class was great! Not only did I learn so much about Excel that I didn't know, the scenarios used in the curriculum were so pertinent to every day life at the office and at home. I send reports on a daily basis using Excel, and as I learned how to create more professional spreadsheets, I changed what I was doing. I've also began to use what I've learned at home! Thanks Chad; this was awesome!!

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 a High School Diploma or 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?

Yes, this course is online. Through well-crafted lessons, expert online instruction and interaction with your tutor, participants in this course gain valuable knowledge. You have the flexibility to study at your own pace combined with enough structure and support to complete the course. You can access the classroom 24/7 from anywhere with an Internet connection.

8.  How do I receive my course?

After you have completed 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?

This is a self-paced course that can be started at anytime as long as you have internet access and a computer.

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?

You have unlimited access for 3 months. You may start and finish the course at your own time and learn at your own pace.

13.  How long will my course take?

Individual courses are very comprehensive and can take up to 24 hours to complete.

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 24 hours = 48 hours
  • 3 course bundle is 3 x 24 hours = 72 hours
  • 5 course bundle is 5 x 24 hours = 120 hours
  • 10 course bundle is 10 x 24 hours = 240 hours
14.  Is there tutor support available?

Yes, there is tutor support, a dedicated professional instructor is available via email, answering questions and providing feedback.

15.  What is included with the course?

The onetime fee includes all training materials, including online content, diagrams, videos if included, interactive instructions and quizzes, plus you will receive a certificate upon completion.

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

17.  Is the course interactive?

Yes, all our courses are interactive.

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

19.  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 potential 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.

20.  Will this course be credited by universities?

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

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

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

23.  How long is the certificate valid for?

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

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

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

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 email/info)(coursesforsuccess.com, to pay via bank transfer.

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

27.   Can I request for an invoice before purchase?

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

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

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

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

Master the Fuctions of Microsoft Excel 2010

Any proficient Microsoft Excel user will agree that this program is a very powerful analytical tool. Wouldn't it be great to learn how to effectively use all the advanced Excel features?

In this practical and information-packed course, you'll see how to maximize this program's functions and capabilities.

Most organizations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization.

You'll see how to work with the additional analytical tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. Become adept at consolidating and importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.  

Learn how Excel 2010 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!

Course Fast Facts:

  • Only 6 weeks to complete this online course
  • Approximately only 2 to 4 hours per week of study is required
  • This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone
  • Instructors lead each course and you will be able to interact with them and ask questions
  • You can study from home or at work at your own pace in your own time
  • You can download printer friendly course material or save for viewing off line
  • You will be awarded a certificate at completion of this course

Course Delivery

Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand.

Recognition & Accreditation

All students who complete The Advanced Microsoft Excel 2013 Online Course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email.

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.

 

There are 12 units of study

Lesson 01: Customizing Excel

Over the next six weeks, we're going to explore Microsoft Excel 2010's new and advanced features. You'll learn how to use data analysis tools and techniques to improve your decision making, and you'll practice generating accurate data more quickly. By the end of this course, you'll be well prepared to contribute more value to your organization with your advanced understanding of Excel. To kick things off, we'll spend this first lesson exploring how you can modify Excel to streamline processes and make your work easier. You'll use the Excel Options dialog box to customize some of Excel's behind-the-scenes behavior, set up your Quick Access Toolbar, and take a look at the new and improved status bar and its customizable features. Mastering these processes will lay the foundation for our exploration of advanced topics throughout the course.

Lesson 02: Table Management

Today we'll explore some new table management features in Excel 2010, discuss how to use data forms with Excel databases, and look at a few alternative database techniques. You'll be glad to know that formatting and working with tables has gotten much easier in this latest version of Excel. Now, instead of applying filters, total rows, and formats separately, you can perform these actions through a single user interface. We'll delve into how it's done. You'll also learn how data forms provide a more user-friendly method for adding, deleting, and editing records in a table, and you'll practice using a data form to search for and view records that match specific criteria. We'll wrap things up with a brief look at some of the practical applications for data forms.

Lesson 03: Data Validation

In this lesson, we'll tackle data validation techniques—your first line of defense against incorrect or missing data and the logical next step after data forms. You'll practice using whole number, decimal, date, time, list, and other forms of validation. After that, we'll explore the possibilities of custom validation, which allows you to apply validation on a cell or range of cells based on a formula you create. The possibilities for using it are limitless! You'll also learn how to create input messages and error alerts to guide the user's data entry, how to keep track of validation rules, and how to apply a custom validation rule to other cells so that you don't have to create it all over again.

Lesson 04: Custom Controls

In the first three lessons, we covered what you might call intro-level advanced Excel topics, and now it's time to head into more complex territory. So, today, let's start working with custom controls—graphical objects that help facilitate data input and are sure to impress users. We'll start by getting your Ribbon set up to work with custom controls, and then we'll walk through some practice exercises. You'll learn how to create standard and drop-down list boxes, check boxes, option buttons, and group boxes. You'll also master the process of creating a dynamic list box, which allows you to control the values in one list box based on the values chosen by your user in a separate custom control.

Lesson 05: Conditional Formatting

Today you'll discover how to use conditional formatting. And I'm not just talking about creating validation based on cell values. We'll do a quick review of that process, just as a refresher, but after that we're going to focus on formula conditional formatting. We'll work through nine different practice exercises that explore row conditional formatting, and we'll briefly discuss how the formula works after each exercise. You'll see how to use conditional formatting to hide errors, to highlight records based on multiple criteria, to track and alert you about due dates, to find the differences between two lists, to shade every other row (my personal favorite), and more. I think you'll especially enjoy learning how to set up a scorecard, which will show you problem areas in red, possible problems in yellow, and everything running smoothly in green. (Your manager will love this.)

Lesson 06: Consolidating and Outlining

In this lesson, you'll learn how to use Excel's consolidation function to efficiently summarize data from multiple sources. A lot of people do this the hard way, but with Excel's automatic consolidation feature, you'll no longer need to develop a web of formula links to multiple sources. Goodbye, potential for human error! We'll begin with an exercise on consolidating data within the same workbook, and after that, you'll practice consolidating using an advanced technique with category labels and wildcards. Next, we'll step things up with a practice exercise on consolidating from multiple workbooks. You'll also learn how to use automatic and manual outlining to view or hide different levels or sections of your information.

Lesson 07: Excel Functions and Nesting

Excel's functions (or predefined calculations) are too numerous to completely cover in one lesson, so today we'll just focus on a few important ones spanning four categories: Logical, Database, Math & Trig, and Lookup & Reference. We'll start today with an overview of functions, take a look at the Insert Function dialog box, and then practice working with the IF function, nesting functions, the DSUM function, and the VLOOKUP function—all of which will come in handy when you need to perform a quick, thorough analysis of your data.

Lesson 08: Import External Data

In this lesson, you'll find out all about importing external data. We'll begin with a practice exercise to get you comfortable with importing data from another Excel file, during which you'll see how to use the Microsoft Query Wizard. You'll test two methods for refreshing the target area for the imported data and find out how to edit an Excel query. After that, you'll do an import from an external database. Finally, you'll learn how to perform a Web query, which—you guessed it—allows you to import data from the Internet. The Web query feature is another fantastic feature in Excel 2010.

Lesson 09: Data Tables

It's time to look at data tables, which let you compare the outcomes of different versions of the same formula without slogging through the process of calculating each of them. Data tables are very powerful what-if analysis tools that are great for analyzing potential outcomes of personal or business financial decisions. In this lesson, you'll learn how to use two types of data tables: a one-variable data table (which lets you substitute just one variable into the formula calculation) and the two-variable data table (which allows you to change multiple aspects of the formula).

Lesson 10: What-If Analysis Tools

Today we'll explore three more of Excel's what-if analysis tools: Goal Seek, Scenario Manager, and Solver. You'll find out how to use Goal Seek to solve formulas backward—for example, you might want to do this if you knew the result you wanted but needed to determine how to change a single input cell in order to get that desired result. After that, we'll practice using Scenario Manager to create and save different input values and their results as scenarios (great for working on budgets). And finally, you'll put Excel's Solver to work to discover the optimal solution to models that have multiple variables and constraints.

Lesson 11: Advanced PivotTables, Analysis ToolPak, Advanced

In this lesson, you'll discover how to use PivotTables, which are excellent for summarizing massive amounts of data and viewing different cuts of the information quickly. There are two methods for creating PivotTables, and you'll practice using both. You'll also learn how to edit a PivotTable, how to filter the table to create individual reports, how to format a PivotTable to make it reader-friendly, and how to create and use calculated fields and items. After this, you'll create a PivotChart based on the data fields in your PivotTable. We may not be quite done with the course, but after mastering PivotTables and PivotCharts, you'll certainly be able to count yourself an advanced Excel user.

Lesson 12: Filter, Array Formulas, and More!

We'll begin our final lesson with a look at the functions available in the Analysis ToolPak, including two of my favorites: the Moving Average and Sampling tools. You'll complete an exercise using advanced filters, and then I'll show you some of my favorite Excel tips and tricks. You'll find out how to work with the View Side by Side tool and how to use the Watch Window to keep tabs on your data when you're updating a workbook. We'll wrap things up with practice exercises using array formulas and the AutoSum Tool. When you're done with this lesson—and the course—you'll want to pass along the techniques you've learned to friends and colleagues who are still wrestling with Excel!

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)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome)

Students will also need access the following applications:

Adobe Acrobat Reader

Note: This course is not suitable for Macintosh users.

I would definitely recommend this course to my friends and co-workers. I really appreciated the way the instructor explained and taught the class. I feel I learned tremendously about using Excel and look forward to putting it to use!

I have learned so much from taking this course, and my new skills will make me a better Excel teacher!

This was by far the best Excel class I have taken. Of course, the others were one-day, 8-hour classes and more expensive and much less detailed information. The course workbook provided was excellent.

I thoroughly enjoyed the class and received a solid understanding combined with a practical ability to use Excel 2010. I enjoyed the instructor. He has a good sense of humor and explains the processes in a step-by-step way which is easy to understand.

This was a great course. Even though I have been using Excel for years I learned lots of new tips. I have already started using many of these in my day to day job.

I loved this course, easy to understand from beginning to end. I was wary of taking an online course in Excel due to prior experience, but this far surpassed my expectations!

This course was perfect for the skills I wanted to develop. It was fun and practical. I would highly recommend this course. A lot of content was delivered in a short amount of time. Kudos for the course design!

I have already recommended this course to several of my coworkers. The material presented will be useful and touches on many capabilities of Excel, but presented it in a way that was not overwhelming.

This class was great! Not only did I learn so much about Excel that I didn't know, the scenarios used in the curriculum were so pertinent to every day life at the office and at home. I send reports on a daily basis using Excel, and as I learned how to create more professional spreadsheets, I changed what I was doing. I've also began to use what I've learned at home! Thanks Chad; this was awesome!!

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 a High School Diploma or 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?

Yes, this course is online. Through well-crafted lessons, expert online instruction and interaction with your tutor, participants in this course gain valuable knowledge. You have the flexibility to study at your own pace combined with enough structure and support to complete the course. You can access the classroom 24/7 from anywhere with an Internet connection.

8.  How do I receive my course?

After you have completed 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?

This is a self-paced course that can be started at anytime as long as you have internet access and a computer.

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?

You have unlimited access for 3 months. You may start and finish the course at your own time and learn at your own pace.

13.  How long will my course take?

Individual courses are very comprehensive and can take up to 24 hours to complete.

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 24 hours = 48 hours
  • 3 course bundle is 3 x 24 hours = 72 hours
  • 5 course bundle is 5 x 24 hours = 120 hours
  • 10 course bundle is 10 x 24 hours = 240 hours
14.  Is there tutor support available?

Yes, there is tutor support, a dedicated professional instructor is available via email, answering questions and providing feedback.

15.  What is included with the course?

The onetime fee includes all training materials, including online content, diagrams, videos if included, interactive instructions and quizzes, plus you will receive a certificate upon completion.

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

17.  Is the course interactive?

Yes, all our courses are interactive.

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

19.  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 potential 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.

20.  Will this course be credited by universities?

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

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

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

23.  How long is the certificate valid for?

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

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

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

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 email/info)(coursesforsuccess.com, to pay via bank transfer.

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

27.   Can I request for an invoice before purchase?

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

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

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

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

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.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

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: 007AE0
Delivery Mode: Online
Access: 3 months
Tutor Support: Yes
Time: 40 Hours
Assessments: Yes
Qualification: Certificate

Similar Courses & Bundles

Popular Courses and Bundles

Get a FREE Career Planner