Social Media Marketing for Dummies

Excel 2013 For Dummies eCourse

11 Chapters         94 Videos
$59.99 $49.99
  • Table of Contents
  • Course Details
  • Creating Basic Worksheets
    Seeing How Worksheets Work
    Typing Text or Numbers into a Cell
    Editing Cell Content
    Copying and Moving Data between Cells
    Adding or Deleting Rows, Columns, Cells, and Ranges
    Generating Content Automatically
    Working with Workbooks
  • Creating Formulas and Functions
    Using Formulas for Calculations
    Moving and Copying Formulas
    Introducing Functions
    Working with Named Ranges
    Performing Quick Analysis
  • Formatting and Printing Worksheets
    Adjusting Rows and Columns
    Setting the Scene with a Worksheet Background
    Adding a Worksheet Header or Footer
    Using Theme Formatting
    Printing Worksheets
  • Formatting Data
    Formatting Cells
    Formatting Cell Content
    Formatting Numbers
    Using Conditional Formatting
  • Storing and Managing Tables and Lists
    Understanding databases
    Working with Tables in Excel
    Merging and Splitting Data
  • Exploring Financial Functions and Scenarios
    Working with Financial Functions
    Finding a Value with Goal Seek
    Analyzing Complex Financial Problems with Solver
    Creating Scenarios
  • Working with Math, Statistical, and Text Functions
    Using Math and Trig Functions
    Calculating with Statistical Functions
    Formatting Data with Text Functions
  • Creating and Formatting Charts
    Introducing Chart Types
    Creating a Basic Pie or Column Chart
    Changing a Chart
    Adding and Positioning Chart Elements
    Formatting a Chart
  • Working with PivotTables and PivotCharts
    Creating a PivotTable
    Sorting and Filtering PivotTable Data
    Creating a PivotChart
  • Correcting and Validating Data
    Finding and Fixing Errors in Formulas
    Validating Data
  • Protecting and Sharing Data
    Protecting Ranges
    Securing Workbooks
    Tracking Changes in a Shared Workbook
  • Creating and editing a basic Excel worksheet
  • What formulas do and how to use functions
  • Directions for formatting and printing worksheets
  • Storing and managing tables
  • How to work with financial, math, statistical, and text functions
  • Creating and formatting charts
  • Working with PivotTables and PivotCharts
  • Correcting, protecting, and sharing data
  • . . . and much more!


This course covers the basics of creating and using Excel spreadsheets. You'll move through the process of creating a worksheet, using formulas and functions, formatting data, and working with tables. Eleven interactive lessons take you all the way to working with financial and statistical formulas, creating and formatting charts, using PivotTables and PivotCharts, sharing worksheet data, and more.

In each lesson you'll find clear, expert instruction, interactive questions, and hands-on activities that help ensure you have mastered each skill.