Excel 2010 Advanced

Take Excel to the next level with PivotTables, Goal Seeking, Scenario Manager and much more
  • Lectures 24
  • Video 4 Hours
  • Skill level expert level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

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.

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?

  • Over 24 lectures and 3 hours of content!
  • 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

Instructor Biography

CompuWorks Trainers , Computer Training Specialists

CompuWorks is a collaborative of computer training specialists with over 25 years’ experience teaching students how to get the most out of their technology tools.  CompuWorks innovative elearning videos display trainers on screen all the time creating a learning experience that most closely mimics a traditional classroom.

Join the biggest student community

6,400,000

Hours of video content

28,000,000

Course Enrollments

7,500,000

Students

Reviews

Average Rating
3.7
Details
  1. 5 Stars
    0
  2. 4 Stars
    2
  3. 3 Stars
    1
  4. 2 Stars
    0
  5. 1 Stars
    0
Ready to start learning?
Preview this course