* COVID-19: 1 Person per Room Health & Safety Policy *


Microsoft Office Excel 2019/365: Part 1 Online Course

Microsoft Excel TrainingMicrosoft Office Excel 2019/365: Part 1

by Certstaffix® Training

Length: 1 Course(s)      Price: $175/person (US Dollars)      Bulk Pricing: 6+ Contact Us      Access Length: 6 Months      Category: Microsoft Excel


In this Introduction to Microsoft Excel 2019 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets using Excel 2019 or Excel 365.
Purchase This Course ➥
Course Description: Print It | Download PDF | Email It

  Online Microsoft Excel Classes: Learn at Your Own Pace

We will enroll you into a demo (Windows 10) eLearning session. Login information will be emailed to you.

Prefer a self-paced learning solution to fit your own schedule? Certstaffix® Training offers eLearning courses bundled together:

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • 6 month subscription length
  • Any needed software for training is provided in an online lab environment.

  Detailed Training Topics

Course Description: Print It | Download PDF | Email It
Microsoft Excel Training

Introduction to Microsoft Excel 2019 Training - 7:52 hours

In this Introduction to Microsoft Excel 2019 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel worksheets using Excel 2019 or Excel 365.

Creating a Microsoft Excel Workbook
Starting Microsoft Excel
Creating a Workbook
Saving a Workbook
The Status Bar
Adding and Deleting Worksheets
Copying and Moving Worksheets
Changing the Order of Worksheets
Closing a Workbook
Exercise: Creating a Microsoft Excel Workbook
The Ribbon
Tabs
Groups
Tell Me
Commands
Exercise: Exploring the Ribbon
The Backstage View (The File Menu)
Introduction to the Backstage View
Opening a Workbook
Exercise: Open a Workbook
New Workbooks and Excel Templates
Exercise: Select, Open and Save a Template Agenda
Printing Worksheets
Exercise: Print a Worksheet
Adding Your Name to Microsoft Excel
Adding a Theme to Microsoft Excel
The Quick Access Toolbar
Adding Common Commands
Adding Additional Commands with the Customize Dialog Box
Adding Ribbon Commands or Groups
Placement
Exercise: Customize the Quick Access Toolbar
Entering Data in Microsoft Excel Worksheets
Entering Text
Using Flash Fill
Expand Data across Columns
Adding and Deleting Cells
Adding a Hyperlink
Add WordArt to a Worksheet
Using AutoComplete
Exercise: Entering Text and Using AutoComplete
Entering Numbers and Dates
Using the Fill Handle
Exercise: Entering Numbers and Dates
Formatting Microsoft Excel Worksheets
Selecting Ranges of Cells
Hiding Worksheets
Adding Color to Worksheet Tabs
Adding Themes to Workbooks
Exercise: Customize a Workbook Using Tab Colors and Themes
Adding a Watermark
The Font Group
Exercise: Working with Font Group Commands
The Alignment Group
Exercise: Working with Alignment Group Commands
The Number Group
Exercise: Working with Number Group Commands
Using Formulas in Microsoft Excel
Math Operators and the Order of Operations
Entering Formulas
Ink Equations
AutoSum (and Other Common Auto-Formulas)
Copying Formulas and Functions
Displaying Formulas
Relative, Absolute, and Mixed Cell References
Exercise: Working with Formulas
Working with Rows and Columns
Inserting Rows and Columns
Deleting Rows and Columns
Transposing Rows and Columns
Setting Row Height and Column Width
Hiding and Unhiding Rows and Columns
Splitting the Worksheet Window
Freezing Panes
Exercise: Working with Rows and Columns
Editing Worksheets
Find
Find and Replace
Exercise: Using Find and Replace
Using the Clipboard
Exercise: Using the Clipboard
Exercise: Using Format Painter
Managing Comments
Adding Comments
Working with Comments
Finalizing Microsoft Excel Worksheets
Setting Margins
Setting Page Orientation
Setting the Print Area
Print Scaling (Fit Sheet on One Page)
Printing Headings on Each Page/Repeating Headers and Footers
Headers and Footers
Exercise: Preparing to Print
Course Description: Print It | Download PDF | Email It