Graphs
Creating a Database
Mail Merge Excel
Up to speed with Excel 2007 |
|
Get to know Excel 2007: Create your first workbook |
|
Get to know Excel 2007: Enter formulas |
|
Learn how to figure out dates using formulas in Excel 2007 |
Charts I: How to create a chart in Excel 2007 |
PivotTable I: Get started with PivotTable reports in Excel 2007 |
|
PivotTable II: Filter PivotTable report data in Excel 2007 |
|
PivotTable III: Calculate data in PivotTable reports in Excel 2007 |
Share Excel data with others by exporting it to a SharePoint site |
|
Excel Services I: The basics |
|
Excel Services II: Requirements, recommendations, and permissions |
|
Excel Services III: Control what people see |
|
Excel Services IV: Allow user input |
Keyboard shortcuts in the 2007 Office system |
|
Security I: How the 2007 Office system helps you to stay safer |
|
Security II: Turn off the Message Bar and run code safely |
|
Security III: Sign your own macros for stronger security |
|
Office Open XML I: Exploring the Office Open XML Formats |
|
Open XML II: Editing Documents in the XML |
Note You can also download shorter PowerPoint versions of some Excel 2007 and general office training courses and use them as training for yourself or a group.
Create a Timeline
http://www.microsoft.com/Education/CreateTimeline.aspx
Display Fractions
http://www.microsoft.com/education/DisplayFractions.aspx
Pictograph
http://www.microsoft.com/education/CreatePictograph.aspx
Charts
http://www.dummies.com/how-to/content/how-to-create-a-graph-in-excel-2007.html
Pie Chart
"What If" scenarios
http://www.microsoft.com/Education/excelscenario.aspx
Create Data
http://www.microsoft.com/Education/datasets.aspx
http://www.microsoft.com/Education/CreateTimeline.mspx
http://learntech.ties.k12.mn.us/Excel_Classroom_Projects
http://www.teacher2teacher.com/index.php?loc=excel
Apply a Cell Style in Excel 2007
Apply a Table Style in Excel 2007
Change a Theme Effect in Excel 2007
Clear Recent Documents in Excel 2007
Compare Windows Side by Side in Excel 2007
Create a Custom Cell Style in Excel 2007
Create a Custom Date or Time Format in Excel 2007
Create a Custom Number Format in Excel 2007
Create a Custom Series in Excel 2007
Create a Custom Table Style in Excel 2007
Create Custom Lists in Excel 2007
Create New Theme Colors in Excel 2007
Customize the Quick Access Toolbar in Excel 2007
Customize the Status Bar in Excel 2007
Define a Cell Name in Excel 2007
Delete a Custom Number or Date Format in Excel 2007
Delete a Worksheet in Excel 2007
Format Cell Text in Excel 2007
Group Worksheets in Excel 2007
Insert a New Worksheet in Excel 2007
Manage Defined Names in Excel 2007
Merge and Center in Excel 2007
Modify a Cell Style in Excel 2007
Move or Copy a Worksheet in Excel 2007
Name a Worksheet in Excel 2007
Navigate the Excel 2007 Workspace
Organize Worksheets in Excel 2007
Set a Default Table Style in Excel 2007
Turn Off the Mini Toolbar in Excel 2007
Use Custom Views in Excel 2007
Use Multiple Windows in Excel 2007
Use Paste Special in Excel 2007