Take this
course

Office Productivity / Microsoft

Excel 2013 Introduction

A introduction to Excel 2016. Get started creating spreadsheets, formulas, and more.

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.


Instructor: Pamela Conway

Full details

Curriculum

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

Skills

  • Microsoft Excel

Similar Courses

More Courses by this Instructor