Outcomes
By the end of this training course, trainees will be able to :
- Discover the application's capabilities while working through exercises to create simple worksheets.
- Use functions efficiently in work.
- Automate common tasks.
- Identify new skills & techniques and how to solve problems in multi different ways.
Target Group
- Finance and accounting teams.
- HR officers.
- ATM department employees.
Contents
- Sort.
- Filter.
- Sum , sum-as-running-total.
- Autosum shortcut key.
- Average.
- If.
- And.
- Count, counta , countblank , countif , countifs
- Sumif , sumifs
- Vlookup , Hlookup .
- Lookup (vector).
- Sum product.
- Concatenate.
- Match.
- Index.
- Right , left.
- Mid , len , upper
- Lower.
- Proper.
- Min , max .
- Round , rounddown , roundup .
- Trim.
- Trunc.
- Month , year.
- Now , today.
- Pivot table.
- Show all formula.