$29.99
Certification

Industry recognized certification enables you to add this credential to your resume upon completion of all courses

Need Custom Training for Your Team?
Get Quote
Call Us

Toll Free (844) 397-3739

Inquire About This Course
Instructor
Intellezy Trainers, Instructor - Excel 2016 Introduction

Intellezy Trainers

Improving individual or company performance begins with the right training resources. Keep your team’s Microsoft and Adobe skills fresh with our engaging, short-segment videos. Intellezy’s training is delivered by certified instructors and industry experts. Their friendly, engaging style breaks down complex ideas into bite-sized learning nuggets. And, because they never leave the screen, the learner’s attention is held longer. Start watching and find out how valuable 3 minutes can be.

Instructor: Intellezy Trainers

Learn the Essentials of Working with Microsoft Excel Worksheets

  • Learn to create simple worksheets.
  • Understand calculation hierarchy and the order of operations.
  • 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.

Duration: 3h 45m

Course 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. Instructor: Ed McCrae Student data files are available under Downloads in the course dashboard.

What am I going to get from this course?

  • Learn to create simple worksheets
  • Understand calculation hierarchy and the Order of Operations
  • Add columns and rows
  • Format and align worksheet data
  • Use cell styles and themes
  • Proof and print a workbook
  • Manage Worksheets

Prerequisites and Target Audience

What will students need to know or do before starting this course?

Basic Windows skills

Who should take this course? Who should not?

Anyone who needs to create or maintain worksheets

Curriculum

Module 1: Introduction

01:03
Lecture 1 Introduction
01:03
Resource 1 Student Data Files

Module 2: Getting Started with Excel

23:36
Lecture 2 What is Excel?
02:01
Lecture 3 Opening Excel
04:25
Lecture 4 Navigating the Excel User Interface
07:48
Lecture 5 Using the Excel Ribbon
02:55
Lecture 6 Understanding Excel Worksheet Components
03:55
Lecture 7 Using the Backstage View
02:32

Module 3: Creating Workbooks and Using Templates

14:04
Lecture 8 Creating a New Workbook
03:01
Lecture 9 Creating Workbooks Using Templates
03:24
Lecture 10 Saving an Excel Workbook
05:20
Lecture 11 Using Convert and Checking Compatibility
02:19

Module 4: Entering Data

25:18
Lecture 12 Navigating a Worksheet by Mouse or Keyboard
04:52
Lecture 13 Understanding Excel Data Types
02:50
Lecture 14 Working with Cell and Range Addressing
02:20
Lecture 15 Using Various Data Selection Techniques
05:14
Lecture 16 Working with Common Excel Commands
07:25
Lecture 17 Using the Autofill Handle
02:37

Module 5: Excel Formula Basics

27:07
Lecture 18 What are Formulas and Functions?
02:02
Lecture 19 Understanding the Components of a Formula
05:39
Lecture 20 Understanding Calculation Hierarchy and the Order of Operations
02:26
Lecture 21 Creating Basic Formulas
08:09
Lecture 22 Working with Basic Functions and AutoSum
03:59
Lecture 23 Using Cell References
03:37
Lecture 24 Using the Quick Analysis Tool
01:15

Module 6: Adjusting a Worksheet

09:14
Lecture 25 Modifying Columns and Rows
06:08
Lecture 26 Hiding and Unhiding Columns and Rows
03:06

Module 7: Formatting and Aligning Worksheet Data

19:56
Lecture 27 Formatting and Aligning Data
05:47
Lecture 28 Merging Data
03:52
Lecture 29 Wrapping Text and Adjusting Orientation
01:45
Lecture 30 Formatting Numbers
03:10
Lecture 31 Using Borders and Shading
02:37
Lecture 32 Using the Format Painter
01:21
Lecture 33 Removing Formatting Quickly
01:24

Module 8: Using Cell Styles and Themes

09:14
Lecture 34 Understanding Cell Styles
01:38
Lecture 35 Applying Cell Styles
04:23
Lecture 36 Applying Themes
03:13

Module 9: Inserting Objects and Graphics

30:37
Lecture 37 Inserting and Formatting Images
02:46
Lecture 38 Inserting and Formatting Shapes
04:27
Lecture 39 Inserting and Formatting SmartArt
03:47
Lecture 40 Inserting Screenshots
02:17
Lecture 41 Inserting Hyperlinks
02:37
Lecture 42 Inserting Symbols and Equations
03:13
Lecture 43 Inserting WordArt and Text Boxes
03:50
Lecture 44 Inserting Other Excel Objects
03:53
Lecture 45 Arranging Objects
03:47

Module 10: Proofing a Workbook

13:03
Lecture 46 Using Find and Replace
03:43
Lecture 47 Finding and Replacing Formatting
01:19
Lecture 48 Using Go To and Go To Special
02:23
Lecture 49 Using the Spell Checker
02:34
Lecture 50 Using the Thesaurus and Translation Features
03:04

Module 11: Printing an Excel File

20:11
Lecture 51 Printing and Previewing Excel Files
02:57
Lecture 52 Creating Custom Margins and Scaling
04:53
Lecture 53 Adding Headers and Footers
03:40
Lecture 54 Formatting a Page with the Page Layout Tab
02:34
Lecture 55 Printing Titles and Specific Worksheet Areas
04:31
Lecture 56 Exporting to PDF and XPS
01:36

Module 12: Managing Worksheets

11:58
Lecture 57 Renaming and Coloring Worksheet Tabs
02:34
Lecture 58 Adding, Deleting, and Navigating Worksheets
03:29
Lecture 59 Moving and Copying Worksheets
03:44
Lecture 60 Hiding and Unhiding Worksheets
02:11

Module 13: Navigating and Viewing Excel Files

18:25
Lecture 61 Viewing Workbooks
02:44
Lecture 62 Using Zoom Tools
02:13
Lecture 63 Configuring Sheet Options
02:16
Lecture 64 Using the Freeze Panes and Split Commands
04:49
Lecture 65 Working with Window Commands
03:41
Lecture 66 Adjusting Workbook Properties
02:42

Module 14: Conclusion

01:42
Lecture 67 Course Recap
01:42
350