1) SUMIF/SUMIFS 2) COUNTIF / COUNTIFS 3) Data Tables, Simulations & Solver 4) Data Sorting 5) Pivot Tables & Pivot Reporting 6) Cell Formatting 7) Data validation 8) Excel shortcut keys 9) Workbook 10) Managing Page Layout 11) Charts & its Analysis 12) Conditional Formatting 13) VBA & Macros 14) Using Excel Productively (a) Keyboard Shortcuts (b) Mouse Shortcuts (c) Making better Excel workbooks 15) Integrating Excel with other tools & Optimizing Excel