background preloader

20-excel-spreadsheet-secrets-youll-never-know-you-dont-read-this

20-excel-spreadsheet-secrets-youll-never-know-you-dont-read-this
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. Please note that all these functions are based on Microsoft Excel 2010. 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. 5. 6. 7. 8. 9. 10. 11. 12. 13.

http://www.lifehack.org/articles/technology/20-excel-spreadsheet-secrets-youll-never-know-you-dont-read-this.html

Related:  Learning StuffICTDropZone DumpscatterpointsFreeTechnology

40 Key Computer Science Concepts Explained In Layman’s Terms Software developer Carl Cheo, founder of technology blog Carlcheo.com, knows what he’s talking about when it comes to computers! So, to help those of us who aren’t particularly technologically inclined he’s written an article explaining 40 Key Computer Science Concepts in easy, understandable terms. Read Carl’s fantastic article below to find out all you need to know about algorithms and data structures, AI, computer architecture, concurrency, computer security, cryptography and software development methodologies. 40 Key Computer Science Concepts Explained In Layman’s Terms Corkboard Connections: Out with Answer Keys - In with QR Codes! Try QR Codes with this Task Card Freebie! You know what QR codes are ... those black and white patterned squares you scan with your smartphone to be taken to a webpage with more information about, well, anything! They've been popping up everywhere, from restaurant menus to PTA flyers. QR stands for "Quick Response" because scanning the code takes you to a new location instantly. But did you know that QR codes are super useful in the classroom, too?

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. Bakery technology - Salt, sugar, emulsifiers, enzymes 1.4. Other ingredients - salt, sugar and emulsifiers Salt Salt's main function is to bring out the flavour of the baked product. Salt tends to bring out the good flavours and mask the off-flavours. Usage levels are normally between 1,8 % and 2,2 %.

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.

11-steps-creating-the-perfect-business-logo You know the saying: a picture says a thousand words, and this could not be more true when it comes to logo design. Whether you’re running a big brand or your own personal business, your logo is key! You can show someone exactly what you’re aiming to do and what your selling in a millisecond, so you better put a lot of effort into that design. Fortunately, Company Folders has your back so your logo will stand out amongst the design crowd. 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

Self-organising origami robot unfolds itself… and walks - tech - 07 August 2014 Video: Self-folding robot walks on its own It's a real Transformer. A flat chunk of butterfly-shaped plastic magically folds itself into the shape of a four-legged robot – and then, astonishingly, walks off using its own power source.

Related: