Excel 2010 Advanced

Take Excel to the next level with PivotTables, Goal Seeking, Scenario Manager and much more
4.2 (21 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.
602 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 24
  • Length 3 hours
  • Skill Level Expert Level
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2013 English Closed captions available

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

What are the requirements?

  • Basic Microsoft Windows and Intermediate Microsoft Excel 2010 training or equivalent experience

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
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.  
Section 2: Using Advanced Functions
Help with Functions
Preview
04:12
Logical Functions
18:42
Financial Functions
09:38
Text Functions
15:43
Lookup Functions
08:36
Section 3: Conditional Formatting and SparkLines
Applying Conditional Formats
Preview
06:39
Managing Conditional Formats
05:05
Creating SparkLines
Preview
04:33
Modifying SparkLine Styles
05:06
Section 4: Managing Data
Data Validation
Preview
05:22
Working with Tables
04:26
Sorting a List
05:06
Filtering Data
08:46
Section 5: Using PivotTables, Pivot Charts, and Slicers
Creating and a Pivot Table
09:57
Filtering and Sorting
16:40
Filtering with Slicers
06:07
Adding a PivotChart
07:50
Section 6: Analyzing Data
Auditing and Error Checking
09:26
Using the Scenario Manager and Goal Seek
11:39
Section 7: Importing and Exporting Data
Transferring between Word and Excel
10:43
Importing a Text File
Preview
04:08
Transferring between Access and Excel
04:17
Section 8: Conclusion
Conclusion
03:43

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, 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.

Ready to start learning?
Take This Course