Excel Pivot Tables and Charts

Excel Pivot Tables and Charts

Course Description

Are you new to Excel? 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 data, format data, and you will even learn how to create simple formulas. With basic Excel training, you will learn how to work in pre-created spreadsheets as well as create your own simple spreadsheets from scratch.

Training Class Goal

In this Basic Excel training, students will exit this class 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 functions to give you the foundation from which to grow from.

PreRequisites

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

Topics Covered

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

Other classes covering Excel navigation

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

Other classes covering Excel formulas

Using functions

Manually typing functions

AutoSum and AutoCalculate

Other classes covering Excel functions

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

Other classes covering Excel Formatting

The Intermediate Excel training covers things beyond the basics, to give you more confidence in building your spreadsheets and creating formulas to automate them.