|
Excel 2 details
- Topics to be covered
- Reviewing Excel 1 topics
Cell addressing
- Using relative addresses
- Using absolute addresses
- Using mixed addresses
Formatting worksheet appearance
- Adding borders and shading
- Using drawing objects
- Manipulating drawing objects
- Inserting clipart
- Formatting worksheet background
- Using Autoformat
- Using Format Painter
- Indenting cell entries
Using styles
- Creating and applying styles
- Modifying and deleting styles
Linking and copying worksheets
- Copying data between worksheets
- Arranging multiple worksheets
- Linking worksheets
Using functions
- Using the function generator
- Using ROUND, ROUNDUP and ROUNDDOWN
- Using MAX, MIN and AVERAGE
- Using LARGE and SMALL
- Using IF, AND and OR conditional formulas
|
Formatting data
- Setting number formats
- Setting custom date formats
- Using conditional formatting
Tables
- Using the LOOKUP function
- Using the VLOOKUP function
- Using the HLOOKUP function
Using ranges
- Creating named ranges
- Using range names in formulas
- Using Go To command
Charts and graphs
- Using Chart Wizard
- Creating pie charts
- Changing segment shading and colour
- Creating bar and comparative bar charts
- Creating line graphs
- Changing format of charts
- Changing chart data
- Embedding charts in the worksheet
- Copying and pasting charts to other applications
- Creating headers and footers for charts
- Printing charts
|
