Take this
course

Office Productivity / Microsoft

Excel 2007 Advanced

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

Description

This course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you learn how to analyze and manage your data. You will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager, and subtotals. Additionally, during this course, you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts, and record basic Macros. 


Instructor: Pamela Conway

Full details

Curriculum

  • Introduction
    Introduction
    1:42
    Course Exercise Files
  • Using Advanced Functions
    Financial Functions
    7:45
    Logical Functions
    16:05
    Text Function
    14:58
    Statistical and Math Functions
    5:27
    Lookup Functions
    10:15
  • Formula Auditing
    Displaying Formulas
    1:22
    Tracing Cell Precedents and Dependents
    1:24
    Using the Formula Evaluator
    4:06
    Error Checking
    1:32
  • Analyzing Data
    Using Subtotals
    4:12
    Using Goal Seek
    3:16
    Using the Scenario Manager
    8:01
  • Advanced Formatting
    Understanding Custom Formats
    9:22
    Applying a Custom Format
    3:45
    Using Conditional Formatting
    2:59
    Adding Data Bars, Color Scales, and Icon Sets
    4:37
    Managing Formatting Rules
    5:15
  • Managing Data
    Planning a Database and Understanding Database Terms
    10:42
    Formatting and Sorting Tables
    1:49
    Filtering a Table
    10:04
    Using an Advanced Filter
    7:53
  • Working with PivotTables
    Creating a Simple PivotTable
    1:57
    Using the PivotTable Field List Pane
    5:31
    Working with PivotTable Options
    5:45
    Sorting in a PivotTable
    6:04
    Formatting a PivotTable
    2:38
    Creating a PivotChart
    5:16
    Formatting a PivotChart
    2:15
  • Importing and Exporting Data
    Importing from Access
    7:07
    Importing a Text File
    7:17
    Managing Updates
    1:45
    Exporting Data
    2:59
  • Macros
    Recording a Macro
    2:44
    Running a Macro
    1:32
    Running a Macro from a Custom Button
    2:35
  • Conclusion
    Course Recap
    1:22

Skills

  • Microsoft Excel

Similar Courses

More Courses by this Instructor