Classroom Instructor Led Microsoft Excel Training 817-841-9560

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

$425 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
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
Tables
  • Tables Overview
  • Creating Tables
  • Adding & Removing Data
Pivot Tables
  • Pivot Tables Overview
  • Creating Pivot Tables
  • How Pivot Tables Work
  • Slicing and Dicing
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 Location Price Registration
March 29, 2024
9:00 AM to 5:00 PM
Fort Worth, TX $425.00 Class is Full. Waiting List
April 1, 2024
9:00 AM to 5:00 PM
Fort Worth, TX $425.00 Register
April 10, 2024
9:00 AM to 5:00 PM
Fort Worth, TX $425.00 Class is Full. Waiting List
April 15, 2024
9:00 AM to 5:00 PM
Fort Worth, TX $425.00 Register
April 24, 2024
9:00 AM to 5:00 PM
Fort Worth, TX $425.00 Register
April 29, 2024
9:00 AM to 5:00 PM
Fort Worth, TX $425.00 Class is Full. Waiting List
Live Online Classes Schedule


Date Location Price Registration
April 1, 2024
9:00 AM to 5:00 PM
Live Online $425.00 Register
April 10, 2024
9:00 AM to 5:00 PM
Live Online $425.00 Class is Full. Waiting List
April 15, 2024
9:00 AM to 5:00 PM
Live Online $425.00 Register
April 24, 2024
9:00 AM to 5:00 PM
Live Online $425.00 Register
April 29, 2024
9:00 AM to 5:00 PM
Live Online $425.00 Class is Full. Waiting List

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.

Contact Us

Phone

817-841-9560

Office Address

2601 Scott Avenue
Suite 107
Fort Worth, TX 76103

Mailing Address

PO Box 712
Aledo, TX 76008

Communication Preference

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.