- Interactive one to one session - Focus on Individual's challenges

Topics Covered

MS Excel: Basic worksheet operations Basic formulas: Rand, Randbetween, Int, Mod, Round, Average, Sum, Min, Max Advanced formulas: Small, Large, Lower, Upper, Proper, Left, Right, Middle, Len, Count, countblank, Countif, Vlookup, Hlookup, If, Sumif, And, Or, Concatenate, Find, Rept, Substitute, Trim, Value, Day, Hour, Minute, Month, Networkdays, Now, Second, Today, Weekday, Year. Advanced excel topics: • Sorting of data • Filtering of data • Auto filters • Remove Duplicates • Freezing Panes • Conditional Formatting - Highlight Cell Rules (Highlight duplicate values) - Top/bottom rules (Highlight above/below average values, top or bottom 10 % percent values) - Data Bars - Colour Scales • Charting • Pivot table • Macros

Who should attend

Executives, Managers, Analysts, Researchers, MIS Personals, Accountants, HR, Students etc. Note: Only male candidates apply

Pre-requisites

Basic knowledge of MS Excel

What you need to bring

Laptop, Notebook and Pen

Key Takeaways

- Solved excel sheets discussed during the class - Examples