facebook-pixel
$19.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 2019 Beginner

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

  • The newest version of Excel for beginners.
  • 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.

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.

What am I going to get from this course?

Learn to enter data, create worksheets, handle large worksheets etc. 

Prerequisites and Target Audience

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

Basic computer skills 

Who should take this course? Who should not?

Beginners & anyone who wants to learn Excel

Curriculum

Module 1: Introduction

Lecture 1 Introduction

Module 2: Getting Started with Excel

Lecture 2 What is Excel?
Lecture 3 Opening Excel
Lecture 4 Navigating the Excel User Interface
Lecture 5 Using the Excel Ribbon
Lecture 6 Understanding Excel Worksheet Components
Lecture 7 Using the Backstage View

Module 3: Creating Workbooks and Using Templates

Lecture 8 Creating a New Workbook
Lecture 9 Creating Workbooks Using Templates
Lecture 10 Saving an Excel Workbook
Lecture 11 Using the Accessibility Checker

Module 4: Entering Data

Lecture 12 Navigating a Worksheet by Mouse or Keyboard
Lecture 13 Understanding Excel Data Types
Lecture 14 Using the Inking Tools
Lecture 15 Working with Cell and Range Addressing
Lecture 16 Using Various Data Selection Techniques
Lecture 17 Working with Common Excel Commands
Lecture 18 Using the AutoFill Handle
Lecture 19 Using Flash Fill

Module 5: Excel Formula Basics

Lecture 20 What are Formulas and Functions?
Lecture 21 Understanding the Components of a Formula
Lecture 22 Calculation Hierarchy and the Order of Operations
Lecture 23 Creating Basic Formulas
Lecture 24 Working with Basic Functions and AutoSum
Lecture 25 Using Cell References
Lecture 26 Using the Quick Analysis Tools

Module 6: Adjusting a Worksheet

Lecture 27 Modifying Columns and Rows
Lecture 28 Hiding and Unhiding Columns and Rows

Module 7: Formatting and Aligning a Worksheet

Lecture 29 Formatting & Aligning Data
Lecture 30 Merging Data
Lecture 31 Wrapping Text and Adjusting Orientation
Lecture 32 Formatting Numbers
Lecture 33 Using Borders and Shading
Lecture 34 Using the Format Painter
Lecture 35 Removing Formatting Quickly

Module 8: Using Cell Styles and Themes

Lecture 36 Using Cell Styles
Lecture 37 Applying Themes

Module 9: Inserting Objects and Graphics

Lecture 38 Inserting and Formatting Images
Lecture 39 Inserting and Formatting Shapes
Lecture 40 Inserting and Formatting SmartArt
Lecture 41 Working with Icons
Lecture 42 Working with 3-D Models
Lecture 43 Inserting Screenshots
Lecture 44 Inserting Hyperlinks
Lecture 45 Inserting Symbols and Equations
Lecture 46 Inserting WordArt and Text Boxes
Lecture 47 Inserting Other Excel Objects
Lecture 48 Arranging Objects

Module 10: Proofing a Workbook

Lecture 49 Using Find and Replace
Lecture 50 Using Go To and Go To Special
Lecture 51 Using the Spell Checker
Lecture 52 Using the Thesaurus and Translation Features

Module 11: Printing an Excel File

Lecture 53 Printing and Previewing Files
Lecture 54 Creating Custom Margins and Scaling
Lecture 55 Adding Headers and Footers
Lecture 56 Exporting to PDF and XPS

Module 12: Managing Worksheets

Lecture 57 Renaming and Coloring Worksheet Tabs
Lecture 58 Adding, Deleting and Navigating Worksheets

Module 13: Navigating and Viewing Excel Files

Lecture 59 Viewing Workbooks
Lecture 60 Using Zoom Tools
Lecture 61 Configuring Sheet Options
Lecture 62 Configuring Sheet Options
Lecture 63 Using the Freeze Panes and Split Commands
Lecture 64 Working with Window Commands
Lecture 65 Adjusting Workbook Properties

Module 14: Conclusion

Lecture 66 Course Recap
350