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.

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

7 Tricks To Make You A Spreadsheet Expert Computer spreadsheet programs, like Excel, are an excellent tool for organizing, storing and manipulating data. Here are tricks that will assist with data entry into the spreadsheet: 1. Control the cell pointer during data entry: Excel automatically moves the cell pointer to the next cell down when you press Enter after entering data into a cell. Choose: File ->Excel Options -> Advanced ->Editing Options. Enable Check-box “After pressing Enter, move selection” and the corresponding drop-down, controls the action of the cell pointer during data Entry.Tip: On disabling the check-box, arrow keys can be used to control the direction of the pointer. 2. Excel Spreadsheet is grid of rows and columns. To add Excel Data Tables, select a Range of Cells comprising of data and click on Table button residing inside the Insert Ribbon. Data Table Tricks: Data Tables comes with its own set of Data Filters and Sort Options by default. 3. The options on the Dialog box are as follows: 4. 5. 6. 7.

15 Best Keyboard Shortcuts You're Not Using One of the best features of Windows 7, which also appears in Windows 8's desktop mode, is the ability to snap windows next to each other so you can split the screen evenly between applications. To perform this snap feature with the mouse, you need to drag a window all the way to the left or right side of the screen. Don't bother. Hit Windows + Left Arrow to snap a window to the left side of the screen or Windows + Right Arrow to snap it to the right. More: 8.1 Worst Windows 8.1 Annoyances And How to Fix Them

Related: