MS Excel Skills and Techniques
MS Excel Skills and Techniques
Training Activity Rate
Trainer/s
Mahmoud Elqasem
Training activity Hours
15
Training activity Date
-
Training Activity Days
Sunday
Monday
Tuesday
Wednesday
Thursday
Start and End Time
17: - 20:00
Training Activity Classification
Basic Skills
Course Language
0
Methodology
In class
Type of Training
short courses
Pricing Method
Per hour
Price For Jordanian
120 JOD
Price For Non Jordanian
300 US$
Outcomes

By the end of this course, trainees will be able to:     

- Enable participants to discover the application's capabilities while working through exercises to create simple worksheets.

- Learn how to use functions efficiently in work.

- Learn how to automate common tasks.

- Learn new skills & techniques and how to solve your problem in multi different ways.

Target Group

- Finance & 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).

- Sumproduct.

- 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.