| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Stop wasting time looking for files and revisions! Dokkio, a new product from the PBworks team, integrates and organizes your Drive, Dropbox, Box, Slack and Gmail files. Sign up for free.

View
 

Excel

Page history last edited by Susan Jazwiec 5 years, 5 months ago

 

Videos

Graphs

 

 

 

Creating a Database

 

Mail Merge Excel

 

Excel 2007 training courses

 

A roadmap to Excel 2007 training:

 

1. Get familiar with Excel

Course overview art

Up to speed with Excel 2007 
The layout of the new design, how to accomplish everyday tasks in Excel 2007, and a bit about the new XML file formats

Course overview art

Get to know Excel 2007: Create your first workbook 
How to create a workbook, enter and edit text and numbers, and add rows or columns

Overview art

Get to know Excel 2007: Enter formulas 
How to enter simple formulas into worksheets, and how to make formulas update their results automatically

A conceptual view of Excel

Learn how to figure out dates using formulas in Excel 2007 
How to find the number of days between dates, or the date after a number of workdays, or the date after a number of days, months, or years

 

2. Create charts in Excel

Excel chart

Charts I: How to create a chart in Excel 2007 
How to create a chart using the new Excel 2007 commands and make changes to a chart after you create it

 

3. Create PivotTable reports

Course overview art

PivotTable I: Get started with PivotTable reports in Excel 2007 
How PivotTable reports organize, summarize, and analyze your data to reveal its meanings. How to create a PivotTable report yourself — fast!

Filter on PivotTable report

PivotTable II: Filter PivotTable report data in Excel 2007 
How to filter to hide and display selected data in PivotTable reports

Numbers and a PivotTable report

PivotTable III: Calculate data in PivotTable reports in Excel 2007 
Power tools: how to summarize data by using summary functions other than SUM, such as COUNT and MAX. How to show data as a percentage of the total by using a custom calculation. How to create your own formulas in PivotTable reports.

4. Share data with other people

Hands reaching for data

Share Excel data with others by exporting it to a SharePoint site 
How to export data to your SharePoint, where more than one person at a time can make revisions to the data

Person looking at an Excel spreadsheet in Excel Services on the Web

Excel Services I: The basics 
What Excel Services is, and how to share data with others by publishing Excel spreadsheets to a SharePoint site based on SharePoint Server 2007 Enterprise

SharePoint permission groups: Owners, Members, Visitors, and Viewers

Excel Services II: Requirements, recommendations, and permissions 
How SharePoint permissions can be set so that some people can edit Excel Services spreadsheets, while other can only view them

A conceptual view of private data in an Excel spreadsheet.

Excel Services III: Control what people see 
How to share data in Excel services and at the same time, how to hide data that you do not want people to see

A conceptual image of entering data in Excel Services

Excel Services IV: Allow user input 
How to allow people to do calculations in Excel Services

5. Learn general Office skills

Use the keyboard in the 2007 Office system

Keyboard shortcuts in the 2007 Office system 
The brand-new look of the 2007 Microsoft Office system, with new and easier ways to use the keyboard

A lock

Security I: How the 2007 Office system helps you to stay safer 
How to help protect your data, your computer, and yourself from risk

learn how to turn off the message bar

Security II: Turn off the Message Bar and run code safely 
Learn how to turn off the Message Bar and its security warnings

Security images

Security III: Sign your own macros for stronger security 
Signing your own macros will reduce the number of security warnings you see while still maintaining a high security level

xml document

Office Open XML I: Exploring the Office Open XML Formats 
The new Office Open XML Formats, the basics of working with them, and the XML structure behind documents

Edit with and XML zip file

Open XML II: Editing Documents in the XML 
Learn the basics of how to edit document content and troubleshoot document issues directly 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

 

 

Wonderful sites and activities

http://www.microsoft.com/Education/CreateTimeline.mspx

 

http://learntech.ties.k12.mn.us/Excel_Classroom_Projects

 

http://www.teacher2teacher.com/index.php?loc=excel

 

Align Cells in Excel 2007

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

Edit Data in Excel 2007

Enter Data in Excel 2007

Format Cell Text in Excel 2007

Format Numbers in Excel 2007

Freeze Panes 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

Split Panes 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

Use the Mini Toolbar in Excel 2007

Using Document Themes in Excel 2007

Comments (0)

You don't have permission to comment on this page.