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...
Using Templates in Excel
Using Templates in MS Excel Template is essentially a model that serves as the basis for something. An Excel template is a workbook...
Adding Graphics in Excel
Graphic Objects in MS Excel MS Excel supports various types of graphic objects like Shapes gallery, SmartArt, Text Box, and WordArt available on...
Cross Referencing in Excel
Graphic Objects in MS Excel When you have information spread across several different spreadsheets, it can seem a daunting task to bring all...