Using Templates in MS Excel Template is essentially a model that serves as the basis for something. An Excel template is a workbook that’s used to create other workbooks. Viewing Available Templates To view the Excel templates, choose File » New to display the available templates screen in Backstage View. You can select a template stored on […]
Tag: Microsoft Excel
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 the Insert tab of the Ribbon.Graphics are available in the Insert Tab. See the screenshots below for various available graphics in MS Excel 2010. Insert Shape Choose Insert Tab » Shapes dropdown. Select […]
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 these different sets of data together into one meaningful list or table. This is where the Vlookup function comes into its own. (toc) VLOOKUP VlookUp searches for a value vertically down for […]
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 two ways in which we can use this option. (toc) Choose File » Print (which displays the Print pane), and then click the Print button. Press Ctrl+P and then click the Print button (or […]
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. Choose File » Save and Send. It basically saves the document first and then the emails. Click on Send using E-mail if your email system is configured. MS Outlook will open with the […]
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 and perform calculations that are difficult if you use only the operators. For example, you can use the LOG or SIN function to calculate the Logarithm or Sin ratio. You can’t do […]
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 translate your whole file with MS Excel 2010 Translate Worksheet. Translation is available in the review tab of the ribbon in MS Excel 2010. You can quickly translate cell into different language […]
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 protection-related features fall into three categories. Worksheet protection − Protecting a worksheet from being modified, or restricting the modifications to certain users. Workbook protection − Protecting a workbook from having sheets inserted or deleted, […]
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 available in Data Tab » What-If analysis dropdown » Data table in MS Excel. Protect Workbook Data Table with Example Now, let us see data table concept with an example. Suppose you have the […]
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 of a table) or in an external data file. A pivot table can help transform endless rows and columns of numbers into a meaningful presentation of the data. Pivot tables are very […]