background preloader

20 Tricks That Can Make Anyone An Excel Expert

20 Tricks That Can Make Anyone An Excel Expert
After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. Here are 20 useful Excel spreadsheet secrets you may not know. 1. You might know how to select all by using the Ctrl + A shortcut, but few know that with only one click of the corner button, as shown in the screenshot below, all data will be selected in seconds. 2. Rather than open files one by one when you have multiple files you need to handle, there is a handy way to open them all with one click. 3. When you have different spreadsheets open, it’s really annoying shifting between different files because sometimes working on the wrong sheet can ruin the whole project. 4. Generally there are three shortcuts in the top menu, which are Save, Undo Typing and Repeat Typing. 5. Related:  DropZone DumpFreeTechnology

Top 10 Incredibly Useful Windows Programs to Have On Hand List of collective nouns A skein of geese This is a list of traditional or whimsical collective nouns. The large number of collective nouns in English is based on a tradition of venery (words for groups of animals) which arose in the Late Middle Ages. Standard terms for particular groups are listed first in each group and shown in bold. See also[edit] References[edit] Create a Macro in Excel - Excel VBA Easy Developer Tab | Command Button | Assign a Macro | Visual Basic Editor With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro which will be executed after clicking on a command button. First, turn on the Developer tab. Developer Tab To turn on the Developter tab, execute the following steps. 1. 2. 3. 4. 5. Command Button To place a command button on your worksheet, execute the following steps. 1. 2. 3. Assign a Macro To assign a macro (one or more code lines) to the command button, execute the following steps. 1. 2. The Visual Basic Editor appears. 3. 4. Note: the window on the left with the names Sheet1, Sheet2 and Sheet3 is called the Project Explorer. 5. 6. Result: Congratulations. Visual Basic Editor To open the Visual Basic Editor, on the Developer tab, click Visual Basic.

Microsoft Sway: Introduction and tutorial Microsoft Sway is a new tool in the Office family. It is a cloud-based WSYWIG editor to express your creativity visually. As we are moving forward in “Cloud First, Mobile First World” we need something new which give us more power to become more productive.So we are on the way to re-imagine our world. In this post, you will learn What is Sway? What is Sway? Sway is used to create beautiful, web-based expression, quickly and easily whenever you need, whatever device you have. Watch this introduction video about Sway. Sway is for Students, Designers, Manager’s even for Ceo’s. No doubt these all are having their own functionality and importance at their place even they are well established in a cloud but their native work is content creation. Read all the Idea and Philosophy behind the creation of Sway from Microsoft Team. So let’s get started with Sway. Creating your First Sway As sway is a web-based tool you need an internet connection and a browser to get started with it. Sharing Sway

14 Reasons Why Your iPhone Goes Out Of Battery Quickly The iPhone is considered a great feat in not only advancing some of the cellular features that have already been a part of cellular phones, but to also be the forefront of the creation of some of these features. However, one thing that comes with these added features and advancements is a weak battery life. The batteries can only take so much and when you couple in the applications that individuals love to hoard, the battery most likely won’t even last half the day. This doesn’t have to happen. You’re Not Limiting Location Services You’d be surprised by the number of applications that are making use of location services and you don’t even need to make use of it. Your Mail is Always Fetching Similar to the issue with locations, mail that is set to fetch means that your iPhone continuously check your mailbox server, waiting for a new message. Your Apps Are Always Running iOS 4, your iPhone has been able to run multiple apps at the same time. Your Screen is Too Bright You Have Apps Refreshing

zdnet As reported by Wayne Williams at Betanews and confirmed by us, a simple registry hack to a Windows XP system tricks Windows Update into providing updates for it. Williams says that the hack, included just below, makes the system look like Windows Embedded POSReady 2009 which will continue to receive updated until April 9, 2019. To apply the hack, create a text file with a .reg extension and the contents below: Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\WPA\PosReady] "Installed"=dword:00000001 Run it by double-clicking in Windows Explorer. The screen capture is from our own tests, which appear to work. This specific hack works only on 32-bit systems, but a 64-bit workaround is available at this page, which may have been Williams's source for the 32-bit hack. We asked Microsoft for a comment, but due to the holiday we don't expect one immediately.

How to Transfer Data between two laptops using LAN Cable - Microsoft Community Found this helpful 1 You can't use an ordinary Ethernet cable - you need a cross-over cable. MS Community Contributor Award 2011 By creating a Homegroup you can share files through a local network. See here for instructions on Windows 7 and here for Windows 8 Create your homegroup on Windows 7 and select the categories you wish to share. Now you'll be able to view files on one computer using the other and in the same way copy and paste them through network. If you just want to do a file transfer once, remember to undo the sharing settings. Hope this helps Found this helpful 3 Answer Hi friends i tried with the below procedure and it worked .. so am posting this for future reference..:) 1. Open control panel window. Then you find a pop up box of Network and Sharing Center. Enter IP Address: – 192.168.0.1

OfficeMix : Office 365 – Did You Know Created 6 weeks ago Duration 0:09:56 More Tips and Tricks from Office 365 Select the file type you wish to download Slide Content Slide 1 - Office 365 – Did You Know? Slide 13 - Share with your friends Don’t forget to check out our first Mix – Office 365 Trivia

Related: