Excel tables, (known as lists in excel 2003) is a very powerful and supercool feature that you must learn if your work involves handling tables of data.
Articles Tagged: Learn Excel
5 Handy Office Tips for Microsoft Excel
Looking for some Excel goodness? Here are some quick tips you might like to try to improve your productivity.
Excel Circular References – How to deal with them?
In Excel, a circular reference is created when you refer to same cell either directly or indirectly. Learn more about Excel Circular References here.
100+ Quick Excel Tips
I’ve compiled 100+ Excel tips below so that you can soak in a bunch all at once.
How to Build an ARRAY Formula in Excel
Array formulas may be Excel’s most powerful feature for summarizing data. However, they also are one of Excel’s least-used features. Here’s how to use this hidden power.
5 Quick Excel Tips for Marketers and SMBs With No Time
Save time and improve your reporting skills with these important tips.
5 Interesting and Funny Excel Tricks You Must Know
MS Excel is a sea of knowledge. Whatever proficiency you may have in Excel but still I would say there would be a lot of thing yet to be known. I just love MS Excel. Lets learn these funny and interesting Excel tricks.
24 Excel Keyboard Shortcuts to Help You Work Faster, Better
Make working with spreadsheets a little easier with these Excel keyboard shortcuts that will have you working like the pros in no time.
Excelling PivotTables – All you should know about PivotTables
PivotTables are Awesome. Awesome in general, but more specifically awesome for processing large flat tables of data.
Conditional Formulas in Excel & Tricks Using the IF Function in Excel
If ever there was a single function in Excel that I use the most, it’d probably be the IF function. It is a workhorse as far as I’m concerned, as it can be used in combination with several other functions for a plethora of purposes. Along with other Logical Functions like AND, OR, NOT, TRUE, and FALSE, you’ve got all the ingredients you need to create some really cool formulas that will help you not only sort your data, but can even help improve the aesthetics of your spreadsheets and help to automate the analysis of your data. Here are some reasons why I have unconditional love for conditional formulas in Excel.