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 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

How to create a 3d formula in excel

Creating formulas on identical sheets become quite easy. You don’t need to go to every sheet to select the concerned cell to create a formula instead by turning all the sheets into a range you can create a 3d formula which will be quite concised and less prone to making mistakes.

So in this tutorial, we will see how we can create a 3d formula in excel.

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

#3dformula #identicalsheets #MsExcel

Create your website with WordPress.com
Get started
%d bloggers like this: