Free Microsoft Office Training and Tutorial Resources


February 19, 2011

Excel Functions and Formulas Help and Support

Here are 7 Excel resources that explain and show how to use Excel Functions, Formulas, and some Advances Techniques. One of Excel’s most useful features is that it allows users to create custom formulas to perform calculations on their data. Excel also contains built-in formulas called functions that make it easy to perform common calculations on data.

How to Create Custom User Defined Excel Functions
Excel allows you to create custom functions, called “User Defined Functions” (UDF’s) that can be used the same way you would use SUM() or some other built-in Excel function.

Excel Functions
Provides information and examples of Excel spreadsheet functions and topics such as graphs, testing and short cuts.
  - Functions and Calculations
- IF, conditions and selecting
- Formatting Cells and Values
- Dates and Times
- Sharing data with other programs
- Reference, Input and Navigation
- Auditing and other stuff

Excel Function Reference
Create your own worksheet functions
Go with the cash flow: Calculate NPV and IRR in Excel
List of worksheet functions (by category)
Using worksheet functions for quality control
Creating custom functions
Database Functions
Date and Time Functions
Engineering Functions
External Functions
Financial Functions
Information Functions
Logical Functions
Lookup Functions
Math Functions
Statistical Functions
Text and Data Functions
Basic Excel
Built-In Functions
Text Functions
Logical Functions
Information Functions
Date & Time Functions
Lookup & Reference Functions
Math Functions
Statistical Functions
Database Functions
Financial Functions
Engineering Functions
Excel Vlookup Tutorial
Pivot Table Tutorial
Excel Formulas
Array Formulas
Tips & Tricks
Common Excel Errors
Excel Templates
Excel Macros
Excel VBA Tutorial

Excel Formulas and Functions
Here you will find step by step tutorials, tips and shortcuts on how to use formulas and the common and less common functions available in Excel. Excel 2010 Functions (48)
IF Functions (14)
Count Functions (8)
Date Functions (15)
Logical Functions (4)
Math Functions (13)
Text Functions (10)
Rounding Number Functions (9)
Excel 2003 Functions (20)
Random Number Functions (3)
Trig Functions (5)
Lookup Functions (11)
Statistical Functions (14)
Information Functions (5)
Engineering Functions (1)
Financial Functions (2)
Basic Excel 2007 Spreadsheet Tutorial
This tutorial covers creating a basic spreadsheet in Excel 2007. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.

Excel Function Dictionary
This Excel Function Dictionary contains over 150 examples of functions.

Advanced excel tips, Excel tools, Excel reporting applications, and Excel add-ins.

Tags for this post>> | |

January 30, 2011

2 Excel 2007 Quick Reference Cards

Here are 2 Excel 2007 Quick Reference Cards, covering many of the important features and functionality of Excel that you need to know to start using Excel like an expert or to refer to when you need a little Excel help.

Quick Reference card: Getting Started with Excel 2007

 - Working with Workbooks
 - Entering Data
 - Moving and Copying Cells
 - Entering Formulas
 - Entering Functions
 - Inserting Functions
 - Formatting Cells
 - Merging and Unmerging Cells
 - Inserting Columns or Rows
 - Deleting Columns or Rows
 - Creating Charts
 - Editing a Chart
 - Printing a Worksheet
 - Page Setup Features

Quick Reference card: Doing More with Excel 2007

 - Using AutoFill
 - Setting a Custom Auto-Fill Series
 - Using Paste Special
 - Selecting Non-contiguous Cells
 - Entering the same data in many cells at once
 - Absolute & Relative References
 - Customizing Toolbars
 - Freezing Panes
 - Setting Print Titles and Print Area
 - Controlling Page Breaks
 - Sorting Data
 - Filtering Data

Tags for this post>> |

January 27, 2011

Excel 2003 Reference Guide

Here is a well written, detailed, and illustrated Excel 2003 Reference Guide. The important features taught by this reference tutorial are listed below. This document will show you how to perform Excel tasks that will help you work with and manage your data, perform math functions and formulas, and do some database functions. (26 pages, 1.1 mb, pdf file)

Contents of Excel 2003 Reference Guide:
 - Working with and Managing Excel Workbooks, Worksheets, and Cells
 - Saving Workbook
 - Changing Options
 - Display Toolbars
 - Entering and Editing Cell Data
 - Controlling Row Height
 - Inserting Cells, Rows. and Columns
 - Selecting with Shift and Control Keys
 - Moving Cells and Worksheets
 - Using other Sheets in the Workbook
 - Page Setup
 - Working with Headers and Footers
 - Excel Help
 - Printing from Excel
 - Templates
 - Autofill b y Example
 - Cell References
 - Excel Formulas
 - Auto Calculate
 - start with page 13, right side

Tags for this post>> |

January 24, 2011

3 Excel 2007 Training Sessions

Here are 3 Excel 2007 Training Sessions, each providing a Tutorial and Workshop Manual, from Hillsborough Community College. These Excel training sessions provide free learning materials for many important Excel features and functionality. The tutorials and manuals have screen shots to demonstrate each feature taught. The first Excel training session shows how to open and save worksheets, print them, format cells, insert rows and columns, and use and work with formulas and charts. The second Excel training session teaches currency and percent formatting, inserting charts and graphics, using the IF statement, autoformatting a worksheet, conditional formatting of a worksheet, and sharing a worksheet. The third Excel training session demonstrates how to use and work with pivot tables and macros.

Excel Animated Tutorial Excel 1

Unit 1: Navigating Excel 2007
Unit 2: Open, Save
Unit 3: Page Setup and Print
Unit 4: Format Cells
Unit 5: Insert Row, Column or Sheet
Unit 6: Formulas
Unit 7: Charts

Excel Workshop Manual 1
(35 pages, 1.3mb, pdf)

 - Overview
 - Ribbon (Toolbar)
     Home Tab
     Insert Tab
     Page Layout Tab
     Formulas Tab
     Data Tab
     Review Tab
     View Tab
 - Parts of a Worksheet
 - Open an Existing Workbook
 - Save a Workbook
 - Page Setup
 - Print Preview and Print
 - Insert a Row, Column or Worksheet
 - Format a Cell
     Merging Cells
     Text Orientation
     Change the Font
 - Formulas
 - Types of Charts
 - Create a Chart
 - Customize a Chart

Upon completion of Excel training 1, you will be able to:

  1. Use the Office Button and Ribbon tabs;
  2. Know the parts of an Excel worksheet;
  3. Know how to open and save a workbook;
  4. Use the Page Setup Dialog box;
  5. Insert a row, column, or worksheet;
  6. Format a cell;
  7. Change the font type, style, size and color of a cell or range of cells;
  8. Create a border around a range of cells;
  9. Use basic Excel formulas;
  10. Know how to create and customize a chart.

Excel Animated Tutorial 2

Unit 1:  Automatically Number Rows and Sort
Unit 2:  Formatting Cells – Currency & Percent
Unit 3:  Inserting Charts & Graphics
Unit 4:  Create IF Statement
Unit 5:  Insert a Comment
Unit 6:  AutoFormat a Worksheet
Unit 7:  Conditional Format a Worksheet
Unit 8:  Share a Workbook

Excel Workshop Manual 2
(22 pages, 570kb, pdf)

 - Automatically Number Rows
 - Sort the worksheet
 - Format Cells – Currency
 - Format Cells – Percent
 - Insert Tables or Charts into other Office docs
 - Insert Graphics
 - Create IF statement
 - Insert a Comment
 - AutoFormat a Worksheet
 - Conditionally Format a Worksheet
 - Format the Header and Footer
 - Share a Workbook

Upon completion of Excel training 2, you will be able to:
  1. Automatically number rows;
  2. Sort the worksheet;
  3. Format the cells to currency;
  4. Format the cells to percent;
  5. Insert a chart into another Microsoft Offi ce Document;
  6. Insert a graphic into a worksheet;
  7. Create IF Statements;
  8. Insert a comment into a worksheet;
  9. Use autoformat to format the body of a worksheet;
  10. Use conditional formatting to format the body of a worksheet;
  11. Format the header and footer of a worksheet;
  12. Set up a workbook to be shared simultaneously

Excel Animated Tutorial 3

Unit 1: Create a PivotTable
Unit 2: Populate PivotTable with Data
Unit 3: Create a PivotTable Chart
Unit 4: Record and Run a Macro
Unit 5: Create a Macro Shortcut
Unit 6: View Macro in the VB Script Editor 

Excel Workshop Manual 3
(25 pages, 1.0mb, pdf)

 - PivotTable
     Create a PivotTable
     PivotTable Layout Area
     PivotTable Tools Options Tab
     Populate PivotTable with Data
     Change Summary Calculation
     Add Data and Pivot a PivotTable
     Rename Data Headings
     Remove Data from PivotTable
     Report Filter
     Group and View Underlying Data
     Create a Chart
     Format a Report
 - Macros
     Security Setting
     Record and Run a Macro
     Create a Macro Shortcut
     Record a Macro to Alter Format
     View Macro in the VB Script Editor

Upon completion of Excel training 3, you will be able to:
  1. Understand the purpose of a PivotTable;
  2. Choose the correct data source for the PivotTable;
  3. Choose the information desired on the PivotTable;
  4. Modify Pivot Table layout;
  5. Group and view data within a PivotTable;
  6. Create a chart from a PivotTable;
  7. Format a report from a PivotTable;
  8. Understand the purpose of a macro;
  9. Plan and record a macro;
  10. Record a macro;
  11. Run a macro;
  12. Assign a macro to a button.

Tags for this post>> |
October 21, 2010

60 Excel 2007 Tutorials

Here are 60 Excel 2007 Tutorials, hosted by the University of Wisconsin – Eau Claire. These will help you understand and learn how to use Excel’s spreadsheets, cells, rows, and columns, and also teach these Excel features: printing options and layouts, paste special, find and replace, hiding columns and rows, separating cell data, sorting data, tables and databases, navigating, calculations, charting, functions, and clip art. These tutorials are available for both Windows and Macintosh platforms.

Working with Excel

Printing with Excel

Special Features

Working with Tables and Databases – Windows:

Working with Tables and Databases – Macintosh:

Managing Your Excel Worksheet

Charting with Excel

Favorite Excel Functions

Inserting Clip Art

Excel Gradebook
Using Microsoft Office Help

Tags for this post>> |
July 2, 2010

55 Excel 2007 Training Tutorials

Here are 55 great Excel 2007 Training Tutorials, hosted by AgileConcepts. These include 11 Excel 2007 Video Training Modules. These free Excel training materials are in Word (docx), PowerPoint (pptx), and Windows Media (wmv) file formats. Included are18 beginning, 24 intermediate, and 13 advanced tutorials, all of which provide an excellent overview and learning opportunity for mostl of Excel’s important features and tools, from the very beginning to more advanced topics, including charting, pivot tables, formulas, functions, sorting, and filtering. You can also use the search form to help you find what features and tasks you are looking to learn more about.

18 Beginning Excel 2007 Tutorials:
(docx) Display or Hide Chart Gridlines
(docx) Change a Chart Type
(docx) Changing the font face and size in Excel
(wmv) Creating Charts- visualize raw data in an attractive format
(docx) Creating or deleting Formulas
(docx) Define Worksheet Print Area
(docx) Designing effective Cell Styles in Excel 2007
(pptx) Editing Data, Remove Formatting, and Revise Worksheets
(pptx) Entering Text, Number and Date data into Cells
(wmv) Hiding and Unhiding Rows
(pptx) Introduction to Excel, Create a Worksheet and Workbook
(docx) Print and Adjust Gridlines in aWorksheet
(docx) Set Worksheet Page Margins
(docx) Using Automatic Formatting to format text as you type.
(docx) Using Chart Templates
(pptx) What’s new in Excel 2007: Ribbon, New Commands, and other New Features
(docx) Working with Gridlines
(pptx) Worksheet basics: Format data, Create Columns and Footers, and Printing

24 Intermediate Excel 2007 Tutorials:
(pptx) Calculate Dates using Formulas
(docx) Changing Cell Styles in Excel
(docx) Converting Numbers Stored as Text into Actual Numbers.
(docx) Copying Excel Data to PowerPoint
(docx) Copying Excel Data to Word
(docx) Create a Chart in Excel
(docx) Create conditional formulas
(docx) How to Create and Customize Charts
(pptx) Creating Charts – customize charts and use charting tools
(pptx) Customizing Charts – formatting titles and columns
(docx) Filter data in a range or table
(wmv) Freezing and unfreezing Panes of Rows and Columns
(docx) Guidelines and examples for Sorting and Filtering Data by Color and Icons
(pptx) How Excel Handles and Stores Dates
(pptx) Introduction to Excel Formulas, totaling values
(docx) Insert and Modify Page Breaks in Worksheets
(docx) Reapply a Filter and Sort
(pptx) Simplify Formulas by using Functions
(docx) Sort Data in a Range or Table
(docx) Ten Ways to Clean Up Your Data
(pptx) The new Excel file format
(pptx) How to Use Cell References in Formulas
(docx) Using Chart Template to create publication-ready Charts
(docx) Using the Format Painter to copy formatting from one section of worksheet to another

13 Advanced Excel 2007 Tutorials:
(pptx) Calculations in Excel Services
(docx) Combining Text and Numbers in Excel
(docx) Conditional Formatting in Excel
(docx) Excel 2007 Worksheet Functions, by category
(pptx) Excel Services control content that users can see
(pptx) Exporting to a SharePoint site
(docx) Filter by using  Criteria
(pptx) How to create PivotTables, how they work and why they are needed
(docx) Summary of PivotTable Functions
(docx) Summing up ways to Sum up Data in Excel
(wmv) Using Conditional Formatting in reports
(wmv) Using Pivot Tables for analyzing complicated worksheets
(docx) Guide to Using Excel Shortcut and Function Keys

Tags for this post>> |

May 3, 2010

2 Excel 2007 Quick References and 45 Flashcards

Here are  2 Excel 2007 Quick References, and also 45 Excel 2007 Flashcards with answers. Each quick reference document lists Excel tasks or features to be performed along with their corresponding commands or menu items using the Mouse, the Ribbon, the Shortcut Menu, and Keyboard Shortcuts. The first quick reference lists about 85 Excel 2007 tasks, and the second one details out about 140 tasks.

 - Excel 2007 Quick Reference 1  (5 pages, pdf format, 175kb)

 - Excel 2007 Quick Reference 2  (8 pages, pdf format, 167kb)

Update 5/11/2010: This MS Office training site also provides the following free Excel 2007 Flashcards, Practice Tests with answers, and Learning Games:

Chapter 1:
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 2:
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 3:
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 4:
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 5:
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 6:
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 7:
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 8:
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 9:
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Tags for this post>> |

April 21, 2010

4 Excel eBooks, 6 Access eBooks, and 1 Visio eBook

This computer ebook site hosts 11 Office eBooks: 4 Excel ebooks, 6 Access ebooks, and 1 Visio ebook. To find these ebooks, simply do a Find command in your browser (Edit->Find on menu, or Ctl+F) and type in the keyword ‘Excel’, ‘Access’, or ‘Visio’.

4 Excel eBooks:
Excel – All Features
Excel – Macros and VBA

6 Microsoft Access eBooks:
Access – All Features
Access – with SQL Server
Access – Database Design
Access – Programming
Access – with VB .NET

1 Visio eBook:
Visio – All Features

Tags for this post>> | | | |

March 19, 2010

25 Office Reference and Help Docs

Here are 25 Office Reference, Help and Support Documents, hosted by admi-lan, along with 7 Internet Explorer help documents. These include keyboard shortcuts, efficiency and security tips, and techniques for getting more out of Word, Excel, Powerpoint, Outlook, Office, Sharepoint, and IE.

Microsoft Office Reference and Support Documents:

10 obscure Word tricks that can expedite common chores
Word 2003 Keyboard Shortcuts
Cut your Word docs down to size with these OLE techniques
50 indispensable Microsoft Word tips
Word 2003 Document Privacy and Security Options

Excel Keyboad Shortcuts
85 Keyboard Shortcuts for moving faster in Microsoft Excel

How to Compact Outlook Powerpoint PST Files
Put a Microsoft PowerPoint presentation on a CD
Creating Animated build Sildes in PowerPoint 2002

10 Things you can do to Become an Outlook Web Access (OWA) power user
80+ Keyboard Shortcuts to move faster in Microsoft Outlook
Accessing Exchange public folder data outside of Outlook
Create easy-to-use Outlook e-mail templates

6 Tips for Optimizing Exchange Server performance
Add a secondary domain to your organization
Discover Exchange 2003′s improved mailbox move feature  
Exchange 2000 planning – ADS and IM preparation

General Office:
10 Windows registry hacks for Microsoft Office
Expand Microsoft Office functionality with these 10 free add-ins
Corporate Error Reporting – A double-edged sword
10 things you should know about fighting spyware in Windows XP

10 Things you should know – Microsoft’s SharePoint Services
10 Ways to make SharePoint more Secure
Plan and design a successful SharePoint 2003 infrastructure

Internet Explorer:
10 things you should know about Internet Explorer 7 Security
10 things you should know about Internet Explorer 7.0 enhancements
Fine-tune IE’s behavior by utilizing it’s advanced settings
Investigate Internet Explorer add-ons in Windows XP
Keep IE secure by configuring the right settings
Make Internet Explorer as secure as possible with this step-by-step guide
Uninstall Microsoft Internet Explorer 7

Tags for this post>> | | | | | | |

March 15, 2010

3 Excel 2003 Tutorials

Here are 3 Excel 2003 Tutorials, at the University of the Incarnate Word, which outline and teach important features of Microsoft Excel 2003. These Excel tutorials are divided into three sections for better understanding of this popular spreadsheet tool. The documents are in pdf format.

Excel 2003 Basics Tutorial  (802 Kb, 22 pages)
You will be learning some of the basic features of Excel 2003 in this section. The topics that are covered here are managing and formatting spreadsheets, formulas and charts, and Excel options.

 - Toolbars and Taskbars
 - Managing Spreadsheets
 - Formatting Spreadsheets
 - Formulas
 - Charts
 - Excel Options

Excel 2003 Advanced Tutorial  (4.58 Mb, 90 pages)
Some of the advanced features in Excel 2003 that are demonstrated in this section include: formatting spreadsheets, creating more advanced formulas, working with charts, sharing and protecting workbooks, and linking spreadsheets.

 - Toolbars and Taskbars
 - Managing Spreadsheets
 - Formatting Spreadsheets
 - Formulas
 - Page Setup, Headers & Footers
 - Charts
 - Database
 - Sharing and Protecting Workbooks
 - Tracking Changes
 - Linking Spreadsheets
 - Excel Options

Excel Database Tutorial  (963 Kb, 15 pages)
The Excel concepts of creating, filtering, and sorting a database using Excel 2003 is illustrated in this section of the tutorial.

 - Database
 - Adding Data
 - Sort Using Single Field
 - Sort Using Multiple Fields
 - Sort by Auto Filter Sorting with more than one filter

Tags for this post>> |

January 26, 2010

8 Excel 2007 Tutorials

Here 8 Excel 2007 Tutorials, hosted by the University of the Incarnate Word. These Excel tutorials introduce and demonstrate many of the most important Excel features, including how to create charts, using vertical lookups, page setup, creating formulas, and using database functions. These Excel tutorials are well illustrated with screen shots, and include exercises that will help you remember what you are learning. The necessary documents for the exercises can be downloaded from here.

Excel 2007  3.37 MB, 69 pages
This presentation introduces Excel 2007′s new features, such as Quick Access Toolbar, MS Office Button, Mini Toolbar & Ribbon.

Excel 2003 & 2007 Comparison
This document explains the differences between Excel 2003 and Excel 2007 by comparing the Menus and toolbars in Excel 2003 with the Excel 2007 Button and Ribbon.

Formatting Excel Worksheets  1.26 Mb, 22 pages
This Excel tutorial teaches how to Format Excel Cells, Columns, Rows, Worksheets, and Workbooks.

Vertical Lookup in Excel  223 Kb, 4 pages
This tutorial presents the vertical look up feature available in Excel 2007.

Creating Excel Charts  535 Kb, 11 pages
This Excel Chart tutorial teaches how to create an attractive and useful chart in Excel 2007.

Page Setup and Other Functions  1.04 Mb, 16 pages
Learn how to setup Excel pages using the page break, margins, headers and footers.

Excel Database Functions  339 Kb, 7 pages
This Excel tutorial explains the database functions such as sort and auto filter.

Excel Formulas   794 Kb, 17 pages
Describes the a variety of tools available in the formula tab and how to use the formulas effectively in Excel worksheets.

Tags for this post>> |

January 21, 2010

eBooks on Office, Excel, Access, Powerpoint, and Project

Update: Here are 7 more Microsoft Office eBooks, covering Excel, Word, Access, PowerPoint, and Project. The first 3 are in Windows Help format (chm) and the last for are in pdf format.

 - Excel ebook

 - Word ebook

 - Microsoft Access ebook

 - Powerpoint 2003 ebook

 - Microsoft Project 2003 ebook

 - Microsoft Office 2003 ebook

 - Microsoft Office 2007 ebook

Here are 10 eBooks covering Microsoft Office, Excel, Access, and Project.

 - Excel 2003 ebook 1
 - Excel 2003 ebook 2
 - Excel 2003 Programming ebook 1
 - Excel Programming ebook 2

 - Microsoft Office 2003 ebook 1
 - Microsoft Office 2003 ebook 2

 - Microsoft Access 2003 ebook 1
 - Microsoft Access 2003 ebook 2
 - Microsoft Access 2003 ebook 3

 - Microsoft Project 2003 ebook

Tags for this post>> | | | | |

January 16, 2010

4 Video Excel Tutorials

Here are 4 Video Excel Tutorials that demonstrate and teach some of the fundamental features of Excel, so you can get up to speed and start using this spreadsheet application quickly and effectively.

Screen display, cursors, worksheets (5:48 min.)
This video Excel tutorial deals with screen display, cursors and worksheets.

Formatting cells, inserting rows and columns (7:43 min.)
The features that are covered in this video Excel  tutorial are formatting cells and inserting rows and columns.

Formatting, sorting, and auto-filling data (5:01 min.)
This video Excel  tutorial shows how to do formatting, sorting, and auto-filling data.

Formulas and functions (1:34)
You will get to know about the usage of formulas and functions in this video tutorial.

Tags for this post>>

January 12, 2010

4 Excel 2007 Tutorials

Here are 4 Excel 2007 Tutorials, located at Orbit Computer Solutions. These Excel tutorials explain and cover several Excel features, including: creating a workbook, editing data in a spreadsheet, and modifying a worksheet. Each feature and scenario demonstrated is described with screenshots to help you understand how to do it yourself.

Getting Stated With Excel 2007
This Excel tutorial will give you an introduction to the world of Excel 2007.
 - The Microsoft Office Button  
 - The Ribbon  
 - Quick Access Bar

How To Create A Workbook
Here you will learn how to work with Workbooks in Excel 2007. Various functionalities like creating, saving, opening and entering data on a spreadsheet are explained here.
 - Working With A Workbook  
 - How To Create Workbook Using Template  
 - How To Save A Workbook  
 - How To Open An Existing Workbook  
 - How To Enter Data On A Spreadsheet

How To Edit Data In an Excel Spreadsheet
In this Excel tutorial you will learn how to edit data in a Spreadsheet.
 - Selecting Data, Cell, Columns  
 - How To Copy And Paste  
 - How To Cut And Paste  
 - How To Edit Cell Content  
 - How To Undo And Redo Changes  
 - How To Use Auto fill

Modifying A Worksheet
In this Excel tutorial, we are explaining how to modify data in a worksheet by inserting cells, rows and columns, using spell check and find replace tools.
 - How To Insert Cells, Rows, And Columns  
 - How To Use Find And Replace  
 - How To Use Spell Check

Tags for this post>> |

November 17, 2009

10 Excel Tips that Speed up Spreadsheets

Here are two good video tutorials for 10 Excel Tips that Speed up Spreadsheets. Excel is a spreadsheet application from Microsoft that features calculations, graphing tools, pivot tables and a macro programming language called VBA. These two video tutorials explain various features in Excel, such as data entry; moving multiple cells, columns and rows; formatting, charting, inserting line breaks and graphics, and editing strings using functions.

10 Excel Tips to Make Your Life Easier – Part 1
This Excel video tutorial explains how to handle bulk data entry, inserting rows and columns, moving data and utilizing the format painter and format copy tool.

 - Master the Art of Bulk Entry
 - Quickly Inserting Rows & Columns
 - Moving Your Data Around in One Shot
 - Utilize the Format Painter & Format Copying
 - Taking the “Work” out of Worksheets

10 Excel Tips to Make Your Life Easier – Part 2
This video tutorial discusses the use of charts, working with repeated data, inserting line breaks, working with dates, inserting a picture and manipulating strings with functions.

 - Utilizing Quick Charts
 - Easily Remove Repeated Data
 - Inserting Line Breaks & Today’s Date in a Cell
 - Insert a Picture in a Comment
 - Manipulating Strings with Functions

Tags for this post>>

November 13, 2009

Word, Excel, and Office Tutorials

Here are some very good tutorials on Word, Excel, and MS Office, hosted by University of Florida. These Word, Excel, and Office tutorials discuss and demonstrate the important features of Microsoft Word, Excel and Office that combine together to provide users with a powerful word editing application and a spreadsheet program. These Office tutorials can be downloaded (doc and ppt formats) and saved for later reference.

Microsoft Office: Word and Excel 531 Kb, 22 pages)
This Word and Excel tutorial discusses features such as tables, toolbars, cell addresses, splitting cells and complex cell manipulation.

 - Word Tables
 - Word Tables and Borders Toolbar
 - Math in Word Tables
 - Math in Excel
 - Order of Operations
 - Cell Addresses
 - Splitting Cells in Microsoft Word
 - Dealing with Complex Cells in Microsoft Word
 - Splitting Cells in Microsoft Excel (Text to Columns)
 - Dealing with Complex Cells in Microsoft Excel

Microsoft Office 2003: Word and Excel  (538 Kb, 23 pages)
This Word and Excel tutorial explains features in Microsoft Office 2003, including math functions in Word and Excel, splitting cells, complex cell manipulation and the creation of tables.

 - Creating Tables
 - Tables and Borders Toolbar
 - Math in Word Tables
 - Math in Excel
 - Functions
 - Splitting Cells in Microsoft Word
 - Dealing with Complex Cells in Microsoft Word
 - Splitting Cells in Microsoft Excel (Text to Columns)
 - Dealing with Complex Cells in Microsoft Excel

Microsoft Office: Drawing Toolbar  (372 Kb, 15 pages)
This tutorial discusses the drawing toolbar in Microsoft Office with its autoshapes, the draw menu, wrapping text around objects and tips and tricks for drawing objects.

 - Drawing Toolbar
 - AutoShapes
 - The Draw Menu
 - Wrapping Text Around Objects in Word 97
 - Wrapping Text Around Objects in Word 2000
 - Tips and Tricks for Graphics and Drawing Objects

Microsoft Office Overview  (719 Kb, 23 slides)
This PowerPoint presentation is a handout of the features of Microsoft Office and its applications.

Microsoft Office Overview  (2.7 Mb, 23 slides)
This PowerPoint presentation provides an in-depth overview of Microsoft Office and its applications.

 - Word
 - Excel
 - PowerPoint
 - Access

Tags for this post>> | | |

October 17, 2009

11 Excel 2007 Tutorials

Here are 11 excellent Excel 2007 Tutorials, at the University of Florida, that discuss and present many of Excel’s important features. These Excel turorials, as handouts and notes, cover calculations, navigation, graphing and charting, pivot tables, printing, and sorting and filters. They are in pdf format, and can be downloaded and saved for later reference.

Charts Handout  (918 Kb, 15 pages)
This is a handout that discusses how and why charts are created and used for communicating and presenting things.

Charts Notes  (31 Kb, 3 pages)
This Word document contains important notes on Excel charts and how they are used to represent important details.

Math & Fun Handout  (194 Kb, 11 pages)
This handout discusses math functions used in Excel to carry out calculations from raw data.

Mult Handout  (348 Kb, 11 pages)
This handout demonstrates to users how to use multiple spreadsheets and worksheets.

Mult Notes  (28 Kb, 3 pages)
This Word document provides users with notes and tips on how to use multiple worksheets in Excel.

Nav & Form Handout  (446 Kb, 21 pages)
This handout discusses the navigation and formatting, including moving between cells and editing data.

Nav & Form Notes  (58 Kb, 7 pages)
This Word document provides important notes for users regarding navigation and formatting in Excel 2003.

Pivot Tables Handout  (324 Kb, 14 pages)
This handout explains to users what Pivot tables, how to create them and how they work.

Print Handout  (603 Kb, 16 pages)
This handout explains to users how the Print function works in Excel 2003 and how printing can be customized to suit ones needs.

Print Notes  (44 Kb, 5 pages)
These notes on printing in Excel 2003 offer users quick tips and trick that can be used to suit their printing styles.

Sorting & Filters  (203 Kb, 9 pages)
This tutorial imparts knowledge on how sorting is done in Excel 2003 and how filters can be applied on raw data to get the desired results.

Tags for this post>> |

October 16, 2009

14 Excel 2003 Tutorials

Here are 14 excellent Excel Tutorials, hostsed by the University of Florida. These tutorial handouts and notes discuss and teach many important features of Excel 2003, including calculations, graphing tools, pivot tables, printing, sorting and filters, and macros. These Excel 2003 tutorials are in .doc format, and can be downloaded and saved for later reference.

14 Microsoft Excel 2003 Tutorials:

 - Charts Handout 339 Kb, 14 Pages
 - Forms Handout 120 Kb, 7 pages
 - Macros Handout 145 Kb, 10 Pages
 - Macros Notes 35 Kb, 3 Pages
 - Math & Fun Handout 170 Kb, 11 Pages
 - Math & Fun Notes 73 Kb, 10 Pages
 - Mult Handout 177 Kb, 10 Pages
 - Mult Notes 29 Kb, 2 Pages
 - Navigation & Forms Handout 289 Kb, 17 Pages
 - Navigation & Forms Notes 57 Kb, 7 Pages
 - Pivot Tables Handout 377 Kb, 13 Pages
 - Print Handout 292 Kb, 14 Pages
 - Print Notes 39 Kb, 4 Pages
 - Sorting & Filters Handout 179 Kb, 8 Pages

Tags for this post>> |

August 31, 2009

Excel 2007 Course Tutorials

Here are some excellent Excel Course Tutorials, at the University of Minnesota, that provide information on the new features of Excel 2007, its uses, its advantages over the existing versions of Excel, working with Excel charts in Word or PowerPoint, the different formulae used in Excel cells and how to effectively manage and analyze data. The first three tutorials below are in pdf format.

Excel New Features Tutorial  (761 Kb, 7 pages)
This document discusses the new features of Excel 2007 such as formatting itemized lists, creation of charts, using conditional formats and creating pivot tables.

Excel Treasure Hunt  (240.54 Kb, 2 pages)
This 2 page pdf document allows users to guess the features that users have learned so far and this is done using a clue for each feature of Excel.

Pasting Excel Charts in Word or PowerPoint  (117.20 Kb, 2 pages)
This Excel tutorial explains how to use and embed Excel charts and worksheet data in Word and PowerPoint.

Class Files (.zip)
This section contains downloadable zip files that contain spreadsheet that will help you learn spreadsheet basics, and how to manage and analyze data using Excel.

 - Excel 2007: Managing and Analyzing Data
 - Excel 2007: Spreadsheet Basics

Tags for this post>> |

August 9, 2009

9 Excel Tutorials

Here are 9 Excel Tutorials at California Polytechnic State University that discuss various features of Excel that make it such a useful spreadsheet application. These features include chart creation, application of formulas, creating functions, cell formatting, effectively using the IF function, and working with templates and spreadsheets. Each of these Excel tutorials are in pdf format, so they can be downloaded for later reference and use.

9 Excel Tutorials:

Excel Tutorial 1 - Introduction  (208 Kb, 8 pages)
This tutorial introduces Excel’s features, how to chart values, keyboard shortcuts and working with worksheets. All these features are explained with appropriate diagrams.

Excel Tutorial 2 - Simple Formulas & Absolute/Relative Cell References  (103 Kb, 5 pages)
This tutorial provides users with information about formulas, the operators that can be used in formulas, and their related functions with absolute and relative cell references.

Excel Tutorial 3 – Data Forms and Creating Charts  (113 Kb, 4 pages)
This tutorial discusses the use data forms, how to create them and use them effectively. Chart creation and its implementation are also discussed.

Excel Tutorial 4 - Formatting and Formulas  (306 kb, 10 pages)
This tutorial explains how to work with formulas and formatting them to calculate values provided in the cells. Also discussed are triggers that cause certain actions on the screen when the result of the formula matches an expected result.

Excel Tutorial 5 - Formulas and Functions  (167 Kb, 6 pages)
This tutorial teaches the use of functions to perform calculations by using specific values passed to them. These values are the function’s parameters and the calculations are carried out based on their values.

Excel Tutorial 6 - nVision  (290 Kb, 10 pages)
This tutorial explains the nVision concept which can be achieved by splitting the view in Excel to hold many views with calculations. This provides a multi-dimensional approach when viewing multiple cells.

Excel Tutorial 7 – Using the IF and Nested IF Function  181 Kb, 8 pages)
This tutorial describes the IF function with its related operators and conditions. Also discussed are the nested IF function where multiple IF statements are used to sift between available options.

Gradebook Template  (28 Kb)
This simple template created in Excel is for users to work with when working on calculations. This template is that of a class record with student name and their marks in different exams

Grading Spreadsheet  (22 Kb)
This spreadsheet template uses calculates the grades of various students based on the marks obtained in various subjects. This is a simple template for users to work on and learn the basics of Excel.

Tags for this post>>

Next Page »