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
This course is delivered online over 2 days.
Dates: Tuesday 8th October & Wednesday 9th October
To book a place on this course visit www.dundalkskillnet.ie