Excel 2010 Advanced
4.2 (158 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,224 students enrolled

Excel 2010 Advanced

Take Excel to the next level with PivotTables, Goal Seeking, Scenario Manager and much more
4.2 (158 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,224 students enrolled
Last updated 5/2018
English
English, French, 7 more
  • German
  • Hindi
  • Japanese
  • Portuguese
  • Russian
  • Simplified Chinese
  • Spanish
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 2 downloadable resources
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Use several different types of advanced functions
  • See the benefits of conditional formatting
  • Use Excel as a simple database
  • Mine business intelligence from your data with PivotTables and PivotCharts
  • Be able to import and export data
Requirements
  • Basic Microsoft Windows and Intermediate Microsoft Excel 2010 training or equivalent experience
Description

This course delves into a variety of topics beyond the basics. You will learn how to use a wide range of financial, logical, text, and statistical functions; analyze data with the scenario manager; apply conditional formatting; and use the new Sparkline feature. Database management, PivotTables, PivotCharts and Slicers are covered in detail, as well as importing and exporting Excel data between applications.


This IAAP-certified counts for 3 recertification points for the CAP certification under the Operational Functions content area.

Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Who this course is for:
  • Students who understand the basics of Excel formulas, functions and data collection and are now ready to expand their skills and learn to use tools for gleaning information from their data
Course content
Expand all 24 lectures 03:08:12
+ Introduction
1 lecture 01:48
If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.  
Preview 01:48
+ Using Advanced Functions
5 lectures 56:51
Logical Functions
18:42
Financial Functions
09:38
Text Functions
15:43
Lookup Functions
08:36
+ Managing Data
4 lectures 23:40
Working with Tables
04:26
Sorting a List
05:06
Filtering Data
08:46
+ Using PivotTables, Pivot Charts, and Slicers
4 lectures 40:34
Creating and a Pivot Table
09:57
Filtering and Sorting
16:40
Filtering with Slicers
06:07
Adding a PivotChart
07:50
+ Analyzing Data
2 lectures 21:05
Auditing and Error Checking
09:26
Using the Scenario Manager and Goal Seek
11:39
+ Importing and Exporting Data
3 lectures 19:08
Transferring between Word and Excel
10:43
Transferring between Access and Excel
04:17