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

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!

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

Register


Price: $350   Duration: 1 day

- EST

Select Date: