Excel 2010 Essentials

Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. The participants will learn how to use the basic features of Excel 2010. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the basic features right on a computer.
With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information – and better information leads to better decision making!

Course Outline

Module One: Getting Started
• Icebreaker
• Housekeeping Items
• The Parking Lot
• Workshop Objectives

Module Two: Opening and Closing Excel
• Opening Excel
• Understanding the Interface
• Using Backstage View
• Understanding Worksheets
• Understanding Workbooks

Module Three: Your First Worksheet
• Entering Data
• Editing Data
• Using the Wrap Command
• Adding Rows and Columns
• Checking Your Spelling

Module Four: Working with Excel Files
• Saving Files
• Publishing Files to PDF
• Sending Files via E-Mail
• Closing Files
• Opening Files

Module Five: Viewing Excel Data
• An Overview of Excels Views
• Switching Views
• Creating Custom Views
• Using Zoom
• Switching Between Open Files

Module Six: Printing Excel Data
• An Overview of the Page Layout Tab
• Setting Up Your Page
• Using Print Preview
• Printing Data

Module Seven: Building Formulas
• The Math Basics of Excel
• Building a Formula
• Editing a Formula
• Copying a Formula
• Relative vs. Absolute References

Module Eight: Using Excel Functions
• Formulas vs. Functions
• Using the SUM Function
• Using Other Basic Excel Functions
• Understanding the Formulas Tab
• Using the Status Bar to Perform Calculations
• Understanding the New Function Names

Module Nine: Using Time Saving Tools
• Using AutoFill
• Using AutoComplete
• Sorting Data
• Filtering Data
• Adding Sparklines

Module Ten: Formatting Your Data
• Changing the Appearance of Text
• Changing the Appearance of Numbers
• Setting Alignment Options
• Using Merge
• Removing Formatting

Module Eleven: Advanced Formatting Tools
• Adding Borders
• Adding Fill Color
• Using Cell Styles
• Using Conditional Formatting
• Changing the Theme

Module Twelve: Wrapping Up
• Words from the Wise
• Review of Parking Lot
• Lessons Learned
• Completion of Action Plans and Evaluations