ADVANCE EXCEL SKILS (ICCE/0206)

FORMATTING, FORMULAS, CELL REFERENCES, PAGE SETUP, FORMULA INPUTS AND CHARTS, BASIC EXCEL FUNCITIONS, PIVOT TABLES TO CREATE SUMMARY REPORTS, KEYBOARD SHORTCUTS, DATA ALIGNMENT, NUMBER FORMATTING, IF and IS FUNCTION, VLOOKUP FUNCTION AND RELATIONSHIPS TABLES, MIXED CELL REFERENCES, STYLE FORMATTING, SORTING, FILTERING, FLASH FILLING DATA, CHARTS AND GRAPHS, POWER QUERY BASICS