Outcomes
By the end of this course, participants will be able to :-
- Discover the application's capabilities while working through exercises to create simple worksheets.
- Use (FX) Functions efficiently in work.
- Automate common tasks.
- Learn new skills & techniques and how to solve problems in multi different ways.
Target Group
- Finance & accounting teams, and HR officers and admins whom have at least basics of MS Excel.
Contents
- Pasting using paste special.
- Inserting rows, columns and cells.
- Using the undo and redo feature.
- Using the format painter to copy a cells format.
- Using formatting.
- The basics of excel formulas.
- Using some of excel's most common functions.
- Excel cell comments.
- Excel find & replace.
- Sorting data in excel.
- Use auto filter.
- Pivot table.
- Data validation.
- Text to columns.
- Intermediate excel formulas.
- Excel autosum function/formula.
