Like the other windows based programs, PowerPoint 2010 also offers a wide range of keyboard shortcuts. For the current PowerPoint users, there is a major change in the way these shortcuts are being mapped in the 2010 release compared to some of the older ones. With a whole new range of features being added to […]
Tag: M S Office
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 […]
Simple Charts in MS Excel
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. Excel provides you with the tools to create a wide variety of highly customizable charts. Displaying data […]
Pivot Charts MS Excel
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 pivot chart without a pivot table. All Excel charting […]
Keyboard Shortcuts in MS Excel
Keyboard Shortcuts in MS Excel MS Excel Keyboard Short-cuts MS Excel offers many keyboard short-cuts. If you are familiar with windows operating system, you should be aware of most of them. Below is the list of all the major shortcut keys in Microsoft Excel. Ctrl + A − Selects all contents of the worksheet. Ctrl + […]
Merge & Wrap in M S Excel
Merge Cells MS Excel enables you to merge two or more cells. When you merge cells, you don’t combine the contents of the cells. Rather, you combine a group of cells into a single cell that occupies the same space. (toc) You can merge cells by various ways as mentioned below. Choose Merge & Center control on […]
Borders and Shades in M S Excel
Apply Borders MS Excel enables you to apply borders to the cells. For applying border, select the range of cells Right Click » Format cells » Border Tab » Select the Border Style. Setting Border Style Then you can apply border by Home Tab » Font group » Apply Borders. Setting Border Apply Shading You can […]