Take this
course

Office Productivity / Microsoft

Excel 2010 Advanced

Learn the advanced features and functionality of Excel 2010, including PivotTables and advanced functions.

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 Sparklines feature. Database management, PivotTables, PivotCharts, and Slicers are covered in detail, as well as importing and exporting Excel data to and from other applications.



Instructor: Lisa Connors Miles

Full details

Curriculum

  • Introduction
    Introduction
    1:49
    Course Exercise Files
  • Using Advanced Functions Part 1
    Help With Functions
    4:12
    Logical Functions
    18:43
  • Using Advanced Functions Part 2
    Financial Functions
    9:38
    Text Functions
    15:44
    Lookup Functions
    8:37
  • Conditional Formatting and SparkLines
    Applying Conditional Formats
    6:39
    Managing Conditional Formats
    5:06
    Creating Sparklines
    4:34
    Modifying Sparkline Styles
    5:07
  • Managing Data
    Using Data Validation
    5:22
    Working With Tables
    4:27
    Sorting a List
    5:07
    Filtering Data
    8:47
  • Using PivotTables, PivotCharts, and Slicers
    Creating a Pivot Table
    9:57
    Filtering and Sorting
    16:41
    Filtering With Slicers
    6:08
    Adding a PivotChart
    7:51
  • Importing and Exporting Data
    Transferring Between Word and Excel
    10:43
    Importing a Text File
    4:09
    Transferring Between Access and Excel
    4:18
  • Analyzing Data
    Auditing and Error Checking
    9:27
    Using the Scenario Manager and Goal Seek
    11:40
  • Conclusion
    Course Recap
    1:55

Skills

  • Spreadsheet
  • Microsoft Excel

Similar Courses

More Courses by this Instructor