Excel for Managers  

TGBS conducted training programme on “Excel for Managers” for semester 2 FMHO students between Feb 2022 to March 2022.

Day 1 covered basics of excel like rows, columns, freeze panes, sum, use of keyboard over mouse

Day 2 covered filter, sort, conditional formatting, sumif, if, index, and, or, goalseak functions.

Day 3 covered text to column, grouping, ungrouping, index, vlookup, hlookup.

Day 5 & 6 was focused on pivot table, interactive dashboard, charts & graphs.

Students learnt the smart way of using excel which will make their work life smooth and efficient.