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 365 Beginner

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:00:56
  2. Getting Started with Excel
    1. What is Excel?
    2. Opening Excel
    3. Navigating the Excel User Interface
    4. Using the Excel Ribbon 00:06:59
    5. Understanding Excel Worksheet Components 00:06:36
    6. Using the Backstage View
  3. Creating Workbooks and Using Templates
    1. Creating a New Workbook
    2. Saving an Excel Workbook 00:04:42
    3. Using the Accessibility Checker
  4. Entering Data
    1. Navigating a Worksheet by Mouse or Keyboard
    2. Understanding Excel Data Types
    3. Using the Inking Tools 00:05:13
    4. Working with Cell and Range Addressing
    5. Using Various Data Selection Techniques 00:04:41
    6. Working with Common Excel Commands 00:05:43
    7. Using Flash Fill and AutoFill
  5. Excel Formula Basics
    1. What are Formulas and Functions? 00:04:50
    2. Understanding the Components of a Formula
    3. Understanding Calculation Hierarchy and the Order of Operations
    4. Creating Basic Formulas 00:04:58
    5. Working with Basic Functions and AutoSum
    6. Using Cell References 00:04:57
    7. Using the Quick Analysis Tool 00:03:28
  6. Adjusting a Worksheet
    1. Modifying Columns and Rows 00:05:58
    2. Hiding and Unhiding Columns and Rows 00:05:48
  7. Formatting and Aligning Data
    1. Formatting and Aligning Data 00:07:10
    2. Merging Data
    3. Wrapping Text and Adjusting Orientation
    4. Formatting Numbers
    5. Using the Format Painter 00:04:07
    6. Removing Formatting Quickly 00:03:40
  8. Using Cell Styles and Themes
    1. Using Cell Styles
    2. Applying Themes
  9. Inserting Objects and Graphics
    1. Inserting and Formatting Images and Shapes
    2. Inserting and Formatting SmartArt
    3. Working with Icons 00:03:45
    4. Inserting Hyperlinks
    5. Inserting Symbols and Equations
    6. Inserting WordArt and Text Boxes
    7. Inserting 3D Models
    8. Arranging Objects
  10. Proofing a Workbook
    1. Using Find and Replace
    2. Using Go To and Go To Special
    3. Using the Spell Checker
    4. Using the Thesaurus and Translation Features
  11. Printing an Excel File
    1. Printing and Previewing Excel Files 00:05:38
    2. Creating Custom Margins and Scaling
    3. Adding Headers and Footers
    4. Formatting a Page with the Page Layout Tab 00:06:00
    5. Printing Titles and Specific Worksheet Areas 00:02:45
    6. Exporting to PDF and XPS 00:03:44
  12. Managing Worksheets
    1. Renaming and Coloring Worksheet Tabs
    2. Adding, Deleting, and Navigating Worksheets
    3. Hiding and Unhiding Worksheets 00:02:41
  13. Navigating and Viewing Excel Files
    1. Viewing Workbooks 00:03:14
    2. Using Zoom Tools
    3. Configuring Sheet Options 00:04:43
    4. Using the Freeze Panes and Split Commands
    5. Adjusting Worksheet Properties 00:03:31
  14. Conclusion
    1. Course Recap 00:01:39