Classroom Instructor Led Microsoft Excel Training 817-841-9560 excel@dfwexcel.com

Excel Introduction

Overview

This course is ideal for complete novices, those who have basic knowledge of Excel or are self-taught. The course will provide you with the skills you need to work quickly and produce functional and well formatted spreadsheets. This course is often used to benchmark Microsoft Excel skills and ensure a level of understanding for new hires at companies. Students will leave feeling confident about creating professional worksheets with the software and be able to navigate the interface intuitively and productively.

Price

$395 per Student

CPE Credits

8 CPE Credits

Prerequisites

Participants must have basic keyboard and mouse skills and be familiar with the Windows operating system.

Duration

1 Day

Class Outline
Getting Started with Excel
  • Working with the Excel Environment
  • Title Bar
  • Ribbon and Ribbon Tabs
  • Quick Access Toolbar
  • Worksheet Views
  • Backstage View
Creating and Opening Workbooks
  • Create New Workbook
  • Open Existing Workbook
  • Pin a Workbook
  • Using Templates
  • Compatibility Mode
Saving and Sharing Workbooks
  • Save and Save As
  • Auto Recovery
  • Exporting Workbooks
  • Sharing Workbooks
Cell Basics
  • Understanding Cells
  • Select a Cell
  • Select a Cell Range
  • Inserting Cell Content
  • Deleting Cell Content
  • Cutting & Pasting Cell Content
  • Drag and Drop Cells
  • Completing Series with Fill Handle
Modifying Columns, Rows, and Cells
  • Changing Column Width
  • Changing Row Height
  • Inserting & Deleting Columns and Rows
  • Hiding & Showing Columns and Rows
  • Wrapping Cell Text
  • Merging Cells
Formatting Cells
  • Font Type, Size, Color, and Decorations
  • Cell Borders and Fill Colors
  • Cell Alignment and Styles
Cell Formats
  • Number Formats
  • Percentage Formats
  • Date Formats
Working with Multiple Worksheets
  • Inserting Worksheets
  • Copying Worksheets
  • Deleting Worksheets
  • Moving Worksheets
  • Renaming Worksheets
  • Changing Worksheet Tab Colors
  • Grouping and Ungrouping Worksheets
Using Find and Replace
  • Finding Text
  • Replacing Text
Page Layout and Printing
  • Print Pane
  • Print Area
  • Page Orientation
  • Page Breaks
Intro to Formulas
  • Formulas Overview
  • Mathematical Operators
  • Cell References
  • Creating Formulas
  • Copying Formulas
Creating More Complex Formulas
  • Order of Operations
  • PEMDAS
Relative and Absolute Cell References
  • Relative References
  • Absolute References
  • Cell References Across Worksheets
Functions
  • Functions Overview
  • Parts of a Function
  • Function Arguments
  • Using Functions
  • Function Library
IF Function
  • IF Function Overview
  • IF Function Arguments
  • Using the IF Function
VLOOKUP Function
  • VLOOKUP Function Overview
  • VLOOKUP Function Arguments
  • Using the VLOOKUP Function
Charts
  • Charts Overview
  • Chart Components
  • Chart Layout and Styles

Excel Introduction Schedule

In-Person Classes Schedule
Date/Time Event Registration
October 1, 2021
9:00 am - 5:00 pm
Excel Introduction
Bedford Training Facility S8, Bedford TX
Class is Full. Add Your Name to the Waiting List
November 5, 2021
9:00 am - 5:00 pm
Excel Introduction
Bedford Training Facility S8, Bedford TX
Class is Full. Add Your Name to the Waiting List
December 3, 2021
9:00 am - 5:00 pm
Excel Introduction
Bedford Training Facility S8, Bedford TX
Spaces Available, Register for Class
Price: $395.00

Date Location Price Registration
#_EVENTDATES#_12HSTARTTIME to #_12HENDTIME {has_location}#_LOCATIONTOWN, #_LOCATIONSTATE{/has_location}{no_location}Live Online{/no_location} #_EVENTPRICEMAXALL {bookings_open}Register{/bookings_open}{bookings_closed}Class is Full. Waiting List{/bookings_closed}
Live Online Classes Schedule
Date/Time Event Registration
October 1, 2021
9:00 am - 5:00 pm
Excel Introduction Class is Full. Add Your Name to the Waiting List
November 5, 2021
9:00 am - 5:00 pm
Excel Introduction Class is Full. Add Your Name to the Waiting List
December 3, 2021
9:00 am - 5:00 pm
Excel Introduction Class is Full. Add Your Name to the Waiting List

Date Location Price Registration
#_EVENTDATES#_12HSTARTTIME to #_12HENDTIME {has_location}#_LOCATIONTOWN, #_LOCATIONSTATE{/has_location}{no_location}Live Online{/no_location} #_EVENTPRICEMAXALL {bookings_open}Register{/bookings_open}{bookings_closed}Class is Full. Waiting List{/bookings_closed}

Don't see a Class Date that works for you?

Let us know when you would like to take the class and we will see if we can add a new class date to our schedule.

Public Classes

Need to Pay via an Invoice?

No problem. If you need to pay with an invoice, please use our contact form and let us know what class you would like to attend and we will email you an invoice you can pay via your Accounts Payable department.

Contact Us

Phone

817-841-9560

Email

excel@dfwexcel.com

Office Address

5608 Malvey Ave,
Suite 14620,
Fort Worth, TX 76107

Mailing Address

PO Box 712
Aledo, TX 76008

Communication Preference