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 2013 Introduction

Video Description

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks and use collaboration tools to work in conjunction with other users.

Table of Contents

  1. Introduction
    1. Introduction 00:03:15
  2. Getting Started
    1. What is Excel? 00:02:48
    2. Launching Excel and Opening a File 00:13:17
    3. The Application Window 00:10:07
    4. Cell Addressing and Navigating a Worksheet 00:08:27
  3. Basic Worksheet Skills
    1. Creating a New Workbook 00:02:57
    2. Entering Data and Selecting 00:07:47
    3. Using AutoFill 00:06:28
    4. Using Clear 00:05:06
    5. Using Worksheets 00:06:16
    6. Flash Fill 00:09:21
    7. Saving a Workbook 00:05:25
  4. Creating Formulas
    1. Simple Formulas and Functions 00:18:28
    2. Using AutoSum 00:05:14
    3. Date Arithmetic 00:02:25
    4. AutoCalculate 00:03:52
    5. Relative v. Absolute Cell Addressing 00:07:31
  5. Editing a Workbook
    1. Editing and Deleting 00:05:41
    2. Using Undo and Redo 00:03:06
    3. Using Cut, Copy, Paste, and Paste Special 00:09:38
    4. Using Find and Replace 00:08:02
  6. Formatting the Worksheet
    1. Inserting and Deleting Columns and Rows 00:07:25
    2. Adjusting and Hiding Columns and Rows 00:09:41
    3. Changing Number Formats 00:09:05
    4. Formatting Text 00:05:20
    5. Merging and Aligning Cells 00:10:35
    6. Formatting Borders and Shading 00:08:03
    7. Using, Modifying, and Creating Cell Styles 00:06:54
    8. Using Themes 00:04:15
  7. Working with Large Worksheets or Multiple Workbooks
    1. Using the Zoom Feature 00:03:12
    2. Freezing Panes and Splitting the Window 00:05:57
    3. Tiling Windows 00:05:53
    4. Viewing Multiple Worksheets 00:03:54
  8. Collaborating
    1. Protecting Cells 00:06:55
    2. Using Comments 00:05:36
    3. Working with Track Changes 00:08:51
  9. Printing and Page Setup
    1. Page Break and Print Preview 00:06:19
    2. Changing Page Setup 00:06:57
    3. Adding Headers and Footers 00:08:41
    4. Print Titles and Print Areas 00:07:59
  10. Conclusion
    1. Course Recap 00:01:56