Creating Scrollable data ranges in Excel - Excel Form Controls: Scroll Bars
If Excel ever had a tongue it surely would have told us that eating thousands of rows is as delicious for it as dunking oreos in milk for humans! But we humans have another issue and that is we easily get tired of scrolling down especially if the list is so long as if it is […]
Making Interactive Charts in Excel [How To]
Graphs and charts are amazing tools to understand the information in the blink of an eye. It not only saves you from reading at all levels. That is why charts and Excel is one combination not to miss when you are learning Microsoft Excel application. But sometimes even the charts are so laborious that you wish […]
5 Ways to Transpose in Excel - Shifting Columns to Rows or Rows to Columns
One of our community member asked how to convert rows to columns or make columns as rows in Excel quickly without using pivot tables? Many already know how to do this. But for those who don’t this one minute Excel tutorial is for them. By the way, yes! you can use pivot tables to shift […]
![How Excel LOOKUPs Work: Demystifying mighty functions with an example from past [1 of many]](../../wp-content/uploads/2012/09/excel-page-featured-image-150x150.png)
How Excel LOOKUPs Work: Demystifying mighty functions with an example from past [1 of many]
Functions to Excel is like Sense to Humans. Humans with absent sense are no better than crawlers walking on two legs, without functions Excel is just another program with ability to store information and doing simple maths. In a nutshell functions made a spreadsheet program that can really excel at data. Functions are like ready […]
