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

Microsoft Excel 2007: Essentials

Video Description

Learning to use Microsoft Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers. This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time!

Table of Contents

  1. CHAPTER 1: WORKING WITH THE USER INTERFACE
    1. INTRODUCTION 00:01:20
    2. Introducing the Ribbon User Interface 00:07:01
    3. Introducing Workbooks & Worksheets 00:04:41
    4. Introducing the Formula Bar 00:04:03
    5. Saving with Different File Extensions 00:02:19
    6. Customizing the User Interface 00:05:16
  2. CHAPTER 2: ENTERING & MANAGING DATA
    1. INTRODUCTION 00:00:31
    2. Getting Data into Excel 00:09:34
    3. Importing Text Files 00:04:29
    4. Using the Freeze Panes Functionality 00:03:49
    5. Using the Zoom Functionality 00:02:49
    6. Using Hot Keys 00:01:13
    7. Managing Rows & Columns 00:03:34
    8. Finding Data 00:07:12
    9. Matching Case & Entire Cell Contents 00:02:51
    10. Replacing Data 00:02:54
    11. Finding & Replacing Empty Values 00:01:39
    12. Sorting Data 00:01:34
    13. Sorting Multiple Columns 00:01:54
    14. Filtering Data 00:03:06
  3. CHAPTER 3: USING FORMATTING TECHNIQUES
    1. INTRODUCTION 00:00:23
    2. Formatting Numbers & Dates 00:06:19
    3. Formatting Cells 00:05:22
    4. Setting the Font Type, Color & Size 00:01:21
    5. Using Borders & Cell Styles 00:03:36
    6. Adding Shapes & Pictures 00:03:55
    7. Creating WordArt 00:01:50
  4. CHAPTER 4: FORMULA BASICS
    1. INTRODUCTION 00:00:25
    2. Constants, Formulas & Cell References 00:03:13
    3. Understanding the Order of Operations 00:06:34
    4. Using Formulas with Dates & Text 00:04:10
    5. Linking Cells & Using Comparison Operators 00:03:08
    6. Creating an Absolute Reference 00:04:31
    7. Defining Named Ranges 00:03:40
    8. Exploring the Function Library 00:04:46
    9. Using the AutoSum Function 00:03:26
  5. CHAPTER 5: USEFUL FUNCTIONS
    1. INTRODUCTION 00:00:33
    2. Using the INT Function 00:04:52
    3. Using the Rounding Function 00:02:24
    4. Using the ABS Function 00:02:19
    5. Using the SUBTotal Function 00:02:58
    6. Using Logical Functions 00:06:56
    7. Using the AND & the OR Function 00:03:24
    8. Using LEFT, RIGHT, and MID Functions 00:02:07
    9. Using the UPPER, LOWER, PROPER and TRIM Functions 00:01:33
    10. Using COUNT Functions 00:04:34
    11. Using the VLOOKUP Function 00:06:29
  6. CHAPTER 6: CREATING REPORTS
    1. INTRODUCTION 00:00:30
    2. Creating a Subtotal Report 00:05:03
    3. Using Conditional Formatting 00:07:24
    4. Creating & Managing Conditions 00:03:27
    5. Creating a Chart 00:03:08
    6. Refining Charts 00:06:27
    7. Using Basic Chart Types 00:07:02
  7. CHAPTER 7: SHARING & DISTRIBUTING YOUR WORK
    1. INTRODUCTION 00:00:29
    2. Inserting Headers & Footers 00:03:41
    3. Adding Comments 00:02:30
    4. Adjusting Page Layout 00:03:07
    5. Distributing Your Worksheets 00:04:03
    6. Protecting Your Worksheets 00:06:59
    7. Understanding Compatibility 00:04:35
  8. CHAPTER 8: TIPS & TRICKS
    1. INTRODUCTION 00:00:34
    2. Using the Fill Handle 00:02:25
    3. Filling in a Series of Numbers 00:01:56
    4. Typing in Multiple Cells at Once 00:01:33
    5. Leveraging a Custom List & Transposing a Range 00:03:49
    6. Deleting & Inserting Blank Cells 00:03:31
    7. Filling Holes in Your Data 00:02:07
    8. Getting a List of Unique Records & Parsing Text 00:02:56
    9. Rearranging Columns & Linking to Multiple Cells 00:02:57
    10. Using Right Mouse Button Drag Options 00:01:11
    11. Make Format Painter Persist & Paste Special Formats 00:02:58
    12. Formatting Portions of Text & Multiple Sheets 00:02:47
    13. Creating Cell Border Effects & Sorting on Color 00:03:51
    14. Turning Formulas into Hard Data 00:01:42
    15. Copy Formula References & Highlight Formulas 00:03:22
    16. Creating Dynamic Charts & Combination Charts 00:04:58
    17. Add a Secondary Axis, Average Line & Smooth Line 00:05:26
    18. Comparing Data Dynamically with Charts 00:02:43
    19. Final Comments & Credits 00:02:12