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 2013

Video Description

This VTC course will give you the knowledge and skills you need to get the most out of Microsoft Excel 2013. You will learn about the Excel interface by working in it. You will create and format worksheets, make calculations, create charts, and use tools to analyze data in meaningful ways. Author Helen Bradley teaches Excel from a business perspective, focusing on tools that maximize productivity and accuracy. She demonstrates how to design worksheets intelligently and then shows you how to check for accuracy to ensure that worksheets return correct results. She also covers automating data entry, testing formulas, and using PivotTables for data analysis. She concludes with a discussion of SkyDrive and the Excel WebApp. To begin learning today, simply click on the movie links.

Table of Contents

  1. Excel Basics
    1. About Excel 00:03:50
    2. Start Screen 00:02:41
    3. Ribbon QAT and Status Bar 00:04:14
    4. Backstage View 00:03:09
    5. Menus / Mini Toolbar / Task Panes 00:03:38
    6. Get Help 00:03:37
  2. Getting Started
    1. Open and Close a Workbook 00:02:54
    2. Move Around in a Workbook 00:03:23
    3. Save a Workbook 00:04:33
    4. Work with Accounts in Excel 00:04:20
    5. Create a New Workbook 00:01:43
    6. Use an Excel Template 00:03:20
  3. Entering Data
    1. Enter Text and Headings 00:04:15
    2. Enter Numbers 00:04:10
    3. Enter Dates 00:03:36
    4. AutoFill Dates 00:03:49
    5. AutoFill Numbers 00:03:32
    6. AutoFill Text 00:03:56
    7. Create an AutoFill Series 00:04:03
    8. Enter Hyperlinks 00:03:57
  4. Rearranging a Worksheet
    1. Size Columns and Rows 00:04:40
    2. Insert & Delete Rows & Columns 00:03:45
    3. Copy or Move Data 00:04:18
    4. Copy or Move a Worksheet 00:03:31
    5. Transpose Data 00:02:24
  5. Basic Formulas & Functions
    1. Using SUM and AutoSum 00:04:25
    2. Doing Simple Math 00:04:24
    3. Order of Operations 00:03:20
    4. Calculating Averages 00:03:54
    5. Quick Analysis - Totals 00:02:26
    6. Adding & Subtracting Dates 00:03:08
    7. Copy Formulas 00:04:20
    8. Absolute & Relative Addressing 00:04:00
    9. Naming Ranges 00:04:14
    10. Calculating Using Names 00:04:11
    11. Understanding Errors 00:04:17
    12. Evaluating a Formula 00:04:13
  6. Formatting a Worksheet
    1. Format Numbers 00:04:48
    2. Format Dates 00:02:25
    3. Format with Color 00:03:15
    4. Use Worksheet Themes 00:03:38
    5. Add Borders 00:04:27
    6. Conditional Formatting pt. 1 00:04:18
    7. Conditional Formatting pt. 2 00:04:23
    8. Borrow Table Formats 00:03:02
    9. Create and Use Styles 00:04:21
    10. Paint and Clear Formats 00:02:23
  7. Creating Charts
    1. Create a Chart 00:04:43
    2. Add Chart Titles and Legends 00:03:21
    3. Format a Chart pt. 1 00:03:38
    4. Format a Chart pt. 2 00:04:19
    5. Create a Pie Chart 00:04:28
    6. Understanding Chart Types 00:03:23
    7. Plot Data on Multiple Axes 00:03:10
    8. Create Sparklines 00:04:05
  8. Adding Art
    1. ClipArt and Photos 00:03:53
    2. Worksheet Backgrounds & Watermarks 00:04:05
    3. SmartArt 00:03:09
    4. Shapes 00:04:16
  9. More Complex Functions
    1. Using IF to Make Calculations 00:04:03
    2. Using SUMIF & COUNTIF 00:04:15
    3. Calculating with SUMPRODUCT 00:02:21
    4. Random Numbers with RANDBETWEEN 00:03:45
    5. Find and Use Functions 00:04:16
    6. Building a Mortgage Calculator 00:04:23
  10. Working with Tables
    1. Create and Format a Table 00:03:37
    2. Create a Chart of Table Data 00:01:58
    3. Calculations in a Table 00:03:26
    4. Use the Subtotal Function 00:03:59
    5. Filter Table Data 00:04:22
    6. Sort Data in a Table 00:03:24
  11. Working with PivotTables
    1. PivotTables Introduction 00:02:50
    2. Create a PivotTable 00:03:03
    3. Query a PivotTable 00:04:05
    4. Use Slicers 00:03:37
    5. Create a PivotChart 00:02:04
  12. Working with Large Worksheets
    1. Freeze Panes 00:03:59
    2. Headers & Footers 00:04:06
    3. Views 00:04:07
    4. Find & Replace 00:04:01
    5. Manipulate Data with Flash Fill 00:03:45
    6. Remove Duplicate Data 00:04:22
  13. Advanced Tools & Techniques
    1. Goal Seek 00:03:38
    2. Create and Use a Watch Window 00:03:00
    3. Create and Save a Template 00:04:00
    4. Calculate Across Multiple Worksheets 00:03:20
    5. Working with Comments 00:03:50
    6. Use a Lookup Table pt. 1 00:04:12
    7. Use a Lookup Table pt. 2 00:04:26
    8. Import Data into Excel 00:04:47
    9. Find Precedents and Dependents 00:02:39
    10. Use Data Validation 00:04:13
    11. Enter Data Using Data Validation 00:03:30
    12. Work with Other Office Programs 00:04:37
  14. Printing a Worksheet
    1. Set Up a Worksheet for Printing 00:03:30
    2. Shrink to Fit 00:04:03
    3. Configure Printing Options 00:04:26
    4. Print a Chart 00:02:35
    5. Print a Selection 00:02:13
    6. Print to PDF 00:03:44
  15. Spreadsheet Design
    1. Design Basics 00:04:15
    2. Create a Data Area 00:01:56
    3. Work with Multi-Sheet Workbooks 00:04:03
    4. Protect a Worksheet 00:03:49
    5. Error Checking and Testing 00:04:24
    6. Spell Check and AutoCorrect 00:03:08
  16. Automating with Macros
    1. Understanding Macros 00:02:24
    2. Record a Macro 00:04:02
    3. Run a Macro 00:02:07
    4. Explore the Visual Basic Editor 00:04:41
  17. Working with Skydrive
    1. SkyDrive Introduction 00:03:22
    2. Save and Open SkyDrive Files 00:04:17
    3. Work in the Excel Web App 00:03:41
    4. How to Use SkyDrive 00:02:03
  18. Conclusion
    1. Course Wrap Up 00:02:51
  19. Credits
    1. About the Author 00:03:00