Excel for Beginners

About Course

Excel 2019 for beginners course includes step-by-step video instruction with screenshots and clear audio narration for an easy learning experience.
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. This course has an assessment which may be required for a certificate to be generated.

Course Content

1.Introduction

Introduction

01:13

2.Getting Started with Excel

3.Creating Workbooks Using Templates

4.Entering Data

5.Excel Formula Basics

6.Adjusting the Worksheet

7.Formating and Aligning Worksheets

8.Using Cell Styles and Themes

9.Inserting Objects and Graphics

1.Inserting and Formatting Images

00:00
2.Inserting and Formatting Shapes

00:00
3.Inserting and Formatting SmartArt

00:00
4.Working with Icons

00:00
5.Working with 3-D Models

00:00
6.Inserting Screenshots

00:00
7.Inserting Hyperlinks

00:00
8.Inserting Symbols and Equations

00:00
9.Inserting WordArt and Text Boxes

00:00
10.Inserting Other Excel Objects

00:00
11.Arranging Objects

00:00

About Course

What Will You Learn?

Course Content

1.Introduction

Introduction

2.Getting Started with Excel

1.What is Excel

2.Opening Excel

3.Navigating the Excel User Interface

4.Using the Excel Ribbon

5.Understanding Excel Worksheet Components

6.Using the Backstage View

3.Creating Workbooks Using Templates

1.Creating a New Workbook

2.Creating Workbooks Using Templates

3.Saving an Excel Workbook

4.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

4.Working with Cell and Range Addressing

5.Using Various Data Selection Techniques

6.Working with Common Excel Commands

7.Using the AutoFill Handle

8.Using Flash Fill

5.Excel Formula Basics

1.What are Formulas and Functions

2.Understanding the Components of a Formula

3.Calculation Hierarchy and the Order of Operations

4.Creating Basic Formulas

5.Working with Basic Functions and AutoSum

6.Using Cell References

7.Using the Quick Analysis Tools

6.Adjusting the Worksheet

1.Modifying Columns and Rows

2.Hiding and Unhiding Columns and Rows

7.Formating and Aligning Worksheets

1.Formatting and Aligning Data

2.Merging Data

3.Wrapping Text and Adjusting Orientation

4.Formatting Numbers

5.Using Borders and Shading

6.Using the Format Painter

7.Removing Formatting Quickly

8.Using Cell Styles and Themes

1.Using Cell Styles

2.Applying Themes

9.Inserting Objects and Graphics

1.Inserting and Formatting Images

2.Inserting and Formatting Shapes

3.Inserting and Formatting SmartArt

4.Working with Icons

5.Working with 3-D Models

6.Inserting Screenshots

7.Inserting Hyperlinks

8.Inserting Symbols and Equations

9.Inserting WordArt and Text Boxes

10.Inserting Other Excel Objects

11.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 Files

2.Creating Custom Margins and Scaling

3.Adding Headers and Footers

4.Exporting to PDF and XPS

12.Managing Worksheets

1.Renaming and Coloring Worksheet Tabs

2.Adding, Deleting and Navigating Worksheets

13.Navigating and Viewing Excel Files

1.Viewing Workbooks

2.Using Zoom Tools

3.Configuring Sheet Options

4.Using the Freeze Panes and Split Commands

5.Working with Window Commands

6.Adjusting Workbook Properties