Excel Basic Training

Class Duration: 4 hours

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. Our instructors will be on hand to answer your questions and lead you to a thorough understanding of the application on a beginner’s level.

Training Class Goal

In this Basic Excel training course, students who complete the class will exit with a basic knowledge of Microsoft Excel, and have the confidence to build simple worksheets that use the basic functionality of the program. You will understand how Excel works and how to use it, giving you the foundation from which to grow.

Prerequisites

Students entering this class should possess general knowledge of the use of a computer, including the ability to use a mouse (click, double-click, right-click, click-and-drag), and the ability to type on a keyboard.

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

The basic Excel training is optimal for beginners and those new to this application. It will give you the skills needed to work with spreadsheets, and get started in the intricate world of Excel. This training will give you the confidence to navigate a spreadsheet, enter data into Excel, and even create simple formulas. Today, employers expect their workers to have at least an essential understanding of this important and powerful application. AdvantEdge Training’s Excel training for beginners will get you the skills you need for a solid foundation in the world of spreadsheets and workbooks. Our instructors are based in Arizona and Colorado, but can travel to any location outside of those states.