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 2016 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 enter data, 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, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

Table of Contents

  1. Introduction
    1. Introduction 00:01:04
  2. Getting Started with Excel
    1. What is Excel? 00:02:01
    2. Opening Excel 00:04:25
    3. Navigating the Excel User Interface 00:07:48
    4. Using the Excel Ribbon 00:02:55
    5. Understanding Excel Worksheet Components 00:03:55
    6. Using the Backstage View 00:02:32
  3. Creating Workbooks and Using Templates
    1. Creating a New Workbook 00:03:01
    2. Creating Workbooks Using Templates 00:03:24
    3. Saving an Excel Workbook 00:05:21
    4. Using Convert and Checking Compatibility 00:02:19
  4. Entering Data
    1. Navigating a Worksheet by Mouse or Keyboard 00:04:52
    2. Understanding Excel Data Types 00:02:50
    3. Working with Cell and Range Addressing 00:02:20
    4. Using Various Data Selection Techniques 00:05:14
    5. Working with Common Excel Commands 00:07:26
    6. Using the Autofill Handle 00:02:37
  5. Excel Formula Basics
    1. What are Formulas and Functions? 00:02:03
    2. Understanding the Components of a Formula 00:05:39
    3. Understanding Calculation Hierarchy and the Order of Operations 00:02:26
    4. Creating Basic Formulas 00:08:09
    5. Working with Basic Functions and AutoSum 00:03:59
    6. Using Cell References 00:03:37
    7. Using the Quick Analysis Tool 00:01:16
  6. Adjusting a Worksheet
    1. Modifying Columns and Rows 00:06:09
    2. Hiding and Unhiding Columns and Rows 00:03:06
  7. Formatting and Aligning Worksheet Data
    1. Formatting and Aligning Data 00:05:48
    2. Merging Data 00:03:52
    3. Wrapping Text and Adjusting Orientation 00:01:46
    4. Formatting Numbers 00:03:11
    5. Using Borders and Shading 00:02:38
    6. Using the Format Painter 00:01:21
    7. Removing Formatting Quickly 00:01:25
  8. Using Cell Styles and Themes
    1. Understanding Cell Styles 00:01:39
    2. Applying Cell Styles 00:04:23
    3. Applying Themes 00:03:13
  9. Inserting Objects and Graphics
    1. Inserting and Formatting Images 00:02:46
    2. Inserting and Formatting Shapes 00:04:27
    3. Inserting and Formatting SmartArt 00:03:48
    4. Inserting Screenshots 00:02:17
    5. Inserting Hyperlinks 00:02:38
    6. Inserting Symbols and Equations 00:03:13
    7. Inserting WordArt and Text Boxes 00:03:51
    8. Inserting Other Excel Objects 00:03:54
    9. Arranging Objects 00:03:48
  10. Proofing a Workbook
    1. Using Find and Replace 00:03:43
    2. Finding and Replacing Formatting 00:01:20
    3. Using Go To and Go To Special 00:02:24
    4. Using the Spell Checker 00:02:35
    5. Using the Thesaurus and Translation Features 00:03:05
  11. Printing an Excel File
    1. Printing and Previewing Excel Files 00:02:58
    2. Creating Custom Margins and Scaling 00:04:54
    3. Adding Headers and Footers 00:03:41
    4. Formatting a Page with the Page Layout Tab 00:02:35
    5. Printing Titles and Specific Worksheet Areas 00:04:31
    6. Exporting to PDF and XPS 00:01:37
  12. Managing Worksheets
    1. Renaming and Coloring Worksheet Tabs 00:02:35
    2. Adding, Deleting, and Navigating Worksheets 00:03:29
    3. Moving and Copying Worksheets 00:03:45
    4. Hiding and Unhiding Worksheets 00:02:11
  13. Navigating and Viewing Excel Files
    1. Viewing Workbooks 00:02:45
    2. Using Zoom Tools 00:02:13
    3. Configuring Sheet Options 00:02:17
    4. Using the Freeze Panes and Split Commands 00:04:50
    5. Working with Window Commands 00:03:41
  14. Adjusting Workbook Properties 00:02:43
  15. Conclusion
    1. Course Recap 00:01:43