## Excel

##### ​

Excel

Overview of the Basics

• Explore the User Interface

• Work with the Ribbon & Backstage view

• Work with Contextual Tabs

• Use the Excel Galleries

• Customize the Excel Interface

Working with Cell Reference s

• Understanding Cell Reference

• Working with all kind of cell reference (Relative, Absolute & Mixed)

• Understanding Mixed cell reference with some formulas

Working with Formulas & Functions

Date And Time Functions:

• Today, Now, Date, Day, Month, Year, Time, Hour, Minute, Second, Datevalue, Timevalue, Eomonth, Edate, Workday, Workdayintl, Networkdays, Networkdays.Intl, Weekday, Weeknum, Datedif, Days And Real Time  and Practice exercise.

Arithmetic Functions:

• Count, Counta Countblank, Countif, Countifs, Sum, Sumif, Sumifs, Row, Rows, Column, Columns, Average, Averagea, Averageif, Averageifs, Sumproduct, Subtotal, max, min, Large, small and Practice Activities.

String Functions:

• Upper, lower, proper, Mid, Right, Left, Replace, Subsitute, Find, Search, char, Code, Clean, concatenate, Len, Trim and Practice Activities.

Logical Function:

• IF FUNCTION, AND, OR, NOT, IFERROR, MOD AND PRACTICE

Lookup Function:

• LOOKUP, VLOOKUP, HLOOKUP, INDEX, MATCH, CHOOSE, INDIRECT
AND ACTIVITIES

Formatting Function:

• TEXT, ROUND, ROUNDUP, ROUNDOWN, VALUE and combination of functions and formulas.

##### Course Details
• Duration:  hours

• hours effort:  8 hours per week

• Price With GST: 5000/-

• Subject:

• Level: