Excel Tips
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? Check out these 70+ tips and shortcuts that will help you make Excel Magic. Online tutorials & videos The following online tutorials are mostly free and will teach you quite a bit about Excel.
The Excel Magician: 70+ Excel Tips and Shortcuts to help you make Excel Magic
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 I’ve put together the cream of the crop of Excel shortcuts in easy to use cheatsheets you can print up and keep handy.
Takeaway: Users will appreciate a chart that updates right before their eyes. In Excel 2007 and 2010 it’s as easy as creating a table. In earlier versions, you’ll need the formula method.
Two ways to build dynamic charts in Excel
Create a dynamic Excel chart and make your own dashboard
October 14, 2011, 7:33 AM PDT Takeaway: A dynamic chart reuses the same chart object to chart different source values. You’ll save time and your users will appreciate the effort. Charting data is an easy task and reusing a chart is efficient! By reusing, I mean to use the same chart object to chart multiple sources.
November 1, 2011, 8:32 AM PDT Takeaway: Combine data validation and conditional formatting to implement an easy-to-use dynamic banding option for your users. Thanks to conditional formatting, you can apply several banding schemes to your Excel worksheets, and we’ve discussed several of them already. One possibility we haven’t reviewed, however, is using data to determine which rows are banded. Throw in a little data validation and you can let users band (or shade) specific rows by simply choosing an item from a list.
Make every user a power Excel user with dynamic conditional row banding
How to find duplicates in Excel
Ugh! Too much work. I prefer to let the computer do the work for me. I sort first then use custom macros:Sub NextAlike()' This macro moves the active cell down until it finds a duplicate. a = 0 Do... Read Whole Comment +