Beginning Excel Class for Business and Industry

Use Excel to complete those common work tasks quickly.

Class overview.

Our live, hands-on, 1-day class shows you the Excel skills needed to perform a variety of tasks in today's workplace. Businesses and organizations more than ever expect a higher degree of Excel skills than just a few years ago and our class will deliver for you.

We cover the Excel basics like entering data, worksheet formatting, copying / pasting, sorting, and filtering data. Our class also covers need to know topics like problem layout, formula / function construction, dragging and filling formulas, and basic chart design.

Join us and our class will show you the skill sets you need to get up and running in Excel fast.

Some key topics we cover in class.

How to control Excel's Ribbon, dialog boxes, shortcut menus, and help
Controlling and selecting workbooks, worksheets, and cells
Typing, filling, and setting the number format of worksheet data
How to format worksheets, merge cells, and make useful forms
Creating and using shapes and pictures to enhance a worksheet's content
Design rules for worksheet tables that store data
How to layout a problem on the worksheet and build formulas to calculate it
Using worksheet functions to quickly calculate data
Using Excel's filter, sort, and totaling tools to report data
Copying and pasting worksheet data, charts, shapes, pictures...
Creating basic chart reports in Excel
Printing worksheet data and charts

Est 1998. If you haven't heard of us before, here's some of our customers from the past 25 years.

View Customers >

Prerequisites for our beginning Excel training.

Performed basic computer operations like typing and using the mouse
Never opened Microsoft Excel or have just seen it
Never heard of a workbook, worksheet, cell, or cell reference
Just typed data in a cell
Never typed formulas
Never copied, sorted, or filtered data
Have no idea what we just said

Get an instant class discount. Signup for our Exceleration newsletter and get a discount that you can apply instantly to any purchase.

Newsletter Signup >

Class time, manual, and repeats.

Audience: Business, government, industry, military, engineering, science, techs...
Duration: 9:00 - 5:00 CT
# of Days: 1-day
Instruction Type: Live, hands-on
Class Manual: Our complete Excel manual for business and industry (TCEM). Details >
Excel Versions: 2013-Present, Microsoft 365, Windows and Mac
Repeats: Repeat your Excel training. Details >

Class syllabus, training, and price options.

View the dates and signup for our hands-on live virtual training.
Virtual Signup: $150.00 >

View the dates and signup for our hands-on in-person public training.
In-Person Signup: $190.00 >

Can't take the class, buy the self-study manual, apply the price later.
View Manual >

Learn how we can help your business save time and effort in Excel.
View Onsite Details >

Class syllabus.

How we run the class: We focus our training on what our customers need. When training begins, we analyze those needs and shift our training outline appropriately. We will stress topics or add topics that our customers want. No two training sessions are ever the same with EMAGENIT.

Class Syllabus

How to Control Excel's Ribbon, Dialog Boxes, Shortcut Menus, and Help

What is the Ribbon, a dialog box, and shortcut menu?
The 4 mouse movements that control Excel's interface
How to use the Ribbon, its tab system, and categories to control Excel functionality
How to launch and use shortcut menus and dialog boxes to control Excel functionality
How to use Excel help effectively

How to Control and Select Workbooks, Worksheets, and Cells

What is a workbook, worksheet, cell, row, and column and how are they used?
How to create, open, close, name, and save workbooks
Navigating between open workbooks and arranging their windows for easy use
How to add, copy, move, rename, delete, and view worksheets
Hiding and unhiding worksheets and workbooks
How to select a cell, range, row, and column with the mouse

Typing, Filling, and Setting the Number Format of Worksheet Data

What is a number format and how does Excel store data in a worksheet cell?
Typing numeric, date, and text values in a worksheet cell
How to quickly change the number formats for cells, rows, and columns
Using the Flash Fill feature to automatically fill in values in a worksheet table
Dragging and filling data down a worksheet in different patterns using AutoFill

Copying and Pasting Worksheet Data, Charts, Shapes... in Excel

How to copy and paste cell or range data
Quickly copying and pasting an entire worksheet's data to another worksheet
Copying and pasting filtered worksheet data to another worksheet to create a report
Copying and pasting charts, pictures, drawing shapes...
Using Paste Special to paste specific parts of your copied information

How to Format Worksheets, Merge Cells, and Make Useful Forms

Resizing, inserting, deleting, hiding, and unhiding worksheet rows and columns
Changing the font, alignment, color, and borders of a worksheet cell
Merging worksheet cells on a worksheet
Creating and managing comments to flag cell information
Using all these features to create a useful form on a worksheet

Using Drawing Shapes and Pictures to Enhance a Worksheet's Content

How to use shapes and pictures to enhance company brand, visualize products, ideas...
Inserting drawing shapes and pictures on the worksheet
Formatting, resizing, moving, and deleting drawing shapes and pictures
How to crop a picture on a worksheet

Designing Worksheet Tables to Store Data

How Microsoft Excel can be used to store vast quantities of company data
What is a worksheet table and how does it relate to storing and processing data in Excel?
Worksheet table construction guidelines

Laying Out a Worksheet Problem and Building Formulas for It

What is a formula and how are they used to perform calculations on the worksheet?
Laying out a problem on the worksheet so it can be calculated with formulas
A review of absolute, mixed, and relative cell references and how to use them to build formulas
How to use the mouse to accurately build formulas that multiply, subtract, add, and divide
How to rapidly fill a formula down or across worksheet data
How to edit and correct a worksheet formula

Using Functions to Quickly Calculate Worksheet Data

What is a function, how are they used and run, and what is an argument list?
The basics of typing a worksheet function in a formula and running it
What is a range reference and how to use one in a worksheet function?
Using the SUM, MAX, MIN, AVERAGE, COUNTA, and VLOOKUP functions to calculate data
Dragging and filling formulas with functions down or across a worksheet

Using Excel's Filter, Sort, and Totaling Tools to Report Data

How to sort worksheet data using values, colors...
How to use AutoFilter to rapidly filter worksheet data for POs, IDs, Due Dates, SKUs...
Using Remove Duplicates to remove duplicated values from worksheet data
Using the Subtotal feature to quickly sum groups of worksheet data

Creating Basic Chart Reports in Excel

What is a chart and where are they created in Excel?
Organizing your data on a worksheet so it can be used in a chart
How to create a chart on a worksheet or chart sheet
Performing basic formatting and editing tasks on a chart

Printing Worksheets and Charts in Excel

Checking the spelling on your worksheets and charts
Setting your printing options in Excel
Printing worksheets and charts

If you need to contact us about our class.

Phone Number: 1.805.498.7162

Business Hours: Mon-Fri 8:00 AM - 7:00 PM CT

You can email us at info@emagenit.com >

Form >

Beginning Excel for Business and Industry - Class