Excel Training - Intermediate v2003
Microsoft excel course content: Viewing excel worksheets Customise view options Display and customise toolbars Hide workbooks and worksheets Freeze panes Group excel worksheets More Formatting Techniques Using styles Conditional formatting The format painter Hiding and displaying cells More execl formulas and functions Using the series command Using the function wizard Financial functions Correcting formulas Using the error checker Using the auditing toolbar Using the watch window Absolute Cell References Entering an absolute column and row reference into a formula Entering mixed cell references into a formula Using Logical Functions Using the IF function Nesting IF functions Database and List Management Using Excel as a database Sorting a database Using Autofilters and advanced filters Using data forms Excel charts Creating excel charts using the wizard Formatting charts Linking Worksheets within a Workbook Renaming worksheets Inserting and deleting worksheets Creating formulas to link worksheets Drawing and Picture Objects Creating drawing objects Using drawing toolbar to control objects Excel 2003 and Other Applications Copying data from another application Using hyperlinks