Social Media Marketing for Dummies

Excel 2010 For Dummies Advanced

9 Chapters         79 Videos
$39.99 $34.99
  • Table of Contents
  • Course Details
  • Excel 2010 Advanced For Dummies
    Excel 2010 Advanced For Dummies
  • Creating and Formatting Charts
    Creating and Formatting Charts
    Creating a Basic Chart
    Changing a Chart
    Adding and Positioning Chart Elements
    Formatting a Chart
    Creating and Formatting Charts Summary
  • Presenting Data Clearly
    Presenting Data Clearly
    Working with Advanced Number Formatting
    Taking Advantage of Conditional Formatting
    Customizing Themes and Table Styles
    Creating Advanced Charts
    Presenting Data Clearly Summary
  • Exploring financial Functions
    Exploring financial Functions
    Using Common Financial Functions
    Analyzing Financial Data
    Creating Scenarios
    Exploring Financial Functions Summary
  • Working with Math, Statistical, and Text Functions
    Working with Math, Statistical, and Text Functions
    Mastering Math and Trig Functions
    Mastering Statistical Functions
    Managing Data with Text Functions
    Working with Math, Statistical, and Text Functions Summary
  • Storing and Managing Databases
    Storing and Managing Databases
    Introducing Databases
    Working with Tables in Excel
    Merging and Splitting Data
    Storing and Managing Databases Summary
  • Working with PivotTables and PivotCharts
    Working with PivotTables and PivotCharts
    Creating a PivotTable
    Sorting and Filtering PivotTable Data
    Creating a PivotChart
    Working with Pivot Tables Summary
  • Correcting, Protecting, and Sharing Data
    Correcting, Protecting, and Sharing Data
    Finding and Fixing Errors in Formulas
    Validating Data
    Protecting Ranges
    Securing Workbooks
    Tracking Changes in a Shared Workbook
    Correcting, Protecting, and Sharing Data Summary
  • Course Assessment
    Course Assessment
  • Using advanced formatting techniques to make your Excel data easier to read and understand
  • Tackling common financial chores such as calculating loan payments and interest
  • Applying Excel's tools for sophisticated data analysis
  • Calculating math, statistical, and text functions such as exponentiation and square roots, sines, cosines, and tangents
  • Creating and formatting PivotTables and PivotCharts
  • Correcting, protecting, and sharing the data in your workbooks

Description:

In this course, you'll learn how to create and format several types of Excel charts, present data clearly, use financial functions, work with math, statistical, and text functions, store and manage data in tables and lists, work with PivotTables and PivotCharts, and correct, protect, and share your workbook data. The seven interactive lessons take you step-by-step through the process, so you learn at your own pace.

In each lesson, you'll find clear, expert instruction, interactive questions or hands-on activities, summaries, and a way to review topics so you can ensure that you understand and have mastered each skill.