- No Annual Renewal Fees
- Unlimited Users
- Unlimited Printing Rights
- All Components are Completely Customizable!
Excel 365 Essentials Courseware
Printable, customizable, training materials
Welcome to the Office 365 Excel Essentials workshop. With Office 365, you can access your spreadsheets anywhere, and make some basic changes without using a computer where your desktop Office applications are installed. In the Office 365 Excel web app, you can collaborate on a spreadsheet with anyone, no matter what version of Excel they have, and your changes are automatically saved.
The Office 365 experience is designed to render your documents to look exactly like they would when printed, from nearly anywhere in the world. This tool provides its users the freedom to work from anywhere.
This trainer's courseware kit includes everything you need to teach Excel 365 Essentials Microsoft Office training workshops:
|
|
|
|
|
|
|
|
|
|
|
Excel 365 Essentials Course Outline:
Module One: Getting Started
Module Two: Welcome to Office 365 Excel
Module Three: Worksheets and Workbooks
Module Four: Working with Excel Files
Module Five: Editing in the Browser (I)
Module Six: Editing in the Browser (II)
- Icebreaker
- Housekeeping Items
- The Parking Lot
- Workshop Objectives
Module Two: Welcome to Office 365 Excel
- The Home Page
- The Team Site
- Shared Documents
- Uploading a Spreadsheet
- Module Two: Review Questions
Module Three: Worksheets and Workbooks
- Opening a Spreadsheet
- Overview of the Reading View
- Understanding Worksheets vs. Workbooks
- Downloading and Reloading
- Closing Spreadsheets
- Module Three: Review Questions
Module Four: Working with Excel Files
- Using the Find Command
- Saving a Copy
- Editing in Browser
- The Excel Web App Interface
- Opening in Excel
- Module Four: Review Questions
Module Five: Editing in the Browser (I)
- About Saving and Save As
- A New File and Autosaving
- Entering Data
- Editing Data
- Using the Wrap Command
- Module Five: Review Questions
Module Six: Editing in the Browser (II)
- Using Undo and Redo
- Adding Rows and Columns
- Deleting Cells
- Using Timesaving Shortcuts
- Module Six: Review Questions
Module Seven: Building Formulas
Module Eight: Understanding Functions
Module Nine: Working with Data
Module Ten: Formatting Your Data
Module Eleven: The Insert Tools
Module Twelve: Wrapping Up
- The Math Basics of Excel
- Building a Formula
- Editing a Formula
- Copying a Formula
- Relative vs. Absolute References
- Module Seven: Review Questions
Module Eight: Understanding Functions
- Formulas vs. Functions
- Using the SUM Function
- Using Other Basic Excel Functions
- Using AutoComplete
- Module Eight: Review Questions
Module Nine: Working with Data
- Sorting Data
- Filtering Data
- About Collaborating
- About Refreshing External Data
- Module Nine: Review Questions
Module Ten: Formatting Your Data
- Changing the Appearance of Text
- Changing the Appearance of Numbers
- Setting Alignment Options
- Adding Borders
- Adding Fill Color
- Module Ten: Review Questions
Module Eleven: The Insert Tools
- Inserting Tables
- Inserting Charts
- Working with Charts
- Inserting Links
- Module Eleven: Review Questions
Module Twelve: Wrapping Up
- Words from the Wise
- Review of the 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