Design a site like this with WordPress.com
Get started

How to interact with Excel dashboards in PowerPoint (not a good idea)

Well, while presenting a presentation, we often find a need to interact with the data we have added to our presentation so that we can show some speculative changes to the audience.

But interacting with excel dashboards in PowerPoint has many limitations and it also can’t be edited when the slides are in the slide-show mood.

#excel #powerpoint #exceldashboard

I hope this will be helpful for someone out there and thanks for watching.

Advertisement

How to update values in excel on the go or on the spot

Well,…Sometimes, you received a report from your subordinate to present during the board meeting but at the eleventh hour… you received a message or call from him/her informing you the change in the actual data and you need to make these changes in the values on the spot.

So in this tutorial, we will see how we can make changes in the data right away.

#excel #changedata #changevalues

I hope this will be helpful for someone out there and thanks for watching.

How to convert formulas into pure values in excel

After creating formulas, sometimes you want them to convert values for some possible reason and in this tutorial, we will see, how we can convert formulas into values in excel.

I hope this will be helpful for someone out there and thanks for watching.

How to give Raw and Column Reference in excel

In this tutorial, we will see how we can give a raw and column reference instead of getting results through a range of cells.

#excel #rawreference #columnreference

Thanks for Watching & Don’t Forget to Like, Share & Subscribe.

How to show or display cells containing formulas in excel

Sometimes, while working on an excel sheet, we do find a need to see all the formulas at once so that we can figure out what is wrong and if the sheet is full of formulas on random cells then it becomes even difficult to click on every cell and see the formula.

So in this tutorial, we will see how we can show or display all the formulas at once.

And I hope this tip will be helpful for someone out there and thanks for watching.

#MsExcel #displayallformulas #easytoedit

%d bloggers like this: