Microsoft Excel 2010

Table of contents

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