10+ Excel features in Home tab that every beginner MUST learn

1 Don't just Paste, Paste Special! Position in tab: Clipboard group>Paste button drop down | Shortcut: Alt+Ctrl+V This one is definitely a speciality in Excel's arsenal of features. Normal paste option only put what you copy...

Creating and Working with Dynamic Charts in Excel

Title should be "making charts dance to your command in Excel" but lets keep it technical :) OK let me be very quick at it as I learnt about this almost by chance. I used...

My Top 10 personal favourite Excel keyboard shortcuts

Everybody has preferences and likeness towards Excel keyboard shortcuts and I am no exception. So here is my personal top 10 list of Excel keyboard shortcuts that help me immensely when going through my...

Building a reference to specific Worksheet based on Cell value using Formula

Most of the time businesses are managed using specialized software but when it comes to a final touch in reporting the data is exported to Excel where calculations and everything is done much more...

Excel Pivot Table tutorial for Absolute Beginners: Creating your First Pivot Report [2 of...

In Part 1 of this little jump start series on Pivot Tables for Absolute Beginners I explained what excel pivot tables are the science behind their working through example and explained how pivot table let...

10+ ways to SUM Top N values in Excel data range – Ready to...

We all love to add things up. Its always good if things add up to the way we want. And no doubt from Excel newbie to pro everyone uses SUM formula. We have recently...

20+ Excel Table tricks to turbo charge your data

In my last article on tables Introduction to Excel Tables - Data beyond just formatting I discussed the basics. If you are new to excel or if you think that tables are meant for just...

Introduction to Excel Tables – Data beyond just formatting

Many people think converting data into table is basically a formatting options giving it colours and other eye candies like giving data "zebra lines". But there is much more to it beside data formatting...