-
Using Macros in Excel
Macros in MS Excel Macros enable you to automate almost any task that you can undertake in Excel 2010. By using macro recorder from View Tab » Macro Dropdown to record tasks that you perform routinely, you…
-
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 that’s used to create other workbooks. Viewing Available Templates To view the…
-
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…
-
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.…
-
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 »…
-
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…
-
Explore Windows in PowerPoint
The following screenshot shows the various areas in a standard PowerPoint file. It is important to familiarize yourself with these areas as it makes learning and using PowerPoint easier. File Tab This tab opens the Backstage view…
-
Backstage View in PowerPoint
In Office 2010, Microsoft replaced the traditional file menu with the new Backstage view. This view not only offers all the menu items under the file menu, but additional details which makes management of your files a…
-
How to Create Presentation in PowerPoint?
PowerPoint offers a host of tools that will aid you in creating a presentation. These tools are organized logically into various ribbons in PowerPoint. The table below describes the various commands you can access from…
-
How to Add New Slides in PowerPoint
In this chapter, we will understand how to add new slides in an existing presentation. Here are the steps that allow you to insert a new slide in the deck − Step 1 − Right-click in…