Microsoft Excel 2013 Training Course for Beginners Premium class

Simon Sez IT

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
55 Videos (10h 19m)
    • Introduction to Excel 2013

      9:12
    • What's New in Excel 2013

      7:31
    • Using Excel 2013 With a Touch Device

      3:39
    • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns

      11:20
    • Templates; Creating, Opening, and Saving a Workbook

      10:54
    • Online, Offline, and Contextual Help

      8:00
    • Online, Offline, and Contextual Help

      8:00
    • Excel Options

      11:22
    • Ribbon Interface

      15:00
    • Quick Access Toolbar

      8:03
    • Mini Toolbar

      2:58
    • Create Backup Option; Auto-Recover and Autosave

      6:54
    • Entering Text and Numbers

      15:15
    • Date Formats

      15:57
    • Formatting Cells; Editing and Deleting Data

      15:15
    • Fill

      12:51
    • Flash Fill

      5:08
    • Themes and Cell Styles

      14:01
    • Inserting, Deleting, Hiding and Adjusting Rows and Columns

      13:28
    • Wrap Text and Alignment

      15:02
    • Merging Cells; Applying Themes and Styles

      11:36
    • Borders

      9:25
    • Copy, Cut and Paste

      17:06
    • Spell checking

      11:57
    • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets

      14:51
    • Inserting Comments

      6:54
    • Workbook Views, Zoom and Freeze

      11:18
    • Printing; Headers, Footers and Margins

      12:57
    • Overview of Formulas and Functions

      14:08
    • Cell References

      14:50
    • Names

      15:38
    • Finding Errors; New Excel Functions

      14:13
    • Multiple Workbooks and Windows; Comparing Workbooks

      10:39
    • Go to; Find and Replace Options

      11:14
    • Applying, Clearing and Managing Rules

      15:35
    • Chart Types; Chart Recommendation

      13:35
    • Basic Formatting

      14:41
    • Selecting Data, Positioning and Printing Charts

      15:47
    • Saving Workbooks; PDF and CSV Formats

      11:21
    • Sorting

      9:06
    • Filtering

      10:43
    • Tables

      12:25
    • VLOOKUP

      12:58
    • Text Function

      5:17
    • Date and Time Functions

      5:32
    • Logical Functions

      18:31
    • Financial Analysis Case Study - Part 1

      16:03
    • Financial Analysis Case Study - Part 2

      9:23
    • Quick Analysis Tool

      7:57
    • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt

      14:27
    • Protecting Worksheets

      7:42
    • Protecting Workbooks

      10:02
    • Sharing and SkyDrive

      14:24
    • Trust Center; Export; Inspect Workbook

      5:33
    • Summary; More Help

      1:49

About This Class

Starting with the basics, you’ll discover how to enter and format data in the quickest manner possible. Next you’ll be introduced to the power of Excel’s functions and formulas to help you calculate data and derive useful information. To help you present it all in a visually appealing format, learn how to create sophisticated charts and graphs, and publish them online. Finally, you’ll learn to analyze and review worksheets for data discrepancies so you can prevent problems before they arise. 

This course includes exercise files which you can use to help you practice what you learned.

2 of 2 students recommendSee All

great class ..covering all concepts in excel with good examples and explanations ..thankyou