99EXCEL.COM, Excel Training Academy

99EXCEL.COM - Excel Training Academy
Provide Basic/Advanced Excel Training, make user familiar to create formula and give platform to make good analysis and introduce Powerful tools of VBA Excel Coaching Classes so that user can make advance analysis with the help of those tools.

Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.
Sum, Count, Conta, Count blank, Average, Max, Large Min, Abs, Sum if, Count if, Sum ifs, Count ifs, Lowers, Upper, Proper, Trim, Len, Left, Right, Mid,
Concatenate, Subtotal, And, Or, Day, Year, Eo month, E date, Net workdays, Today, Weekday, Week number, Workday, Find, Search, V-lookup, H-lookup, Match, Ifferror, Ifna, If, Index, Offset
Filters (Basic, Advanced , Conditional), Sort ( Ascending, Descending, Cell/ Font Colour), Single and Multiple Charts/Graphs, Conditional Formatting, Data validation, Group & ungroup, Data split.
Pivot Table and Chart, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display.

Тэги:

#Count #Conta #Count_blank #Average #Max #Large_Min #Abs #Sum_if #Count_if #Sum_ifs #Count_ifs #Lowers #Upper #Proper #Trim #Len #Left #Right #Mid #Subtotal #And #Or #Day #Year #Eo_month #E_date #Net_workdays #Today #Weekday #Week_number #Workday #Find #Search #V-lookup #H-lookup #Match #Ifferror #Ifna #If

Скачать видео