|
Spreadsheet objectives
Database objectives
Spreadsheet Design Guidelines
Basics:
·
Customization: Changing Excel's defaults
·
Cursor
movement
·
Data entry, Video
·
Editing
·
Formatting
·
File commands
·
Printing
Copying Formulas
·
Copying
formulas: Absolute/relative cell references, Video
Charts
·
Bad
examples
·
Good
examples
·
Overview, Video
·
About Charting
·
Guidelines for Charting
·
Getting Ready to Chart
·
Creating a Basic Chart
·
Formatting Your Chart
·
Working with Chart
Elements
·
Using Pie Chart
Options
·
Charting Extras
·
Charts
tutorial: How to create a chart (MS)
·
Charts
tutorial: Choose the right chart type (MS)
·
Charts
tutorial: Professional-looking charts (MS)
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
·
Payment (PMT) Video 1, Video 2
·
Future Value (FV)
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
·
Autofiltering Video
·
Advanced
filtering
·
Subtotals
Video 1 Video 2
·
Database
functions
·
Pivot tables Video 1, Video 2, Video 3
·
MS Pivot Table
Tutorial
Miscellaneous
·
Customizing
Excel
·
Macros
and Visual Basic
·
Working with
large and/or 3-D worksheets
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
Excel
2007!
·
Download
the Office 2007 trial edition for free!
MS
Office Specialist Excel 2003 Objectives
MS
Office Specialist Excel 2003 Expert Objectives
USD Excel tutorial
U of Wisconsin Excel Pages
Florida Gulf
Coast University Excel Pages
Sample files
|