Excel Tips (Formula Auditing)

Excel Tips (Remove Duplicates)

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.

Excel Tips (Freeze Panes)

In this video i am going to teach you how to use freeze panes in excel worksheet. We can make our headings visible while working in very long data.

Excel Tips (Transpose Data Row to Column)

In this video i am going to teach you how to transpose data from row to column in excel worksheet. Most of people don't know this technique while they are working and do this work manually.

Excel tips (Create a Hyperlink)

In this video I am going to teach you how to create a hyperlink in Microsoft excel 2010. You will be able to make links between sheets. It is very useful technique to manage your work by hyperlinks. You can jump any sheet in a second by using hyperlinks.

Excel Tips (Create a chart)

In this video I am going to teach you how to create a chart in Microsoft excel 2010. You will be able to create graphical chart professionally. Chart presentation is very useful tips to understanding data which are complicated. You can analyze data with percentage and different options of chart.

Excel Tips (Convert Text into Columns)

Excel Tips (Quickly Insert Formula)