View all the services available for students of the Institute
Study with us
View member services
Services to support your business
This packed course tackles new Excel Functions like FILTER UNIQUE, SEQUENCE, SORT and SORTBY showing their effectiveness over traditional Functions. We explore writing Custom Functions (LAMBDA, BYCOL) and use important Pivot Table techniques (in-table calculations, multi-sheet generation and the new PIVOTBY and GROUPBY). All manifestations of Formatting and key specific areas of Charting and Effective Macro creation and editing are explored.
Currently in planning more details to follow