MS Excel
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...
Printing Worksheets in Excel
Quick Print If you want to print a copy of a worksheet with no layout adjustment, use the Quick Print option. There are...
Email Workbooks MS Excel
Email Workbook MS Excel allows you to email the workbook very easily. To email the workbook to anyone, follow the below mentioned steps....
Using Functions in MS Excel (Formula)
Functions in Formula Many formulas you create use available worksheet functions. These functions enable you to greatly enhance the power of your formulas...
Translate Worksheet in MS Excel
You can translate the text written in a different language, such as phrases or paragraphs, individual words (by using the Mini Translator), or...
Workbook Security in MS Excel
Workbook Security We can apply security to the workbook by the concept of protection available in the Review Tab of ribbon. MS Excel’s...
Data Tables in MS Excel
In Excel, a Data Table is a way to see different results by altering an input cell in your formula. Data tables are...
Pivot Tables in MS Excel
A pivot table is essentially a dynamic summary report generated from a database. The database can reside in a worksheet (in the form...