O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Excel 2010 Essentials

Video Description

This series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you've used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may be!

Table of Contents

  1. GETTING COMFORTABLE WITH EXCEL
    1. Introduction 00:00:06
    2. Introducing Excel 00:12:27
    3. Recognizing Interface Features Unique to Excel 00:05:18
    4. Understanding Workbook Structure 00:10:29
    5. Navigating through Workbooks 00:10:22
    6. Making Workbook Selections 00:12:19
  2. THE BASICS OF DATA
    1. Introduction 00:00:06
    2. Entering Text 00:09:47
    3. Entering Dates & Numbers 00:08:12
    4. Editing Cell Entries 00:07:01
    5. Copying & Moving Data 00:07:29
    6. Filling a Series 00:08:52
  3. MANAGING WORKBOOK STRUCTURE
    1. Introduction 00:00:06
    2. Modifying Workbook & Worksheet Structure 00:14:11
    3. Resizing Worksheet Elements 00:05:58
    4. Hiding Workbook Components 00:07:26
  4. CREATING FORMULAS
    1. Introduction 00:00:06
    2. Excel Calculations 101 00:07:27
    3. Entering Formulas 00:07:25
    4. Enforcing Absolute Referencing 00:11:33
    5. Controlling Calculation Options 00:07:02
  5. THE BASICS OF FUNCTIONS
    1. Introduction 00:00:06
    2. The Foundation of Functions 00:06:10
    3. Using AutoSum & the Formulas Tab 00:09:32
    4. Using Function AutoComplete 00:10:02
  6. WHAT'S IN A NAME?
    1. Introduction 00:00:06
    2. Creating Named Cells 00:07:47
    3. Defining Names 00:05:56
    4. Creating Names from Selections 00:05:06
    5. Creating Named Formulas 00:05:21
    6. Using Names as References 00:08:38
    7. Managing & Displaying Names 00:10:07
  7. MAKING DATA LOOK GOOD
    1. Introduction 00:00:06
    2. Applying Basic Formatting 00:14:21
    3. Formatting Numbers 00:08:40
    4. Exploring the Format Cells Dialog Box 00:13:44
    5. Defining Custom Formats 00:12:23
    6. Creating & Applying Cell Styles 00:07:16
    7. Conditional Formatting 00:06:40
    8. Applying & Editing Conditional Formatting Rules 00:10:55
  8. A PICTURE IS WORTH A THOUSAND WORDS
    1. Introduction 00:00:06
    2. Getting In-Cell Summaries with Sparklines 00:11:04
    3. Creating Charts 00:03:06
    4. Modifying Chart Design 00:10:46
    5. Working with Chart Layout & Format 00:07:57
    6. Saving & Using a Chart Template 00:05:27
  9. THE SIMPLICITY OF TABLES
    1. Introduction 00:00:06
    2. Converting Data Ranges to Tables 00:06:16
    3. Modifying Table Formatting 00:05:30
    4. Working with Table Records 00:06:06
    5. Using Table Calculations 00:06:39
    6. Sorting Data 00:11:44
    7. Creating Custom Lists 00:07:12
    8. Filtering Data 00:10:10
  10. MANAGING THE EXCEL ENVIRONMENT
    1. Introduction 00:00:06
    2. Configuring Excel Options 00:04:49
    3. Adjusting the View 00:07:18
    4. Controlling Excel Windows 00:07:48
  11. PREPARING FILES FOR DISTRIBUTION
    1. Introduction 00:00:06
    2. Print Area, Print Titles & Sheet Options 00:08:04
    3. Renaming Sheets & Adding Headers/Footers 00:08:29
    4. Printing Worksheets 00:05:53
    5. Credits 00:00:12