background preloader

The Ultimate Excel Cheatsheet

The Ultimate Excel Cheatsheet
Working with the new Excel 2007 is now more frustrating than ever when it comes to finding the right commands. Sometimes it seems like part magic and part luck. That’s why we’ve put together the cream of the crop of Excel shortcuts in easy to use cheatsheets you can print up and keep handy. Highlighting the most commonly used and commonly looked for Excel commands, this list puts it all at your fingertips. Learn how to get around Excel using only the keyboard. These cheatsheets have the keyboard shortcuts for mainpulating files, editing content, changing formatting and navigating around workbooks. Excel Function Cheatsheets The key to being efficient with Excel is knowing which functions to use. Excel Formula Cheatsheets If you need specific calculations, this is a good place to start. How To Read Cell References Simple Math Formulas From Microsoft.com Adding Numbers Calculate Percentages Rounding Numbers Advanced Excel Tips From Microsoft.com Guidelines and Examples Of Array Formulas

http://www.investintech.com/articles/excelcheatsheet/

Related:  Free Resources & TutorialExcel

Complete Reference Guides and Online Manuals for All Adobe Tools Even years after it went up, a lot of people still don’t know about it. We’re talking about the free online documentation for all Adobe software – a set of user manuals that can answer quite a few customer questions, and also be a great resource if you don’t use a product yet but want to find out more about it… This exists in searchable and downloadable form for all major Adobe applications, including the Creative Cloud, Creative Suite, Lightroom, Acrobat, Photoshop Elements, etc. – for all recent releases on both Windows and Mac OS. For example, every so often we receive a question on how to save back to earlier versions from InDesign CC or CS6… Fortunately, this is answered in the “Saving Documents” section in InDesign’s online manual. (And for all the cases like these, we also put together a special roadmap for CC file compatibility.)

The Excel Magician: 70+ Excel Tips and Shortcuts to help you make Excel Magic Posted by nitzan on Wednesday, November 28th, 2007 Are you working with Excel and want take your Excel skills to the next level? Or do you want to learn Excel and don’t know where to start?

Complete list of Facebook Chat Emoticons While playing with Facebook Chat I wondered if it supported emoticons. Turns out it does. But when I tried the >:-) emoticon (a 'devil') and saw it printed as boring text, I wondered, "what smilies does facebook actually support?" 15 Free Guides That Really Teach You USEFUL Stuff Freely available to MakeUseOf subscribers, there are now multiple manuals released every month, for everyone to enjoy. After releasing 15 manuals and nearly half a million downloads we thought it was about time to look back and review what has been published so far. Enjoy! Downloads are free, no strings attached. 1 – Internet Guide for the Movie Addict Written by Saikat Basu, this entirely free PDF production will show you anything you’ve ever dreamed about knowing related to movies on the web.

Your Top 10 Boredom-Busting Websites Last week, we asked you what your go-to sites were when you hit the afternoon lull. We checked out all the boredom busters you sent in and let’s just say… it was hard to pull ourselves away! Some of our faves like Pinterest, Tumblr, Twitter, and HuffPo obviously made the list, but here are the 10 others that stood out. Some we’ve been addicted to for a while, some are new finds, all are great ways to kill some downtime.

Two ways to build dynamic charts in Excel If you want to advance beyond your ordinary spreadsheet skills, creating dynamic charts is a good place to begin that journey. The key is to define the chart's source data as a dynamic range. By doing so, the chart will automatically reflect changes and additions to the source data. Fortunately, the process is easy to implement in Excel 2007 and 2010 if you're willing to use the table feature. If not, there's a more complex method. We'll explore both.

Everything you ever wanted to know about C types, Part 1: What's in a type? The C language provides a fairly elaborate system for data types. This series provides an overview of the C type system, as well as some detailed discussions of some of the musty corners people don't normally know about. It is worth learning. As Henry Spencer wrote: High Dynamic Range (HDR) Photography: Tutorials, Tips and Stunning Examples Taking amazing photos is something many aspiring amateur photographers strive for. And HDR effects can really make your images pop. Below is a complete toolbox to get you started with HDR photography on your own. Why Atheism? Just about everyone is an atheist when it comes to other gods — the gods that other people believe in or that nobody believes in anymore. I’m an atheist about all gods because there's no reliable evidence for any god, or even for Jesus. There is also extensive evidence that Jesus and all gods are fictional characters — myths created mainly by primitive people who had little understanding of how our universe operates. We all like myths and other stories, but we don't have to believe them.

The 200 Best Graphic, App & Web Design Tools & Resources (Categorized) This post is #21 in DailyTekk’s famous Top 100 series which explores the best startups, gadgets, apps, websites and services in a given category. Total items listed: 198. Time to compile: 8+ hours.

Related:  ExcelPracticalinterwebComputer Stuff