Beginning Excel Class for Business and Industry

Next Class: 10/03/2022

More Dates >

Free Repeats
Repeat your Excel class with us for an entire year for free.

NASA Project
See how we helped NASA with the Mars Rover using Excel.

Discounts
We provide discounts to active / retired US Military and DOD.

Customers
View our customers like Apple, Boeing, and the US Army.

Key Excel topics covered 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

Click to enlarge, scroll < > if hidden.

Pricing and class options.

Online Virtual Learning

Price: $150.00
Live, hands-on, talk to the instructor training
Bring your own problems to class
Online Details >

Dates / Signup >

Public In-Person Learning

Price: $190.00
Live hands-on training
Bring your own problems to class
We can supply a computer

Dates / Signup >

Onsite Hands-On Learning

We come to you and solve your problems
We cover in person in the USA and Canada
We cover the world virtually using your time zone

Details >

Detailed 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.

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

Excel skills needed for our class.

Select this Excel training if you or your group have:

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

The class details.

Audience: Business, government, industry, military, engineering, science, techs... general audience
Duration: 9:00 - 5:00 CT
# of Days: 1-day
Instruction Type: Hands-on, live, instructor taught training
Full Excel Manual Included: Our 2200 + page manual full of Excel tips, how-to-do topics and examples included with the training. Details >
Excel Versions: 2010-2019, Microsoft 365, Windows and Mac
Free Repeats: Repeat your Excel training. Details >
Personal Examples: We review our attendees personal examples in our training instruction
Available Training Formats:

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 >

Contact us by form.

Beginning Excel for Business / Industry	Intermediate Excel for Business / Industry	Advanced Excel for Business / Industry	Excel Dashboard Design for Business / Industry	Beginning Excel VBA for Business / Industry	Excel VBA Data Processing for for Business / Industry	Advanced Excel VBA for Business / Industry