MS Excel offers support for a large number of keyboard shortcuts. Here is the list some of the wisely used shortcuts in the MS Excel 2010. Ctrl + A – It selects all the …
Pivot charts are widely used charts in the worksheet, which brings a graphical representation of the data summary displayed in the pivot table. Excel offers a great flexibility to the users by allowing them …
Charts helps in bringing a visual representation of the numeric values. MS Excel offers various chart types that can be inserted in the worksheet. The different kinds of charts include Column, Bar, Pie, Line, …
Pivot table makes it easier to create a dynamic summary report from the database. Pivot Tables can be created in MS Excel by going to the Insert tab, followed by PivotTable dropdown and click …
Data Table in Excel offers a unique way to see different results by altering the input cell in the formula. In order to use Data Table, go to the Data Tab followed by What-If …
MS Excel some smart protection related features which falls into three distinct categories. Worksheet protection – It protects the worksheet from being modified or restricts the extent of modification that can be done by …
MS Excel allows users to translate written text into different languages. By using the Mini Translator, you can easily translate phrases and paragraphs as well as individual words in the worksheet. MS Excel 2010 …
Emailing the workbook directly from the MS Excel is extremely simple and easier. In order to email the workbook to anyone from MS Excel, follow these simple steps: Select File, followed by Save and …
MS Excel two smart ways to print the worksheet. Quick Print If you wish to print the worksheet without adjusting the layout, use the Quick Print option. Here are two simple ways to use …
Graphic Object in MS Excel Over time, most of the users find themselves having huge amount of information spread across several different worksheets. It is very challenging and frustrating tasks to bring all these …