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:  shaundonnelly

The Best New Features of Adobe Photoshop CS6 Photoshop CS6 has some great new features that designers are sure to love. Upgrading from CS4 or CS5 is simple and straightforward, and the new tools are intuitive, practical, and extremely helpful for a wide variety of design purposes. Adobe put a lot of time and effort into their newest iteration of Photoshop. As a result, there are hundreds of improvements. Rather than trying to list every single one of them, here are a few of the most noteworthy additions in Photoshop CS6. Content Aware Move

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?" Free Software for College Students - StumbleUpon If you’re in college, check out these eight lesser known, but still indispensable software applications for your computer. We bet these will be as useful as Dropbox and Evernote! Photo by Samantha Decker. 64 Things Every Geek Should Know - laptoplogic.com The term ‘geek’, once used to label a circus freak, has morphed in meaning over the years. What was once an unusual profession transferred into a word indicating social awkwardness. As time has gone on, the word has yet again morphed to indicate a new type of individual: someone who is obsessive over one (or more) particular subjects, whether it be science, photography, electronics, computers, media, or any other field. A geek is one who isn’t satisfied knowing only the surface facts, but instead has a visceral desire to learn everything possible about a particular subject.

Free Excel Downloads. Excel Functions and VBA (Visual Basic for Applications) AdvancedFilter.zip This is a zipped Excel Workbook that has six working examples using Excels Advanced Filter. It has three that use no formulas and three that do use formulas.

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: StumbleUpon BackRex: Outlook Express and Outlook backup tool. Most features in the free version. Mozbackup: Simple utility for creating backups of Firefox, Thunderbird profiles. It allows you to backup and restore bookmarks, mail, contacts, history etc. IMAPSize: A great tool to transfer Thunderbird e-mail to Outlook/Outlook Express (not sure why you would - but it's here). 6 Things I Bet You Didn't Know You Could Do with Google Some of the tips below are effortless to implement and save you a lot of time and energy when dealing with these issues. Let’s start with the first proof of the awesomeness of Google… 1. Create unlimited disposable email addresses with Gmail If you add dots (.) between the letters of your Gmail username, sending an message to the new username will get forwarded to your original email (which is without or with only 1 dot.) For example:

100 Websites You Should Know and Use Entertainment Meet David Peterson, who developed Dothraki for Game of Thrones There are seven different words in Dothraki for striking another person with a sword. Among them: “hlizifikh,” a wild but powerful strike; “hrakkarikh,”a quick and accurate strike; and “gezrikh,” a fake-out or decoy strike. Dictionary of Algorithms and Data Structures This web site is hosted by the Software and Systems Division, Information Technology Laboratory, NIST. Development of this dictionary started in 1998 under the editorship of Paul E. Black. After 20 years, DADS needs to move. If you are interested in taking over DADS, please contact Paul Black. This is a dictionary of algorithms, algorithmic techniques, data structures, archetypal problems, and related definitions.

Related: