
The Microsoft Excel 2003 Intermediate courseware includes charting with Excel, a review of formulas and functions including absolute cell addresses and IF statements, and working with lists (databases) and list functions in Excel. The first three sections cover chart sheets, embedded charts, and enhancing and editing charts. In the third section you will review functions, embed absolute cell addresses in a formula, write IF statements, and learn how to activate the AutoCalculator. The fourth section introduces list (database) criteria required by Excel and list management with the Data Form. Sections 5 and 6 include sorting and filtering list data along with special database functions, SUMIF and COUNTIF.
Page Count:
120
Publication Date:
2004-09-01
No comments yet. Be the first to share your thoughts!