Banner rating d5dfd02e10e7bea369b370d45102dadcf6d70e41b6bfce1ee178127969f7852a
Dynamics Edge
4.67 out of 50 stars, based on 80 reviews*

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Request Group Quote

Purchase

Price: $350   Duration: 1 day
- EST
Select Date:
Number of Seats:

Course 100003

Price: $350, Length: 1 day

Excel 2019 Level 1 - Introduction. Versions 2013, 2016, 2019, Office 365, & Online are available.

To customize this class, call 800-453-5961 or click here to contact us

Excel 2019 , Level 1 - Introduction

Versions 2013, 2016, 2019, Office 365, & Online are also available.

Course Outline

Lesson 1 - Excel Basics

  • Creating an Excel Workbook
  • Examining the Excel Environment
  • Opening an Existing Workbook
  • Navigating a Worksheet
  • Creating a New Workbook
  • Saving a New Workbook
  • Moving Between Workbooks
  • Setting Excel Options
  • Switching Between Views
  • Using Tell Me to Obtain Help
  • Closing a Workbook and Exiting Excel

Lesson 2 – Working with Data

  • Entering Text and Numbers
  • Entering Simple Formulas
  • Choosing Formula Cell References
  • Using AutoSum
  • Changing & Deleting Data
  • Using Undo/Redo
  • Using Find and Replace
  • Using the Go to Command
  • Spell Checking Your Worksheet
  • Inserting Symbols
  • Using Smart Lookup

Lesson 3 – Editing a Worksheet

  • Working with Ranges
  • Copying and Pasting Data
  • Using the Office Clipboard
  • Cutting and Pasting Data
  • Copying and Moving Cells Using Drag-And-Drop
  • Changing Column Width
  • Changing Row Height
  • Inserting and Removing Rows and Columns
  • Copying Data and Formulas with Autofill
  • Filling in Cells Using Flash Fill

Lesson 4 – Formatting a Worksheet

  • Formatting Text
  • Using the Format Cells Dialog Box
  • Formatting Values
  • Using the Format Painter Button
  • Alignment and Text Wrapping
  • Merging Cells and Centering Text
  • Adding Cell Borders
  • Applying Colors and Shading to Cells
  • Applying Cell Styles
  • Hiding and Unhiding Rows and Columns
  • Freezing and Unfreezing Rows and Columns
  • Inserting and Removing Page Breaks

Lesson 5 – Page Setup and Printing

  • Adjusting Margins
  • Setting Page Orientation
  • Setting Paper Size
  • Defining a Print Area
  • Printing Worksheet Titles
  • Forcing a Worksheet to Fit
  • Inserting Headers and Footers
  • Printing a Worksheet

Lesson 6 – Formulas and Functions

  • Relative References
  • Absolute References
  • Mixed References
  • Copying Formulas
  • Min, Max, Count and Average Functions
  • the Insert Function Button

Lesson 7 – Modifying Workbooks

  • Adding and Deleting Worksheets
  • Copying Worksheets
  • Renaming Worksheets
  • Repositioning Worksheets
  • Grouping Worksheets
  • Changing Worksheet Tab Colors
  • Using -D Formulas & References

We look forward to your great success!

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.


100003Excel 2019 Level 1 - Introduction. Versions 2013, 2016, 2019, Office 365, & Online are available.