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 […]
Tag: MS Office
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 […]
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 which basically allows you to manage the file and settings in PowerPoint. You can save presentations, open existing ones and […]
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 lot easier. Accessing Backstage View You can access the Backstage view simply by clicking on the File tab. You can […]
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 the Navigation Pane under any existing slide and click on the New Slide option. Step 2 − The new slide is inserted. You can now […]
Managing Sections in PowerPoint
Managing Sections Given the popularity of PowerPoint and its versatility, there are situations when you are dealing with very large slide decks or just collaborating with different people to build the slides. In such cases, it is always helpful to be able to segregate the slides into smaller groups and work with these groups. […]