Learning Microsoft Excel 2013 Training Video

expand all / collapse all

• 00. Free Videos From This Course

  • Getting Started With Excel 2013
  • About The Author
  • Navigating An Excel Workbook
  • The Fill Handle
  • Merging And Wrapping Cell Contents
  • Modifying More Than One Worksheet At A Time
  • Paper Size, Orientation, Margins, And Scaling Options
  • Absolute Referencing Explained
  • Converting Data To A Table For Formatting
  • Using The 2013 Templates
  • Formatting Graphical Objects
  • The Pie Chart In Detail
  • Filtering Data To Reduce Dataset Size
  • Text Manipulation Using Functions
  • Altering Cell Appearance Based On The Cell Value

• 01. Start Here

  • 0101 Getting Started With Excel 2013
  • 0102 The Excel Workbook Explained
  • 0103 Signing Up For Your Own Free SkyDrive
  • 0104 Customize The Quick Access Toolbar
  • 0105 Using The Included Working Files
  • 0106 About The Author

• 02. Managing Excel Workbooks And Worksheets

  • 0201 Creating And Saving A New Workbook
  • 0202 Opening Workbooks And Save As Options
  • 0203 Saving And Opening SkyDrive Files
  • 0204 Navigating An Excel Workbook
  • 0205 Adding And Removing Worksheets
  • 0206 Renaming Copying And Moving Worksheets

• 03. Entering And Editing Data In Cells

  • 0301 Entering Text, Numbers, And Dates
  • 0302 Entering Numbers As Text
  • 0303 Editing The Contents Of A Cell
  • 0304 Undo And Redo Actions
  • 0305 Cut, Copy, And Paste
  • 0306 Dragging And Dropping Cells
  • 0307 The Fill Handle
  • 0308 Inserting And Deleting Cells Columns And Rows
  • 0309 Changing Column Widths And Row Heights
  • 0310 Hiding And Un-Hiding Columns And Rows
  • 0311 Searching For Values In A Workbook

• 04. Math Basics

  • 0401 Getting Started With Basic Math Formulas
  • 0402 Order Of Operation With BODMAS
  • 0403 Introduction To Basic Formulas
  • 0404 Copying Formulas And Functions
  • 0405 Displaying Formulas On A Worksheet

• 05. Formatting Worksheets

  • 0501 Selecting Cells For Formatting
  • 0502 Modifying Typeface Font, Size, And Colour
  • 0503 Merging And Wrapping Cell Contents
  • 0504 Using Number Formats
  • 0505 Cell Content Alignment And Orientation
  • 0506 Adding And Removing Borders From A Selection
  • 0507 Applying A Date Format To A Cell Or Range
  • 0508 The Format Painter
  • 0509 Finding And Replacing Formats
  • 0510 Clearing Cell Contents Vs. Clearing Cell Formatting

• 06. Workbook And Worksheet Management

  • 0601 Worksheet Navigation And Coloured Worksheet Tabs
  • 0602 Moving Or Copying Worksheets Within And Between Workbooks
  • 0603 Viewing And Scrolling Multiple Workbooks At The Same Time
  • 0604 Hiding And Un-Hiding Sheets
  • 0605 Modifying More Than One Worksheet At A Time

• 07. Page Setup And Printing

  • 0701 Using Print Titles And Print Areas
  • 0702 Paper Size, Orientation, Margins, And Scaling Options
  • 0703 Creating Headers and Footers
  • 0704 Using The Page Break And The Page Layout Views
  • 0705 Printing A Range Of Cells
  • 0706 Running The Spell Checker
  • 0707 Controlling Most Print Settings In One Place

• 08. Mathematical Formulas

  • 0801 The Sum Function
  • 0802 Copying Formulas And Functions
  • 0803 Other Mathematical Functions: Average, Min, And Max
  • 0804 Useful Count Functions
  • 0805 Absolute Referencing Explained
  • 0806 Formulas Across Worksheets
  • 0807 3D Referencing
  • 0808 Making Use Of Named Cells And Ranges

• 09. Advanced Formatting

  • 0901 Enhancing Worksheets Using Themes
  • 0902 Adding, Editing, And Deleting Comments
  • 0903 Creating Your Own Autofill List
  • 0904 Converting Data To A Table For Formatting

• 10. Security

  • 1001 Activating And Deactivating Worksheet Protection
  • 1002 Protecting Part Of A Worksheet To Aid Data Entry
  • 1003 Password Protecting The Whole Workbook

• 11. Excel 2013 Templates

  • 1101 Using The 2013 Templates
  • 1102 Creating And Using Your Own Template

• 12. Graphics Objects

  • 1201 Obtaining And Inserting Online Images
  • 1202 Using SmartArt Graphics
  • 1203 Inserting Shapes And Screenshots
  • 1204 Formatting Graphical Objects
  • 1205 The Stacking Order
  • 1206 Grouping Multiple Objects Together
  • 1207 Using Graphical Objects And Mathematical Formulas

• 13. Using Charts In Excel

  • 1301 The New Recommended Charts Option
  • 1302 Create A Chart Using The Long Or The Short Method
  • 1303 Formatting A Chart With The 2013 Shortcut Options
  • 1304 Modifying The Chart Type
  • 1305 Formatting Chart Elements
  • 1306 Adding A Trendline
  • 1307 The Pie Chart In Detail
  • 1308 Mini Graphs: Sparklines

• 14. Excel As A Database

  • 1401 Fixing On Screen Rows And Columns
  • 1402 Fixing Print Rows And Columns
  • 1403 Sorting Data In Excel
  • 1404 Filtering Data To Reduce Dataset Size
  • 1405 Removing Duplicate Entries In The Data
  • 1406 Adding Subtotals To A Worksheet Of Data
  • 1407 Using Text To Columns Effectively
  • 1408 Linking To Data On A Webpage

• 15. Advanced Formulas

  • 1501 Using An If Formula
  • 1502 Use Of The If Function To Hide Excel Error Messages
  • 1503 Datedif: A Useful But Hidden Formula
  • 1504 Text Manipulation Using Functions
  • 1505 Use The Text Function To Format Numbers
  • 1506 Date Manipulation Functions
  • 1507 Introducing Sumif, Countif, And Averageif
  • 1508 Use Of Rank To Calculate Placings
  • 1509 Flash Fill: The Magic Touch

• 16. Conditional Formatting

  • 1601 Altering Cell Appearance Based On The Cell Value
  • 1602 Displaying Data Bars, Color Scales, Or Icon Sets
  • 1603 Using Top And Bottom Rules For Formatting
  • 1604 Creating A Formatting Rule From Scratch
  • 1605 Managing The Conditional Formatting Rules

• 17. What's Next

  • 1701 The New Office Apps For Excel 2013
  • 1702 Ready To Go Advanced

In this Microsoft Excel 2013 training course, veteran trainer Guy Vaccaro takes you through the basics of the worlds most popular spreadsheet software. Excel can be a complex and confusing program to use, but Guy breaks it down into bite-sized pieces and teaches it in plain English. No prior experience in Excel or spreadsheets is required to get the most out of this Excel beginners video training.

You will start with the absolute basics, creating and saving a new workbook. Guy proceeds step by step through the process of entering data in cells, doing basic math, formatting your worksheets, setting up pages for printing and applying basic mathematical formulas. Once you are comfortable with the basics, you will move on to more advance formatting with themes, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas, and applying conditional formatting to your worksheet.

By the time you have completed this video training course for Microsoft Excel 2013, you will be comfortable with day to day operations that you would perform in this software program. You will be able to perform calculations, and create professional graphs and charts from your data. Working files are included to allow you to follow along using the same source material that the author uses throughout the lessons in this computer based training video.