Excel 2007 Resources

 

Spreadsheet objectives

Database objectives

Spreadsheet Design Guidelines

 

Basics:

·          Excel Overview Video

·          Customization: Changing Excel's defaults

·          Cursor movement

·          Data entry

·          Editing Autofill Video

·          Formatting

·          File commands

·          Printing

 

Charts

·          Bad examples

·          Good examples

·          Overview Creating a Chart Video, Formatting a Chart Video

·Charts tutorial: How to create a chart (MS)

·Charts tutorial: Choose the right chart type (MS)

·Charts tutorial: Professional-looking charts (MS)

 

Copying Formulas

·          Copying formulas: Absolute/relative cell references,
Relative Video, Absolute Video

 

Functions

·          Functions (all)

·          Toolbar functions: SUM, MAX, MIN, AVERAGE, COUNT, Video

·          Date/Time functions: TODAY, NOW, MONTH, DAY, YEAR, DATE, WEEKDAY Video

 

Financial Functions

·          Financial functions overview

·          Future Value (FV) Video

·          Payment (PMT) Video

·          Present Value (PV) Video

·          Rate (RATE)

·          Number of periods (NPER)

·          Rounding numbers

 

 

Making decisions

·          Conditional formatting

·          IF Video

·          AND

·          OR

·Lookup: VLOOKUP

 

Importing Data

·Importing a text file

·Splitting data from a single cell into multiple cells

 

Database features

·          Sorting Video #1, Video #2

·          Autofiltering Video #1, Text Fields, Video #2, Numeric Fields, Video #3, Compound Conditions

·          Advanced filtering

·          Subtotals Video 1 Video 2

·          Database functions

·          Pivot tables Video 1--Lists, Video 2--Tables, Video 3—Sort/Filter, Video 4—Field Settings

 

 

Miscellaneous

·Macros and Visual Basic

·Working with large and/or 3-D worksheets

 

Microsoft Video Tutorials

·          Excel Overview

·          Formulas

·          Charts

·          Pivot Tables

·          Pivot Tables: Filtering

·          Pivot Tables:

·          Keyboard shortcuts

 

Microsoft pages

·         Office Home Page: starting place for info about Excel

·         Downloads: get the latest update (MS calls them "service packs") to Excel

·         Microsoft Office Specialist (MOS) Home Page: get your Excel skills certified

 

MS Office Specialist Excel Objectives

MS Office Specialist Excel Expert Objectives

USD Excel tutorial

U of Wisconsin Excel Pages

Florida Gulf Coast University Excel Pages

Sample files

 

Updated 2007.08.30