Beginning Microsoft Excel Training Outline for Business Professionals

Learn vital Microsoft Excel skills and strategies that you can immediately apply to your everyday Excel problems. Our 1-day "hands-on" Excel training shows you the fundamentals of using Excel like entering data, cell formatting, copying and pasting, basic formula construction, printing, auto summing and more. It not only teaches you the basics of Microsoft Excel but the thinking and mechanics of how to apply it to your everyday business problems.

Free Workshop Repeats

All of our workshops come with free repeats. We believe learning is an iterative process and not just a one time event. Details

EMAGENIT Customers and Awards

At EMAGENIT, we have trained customers like:

Janus Capital, HSBC, Deutsche Bank, Google, Apple, BMW, Capital One and Disney (View More)

We have also trained organizations like ICE, NASA, The US Army, Navy, Air Force and Marines and develop custom Excel software for the likes of Caterpillar and NASA (Award). Our diverse training background and software projects ensure you get the best Excel training drawn from real world experience not academia. We show you what you actually need to succeed.

Why Not Go Online For Your Training

Our live "hands-on" webinars enable us to train you and your company employees at different sites all over the country at once without having to collect them in one room. You can sign up for the webinar below. View Our Webinar Details Page

About Our Workshop

Vital Beginning Excel Skills You Learn

How to use the Microsoft Excel control Ribbon, dialog boxes, shortcut menus and help
How to control Microsoft Excel workbooks
How to format and control Microsoft Excel worksheets
How to copy and paste worksheet data
How to enter, sort and filter data on Microsoft Excel worksheets
How to create simple worksheet formulas that perform calculations
How to use Microsoft Excel worksheet functions like SUM, MAX, MIN, AVERAGE to perform tasks like summations, averages...
How to create simple business charts in Excel
How to print Microsoft Excel sheets

Who Should Take This Workshop (Prerequisites)

Select this workshop 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 sorted or filtered data
No idea of what we are talking about in the previous bullets

Microsoft Excel Versions Taught in Workshop

Our workshops cover Excel versions 2000-2013 including Excel for Mac and discuss differences when necessary. It short, we cover every version.

Included in Our Beginning Excel Workshop

Free Repeats
1800+ page manual filled with key Excel strategies, examples and tips
Hands-on training
Personal questions answered

Workshop Training Choices

Available: Public Seminar, Company Onsite, Self-Study Manual

Public and Self-Study signup buttons below
For company onsite information or if you have any questions, please contact us 1.805.498.7162 or 1.805.558.9277.

Beginning Excel Workshop Outline

In this 1-day "hands-on" workshop you will cover:

Microsoft Excel Parts Review: Definitions and descriptions of the elements that make up the Microsoft Excel environment including workbooks, worksheets and cells
Microsoft Excel Program Operation: How to operate the Microsoft Excel program environment including using the Ribbon, dialog boxes and shortcut menus
Workbook File Tasks: How to create, open, close, save and view Microsoft Excel workbooks
Worksheet Tasks: How to create, move, rename and view Microsoft Excel worksheets
Data Entry: How to enter data in Microsoft Excel worksheet cells
Basic Table Construction: How to build a table on a worksheet
Formatting Data: How to format the look of the data in Microsoft Excel worksheet cells
Formatting the Worksheet: How to change the appearance of a worksheet including merging cells, resizing columns and rows, coloring cells, placing borders around cells, adjusting cell fonts....
Common Excel Tasks: How to copy, paste, insert, delete and move cell information
Cell Comments: How to create and manage Microsoft Excel cell comments, a great way to flag information
Worksheet Formulas: How to construct and edit simple Microsoft Excel worksheet formulas
Naming Cells: How to name Microsoft Excel worksheet cells and use them in formulas
Worksheet Functions: How to use simple Microsoft Excel worksheet functions that are beneficial to business including SUM, AVERAGE, MAX, MIN, COUNTIF, COUNTA, SUMIF
Sorting: How to sort data on the worksheet
Filtering (AutoFilter): How to filter worksheet table data so you see only specific lines
Basic Business Chart Construction: How to create simple Microsoft Excel business charts
Spell Checking: How to check spelling on your worksheets
Printing Worksheets and Charts: How to print Microsoft Excel worksheets and charts

Workshop Signup, Pricing and Self-Study

The Public button below will lead you to our training schedule page listing all possible dates, prices and signups. The Self-Study button will lead you to our manual page where you can get the manual pricing and the manual outline. The manual comes with the class.