Excel Module 3
Data Management Techniques
Take things a step further and improve your knowledge of some of the more niche Excel techniques to help manage your data
![](https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/77df68e-28e4-057f-41d6-ca1d3577146_Course_Overview_Icon.png)
Course overview
Duration:Â 1 day (6.5 hours)
Our Excel Module 3 – Data Management Techniques course looks at the next steps in working with your data.
It explores some more formulas and functions and auditing tools to help when things go wrong. It covers using simple Lookups to pull in data, how to protect your spreadsheets and techniques such as using formulas as part of your conditional formatting and having linked data validation lists to make it easier and more efficient to manage your data. It also includes an introduction to using Macros.
This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets, build formulas and use basic data validation and conditional formatting.
![](https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/8ba0826-4fb5-333c-0ea4-28c13064336b_Objectives_Icon.png)
ObjectivesÂ
By the end of the course you will be able to:
- Use partial absolute cell referencing
- Use the formula auditing tools
- Set cell protection
- Name and work with named ranges
- Use formulas to set conditional formatting
- Create linked data validation lists
- Use the VLOOKUP command
- Use simple date and time functions
![](https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/cbd24e-e374-8bf2-2a2e-66ae236e51d4_Content_Icon.png)
Content
Advanced absolute cell referencingÂ
- Review of absolute vs relative references
- Using partial absolute referencing
Formula auditing Â
- Using the auditing facility
- Tracing how formulas are made up
- Tracing precedents and dependents
- Evaluating formulas
- Error checking
- Showing formulas on a sheet
Range namingÂ
- Naming cells
- Using range names in formulas
Exploring date and time functionsÂ
- Using date functions
- Using time functions
- Calculating with dates
Advanced conditional formattingÂ
- Formatting based on other column information
- Using conditional formulas
- Finding cells with conditional formatting
Advanced data validation
- Naming lists
- Linked data validation lists
Using lookups
- Constructing a simple VLOOKUP function to draw information from another source
- Using HLOOKUP
Cell protection
- Setting cell protection
- Locking and unlocking cells
- Hiding formulas
- Protecting a worksheet
- Setting the level of protection
- Protecting a workbook
Starting with Macros
- Macro concepts
- Recording macros
- Example macros
- Adding buttons to run macros
Discover more about our courses
![](https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/cadc817-b407-2fde-2a02-c7bfee627b_497d7f2d-fcbd-4cda-b5f5-fa524c63ba45.png)
Public Training Programme
Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.
Engage with expert instructors and a diverse peer group in an interactive, online learning environment.
Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.
Check public datesView our full catalogue of Leadership, Personal Development, Systems, Office Applications and Project Management courses
Get in touch
![](https://kajabi-storefronts-production.kajabi-cdn.com/kajabi-storefronts-production/file-uploads/themes/2153291274/settings_images/67667-3172-a343-2227-bce8b5bfe2ab_Contact_Us_Icon.png)
Contact us
Do you have questions, suggestions, or feedback? We value your input and are here to assist you. Please don't hesitate to get in touch with us via email or phone:
- Email: [email protected]
- Phone: +44 (0)20 8152 6551
Our dedicated team is ready to respond to your enquiries and provide the support you need. Feel free to reach out, and we'll do our best to assist you.
Thank you for visiting our website, and we look forward to hearing from you!