Microsoft Excel: Data Analysis and Visualization

Microsoft Excel is used by almost every professional in whatever job he is doing. Analysts use it to crunch numbers. HR staff use it to keep lists and stay organized. Sales specialists use it to track their performance and show their work. It is SO versatile and has SO many functionalities that you might not even know existed. Did you know you could use it as an automated meeting minutes record keeper? Did you know you could use it as an interface to access the files on your computer? Did you know that, if you really know how to use it, you should never reach out for your calculator again?

The course is administered in a classroom style setting to groups of 10 to 16 students. The location will be at TRYP Tower in Barsha Heights.

Course Structure

Day 1

1. What is a worksheet? What is a workbook? What is a cell? What is an array? What is a cell references? What is a formula? What is a macro?
2. Going through the file tab in excel: File, Insert, Data, Formula etc.
3. Simple cell Formulae: addition, subtraction, multiplication, division etc
4. Level 2 cell formulae: sum, minimum, maximum, count etc
5. Hyperlinks
6. Cell locking and cell protection

Day 2

1. Filtering and Sorting
2. Level 3 formulae: sumifs, countifs, lookup, vlookup, iferror.
3. Pivot tables and their application
   1. Simple pivot tables
   2. Dynamic pivot tables and slicers
   3. Pivot charts
4. Application of skills. Create one of these
1. A dynamic to do list with categories and drop downs
2. Pivot table of existing data from everyday use
3. Interface to access files on computer.

This Event is 2 days 9th November and 16th November, from 2 to 7 pm on both days. Registering means registering for both days together