Choose your timezone
Register Below or Call (888) 804-1132
and Talk to a Training Specialist Today
$50 off each course when you book more than one course or more than one person per course. Discount will be applied at checkout.
Class sizes are kept small for a better learning experience. Limited to 15 people per class.
Have more than 6 people for a course? Call us at (888) 804-1132 and ask about our group rates.Want to run this as a private class for your team? Enquire about running this event as a private class
Description
This course provides the basic concepts and skills to start being productive with Microsoft Excel: How to create, save, share, and print worksheets that contain various kinds of calculations and formatting.
Excel Essentials
- Identifying Parts of the Screen
- The Ribbon
- Opening/Creating a Workbook
- Selection Techniques
- Entering Data
- Quickly Adjusting Column Width
- Finishing a Workbook
Performing Basic Calculations
- Creating Simple Formulas
- Using Functions - SUM, AVERAGE, MIN, MAX, COUNT
- Learning Function Syntax with PMT
- Using the AutoSum Button
- Editing Data on the Worksheet
- Clearing the Contents from a Cell or Range
- Defining Relative, Mixed, and Absolute References
- Copying Formulas
Managing the Worksheet
- Navigating in a Worksheet
- Changing the Worksheet Structure
- Deleting Cells, Rows, and Columns
Formatting a Worksheet
- Moving and Copying Data
- Using AutoFill
- Changing the Appearance of Data
- Changing Row Height
- Formatting Numbers, Text, and Dates
Adding Enhancements
- Aligning Data in Cells
- Merging and Centering Cells
- Rotating and Indenting Text
- Adding Borders and Shading
- Adding Graphic Elements
Printing a Worksheet/Workbook
- Printing the Worksheet
- Working with Headers and Footers
- Using Advanced Printing Techniques
- Aligning the Printout
- Fitting a Document onto a Desired Number of Pages
- Working with Page Breaks
- Repeat Title Rows on Each Page
Prerequisites
The course assumes you know how to use a computer and that you're familiar with Microsoft Windows. It does not assume that you've used a different version of Excel or another spreadsheet program before.
Who should attend?
Those who want to accomplish basic workplace tasks in Excel, or if you want to have a solid foundation for continuing on to become an Excel expert.
