By Umair Instructor
This course includes
01. Cell address, cell ranges, ribbon, toolbar
02. Intro to using functions in excel part 1
03. Intro to using functions in excel part 2
04. Filtering Data
05. Sorting Data
06. Shortcuts_x264_002
07.Conditional Formatting_x264
7b
08. Hlookup
09. Vlookup
10. Exact and approximate match
11. If and Nested If
12. And and Or
13. Sumif and countif
14. Creating a chart in excel
16. Iceberg for Kuwait part 1
17. Iceberg for Kuwait part 2
18. What If Analysis_ Scenario Manager
20. What If Analysis_ Data Table
19. What If Analysis_ Goal Seek
21. Solver
22. What if Analysis_ Iceberg for Kuwait
23. & and Concatenate
24. Reid's Raisin Part 1
25. Reid's Raisin Part 2
26. Reid's Raisin_ Using Solver
27. Pivot Tables and Pivot Charts
28. Automating repetitive tasks using macros and VBA
29. Database functions
30. Consolidaing Workbooks
31. Randbetween and coin throw simulation
This course will serve as a beginners guide to Microsoft Excel. You will be taught how to solve problems on excel by making mathematical models and using Microsoft add ins like solver. In addition, you will learn shortcuts to save time and you will do practice questions in most videos to make sure that you fully understand the concepts. All the supporting files are included in each module. The videos follow the course outline of the DISC 112 course at LUMS. You can download the relevant files by this link: https://mega.nz/#F!AxFAlbiQ!hs7NULVVOobRC1LE34daqw
158+ students are Recommending this Course