Programme overview
Excel is the most in commonly used and in demand tool for making sense of data. When you can harness that power, you will be a sought after employee. If you run a business, being proficient in Excel can help you see your business in a completely different light.
Learning Outcomes
- Create an IF Function
- Nest AND, OR and IF Functions
- Sum If, Count If
- Create Named Cells
- Create Named Ranges
- Create drop down lists
- Use the VLOOKUP Function
- Use the HLOOKUP Function
- Text Functions & manipulating Text
- Subtotal Data
- Pivot Tables
- Pivot Table Charts
Who Is This Course For?
This course is perfect if you have an understanding of the fundamentals of Excel and would like to progress to more advanced features
Modules
- Create an IF Function
- Nest AND, OR and IF Functions
- Sum If, Count If
- Create Named Cells
- Create Named Ranges
- Create drop down lists
- Use the VLOOKUP Function
- Use the HLOOKUP Function
- Text Functions & manipulating Text
- Subtotal Data
- Pivot Tables
- Pivot Table Charts