Posts

Showing posts from July, 2015

Chapter 5 - Delete Sheets

Delete sheets Select the sheets you want to delete. How? When you enter or change data, the changes affect all selected sheets. These changes may replace data on the active sheet and other selected sheets. To select Do this A single sheet Click the sheet tab. If you don't see the tab you want, click the tab scrolling buttons to display the tab, and then click the tab. Two or more adjacent sheets Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet. Two or more nonadjacent sheets Click the tab for the first sheet, and then hold down CTRL and click the tabs for the other sheets. All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu  (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.) . Note   If sheet tabs have been color-coded, the sheet tab n...

Chapter -4 - Change the color of cell gridlines

Change the color of cell gridlines Select the sheets on which you want to change the gridline color. How? When you enter or change data, the changes affect all selected sheets. These changes may replace data on the active sheet and other selected sheets.     To select Do this A single sheet Click the sheet tab.If you don't see the tab you want, click the tab scrolling buttons to display the tab, and then click the tab. Two or more adjacent sheets Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet. Two or more nonadjacent sheets Click the tab for the first sheet, and then hold down CTRL and click the tabs for the other sheets. All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu  (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.) . N...

Excel Tutorial

INDEX Chapter 1 - Introduction Chapter 2 - Smart Documents   Chapter 3 -  Document Workspaces  

Technology Update - July 23, 2015

Google patents a way to archive, search your 'real-life experiences' - Google's new patent could make your real-life experiences searchable via a device like say the Google Glass, indicate reports.  Google Glass Enterprise Edition to be rugged, water-resistantGMA News Foldable and waterproof Google Glass soonJagran     OnePlus 2: Leaked images from Chinese regulator show fingerprint scanner, build  -     From its build, specs to online listing and pricing, a lot has already been said and written about the OnePlus 2. Within a week from appearing on the popular website Oppomart, new images of the device have surfaced online.     Apple grows faster in India than China         NEW DELHI: India is proving to be quite a strong growth engine for Apple, the world's most valuable company that sells the iPhone smartphones, iPad devices and Mac line of computers.     Moving from Android to iPhone? ...

Microsoft Excel - Chapter 3

About Document Workspaces A Document Workspace site is a Microsoft Windows SharePoint Services site that is centered around one or more documents. Colleagues can easily work together on the document — either by working directly on the Document Workspace copy or by working on their own copy, which they can update periodically with changes that have been saved to the copy on the Document Workspace site. How to create document workspace: Typically, you create a Document Workspace when you use e-mail to send a document as a shared attachment. As the sender of the shared attachment, you become the administrator of the Document Workspace, and all the recipients become members of the Document Workspace, where they are granted permission to contribute to the site. Another common way to create a Document Workspace is to use the Shared Workspace task pane ( Tools menu) in a Microsoft Office program. You can also use commands on a Windows SharePoint Services site ...

Microsoft Excel Tutorial (Chapter 2)

Smart Documents Smart documents are documents that are programmed to extend the functionality of your workbook by dynamically responding to the context of your actions.   Several types of workbooks, such as forms and templates, work well as smart documents. Smart documents work especially well for workbooks that are part of a process. For example, your company may have a process for filling out annual employee expense forms, and you may already use a Microsoft Office Excel 2003 template for this purpose. If that template is turned into a smart document, it can be connected to a database that automatically fills in some of the required information, such as your name, employee number, manager's name, and so on. When you complete the expense report, the smart document can display a button that allows you to send it on to the next step in the process. Because the smart document knows who your manager is, it can automatically route itself to that person. And...

Microsoft Excel Tutorial (Chapter 1)

Image
INTRODUCTION In Microsoft Office Excel 2003, you can create lists in your worksheet to group and act upon related data. You can create a list on existing data or create a list from an empty range. When you specify a range as a list, you can easily manage and analyze the data independent of other data outside of the list. Additionally, information contained within a list can be shared with others through integration with Microsoft Windows SharePoint Services. A new user interface and a corresponding set of functionality are exposed for ranges that are designated as a list. Every column in the list has AutoFilter enabled by default in the header row which allows you to quickly filter or sort your data. The dark blue list border clearly outlines the range of cells that compose your list. The row in the list frame that contains an asterisk is called the insert row. Typing information in this row will automatically add data to the list. A total row can be added ...

Technology update - July 20, 2015

    Samsung unveils Galaxy Tab S2 in 8-inch and 9.7-inch models; coming next ... Soon after its flagship smartphones Samsung Galaxy S6 Edge and amidst reports about the new Galaxy Note iteration, Samsung has quietly announced its new Galaxy Tab S2 models.         Micromax launches Yu Yureka Plus in India, priced at Rs 9999 - Micromax on Monday launched its third smartphone under the Yu brand. Yureka Plus, said to be the next-generation version of Yu Yureka smartphone, is priced at Rs 9,999.     Net Neutrality Debate : ASSOCHAM in favour of regulating all messaging   - Industry body ASSOCHAM has liked the proposal to regulate domestic Internet call services as it said that the government must expand the scope of regulation to all kind of communication services offered by over-the-top-players (OTT), reported PTI.     Revamped Yahoo Messenger for iOS debuts as Yahoo Livetext - The next versi...