Online Training for Microsoft Products
| Access 2007 | Excel 2007 |
Excel 2007
Fundamentals | Intermediate | Advanced
Fundamentals
| Lesson 1 - Getting Started | ||
|---|---|---|
| 1.1 - Starting Out | Step-by-step Exercise | |
| 1.2 - About Workbooks | Step-by-step Exercise | |
| 1.3 - Exploring your Workbook | Step-by-step Exercise | |
| 1.4 - Getting Help in Excel 2007 | Step-by-step Exercise | |
| Lesson 2 - The New Interface | ||
| 2.1 - The Quick Access Toolbar | ||
| 2.2 - The Home Ribbon | ||
| 2.3 - The Insert Ribbon | ||
| 2.4 - The Page Layout Ribbon | ||
| 2.5 - The Formulas Ribbon | ||
| 2.6 - The Data Ribbon | Step-by-step Exercise | |
| 2.7 - The Review Ribbon | Step-by-step Exercise | |
| Lesson 3 - Excel Basics | ||
| 3.1 - Working with Excel 2007 | Step-by-step Exercise | |
| 3.2 - Basic Excel Features | ||
| 3.3 - Moving your Data | ||
| 3.4 - Smart Tags and Option Buttons | Step-by-step Exercise | |
| 3.5 - Editing Tools | ||
| Lesson 4 - Editing your Workbook | ||
| 4.1 - Modifying Cells and Data | ||
| 4.2 - Cell Formatting | ||
| 4.3 - Enhancing a Worksheet's Appearance | ||
4.4 - Working with Charts | ||
| 4.5 - Working with Charts, Part 2 | ||
| Lesson 5 - Printing and Viewing your Workbook | ||
| 5.1 - Using the View Ribbon | ||
| 5.2 - Managing a Single Window | ||
| 5.3 - Managing Multiple Windows | Step-by-step Exercise | |
| 5.4 - Printing your Workbook | ||
| Lesson 1 - Advanced File Tasks | ||
|---|---|---|
| 1.1 - Using My Computer within Excel | Step-by-step Exercise | |
| 1.2 - Saving Your Files | ||
| 1.3 - Using Templates | ||
| Lesson 2 - Working with Functions and Formulas | ||
| 2.1 - Using Formulas in Excel | ||
| 2.2 - Exploring Excel Functions | ||
| 2.3 - Using Functions in Excel | ||
| 2.4 - Working with Names and Ranges | ||
| 2.5 - Working with Array Formulas | ||
| Lesson 3 - Managing Tables | ||
| 3.1 - Working with Tables | Step-by-step Exercise | |
| 3.2 - Working with Records and Fields | ||
| 3.3 - Working with Tables and Filters | ||
| 3.4 - Using Excel as a Database | ||
| Lesson 4 - Enhancing your Workbook | ||
| 4.1 - Customizing your Workbook | Step-by-step Exercise | |
| 4.2 - Working with Text Boxes | Step-by-step Exercise | |
| 4.3 - WordArt | Step-by-step Exercise | |
| 4.4 - ClipArt | ||
| 4.5 - Using Objects | Step-by-step Exercise | |
| Lesson 5 - Finalizing your Workbook | ||
| 5.1 - Protecting your Workbook | ||
| 5.2 - Finishing your Workbook | ||
| 5.3 - Using Excel in Word | ||
| 5.4 - Using Excel and Access | ||
| 5.5 - Using Excel with other Programs and Files | Step-by-step Exercise | |
| Lesson 1 - Advanced Topics | ||
| 1.1 - Setting Excel Options | Step-by-step Exercise | |
| 1.2 - Excel and Windows | Step-by-step Exercise | |
| 1.3 - Using the Excel Viewer | ||
| Lesson 2 - Getting the Most from your Data | ||
| 2.1 - Getting the Most from your Data | ||
| 2.2 - PivotTables | ||
| 2.3 - More about PivotTables | ||
| 2.4 - Exploring Scenarios | ||
| 2.5 - What-if Analysis | ||
| Lesson 3 - Excel and the Internet | ||
| 3.1 - Excel and Hyperlinks | ||
| 3.2 - Saving Workbooks as Web Pages | ||
| 3.3 - Getting Data from the Internet | Step-by-step Exercise | |
| 3.4 - Excel and Office Servers | ||
| Lesson 4 - Advanced Excel Tasks | ||
| 4.1 - Creating and Using Shared Workbooks | ||
| 4.2 - Using Custom Auto-Filled Lists | Step-by-step Exercise | |
| 4.3 - Using the VLOOKUP Function | ||
| 4.4 - Linking, Consolidating, and Combining Workbooks | ||
-
Helpdesk
-
Team55
-
Training
325-674-2962
training@acu.edu
Training Website -
Check Status of Systems
Connect Online
