Beginning Microsoft Excel Training

Beginning Excel Training Description

Our 1-day hands-on beginning Microsoft Excel training for business professionals shows you the fundamentals of using Excel like entering data, autofills, flash fills, worksheet formatting, drawing, copying and pasting, basic formula construction, 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 problems and the future. Excel for Mac users welcome.

When and Where is Our are Beginning Excel Training Held (Public Event and Live Online)

EMAGENIT holds it Beginning Excel training public events in Thousand Oaks, CA. We start at 8:30 AM PT and run to 4:30 PM PT. We are in the vicinity of Simi Valley, CA; Oxnard, CA; Ventura, CA; Santa Barbara, CA; Carpentaria, CA; Calabasas, CA; Agoura Hills, CA; Studio City, CA; Sherman Oaks, CA; Encino, CA; Woodland Hills, CA; Westwood, CA, Santa Paula, CA; Valencia, CA; Santa Monica, CA and Los Angeles, CA. California counties within morning commute of our area include Santa Barbara county, Ventura county, Los Angeles county and Orange county. Our beginning Excel training is also held live online and is broadcast all over the US, Canada, Mexico and the Caribbean. We can actually broadcast to any part of the world and have. For onsites, we also travel all over the US, Canada and Europe.

Key Skills Learned in Our Beginning Excel Training

Key Skills You'll Learn in Our Beginning Microsoft Excel Training

Key beginning Excel skills learned:

Beginning Excel review of using the Ribbon, dialog boxes, shortcut menus and help
A review of key Excel elements like workbooks, worksheets, cells and ranges
Need to know beginning Excel techniques for controlling workbooks and worksheets in Excel
How to format worksheets and use drawing shapes and pictures
Beginning Excel basics for copying and pasting Excel worksheet data
How to enter, sort, filter and remove duplicate data on Microsoft Excel worksheets
How to use the AutoFill feature and Flash Fill feature to complete data entry
How to create beginning Excel worksheet formulas that add, multiply, subtract and divide
How to use beginning Excel worksheet functions like SUM, MAX, MIN, AVERAGE, COUNTA, SUMIF and COUNTIF to process worksheet data
Basic business chart construction and formatting
How to print Microsoft Excel worksheets and chart sheets

Beginning Excel Training Skill Requirements

Select this beginning 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 sorted or filtered data

Beginning Microsoft Excel Training Topics Outline

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

Microsoft Excel Program Review

What really is Microsoft Excel, how is it used in business and how can it be used in ways that you will not believe
How to operate the Microsoft Excel program environment including using the control Ribbon, dialog boxes and shortcut menus
How to operate the Excel environment using a mouse and keyboard
Important Excel shortcut keys to remember

Beginning Microsoft Excel Training for Business Free Repeats

Beginning Excel Overview of Controlling Excel Workbooks and Worksheets

What is an Excel workbook and how are they used?
How to create, open, close, name and save workbooks
A review of the critical workbook file types
How to navigate between multiple open workbooks and not get lost
How to arrange multiple workbook windows in Excel for easy access
What is a worksheet and how are they used?
What is a cell, column and row on a worksheet?
How to create, copy, move, rename, delete and view Excel worksheets including tab coloring
How to hide and unhide an Excel worksheet and workbook

What Excel Beginners Need to Know About Typing Data in Worksheet Cells

How data is stored in an Excel worksheet cell
How to type numeric, date and text values in a worksheet cell
How to use the Flash Fill feature to automatically fill in values in a worksheet table
How to drag and fill data down a worksheet in different patterns using AutoFill

How to Format Worksheets

How to resize, insert and delete Excel worksheet columns and rows
How to hide and unhide rows and columns on the worksheet
How to change the font, alignment, color and borders of a worksheet cell
How to merge worksheet cells on a worksheet
How to create and manage Microsoft Excel cell comments, a great way to flag information
How to use all these features to create a basic form on a worksheet

Beginning Excel Guide to Using Drawing Shapes and Pictures on the Worksheet

How to turn a boring worksheet into a report / dashboard / display system superstar using shapes and pictures
How to create drawing shapes on the worksheet
How to resize and move drawing shapes
How to format drawing shapes
How to insert a picture on to an Excel worksheet
How to format, resize and crop a picture on an Excel worksheet

How to Create Proper Tables on the Worksheet

What is a table, how does it relate to storing and processing data on the worksheet
Proper table construction guidelines
How Microsoft Excel can be used to store vast quantities of data

Creating Beginning Excel Formulas on the Worksheet

What are cell references and how to use them in formulas
A review of absolute, mixed and relative cell references and how to use them in formulas
How to create a formula in a cell, basic construction methods using the mouse
How to add, multiply, subtract and divide cell data using simple formulas
How to drag and fill formulas down or across a worksheet

Creating and Running Beginning Excel Worksheet Functions on the Worksheet

What is a worksheet function, its actual code structure, how are they run, why are you running them, and what in the world is an argument list?
How to run a worksheet function in a formula
Overview of the different argument constructs you can use to run a worksheet function
What is a range reference on the worksheet and how do you use one to run a worksheet function
How to use essential Excel worksheet functions like SUM, MAX, MIN, AVERAGE, COUNTA, SUMIF and COUNTIF in your formulas to process data
How to drag and fill formulas running worksheet functions down or across a worksheet

Using Sort, AutoFilter, Subtotal and Remove Duplicates to Analyze Worksheet Data

How to construct a proper table on a worksheet that stores and organizes data
How to sort worksheet data using values and colors
How to use AutoFilter to filter your data on a worksheet so you see only the information you want
How to use the Remove Duplicates feature to remove duplicated values from a worksheet table
How to use the Subtotal feature to sum groups of data on the worksheet

Beginning Excel Methods for Creating Basic Charts

What is a Microsoft Excel chart and how can they be used in business
How to organize 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 perform basic formatting and editing tasks on an Excel chart

Need to Know Beginning Excel Methods for Copying and Pasting Data Including PasteSpecial

How to copy a cell or range on a worksheet
How to copy and paste an entire worksheet's data to another worksheet
How to copy and paste filtered data on a worksheet to make a report
How to copy and paste formulas on the worksheet, paste special discussion
How to copy and paste things that float above the worksheet like charts, pictures and drawing shapes
Things to be aware of when copying and pasting in Excel

How to Print in Microsoft Excel

How to check spelling on your worksheets and charts
How to set your printing options in Excel
How to print Microsoft Excel worksheets and charts

Beginning Excel Training Details

Audience: Business Professionals
Time: 8:30 AM - 4:30 PM
# of Days: 1-day
Type: Hands-on, live, instructor taught training
Manual: 2000 + page Microsoft Excel-Aided Business manual full of Excel tips and how-to-do topics included with the training
Platform: Windows 7 - Windows 10, Mac users welcome
Excel Versions: 2007-2016, Windows and Mac
Free Repeats: Repeat your Excel training as many times as you like, no date or limit, click here for details
Examples: We review our attendees personal examples in our training instruction
Training Formats:
- Public Training Workshop
- Live Online Course. We broadcast our Excel public training as a live hands-on online courses so even though you cannot travel to us, you can still take the course as if sitting in the room with us
- Company Onsite
- For self-study, purchase Microsoft Excel Business Essentials. For company onsite information, please contact us 1.866.924.6244
Additional Training:

Public Event / Live Online Course Signup

Click Dates|Signup

Dates | Signup

Beginning Excel Training Inquiry Information

Contact EMAGENIT Directly

Phone Number: 1.866.924.6244
Business Hours: 8:30 - 5:00 PM PT
email: adv_excel_question@emagenit.com

Your Contact Information

*Name:
Company:
Company Web:
Country:
Phone #:
Ext:
*e-mail:
	Contact me directly by phone when this is received

*Required information to complete form. Privacy Policy

Workshop Questions

Please fill out the box below with your workshop questions and EMAGENIT will contact you.

Request Workshop Information and Submit

	Send me on-site workshop information
	Send me public training workshop information
	Send me self-study manual information
	Send me live online course information

Before clicking the Submit button, please fill in at least your name and email under Your Contact Information. Privacy Policy