Call us today: 0800 028 3045
Microsoft Excel Course – Module 2 Gathering and Presenting Data
Is it right for me?
Our Excel Module 2 - Gathering and Presenting Data course looks at techniques for managing data more effectively.
It is designed for existing users of Excel who have attended Module 1 - Essentials or have equivalent knowledge. You should be confident in creating and manipulating Excel spreadsheets and creating calculations before attending.
What will I get out of it?
By the end of the course you will be able to:
- 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 courses in our range
What does it cover?
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 audition facility
Protecting information
- Protecting worksheets
- Selectively protecting
- Protecting workbooks
“A very good trainer, who obviously knows the subject well and enjoys passing on knowledge. The course went at a good speed and everything was explained clearly. My personal objectives to learn more about Excel were indeed met.”
Sarah Whitehead, Community Officer, NHS South East Coast
Course Summary
Send to a colleague
Please enter details below and click 'submit'
Tailor this course
If you are interested in this course but would like it tailored to your specific needs, contact Karen Osborn on 0800 028 3045.
Alternatively, enter your details below and one of our team will contact you.
Thales Training & Consultancy is a highly successful training services company based in Crawley. We help companies to develop advantage through learning and development. Highly trusted by leading enterprises, we deliver a full range of dedicated training solutions that enable organisations to achieve key business goals. The 4 core services we offer are Training Courses, Supply Management, Bespoke Services and Managed Services. Our successful partnerships with clients prove that the delivery and management of the right training and development can significantly enhance the pursuit of business excellence.
