|
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
Florida Gulf
Coast University Excel Pages
Sample files
|