Excel 2013 - Beginner

Duration
4 Hours, 38 Minutes

 

Delivery Method
Self-Paced

Educate 360 Pro from New Horizons

This class is part of a 12‑month Educate 360 Pro Subscription

Course Overview

Microsoft Excel is one of the major workhorses in the Microsoft 365 suite of applications and arguably the most widely-used 365 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.

Course Objectives

Getting Started, Basic Worksheet Skills, Editing a Workbook, Formatting the Worksheet, Collaborating, Printing and Page Setup, Creating Formulas, Working with Large Worksheets or Multiple Workbooks

Course Prerequisites

The recommended pre-requisite for this course is basic computer skills and familiarity with the Windows operating environment.

Agenda

1 - Introduction

  • Introduction

2 - Getting Started

  • What is Excel?
  • Launching Excel and Opening a File
  • The Application Window
  • Cell Addressing and Navigating a Worksheet

3 - Basic Worksheet Skills

  • Creating a New Workbook
  • Entering Data and Selecting
  • Using AutoFill
  • Using Clear
  • Using Worksheets
  • Flash Fill
  • Saving a Workbook

4 - Creating Formulas

  • Simple Formulas and Functions
  • Using AutoSum
  • Date Arithmetic
  • AutoCalculate
  • Relative v. Absolute Cell Addressing

5 - Editing a Workbook

  • Editing and Deleting
  • Using Undo and Redo
  • Using Cut, Copy, Paste, and Paste Special
  • Using Find and Replace

6 - Formatting the Worksheet

  • Inserting and Deleting Columns and Rows
  • Adjusting and Hiding Columns and Rows
  • Changing Number Formats
  • Formatting Text
  • Merging and Aligning Cells
  • Formatting Borders and Shading
  • Using, Modifying, and Creating Cell Styles
  • Using Themes

7 - Working with Large Worksheets or Multiple Workbooks

  • Using the Zoom Feature
  • Freezing Panes and Splitting the Window
  • Tiling Windows
  • Viewing Multiple Worksheets

8 - Collaborating

  • Protecting Cells
  • Using Comments
  • Working with Track Changes

9 - Printing and Page Setup

  • Page Break and Print Preview
  • Changing Page Setup
  • Adding Headers and Footers
  • Print Titles and Print Areas

10 - Conclusion

  • Conclusion

What is Educate 360 Pro?

Educate 360 Pro is a 12-month subscription that provides unlimited access to full-day or short-duration live classes, on-demand video courses, class recordings, and quick reference cards. New Horizons offers more learning solutions for Microsoft Office than any other training provider and they are all included in your Educate 360 Pro subscription.

  • Unlimited enrollments into over 90 full-day and short-duration live training classes
  • Over 750 hours of on-demand video based content
  • A full library of digital quick reference cards for your favorite Office applications
  • Access to class recordings so you never have to worry about missing a scheduled class

Benefits of an Educate 360 Pro Subscription

Our Educate 360 Pro subscription is built to fit in and around your schedule. It will change the way you think about training.

  • Ask questions and get immediate answers during our full-day and short-duration live classes
  • Learn how to perform specific tasks instead of wasting time learning things you already know
  • Collaborate with fellow students and gain insight into new ways to solve problems
  • View on-demand courses with instructors that never leave your screen
  • Utilize course assessments to validate new skills
  • Take full day training classes on your schedule by accessing our class recordings
  • Revisit a prior class to further enhance your skills

Need more information? Click here to learn more about Educate 360 Pro.