About this course
       Excel and Advance Excel

 

What you'll learn

 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: 

Prerequisites​