Excel ALTernate ‘Powercut’ - One key to rule ALL shortcut keys
Ranking up in Excel world is not easy but definitely there are steps you can take to become an Excel head and one of such steps is to remember shortcuts. Well you have no idea how much Excel nerds who know shortcuts are appreciated in this part of the world. But if you look at […]
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 to thought that when you create a chart the selected range is locked tight so show graph therefore if the data […]
30+ Copy & Paste Tricks You Must Know - Mouse Keyboard Autofill Paste Special and More!
Ctrl+C & Ctrl+V - The Saga continues! For sure Ctrl+C and Ctrl+V is one of the most famous keyboard shortcut in windows environment and one big reason for it become famous beyond limits is that it can be used in almost every Windows application software including Microsoft Excel. You might know how to do copy […]
ACCA Online Classes December 2013 Announcement and Quick Excel Tip on Duplicating Excel Worksheets
This time around the post is a mix plate. Some of you were worried that how come key strokes are silent on Excel for more than 24 hours. So here you have the confession and also your Excel tip for which you wait everyday. So again fulfilling the promise to make you excel at Excel […]
Birth Dates Heat Map in Excel - How To
First off whoever has birthday on July the 7th my best wishes to all of them. You people have a very interesting birth date. 7 and 7. Everyone’s birthday is interesting in one or the other. But what if you like to know how the birthdays of employee in an organization are spread over the […]
Microsoft Excel Keyboard Shortcuts - Mega Collection
Microsoft Excel’s best side is its shortcuts. These are pure productivity enhancement toppings that everyone craves to learn and know as many as they can as they not only speeds up things but also gives you freedom of multiple input devices at one time. The following collection of shortcuts is still a work in progress. […]
Replace a formula with the value or final result - Super Easily
Formula and Excel is a bond not meant to break. Although formula do help us get the values we want. But often you find that it will be code that you just get have the result itself what the formula computes. That means you want to hard code the cell with the result and replace […]
Excel Most Wanted - Selection shortcut keys Mega collection
While working in Excel or any data related job selection is one job in itself. And even in Excel it is not easy when you making your way through thousands of cells. However, life is much easier if you know selection tricks Excel has to offer and even better is they come in shape of shortcut keys […]
Excel Custom Shortcuts - Reaping real benefits of Quick Access Toolbar
Many excel beginners especially those who are using version 2007 and later a small bar which is by default placed above ribbon alongside the title bar and many recognize it for its UNDO button. Well it deserves a respect because if it is a toolbar than actually it means efficiency and by overlooking it we are overlooking […]
How to show 0 (digit) as text ZERO or Nil or anything in Excel
Excel is about measuring and calculating but it is not only just numbers it can also help you make the information more understandable and user friendly. In calculations we often get a result 0 instead of any positive or negative digit or number. If you desire highlighting this result and instead of a digit 0 […]
