New Excel Tool: Scribble a line and generate data (and chart)
This is a utility I created along with Raj Chaudhuri many years back.Use the scribble tool to draw a waveform or shape, the utility will create the data for it.
This is a utility I created along with Raj Chaudhuri many years back.Use the scribble tool to draw a waveform or shape, the utility will create the data for it.
Please read the earlier article Efficiency Test 4: Word. The challenge was to format Word tables in the most optimal way. Here is the solution. You need a total of 10 clicks.
Did you know Word can contain formulas? Yes. It can. For simple calculations you don’t need to use Excel. Estimated learning time 5 min
We take accuracy of Excel data for granted. Often the raw data as well as results of formulas can be wrong, outdated or misleading. Here is a collection of 13
Converting data from multiple columns to one column is a common requirement and we struggle to get this done. Very often we would have to resort to manual cut and paste.
Till now we have seen various aspects of plotting geographical information. How do you present this information to others? Often we want to show our plans in a step by
Till now we have been plotting just one number for each geographical location. Now we will understand how the number can be broken down by categories available in your data.
Showing familiar data on a map and that too with time animation added is a completely new and powerful way of visual thinking and analysis.We will continue to explore three
Power Map series article 3. We will explore how to plot and interpret date/time type of information visually on the 3D map. This type of visualization is new to most
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
