Objective

Are you new to Excel? An understanding of Excel is a requirement of nearly all professionals in today’s working world. This class is designed for students who need Excel training for beginners. This course will teach you how to get started on the right foot with essential skills for using Excel spreadsheets. You will learn how navigate within Excel, easily enter information into spreadsheets, learn tricks to best view and manipulate and format data, and you will even learn how to create simple formulas. With basic Excel training, you will learn how to work with pre-created spreadsheets, as well as create your own simple spreadsheets from scratch. 

PreRequisites

Ability to use a mouse (click, double-click, right-click, click-and-drag) and ability to type on a keyboard.

Outline 

Navigating to accomplish tasks
  • ​Using the Ribbon, Office Button, and menus (depending on software version)
  • Cells, columns, and rows
  • Keyboard shortcuts
  • Freezing and splitting panes
  • Zooming
  • Hiding columns and rows

Entering basic data into Excel
  • Formatting dates and times
  • Spell check
  • Undo and redo buttons
  • Creating and modifying tables
  • Sorting and filtering tables

Creating basic Excel formulas
  • ​Subtraction, division, multiplication
  • Cell references

Using functions
  • Manually typing functions
  • AutoSum and AutoCalculate

Moving and copying data
  • ​Cut, copy & paste
  • Fill handle
  • AutoFill
  • Flash Fill
  • Smart Tags

Organizing and Working with Multiple worksheets
  • ​Renaming and coloring tabs
  • Moving, copying, and inserting worksheets
  • Margins
  • Headers and Footers
  • Printing Options

Basic Excel Formatting
  • ​Adjusting width and alignment
  • Formatting text in cells
  • Wrapping and merging
  • Formatting numbers​




Credits

0.40 Continuing Education Units
Course ID #TECH223



Class Details

Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:12/19/2018
Time:8:00 am to 12:00 pm
List Price:$205.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:01/07/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:01/23/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:02/05/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:02/19/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:03/06/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:03/18/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:04/01/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:04/16/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:05/02/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:05/13/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:06/03/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:06/18/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:07/01/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:07/16/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:07/29/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:08/13/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:08/27/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:09/09/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:09/26/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:10/07/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:10/22/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:11/06/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:11/18/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Westminster, 8601 Turnpike Dr Unit 105, Westminster, CO 80031-7044
Date:12/04/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tech Center, 7343 S Alton Way Ste 100, Centennial, CO 80112-2342
Date:12/16/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:01/08/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:02/11/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:03/18/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:04/17/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:05/20/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:06/24/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:07/22/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:08/19/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:09/26/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:10/21/2019
Time:8:00 am to 12:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:11/13/2019
Time:1:00 pm to 5:00 pm
List Price:$220.00
Location:Mission Critical Systems - Tempe, 1500 N Priest Dr Ste 123, Tempe, AZ 85281-1213
Date:12/13/2019
Time:8:00 am to 12:00 pm
List Price:$220.00

Don't see what you are looking for?

Contact Us