Free Microsoft Training


Click for Free Microsoft Office 2003, 2007, 2010 and 2013 Online Training

All Microsoft Office Training

Microsoft Office 2003, 2007, 2010 and 2013 Online Training  


 

What’s new in Microsoft Office 2013

 



What’s new in Word 2013



Download Word 2010 tips and tricks –  Training presentation 

Word 2010 Online Training course – Downloads in PowerPoint format
 

Download Office 2010 training

Article Get free, downloadable versions of many Office 2010 training courses. They’re in PowerPoint 2010 format, so you can customize them…
Word 2010, Access 2010…

Download Office 2007 training

Article Get free, downloadable versions of the following Office 2007 training courses. They’re in PowerPoint format, so you can customize them …
Word 2007, Access 2007
 
Word 2003 training courses

Article A roadmap to Word 2003 training: 1. First words Course  –  What you’ll learn Audio course: Get to know Word: Create your first document  –  How to type text and save documents…
Word 2003
 

WordMS Word           ExcelMS Excel 

PowerPointMS PowerPoint            OneNoteMS OneNote 

All Template Categories –  Office.com

> Microsoft Office Templates   

See All MS Template Categories – Agendas, Award Certificates, Brochures, Budgets, Business, Business Cards, Calendars, Databases, Business Design Slides, Faxes, Flyers, Forms, Invitations, Invoices, Job Descriptions, Labels, Letters, Memos (Memorandums), Newsletters, Planners, PowerPoint, Presentations, Reports, Résumés, Schedules, etc., etc., etc., …

  

All Microsoft Support

All Office Training  –  Office Training Online   

Microsoft Site Map 

Activate Office 

 

Microsoft saying good-bye to Hotmail – CNET Update

Outlook.com e-mail – First Look

 

Outlook Help 

Outlook 2007 Demo: Preview your messages 

 

 

Word

 

PowerPoint

 

PowerPoint 2007 Layer Demo:  Layering Items/Pictures – Layered Selection Pane 

 

 

Excel 

 A spreadsheet is a computer application that simulates a paper, accounting worksheet.

OpenOffice.org Calc spreadsheet

A spreadsheet is a computer application that simulates a paper, accounting worksheet.

It displays multiple cells usually in a two-dimensional matrix or grid consisting of rows and columns. Each cell contains alphanumeric text, numeric values or formulas. A formula defines how the content of that cell is to be calculated from the contents of any other cell (or combination of cells) each time any cell is updated.

Spreadsheets are frequently used for financial information because of their ability to re-calculate the entire sheet automatically after a change to a single cell is made.

A pseudo third dimension to the matrix is sometimes applied as another layer, or layers/sheets, of two-dimensional data. 

Lotus 1-2-3 was the leading spreadsheet when DOS was the dominant operating system. Excel now has the largest market share on the Windows and Macintosh platforms.

Paper spreadsheets

The word “spreadsheet” came from “spread” in its sense of a newspaper or magazine item (text and/or graphics) that covers two facing pages, extending across the center fold and treating the two pages as one large one.

The compound word “spread-sheet” came to mean the format used to present book-keeping ledgers—with columns for categories of expenditures across the top, invoices listed down the left margin, and the amount of each payment in the cell where its row and column intersect—which were, traditionally, a “spread” across facing pages of a bound ledger (book for keeping accounting records) or on oversized sheets of paper ruled into rows and columns in that format and approximately twice as wide as ordinary paper.


Template: Training presentation: Excel 2007—Create your first workbook

This template contains training content that teaches newer Microsoft Office Excel 2007 users the basic skills they’ll need to create their first workbook.

See more Microsoft Office 2007 training presentations


 Crabby goes chart crazy with Excel 2007

Crabby Office Lady goes chart crazy with Excel 2007 Crabby Office Lady

Summing up large quantities of information used to be time-consuming and daunting if you were unfamiliar with how to put it all together, particularly if you had to do it with a chart. Excel 2007 has made such huge improvements in the area of charts that you may find yourself making all sorts of charts for no apparent reason…other than it’s fun.

Below is an example of the chart I created for data I looked at for the months of August 2006, September 2006, and October 2006.

Excel 2007 chart with Crabby's information


Charts make data visual. Instead of having to analyze columns of worksheet numbers, you can see at a glance what the data means.  


Basic chart

In Excel 2007 you can make a chart in about 10 seconds, which you’ll see how to do in just a bit. 

Goals

After completing this course you will be able to:

  • Create a chart using the new Excel 2007 commands.
  • Make changes to a chart after you create it.
  • Understand basic chart terminology.

Excel 2007:  Simple Formulas 

 

Microsoft Excel Resources – Pivot Tables

Excel 2007 training courses  –  Excel 2007 – Create PivotTable reports 

 
A PivotTable report 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.

 

Tour Of Excel: Formulas, Formatting, Sort, Filter, PivotTables, Charts, Keyboards  

Excel is Fun!  How to build efficient systems of spreadsheets to save time, get promoted and have extra time for vacation.

Uploaded by on May 19, 2011

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm (all the way at bottom in the “Other Excel Series” section)

Highline Community College Science Seminar: The Wonders Of Excel, May 20, 2011

Learn about the wonders of what excel can do with a tour of the different things that Excel can do:
1 Copy & Paste Special (2 Examples) (00:48 minute mark)
2 Keyboard Magic (3 Examples) (03:45 minute mark)
3 Number Format (06:03 minute mark)
4 Decimal (6:11 minute mark)
5 Date (5 Examples) (07:32 minute mark)
6 Percentage (15:02 minute mark)
7 Formulas and Relative Cell References (18:26 minute mark)
8 Formulas and Absolute Cell References (2 Examples) (21:47 minute mark)
9 Sorting (4 Examples) (27:27 minute mark)
10 Filtering (32:27 minute mark)
11 PivotTables (2 Examples) (35:19 minute mark)
12 Charts (6 Examples) (43:31 minute mark)

 
 
 

1 Comment (+add yours?)

  1. violetflowerz
    Nov 19, 2012 @ 21:40:58

    Thank you Lyennette for this wonderful site

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: