, ,

90. Pivot Charts

A pivot chart is a graphical representation of a data summary, displayed in a pivot table. A pivot chart is always based on a pivot table. Although Excel lets you create a pivot table and a pivot chart at the same time, you can’t create a…
, ,

89. Simple Charts

A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spreadsheets. Charts generated by early spreadsheet products were quite crude, but thy have improved significantly over the years.…
, ,

88. Securing Workbook

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,…
, ,

87. Translating Worksheets

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.Translation is available in the review tab of the…
, ,

86. Email Workbooks (Spreadsheets)

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…
, ,

85. Printing Worksheets

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.Choose File » Print (which displays the Print pane), and then click the…
, ,

84. Cross Reference: VLOOKUP

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. VLOOKUP VlookUp…
, ,

83. Macros

Macros enable you to automate almost any task that you can undertake in Excel. By using macro recorder from View Tab » Macro Drop-down to record tasks that you perform routinely, you not only speed up the procedure considerably but you are…
, ,

82. Adding Graphics

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…
, ,

81. Styles

With MS Excel, Named styles make it very easy to apply a set of predefined formatting options to a cell or range. It saves time as well as make sure that look of the cells are consistent.A Style can consist of settings for up to six different…