Beginning Excel for Business and Industry Class

How our class will boost your Excel skills.

Our 1-day class gives 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 and pasting; sorting and filtering data; and printing.

In addition, we cover need to know topics like problem layout on the worksheet; using formulas and functions; dragging and filling formulas; worksheet table construction; and basic chart design.

Read our detailed outline > below and see what you'll discover in our class.

What you'll learn in our class.

Learn how to use Excel's menu system (Ribbon, shortcut menus...), control workbooks and worksheets, and select cells and ranges.

Learn how to type data and set its number format, perform drag and fills on data, and setup tables to use Excel's Flash Fill feature.

Learn how to format worksheets, shapes, and pictures; organize worksheet info for ease of use and calculation; and create forms.

Learn how to layout a worksheet problem; build formulas and operators (+,-,*...); use cell references; and drag and fill formulas.

Learn how to copy and paste worksheet data, worksheet formats, formulas, charts, shapes, and ranges.

Learn how to organize data in tables; use functions to quickly calculate and lookup data; and how to link to data in other sheets.

Learn how to sort worksheet data, remove duplicates, and use filters and Slicers to rapidly filter tables for reports.

Learn how to build different chart types, organize chart data on the worksheet, and use formatting to enhance chart information.

How to control Excel's Ribbon, program dialog boxes, shortcut menus, and help
How to open, save, create, and view workbooks; and how to create, delete, and move worksheets
Typing, filling, and setting the number format of worksheet data
How to layout your problem on the worksheet
How to create formulas using various types of cell and range references
How to format worksheets, merge cells, insert / delete columns and rows, and make useful forms
Creating and using shapes and pictures to enhance a worksheet's content
How to create worksheet tables that will store your data
Using essential worksheet functions to quickly calculate data
Copying and pasting worksheet data, charts, shapes, formulas...
Using Excel's filter, sort, and totaling tools to report data
Creating basic chart reports in Excel
Printing worksheet data and charts

Some key topics we cover in class.

4 ways to train.

Virtual

View the dates, signup, and pricing for our hands-on live virtual training.
Virtual Signup > Learn More >

In-Person

View the dates, signup, and pricing for our hands-on in-person training.
In-Person Signup > Learn More >

Manual

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

Onsite

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.

Download Class Brochure

Using the Ribbon, Workbooks, Worksheets, and Cells

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

Typing and Filling Data on the Worksheet

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

Building Your Problems and Formulas on the Worksheet

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 use cell references to link to data on another sheet

How to Format Worksheets, Use Shapes, and Make Forms

Resizing, inserting, merging... worksheet rows, columns, and cells
Changing the font, alignment, color, and borders of a worksheet cell
Creating and managing comments to flag cell information
Creating, formatting, moving... drawing shapes and pictures
Using all these features to quickly create a form on a worksheet

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

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
Copying and pasting cells with formulas

Using Functions and Tables to Calculate Worksheet Data

How to design a worksheet table and create an Excel table to store 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
How to use range, cell, and Excel table references in your functions
Using the SUM, MAX, COUNTIF, VLOOKUP... functions to calculate and lookup 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, Due Dates, SKUs...
How to use Excel tables to calculate data and Slicers to rapidly filter report data
Using Remove Duplicates to remove duplicated values from worksheet data
Using the Subtotal feature to quickly sum groups of worksheet data

Creating Basic Charts 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
How to create a Column, Pie, Line... chart
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

Additional Class Information

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
Limited experience with workbooks, worksheets, cells, or cell references
Just typed data in a cell
Never typed formulas
Never copied, sorted, or filtered data

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 Excel 365, Windows and Mac
Repeats: Repeat your Excel training. Details >

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