Scope of Function - Formula

This programme is the most important aspect of analytics. Through this you would be able to analyse your data; you would understand how to extract meaningful information from dump data. Formulas make Excel smart. Without them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyse it and get answers to most complex questions.

What will it cover?

• Lookup :- (choose, hlookup, indirect, match, transpose, vlookup, lookup, lookup (vector)
• Logical :- (and, if, not, or)
• Date function :- (date, datedif, datevalue, day, edate, minute, month, days360, eomonth, hour, timevalue, networkdays, now, second, time, today, weekday, workday, year etc..)
• Database function :- (Daverage, Dcount, Dcounta, Dmax, Dmin, Dsum)
• Engineering :- (Bin2dec, Convert, Dec2bin, Dec2hex, Delta, Hex2dec etc...)
• Financial function:- (Db etc.)
• Information:- (Cell, Countblank, Info, Isblank, Iserr, Iserror, Iseven, Islogical, Isna, Isnumber, Isodd, Isref, Istext, N, Na etc...)
• Mathematical:- (Abs, Combin, Countif, Even, Fact, Gcd, Int, Lcm, Mod, Odd, Pi, Power, Product, Quotient, Rand, Randbetween, Roman, Round, Roundup, Sign, Sum, Sumif, Sumproduct, Rounddown, Sum (Running Total), Sumifs, Countifs,
• Statistical:- (Average, Correl, Count, Counta, Large, Max, Min, Mode, Permut, Rank, Small, Frequency, Median, Split Forename And Surname, T Etc...)
• Text :- (Char, Clean, Code, Concatenate, Dollar, Exact, Find, Fixed, Left, Len, Value, Lower, Mid, Proper, Replace, Rept, Right, Substitute, Text, Trim, Upper Etc...)
• Offset , Sumifs, Countifs, Workday.Intl, Networkday Intl, Iferror, Etc
• Split & Merging Formula
• Dynamic Formulas
• How to deal with Problem oriented Data

Additional features

• Android Application to learn Excel Function through Videos
• We will provide you dummy data for your practise; Assignments through which you can judge to yourself, Interview preparation question, platform where you can discuss you excel related queries/Job openings.
• We will provide you all kind of study material related to this Function and supporting Videos along with the files.
• You will also get video of the class which you attended; you can grab that in you Pan Drive or any storage device. So the content of the class remain with you for life time.
• You can Attend your class by staying anywhere in the world through video conferencing.
• Life time support / Assistance from our side
• We will provide you dummy data for your practise; Assignments through which you can judge to yourself, Interview preparation question, platform where you can discuss you excel related queries/Job openings.
• Assistance in searching the Job.