Microsoft Excel 2010 Tutorial

| Created on February 7, 2020 | 44 views
Tags
Excel
Specializations
Business
Fields
Finance
Microsoft Excel 2010 Tutorial Click to Preview Course
About Reviews
Course Description

In this Microsoft Excel 2010 video course, Guy Vaccaro introduces you to the 2010 version of Microsoft's Excel.

In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training 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 covers topics such basic to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to share your Microsoft Excel Projects.

As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel 2010.

By the completion of this online training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial Environment.

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

Nil

Audience

Nil

About Instructor
Peter Oni

Labyet Polaris NigLTD is an E-learning company that deals with deploying high quality course from Nigeria and across to government bodies and private organizations.

Microsoft Excel 2010 Tutorial
Share with your friends