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​

Marathahalli Office:

Real Time Signals Technologies Private Limited

#102, Krishna Grand, Over Marathahalli Bridge,

Bangalore, Karnataka, India 560037

BTM office:

Real Time Signals Technologies Private Limited,

#4, 2nd Floor, 1st phase, 2nd Stage, BTM Layout,

Opposite to Udupi Garden,

Bangalore-76, bengaluru, Karnataka, 560076

Whitefield office:

Real Time Signals Technologies Private Limited,

#1906, Brigade Metropolis,

Mahadevpura,

Bengaluru, Karnataka, 560048

Belgium Europe office:

Real Time Signals Technologies,

Hemelstraat 42, 2018 Antwerpen

Belgium, Europe

Thane Office:

Real Time Signals Technologies Private Limited,

#202, GARDEN ENCLAVES BLDG NO1,

VASANT VIHAR,

THANE 400607, MAHARASHTRA, India 

 

 © 2014-2018 by Real Time Signals Technologies. All Rights Reserved.