Microsoft Excel Course – Module 2 Gathering and Presenting Data
Is this course right for me?
Our Excel Module 2 – Gathering and Presenting Data course looks at techniques for managing data more effectively.
This course is designed for existing users of Excel who have attended Module 1
Training course objectives:
- Transfer and link information between worksheets and workbooks
- Create and format graphs
- Automate repetitive tasks with macros
- Add conditional formatting to cells
- Create and use spreadsheets with validation and protection
Versions Available
2003, 2007, 2010
Related Training Courses in Our Range
Formulas review
- Building formulas
- Ordering calculations
- Absolute cell references
- Using functions
Managing multiple worksheets
- Moving, copying, inserting and deleting worksheets
- Selecting multiple worksheets
- Changing tab colour (2007 and 2010)
Transferring and linking data
- Linking within a workbook
- Linking between workbooks
Creating and amending graphs
- Using the chart wizard (2003)
- Changing the type of graph
- Adding, removing and repositioning legends
- Customising the graph
- Creating Sparklines (2010)
Customising and automating the Excel environment
- Recording and running macros
- Assigning macros to quick keys
- Assigning macros to toolbar buttons (2003)
- Assigning macros to the Quick Access Toolbar (2007 and 2010)
- Assigning macros to objects
Conditional formatting
- Changing the cell format depending on set criteria
- Databars, Top/Bottom Rules, Colour Scales and Icon Sets (2007 and 2010)
Setting up data validation
- Setting number and date validation
- Setting drop down list validation
- Setting custom validation
- Using the auditing facility
Protecting information
- Protecting worksheets
- Selectively protecting
- Protecting workbooks
