MS Office Software Training

Introduction to Advanced Excel Training Course, Basic Understanding Menu and Toolbar, Introduction to a different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.

Mathematical Functions:- Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct

Date & Time Function:- Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time

Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.

Statistical Function & Other Functions:- Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen

Logical Functions:- And, Or, If, Iferror, Not, Nested If

Lookup & Reference Functions:- VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link

How to use Table of Contents in MS-Word

About Table of Contents: It is most common and useful feature in ms-word. By using this option, we can create a table of contents(TOC) for a long document. We can easily navigate on pages by clicking specific headings provides in TOC.

Step 1: Write your long documents with heading and subheadings.

Step 2: Modify Heading 1 and Heading two as per your requirement like colour, font size etc.

Choose Heading 1 and Heading 2 Options one by one from Home-Styles and apply on your headings

Step 3: Click on Reference menu and then click on the table of contents option and then select built-in heading styles

Step 4: Now, you can see your document is ready as a table of content on the first page, by this you can navigate page to page or headings.

Hi Folks,

Do you know Excel VBA Editor has functionality where you don't need to declare a variable in memory (DIM).
But what will happen if you write a program without declaring a variable nothing happens?
Then why do we need to declare a variable and what is Option Explicit? Yes here comes the answer.
When you write option explicit at the top of your VBA Editor VBA will force you to declare a variable it's a standard practice to declare a variable.
One more point when you are not declaring a variable in VBA by default VBA Program considers that as a variant data type which consumes more space, Also it increases programs running time.
So next time when you write a program don't forget to declare a variable.
Happy learning!!

Hi Anurag, I hope you have the criteria like below shown Comum A, B, C and now add the following formula in co, umn C to get the grade according to the percentage. Please revert if you have any questions. =IF(B2<=45,"D",IF(B2<=60,"C",IF(B2<=80,"B",IF(B2<=100,"A")))) Column A Column B Column C Student Names Percentage Grade Ram 60 C Suman 80 B Leela 95 A Joe 70 B
Regards,
Nagamani