### What is the PRICE Excel Function Used for?

April 21, 2017

Now we are going to learn all about formulas and functions. This is the best way to learn them:   PRICE Returns the Read More

### Using the ODDFPRICE Function in Excel

April 19, 2017

Now we are going to learn all about formulas and functions. This is the best way to learn them: ODDFPRICE Returns the price Read More

### Visual Interactions in Power BI

April 19, 2017

In this post I’m going to explore the options for Visual Interactions in Power BI … in other words, I’m going to explore the options to control what happens to other visuals when you select one in Power BI. Visual … Continue reading

The post Visual Interactions in Power BI appeared first on The Ken Puls (Excelguru) Blog.

### Reshaping your data easily – Case study [Pivot tables FTW]

April 17, 2017

Late. Jayaram, my uncle is also a teacher. When I was a kid, I used to spend a lot of time with him, learning all sorts of things. He taught me chess, maths and so many life lessons. I remember one such lesson very vividly.  One day, he asked me to do something. I did it in a very long way. After seeing me struggle for several minutes, he chipped in and showed me how to do it easily. He then said, “when someone asks you where your nose is, you don’t twist arm around your head. You just point to your nose directly.”

The idea is that when you have a direct, simple way to do something, you should use it.

Nose and pivot tables… how are they connected?

We are coming to the point. Read on for full case study and solution. Read More

### Quickly reset the last cell and minimize the used range

April 13, 2017

Save 5 minutes a day by using ASAP Utilities to quickly reset the used range on your worksheet. “Easily reset the last cell on your sheet” Have you ever been frustrated when Excel acts as if the active area of your worksheet is significantly larger than the actual area where you have data? Sometimes the […] Read More

### Auto numbering on steroids

April 12, 2017

Save 5 minutes a day by using ASAP Utilities to quickly insert a series of values into your cells. “Easily insert a series of values” Sometimes you need a bit more flexibility than Excel offers with its built-in Fill tool. For example to restart the count when a certain value is reached, add a pre-fix […] Read More

### Easy ways to combine the contents of multiple cells

April 11, 2017

Save 5 minutes a day by using ASAP Utilities to quickly combine the contents of multiple cells into once cell. “Is there a quick way to merge the contents of multiple cells?” We were recently asked: “Does ASAP have a quick alternative for merging the contents of many cells into a single one? Using ampersands […] Read More

### Quickly fix the trailing minus sign for negative numbers

April 10, 2017

Save 5 minutes a day by using ASAP Utilities to quickly fix numbers with a trailing minus sign. “How can I flip the minus sign and make it a real negative number?” We were recently asked: “I have downloaded a report that shows negative numbers as follows: 123.25- How can I make the negative symbol […] Read More

### Latest pre-release new version 5.1 now available

April 9, 2017

We’re happy to announce that the latest pre-release of the new version 5.1 of ASAP Utilities is now available. Many improvements have been made. If you use Excel 2013 or 2010 you will also see speed improvements when editing data formatted as Tables. We tested this pre-release thoroughly and have now made it available to you […] Read More

### Learn to Easily transpose 1 column into multiple rows, creating a table

April 4, 2017

Save 5 minutes a day by using ASAP Utilities to quickly transpose your single column into a table. “How to quickly change a long list to a table?” Have you ever had data in a single column that you manually needed to “Copy > Paste Special > Transpose” over and over again to get it […] Read More

1 2