by Guy Vaccaro | Released June 2010 | ISBN: 9781926873077

In this Microsoft Excel 2010 tutorial video, veteran Infinite Skills trainer Guy Vaccaro introduces you to the latest version of Microsoft's standard spreadsheet application. In this Excel Training Video, you will learn by watching the author actually perform the operations he is instructing on, as he explains step by step to how to perform these functions. Guy explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and even covers topics such as basic to advanced formula and functions. He has even included a chapter on connecting to the new Microsoft Web Apps, and how to use your own SkyDrive to store and share your Microsoft Excel projects. Included with this training video are full practical working files, to allow you to work along side of Guy as he teaches you how to use Microsoft Excel 2010. By the completion of this computer based training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial environment. Show and hide more

1. Getting Started
   • Overview Of Excel 2010 00:06:16
   • The New File Menu In Excel 2010 00:05:10
   • Exploring The Excel Workbook 00:02:26
   • What Will I Be Able To Do At The End Of This Course 00:03:54
   • Customizing The Quick Access Toolbar 00:02:53
   • Working With The Ribbons 00:03:46
   • Using The Files Included With This Course 00:00:33
2. Working With An Excel Worksheet
   • Creating A New Workbook 00:01:36
   • Saving A Workbook 00:02:25
   • Saving In Other Formats 00:03:05
   • Open A Existing Workbook 00:01:46
   • Navigating An Excel Workbook 00:05:17
3. Selecting And Entering Data
   • Entering Text And Numbers 00:03:00
   • Entering Numbers As Text 00:03:47
   • Inputting Dates And Times 00:04:03
   • Editing The Contents Of A Cell 00:02:08
   • Using Copy And Paste 00:06:48
   • The FILL Handle 00:07:06
   • Using Undo And Redo 00:03:03
   • Shortcuts For Selecting Cells 00:05:12
   • Inserting Cells, Columns And Rows 00:05:18
   • Deleting Cells, Columns And Rows 00:03:21
   • Changing Column Widths And Row Heights 00:04:06
   • Hiding And Unhiding A Column Or Row 00:05:10
   • Searching For Values In A Worksheet 00:05:35
4. Developing A Workbook
   • Formatting And Naming Of Worksheet Tabs 00:03:42
   • Moving Worksheets Within And Between Workbooks 00:04:49
   • Copying Worksheets Within Workbooks 00:03:17
   • Inserting And Deleting Worksheets 00:03:34
   • Viewing More Than One Workbook 00:04:35
   • Hiding And Unhiding Worksheets 00:02:02
5. Printing And Page Setup
   • Using The Print Area Command To Control What Excel Prints 00:04:03
   • Setting Page Margins And Page Orientation 00:03:30
   • Creating A Header And Footer 00:04:48
   • Using Page Break View 00:02:56
   • Setting Print Titles For Large Worksheets 00:03:01
   • Printing Gridlines Column Row Headings And Other Related Options 00:02:49
   • Enabling The New Page Layout View 00:03:31
   • Running The Spell Checker 00:03:23
   • Print Preview And Printing The Whole Or Part Of The Worksheet 00:04:03
6. Workbook Formatting
   • Modifying Typeface, Font Size And Colors 00:06:12
   • Merging Cells 00:02:45
   • Applying Number Formats 00:04:04
   • Aligning Cell Contents 00:02:02
   • Changing The Text Direction In A Cell 00:03:39
   • Adding Borders To Cells And Ranges 00:04:43
   • Applying A Date Format To A Cell Or Range 00:05:16
   • Use Of The Format Painter 00:04:30
   • Clearing Cell Contents And/Or Formatting 00:02:50
7. Carrying Out Calculations
   • Getting Started With Basic Math Formula Addition 00:05:23
   • Getting Started With Basic Math Formula Subtraction 00:03:20
   • Getting Started With Basic Math Formula Multiplication 00:02:45
   • Getting Started With Basic Math Formula Division 00:04:23
   • Getting Started With Basic Math Formula Operand 00:02:37
   • Order Of Operations with BODMAS 00:03:14
   • Introduction To Excel Formulas: SUM 00:07:47
   • Copying Formulas And Functions 00:06:55
   • Displaying Formulae On A Worksheet 00:03:00
   • Some Useful Functions For Counting 00:04:06
   • Some Useful Functions For Averages 00:04:02
   • Some Useful Functions For Highest And Lowest 00:03:16
   • Absolute Referencing Requirements 00:05:37
   • Formulas Across Worksheets 00:07:46
   • Functions Across Worksheets 00:04:44
   • 3D Referencing 00:06:58
   • Making Use Of Named Cells And Ranges 00:09:24
8. Advanced Formatting
   • Enhancing Worksheets Using Themes 00:02:41
   • Working With Comments 00:04:45
   • Creating Your Own AutoFill List 00:05:45
   • Turning Your Data Into A Table For Formatting 00:05:33
9. Security
   • Using Protection On A Worksheet 00:03:35
   • Protecting Part Of A Worksheet To Facilitate Data Entry 00:03:59
   • Controlling Access To Cell Ranges By Password And Or User Accounts 00:05:17
   • Saving A Workbook With Password Protection 00:03:47
10. Using Templates
    • Creating A Workbook From A Template 00:03:36
    • Creating Your Own Custom Template 00:06:17
11. Graphics Objects
    • Inserting And Modifying Clipart 00:07:38
    • Using SmartArt Graphics 00:08:11
    • Adding Drawn Shapes To A Worksheet 00:04:48
    • Inserting An External Picture 00:03:01
    • Adding A Background Image To A Worksheet 00:02:58
    • Formatting Graphic Objects 00:05:03
    • Controlling Stacking Order And Alignment Of Multiple Graphics Objects 00:06:15
    • Grouping Graphic Objects 00:03:29
    • Accessing Formula Results In A Callout Bubble 00:05:11
12. Using Excel As A Database
    • Fixing Rows And Columns On Screen 00:02:52
    • Fixing Rows And Columns For Print 00:01:58
    • Sorting Data In A Worksheet 00:06:09
    • Filtering Data In A Worksheet 00:07:29
    • Removing Duplicates In An Excel Database 00:02:36
    • Adding And Using Subtotals In An Excel Database 00:07:59
    • Splitting One Column Of Data Into More Columns 00:06:38
    • Splitting The Screen To View Different Parts Of The Same Worksheet 00:04:29
    • Linking To Data On A Webpage 00:08:24
13. Using Charts In Excel
    • Creating A Chart The Long Way 00:05:01
    • Creating A Chart The Quick Way 00:02:28
    • Changing A Chart From A Sheet Object To A Sheet 00:02:58
    • Modifying Your Chart Type 00:06:31
    • Controlling Chart Style And Layout 00:08:26
    • Adding A Trend line To A Chart 00:05:45
    • Pie Charts In More Detail 00:05:24
14. More Advanced Formula
    • Adding An IF Function For Cell Comparisons 00:06:29
    • Using the IF Function To Suppress Excel Error Messages 00:07:37
    • Text Manipulation With Formulae - Part 1 00:08:17
    • Text Manipulation With Formulae - Part 2 00:03:47
    • Date Formula In Excel 00:06:38
    • DATEDIF - A Hidden But Useful Formula 00:04:28
    • SUMIF COUNTIF And AVERAGEIF 00:12:35
    • Use Of A Formula To Rank Scores 00:03:25
15. Conditional Formatting
    • Changing Cell Appearance Based On Its Value 00:05:35
    • Editing Conditional Formatting Rules On A Worksheet 00:04:51
    • Removing Conditional Formatting Rules 00:01:48
    • Highlighting Duplicate Values Using Conditional Formatting 00:03:35
    • Identifying The Top Or Bottom Percentage Of A Range 00:04:01
    • Use Of Data Bars Within Conditional Formatting 00:04:32
    • Use Of Colour Scales Within Conditional Formatting 00:04:04
    • Applying An Icon Set To Conditional Formatting Rules 00:04:25
16. Office Web Apps And Excel
    • What Is Office Web Apps? 00:02:47
    • Sign In To Or Sign Up For Your Own SkyDrive 00:03:18
    • Saving An Excel Workbook Into SkyDrive 00:03:26
    • Accessing And Editing An Excel Workbook Through SkyDrive 00:03:46
    • Telling Others Where Your Public Documents Are 00:02:09
    • Direct Linking Or Embedding Of SkyDrive Documents 00:02:00
    • Creating A Folder Structure Within SkyDrive 00:02:32
    • Deleting Files From SkyDrive 00:01:14
17. Credits And Beyond
    • About The Author 00:01:17
Show and hide more