Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel 2010 Advanced to your Wishlist.

Add to Wishlist

Excel 2010 Advanced

Take Excel to the next level with PivotTables, Goal Seeking, Scenario Manager and much more
4.1 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
666 students enrolled
Last updated 4/2013
English English
$10 $30 67% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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
View Curriculum
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.

Who is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 24 Lectures Collapse 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
+
Conditional Formatting and SparkLines
4 Lectures 21:23

Managing Conditional Formats
05:05


Modifying SparkLine Styles
05:06
+
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
+
Conclusion
1 Lecture 03:43
Conclusion
03:43
About the Instructor
4.4 Average rating
2,474 Reviews
18,131 Students
127 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.
Report Abuse