- No Annual Renewal Fees
- Unlimited Users
- Unlimited Printing Rights
- All Components are Completely Customizable!
Excel 2007 Essentials Courseware
Printable, customizable, training materials
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. 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 2007, 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!
This trainer's courseware kit includes everything you need to teach Excel 2007 Essentials Microsoft Office training workshops:
|
|
|
|
|
|
|
|
|
|
|
Excel 2007 Essentials Course Outline:
Module One: Getting Started
Module Two: Opening and Closing Excel
Module Three: Your First Worksheet
Module Four: Working with Excel Files
Module Five: Viewing Excel Data
Module Six: Printing Excel Data
- Icebreaker
- Housekeeping Items
- The Parking Lot
- Workshop Objectives
Module Two: Opening and Closing Excel
- Opening Excel
- Understanding the Interface
- Understanding Worksheets
- Understanding Workbooks
- Closing Excel
Module Three: Your First Worksheet
- Entering Data
- Using the Wrap Command
- Editing Data
- Adding Rows and Columns
- Checking Your Spelling
Module Four: Working with Excel Files
- About the New File Format
- Saving Files
- Publishing Files to PDF
- Closing Files
- Opening Files
Module Five: Viewing Excel Data
- An Overview of Excel’s Views
- Switching 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
Module Eight: Using Excel Functions
Module Nine: Using Time Saving Tools
Module Ten: Formatting your Data
Module Eleven: More Formatting
Module Twelve: Wrapping Up
- The Math Basics of Excel
- Building a Formula
- Editing a Formula
- Copying a Formula
- Relative vs. Absolute Referencing
Module Eight: Using Excel Functions
- Formulas vs. Functions
- Understanding the Formulas Tab
- Using the SUM Function
- Using Other Basic Excel Functions
- Using the Status Bar to Perform Calculations
Module Nine: Using Time Saving Tools
- Using AutoFill
- Using AutoComplete
- Sorting Data
- Filtering Data
Module Ten: Formatting your Data
- Changing the Appearance of Your Text
- Changing the Appearance of Numbers
- Setting Alignment Options
- Using Merge
- Removing Formatting
Module Eleven: More Formatting
- 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
Microsoft Office Training
Access 2007 AdvancedAccess 2007 Essentials
Access 2010 Advanced
Access 2010 Essentials
Access 2010 Expert
Access 2013 Advanced
Access 2013 Essentials
Access 2013 Expert
Excel 2007 Advanced
Excel 2007 Essentials
Excel 2010 Advanced
Excel 2010 Essentials
Excel 2010 Expert
Excel 2013 Advanced
Excel 2013 Essentials
Excel 2013 Expert
Excel 365 Essentials
Groove 2007 Essentials
InfoPath 2007 Advanced
InfoPath 2007 Essentials
InfoPath 2010 Advanced
InfoPath 2010 Essentials
InfoPath 2010 Expert
Lync 365 Essentials
OneNote 2007 Advanced
OneNote 2007 Essentials
OneNote 2010 Advanced
OneNote 2010 Essentials
OneNote 2013 Advanced
OneNote 2013 Essentials
OneNote 365 Essentials
Outlook 2007 Advanced
Outlook 2007 Essentials
Outlook 2010 Advanced
Outlook 2010 Essentials
Outlook 2010 Expert
Outlook 2013 Advanced
Outlook 2013 Essentials
Outlook 2013 Expert
Outlook 365 Essentials
PowerPoint 2007 Advanced
PowerPoint 2007 Essentials
PowerPoint 2010 Advanced
PowerPoint 2010 Essentials
PowerPoint 2010 Expert
PowerPoint 2013 Advanced
PowerPoint 2013 Essentials
PowerPoint 2013 Expert
PowerPoint 365 Essentials
Project 2007 Advanced
Project 2007 Essentials
Project 2010 Advanced
Project 2010 Essentials
Project 2010 Expert
Publisher 2007 Advanced
Publisher 2007 Essentials
Publisher 2010 Advanced
Publisher 2010 Essentials
Publisher 2013 Advanced
Publisher 2013 Essentials
SharePoint 365 Essentials
SharePoint Designer 2007 Essentials
SharePoint Designer 2010 Essentials
Visio 2007 Advanced
Visio 2007 Essentials
Visio 2010 Advanced
Visio 2010 Essentials
Windows 7 Essentials
Word 2007 Advanced
Word 2007 Essentials
Word 2010 Advanced
Word 2010 Essentials
Word 2010 Expert
Word 2013 Advanced
Word 2013 Essentials
Word 2013 Expert
Word 365 Essentials
Why choose Global Courseware?
|
|
Classroom ready: save hundreds of hours in prep |
|
|
Modify content to increase relevancy to your audience |
|
|
Peace of mind: professional, classroom tested presentation materials |
|
|
Print as many copies as you need, whenever you want |
|
|
Unlimited number of trainers within your organization |
|
|
Rebrand using your name and logo (and remove ours!) |
Follow us:
 |
 |
 |
|
 |
Copyright 2011 Global Courseware Privacy Policy