by Guy Vaccaro | Released December 2012 | ISBN: 9781771370530

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. Show and hide more

1. Start Here
   • Getting Started With Excel 2013 00:02:21
   • The Excel Workbook Explained 00:02:24
   • Signing Up For Your Own Free SkyDrive 00:02:21
   • Customize The Quick Access Toolbar 00:02:40
   • Using The Included Working Files 00:01:35
   • About The Author 00:01:14
2. Managing Excel Workbooks And Worksheets
   • Creating And Saving A New Workbook 00:03:19
   • Opening Workbooks And Save As Options 00:03:21
   • Saving And Opening SkyDrive Files 00:02:22
   • Navigating An Excel Workbook 00:04:25
   • Adding And Removing Worksheets 00:03:02
   • Renaming Copying And Moving Worksheets 00:04:21
3. Entering And Editing Data In Cells
   • Entering Text, Numbers, And Dates 00:03:29
   • Entering Numbers As Text 00:03:30
   • Editing The Contents Of A Cell 00:02:41
   • Undo And Redo Actions 00:02:50
   • Cut, Copy, And Paste 00:04:41
   • Dragging And Dropping Cells 00:02:49
   • The Fill Handle 00:06:46
   • Inserting And Deleting Cells Columns And Rows 00:04:09
   • Changing Column Widths And Row Heights 00:04:20
   • Hiding And Un-Hiding Columns And Rows 00:03:23
   • Searching For Values In A Workbook 00:03:01
4. Math Basics
   • Getting Started With Basic Math Formulas 00:05:15
   • Order Of Operation With BODMAS 00:03:53
   • Introduction To Basic Formulas 00:05:41
   • Copying Formulas And Functions - Chapter 4 00:04:39
   • Displaying Formulas On A Worksheet 00:04:12
5. Formatting Worksheets
   • Selecting Cells For Formatting 00:02:53
   • Modifying Typeface Font, Size, And Colour 00:05:37
   • Merging And Wrapping Cell Contents 00:06:02
   • Using Number Formats 00:05:56
   • Cell Content Alignment And Orientation 00:03:43
   • Adding And Removing Borders From A Selection 00:04:34
   • Applying A Date Format To A Cell Or Range 00:03:42
   • The Format Painter 00:03:49
   • Finding And Replacing Formats 00:06:14
   • Clearing Cell Contents Vs. Clearing Cell Formatting 00:05:12
6. Workbook And Worksheet Management
   • Worksheet Navigation And Coloured Worksheet Tabs 00:04:25
   • Moving Or Copying Worksheets Within And Between Workbooks 00:03:39
   • Viewing And Scrolling Multiple Workbooks At The Same Time 00:03:47
   • Hiding And Un-Hiding Sheets 00:02:28
   • Modifying More Than One Worksheet At A Time 00:04:45
7. Page Setup And Printing
   • Using Print Titles And Print Areas 00:05:37
   • Paper Size, Orientation, Margins, And Scaling Options 00:06:25
   • Creating Headers and Footers 00:06:03
   • Using The Page Break And The Page Layout Views 00:04:51
   • Printing A Range Of Cells 00:02:16
   • Running The Spell Checker 00:04:27
   • Controlling Most Print Settings In One Place 00:05:34
8. Mathematical Formulas
   • The Sum Function 00:06:51
   • Copying Formulas And Functions - Chapter 8 00:06:45
   • Other Mathematical Functions: Average, Min, And Max 00:05:53
   • Useful Count Functions 00:03:26
   • Absolute Referencing Explained 00:07:08
   • Formulas Across Worksheets 00:07:07
   • 3D Referencing 00:07:25
   • Making Use Of Named Cells And Ranges 00:08:15
9. Advanced Formatting
   • Enhancing Worksheets Using Themes 00:04:34
   • Adding, Editing, And Deleting Comments 00:03:34
   • Creating Your Own Autofill List 00:04:24
   • Converting Data To A Table For Formatting 00:05:24
10. Security
    • Activating And Deactivating Worksheet Protection 00:03:52
    • Protecting Part Of A Worksheet To Aid Data Entry 00:03:07
    • Password Protecting The Whole Workbook 00:04:51
11. Excel 2013 Templates
    • Using The 2013 Templates 00:04:13
    • Creating And Using Your Own Template 00:04:39
12. Graphics Objects
    • Obtaining And Inserting Online Images 00:04:02
    • Using SmartArt Graphics 00:05:46
    • Inserting Shapes And Screenshots 00:05:26
    • Formatting Graphical Objects 00:05:38
    • The Stacking Order 00:04:51
    • Grouping Multiple Objects Together 00:05:06
    • Using Graphical Objects And Mathematical Formulas 00:03:40
13. Using Charts In Excel
    • The New Recommended Charts Option 00:04:17
    • Create A Chart Using The Long Or The Short Method 00:03:34
    • Formatting A Chart With The 2013 Shortcut Options 00:03:22
    • Modifying The Chart Type 00:03:52
    • Formatting Chart Elements 00:04:45
    • Adding A Trendline 00:03:12
    • The Pie Chart In Detail 00:08:01
    • Mini Graphs: Sparklines 00:05:51
14. Excel As A Database
    • Fixing On Screen Rows And Columns 00:05:42
    • Fixing Print Rows And Columns 00:03:02
    • Sorting Data In Excel 00:05:59
    • Filtering Data To Reduce Dataset Size 00:06:03
    • Removing Duplicate Entries In The Data 00:02:21
    • Adding Subtotals To A Worksheet Of Data 00:04:50
    • Using Text To Columns Effectively 00:05:09
    • Linking To Data On A Webpage 00:04:14
15. Advanced Formulas
    • Using An If Formula 00:05:02
    • Use Of The If Function To Hide Excel Error Messages 00:04:51
    • Datedif: A Useful But Hidden Formula 00:04:38
    • Text Manipulation Using Functions 00:05:40
    • Use The Text Function To Format Numbers 00:03:57
    • Date Manipulation Functions 00:03:40
    • Introducing Sumif, Countif, And Averageif 00:06:38
    • Use Of Rank To Calculate Placings 00:04:34
    • Flash Fill: The Magic Touch 00:03:40
16. Conditional Formatting
    • Altering Cell Appearance Based On The Cell Value 00:04:02
    • Displaying Data Bars, Color Scales, Or Icon Sets 00:03:34
    • Using Top And Bottom Rules For Formatting 00:03:33
    • Creating A Formatting Rule From Scratch 00:03:37
    • Managing The Conditional Formatting Rules 00:04:09
17. What's Next
    • The New Office Apps For Excel 2013 00:03:42
    • Ready To Go Advanced 00:02:01
Show and hide more