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
- Using the Ribbon, Office Button, and menus (depending on software version)
- UCells, columns, and rows
- UKeyboard shortcuts
- UFreezing and splitting panes
- UZooming
- UHiding columns and rows
- UOther classes covering Excel navigation
Navigating to accomplish tasks
- Formatting dates and times
- Spell check
- Undo and redo buttons
- Creating and modifying tables
- Sorting and filtering tables
Entering basic data into Excel/h3>
- Subtraction, division, multiplication
- Cell references
- Other classes covering Excel formulas
Creating basic Excel formulas
- Manually typing functions
- AutoSum and AutoCalculate
- Other classes covering Excel functions
Using functions
- Cut, copy & paste
- Fill handle
- AutoFill
- Flash Fill
- Smart Tags
Moving and copying data
- Renaming and coloring tabs
- Moving, copying, and inserting worksheets
- Margins
- Headers and Footers
- Printing Options
Organizing and Working with Multiple worksheets
- Adjusting width and alignment
- Formatting text in cells
- Wrapping and merging
- Formatting numbers
- Other classes covering Excel Formatting
Basic Excel Formatting
The basic Excel training is optimal for beginners in 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 confidence to navigation and enter data into Excel and even create simple formulas. – See more at: https://www.mcstech.net/computer-training/excel/excel-basic.cfm?classDetailsID=1606#sthash.h5nmHX8K.dpuf
Upcoming Classes
Live & In-Person
All of the classes on this page are taught by live instructors who are present in the classroom.
Class Retakes
Retake any public class up to 6 months after original class date....Read more
Hands-on Learning
Interactive classes allow you to immediately try out new skills....Read more
Live Training
Live instructors deliver our classes in an engaging and interactive way....Read more
Small Class Sizes
Classes limited to 12 students for more individual attention....Read more