Excel 2013

Excel 2013 icon
 03:53:52 Hrs

Course Description

Excel 2013

Video Resolution:
   480P
   HD
BM
Lesson Plans
Duration
Status
Notes

Collapse all Expand all

  •   Working with Data and Excel TablesOpen or Close
    -

    Using Fill Options

    02:58

     
     


    -

    Understanding the Flash Fill Option

    02:41

     
     


    -

    Moving Data within a Workbook

    02:28

     
     


    -

    Finding and Replacing Data

    03:36

     
     


    -

    Correcting And Expanding Upon Data

    02:29

     
     


    -

    Working Excel Tables - Part I

    02:01

     
     


    -

    Working Excel Tables - Part II

    03:03

     
     


  •   Performing Calculations on DataOpen or Close
    -

    Simple Operators and Precedence

    02:17

     
     


    -

    Working with Formulas

    03:46

     
     


    -

    Summarizing Data using Conditions

    02:58

     
     


    -

    Working with Iterative Calculation Options

    03:00

     
     


    -

    Understanding Arrays in Excel 2013

    03:09

     
     


    -

    Finding and Correcting Errors in Calculations

    04:33

     
     


  •   Using FiltersOpen or Close
    -

    Limiting Data Using Filters

    04:19

     
     


    -

    Manipulating Worksheet Data

    03:10

     
     


    -

    Using Data Validation

    02:39

     
     


  •   Analyzing Data and Alternative Data SetsOpen or Close
    -

    Using the Quick Analysis Lens

    01:31

     
     


    -

    Working with Alternative Dataset

    02:48

     
     


    -

    Defining Multiple Alternative Datasets

    03:38

     
     


    -

    Analyzing Data by using Data Tables

    01:56

     
     


    -

    Working with Goal Seek

    02:25

     
     


    -

    Using Solver

    06:44

     
     


    -

    Understanding Descriptive Statistics

    02:22

     
     


  •   Charts and GraphicsOpen or Close
    -

    Creating Charts Based on the Data

    03:17

     
     


    -

    Customizing Charts

    03:35

     
     


    -

    Working with Trends

    01:20

     
     


    -

    Understanding Dual-axis Charts

    02:15

     
     


    -

    Using Spark Lines

    03:24

     
     


    -

    Working with Diagrams using SmartArt

    03:15

     
     


    -

    Understanding Mathematical Equations

    04:43

     
     


  •   PivotTables and Pivot ChartsOpen or Close
    -

    Working with PivotTables

    02:53

     
     


    -

    Filtering, Showing, and Hiding PivotTable Data

    03:28

     
     


    -

    Editing PivotTables

    02:59

     
     


    -

    Formatting PivotTables

    04:21

     
     


    -

    Creating PivotTables using External Data

    03:22

     
     


    -

    Creating Dynamic Charts

    03:50

     
     


  •   Print OptionsOpen or Close
    -

    Working with Page Headers and Footers

    04:11

     
     


    -

    Page Setup Properties

    02:53

     
     


    -

    Understanding Print Options

    01:55

     
     


    -

    Printing Parts of Worksheets

    03:43

     
     


    -

    Printing Charts

    01:47

     
     


  •   Macros and FormsOpen or Close
    -

    Enabling Macros

    04:27

     
     


    -

    Examining Macros

    02:34

     
     


    -

    Working with Buttons

    02:47

     
     


    -

    Using Record Macro

    02:20

     
     


    -

    Understanding Form Controls - Part I

    03:44

     
     


    -

    Understanding Form Controls - Part II

    07:33

     
     


  •   Understanding Office365Open or Close
    -

    What is Office 365?

    03:07

     
     


    -

    Office 365 Plans

    02:45

     
     


    -

    System Requirements for Office365

    01:35

     
     


    -

    Working with SkyDrive

    02:25

     
     


    -

    Adding User in SkyDrive

    02:08

     
     


  •   Sharing WorkbooksOpen or Close
    -

    Understanding Sharing Workbooks

    03:12

     
     


    -

    Managing Comments

    01:57

     
     


    -

    Tracking and Managing Changes

    03:00

     
     


    -

    Protecting Workbooks and Worksheets

    05:05

     
     


    -

    Importing and Exporting XML Data

    01:51

     
     


BM
Tips & Tricks
Status
Self Assessments
Attempts
Status
Lesson Plans
Tips and Tricks

Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Glossary is not available for this index.