Text Functions - UPPER,LOWER,CONCATENATE,PROPER,LEFT,RIGHT,MID,SEARCH,SEARCH,FIND,LEN,TRIM....

DATE & TIME - DATE,YEAR,DAY,MONTH,EOMONTH,TODAY,TIME,HOUR,MINUTE,DATEVALUE,WEEKDAY,DATEIF....

FINANCIAL - DB,DDB,SIN,PPMT,PMT,RATE,NPER,PV,FV,PRICE.....

LOGICAL - IF,AND.OR,NOT,TRUE,FALSE,IFERROR....

LOOKUP & REFERENCES - LOOKUP,HLOOKUP.VLOOKUP,MATCH,INDEX,INDIRECT,HYPERLINK....

MATHEMATICS - SUM,SUMIFS,COUNT,COUNTIFS,AVERAGE,ABS,FACT,FLOOR,COS,PI,ROUND,POWER,PRODUCT...

STREAMING WORKFLOW

CREATE A MACRO, EDIT A MACRO, APPLY CONDITIONAL FORMATING, ADD DATA VALIDATION CRITERIA, UPDATE A WORKBOOK PROPERTIES, MODIFYING EXCEL DEFAULT SETTIING

COLLABORATING WITH OTHERS

PROTECT FILES, SHARE A WORKBOOK, SET REVISION TRACKING, MERGE WORKBOOK, ADMINISTRATOR DIGITAL SIGNATURE

CALCULATING DATA WITH ADVANCE FORMULA

MANAGE CELL & RANGE NAME, CALCULATING DATA ACROSS WORKSHEETS, USE SPECIAL FUNCTIONS, USING FORMULA TO SEPERATE DATA INTO SEPERATE COL., LINKING FILES IN EXCEL WORKSHHETS BY USING BUTTON

Organizing Worksheet And Table Data

Create A Chart, Chart Element, Changing A Chart Type, Modifying A Chart, Format A Chart, Set Up Dynamic & Intreactive Chart, Calculating In Pivot Table

Auditing WorkSheets

Trace Cell, Trouble Shoot Error In Formulas, Troubleshoot invalid Data And Formula, Watch And Evalute Formula

Analyzing Data

Create A Scenarios, Perform What-if-analysis, Perform Statistical Analysis, Anlysis Toolpack

Organizing Sheet And Table Data

Table, Create Table Dialog Box, Styles And Quick Style Set, Formate Table, Sort Or Filter Worksheet Or Table Data, Database function…….Dsum(), Daverage(),Dcount()

Inserting Graphics Object

Insert And Modify Picture And Clipart, Draw And Modify Shapes, Illustrate Workflow Using SmartArt graphics, Layer And Group Graphics Object, Customizing And Enahancing Workbook, Customizing Workbook, Manage Themes, Create And Use Template(ex-bills)

Import/Export & Publish

Exporting Excel Data, Importing Delimited Text File, Publish A Worksheet To The Web, Importing Data From The Web, Create A Web Query