Microsoft Excel
Creating Formulas in Excel
Formulas in MS Excel Formulas are the Bread and butter of worksheet. Without formula, worksheet will be just simple tabular representation of...
Copying Formulas in Excel
Copying Formulas in MS Excel Copying formulas is one of the most common tasks that you do in a typical spreadsheet that relies...
Formula Reference in Excel
Cell References in Formulas Most formulas you create include references to cells or ranges. These references enable your formulas to work dynamically...
Built-in Functions in Excel
Built In Functions MS Excel has many built in functions, which we can use in our formula. To see all the functions...
Data Filtering in Excel
Filters in MS Excel Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets...
Data Sorting in Excel
Sorting in MS Excel Sorting data in MS Excel rearranges the rows based on the contents of a particular column. You may...
Using Ranges in Excel
Ranges in MS Excel A cell is a single element in a worksheet that can hold a value, some text, or a formula....
Data Validation in Excel
Data Validation MS Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell....
Using Styles in Excel
Using Styles in MS Excel With MS Excel 2010 Named styles make it very easy to apply a set of predefined formatting options to a...
Using Macros in Excel
Macros in MS Excel Macros enable you to automate almost any task that you can undertake in Excel 2010. By using macro recorder...