Word Tips(Merge Cells,Split Cells,Split Table)

Word Tips (Formula)

Word Tips (Convert Table Into Text)

Word Tips (Repeat Header Rows)

Word Tips(Different First,Odd & Even Pages)

Excel Tips (Remove Duplicates)

Word Tips (Custom headers & footers)

In this video I am going to teach you how to insert custom header and footer in Microsoft word 2010. You will be able to insert custom header and footer such as date and time, file path, title, author name, page number, picture, company, logo, clipart and much more in this video. You can make your own custom header and footer very quickly by using these tips.

Word Tips (Predesigned headers & footers)

In this video I am going to teach you how to insert predesigned header and footer in Microsoft word 2010. You will be able to insert predesigned header and footer which are available in Microsoft word 2010. You can insert predesigned header and footer very quickly in word document.

Excel Tips (Subtotal Option)

In this video I am going to teach you how to use subtotal in Microsoft excel2010. Basically subtotal generates a subtotal and grand total in a list which you are using. It is basically easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab. You will be able to modify this list for further editing.

Excel Tips (Sumif Function)

In this video I am going to teach you how to use sumif() function to add all numbers in a range of cells based on a given criteria.

The syntax of SumIf function is:

• sumif( range, criteria, sum_range )
• range is the range of cells which you want to apply in the given criteria
• criteria is used to determine which cells to be add in range
• sum_range are the range of cells to be sum

Excel Tips (Sort & Filter Options)

In this video I am going to teach you how to use filter and sort options in Microsoft excel 2010. You will be able to apply filter in different criteria by using these tips. You will also learn sorting technique in this video.

Excel Tips (Alignment Techniques)

Excel Tips (Countif Function)

In this video I am going to teach you how to use countif() function in Microsoft excel. You will learn how to  combines the if function and count function. This combination lets you to count the number of times specific data is found in a range of cells. You can find total present in attendance sheet. The if portion of the function concludes what data meets the identified criteria and the count part does the counting.

Excel Tips (Filter Option)

In this video I am going to teach you how to use filter option in Microsoft excel 2010. You will be able to filter any record from your data by using this option. You will learn different criteria which you can use in filter option. You will also learn shortcut keys of filter option.

Excel Tips (Conditional Formatting)

In this video I am going to teach you how to use conditional formatting in Microsoft excel 2010. You will be able to get your desire results in color formatting. You will learn different types of conditional formatting such as highlight cells rules, top/bottom rules, data bars, color scales, icon sets and new rules.