Monday, September 28, 2020

Why the excel does not update the formula | Excel Formula not working

When excel formula not worked, the workbook has been placed in "Manual calculation" Mode, which means excel will not update all the formulas, whenever you update the workbook, it manuallay forced to do so.
It can also effect copying, as when you copy and paste a formula, the result will be copied instead of the correct answer, it would not automatically update, so we have to perform manual calcualtion and use it's prompt.
How to solve it We have to force a manual calcualtion.
Turn it back to automatic.
It has to be noticed that manual calculation is performed only when you have large data and you have to speed up the calculations.
1. Force a Manual calucation by pressing F9
2. Swith your workbook back to automatic from Formulas => Calculation options.
It solves most of our problems like Formula not calculating in excel
Formula not calculating correctly in excel
Formula not calculating in cells
Formula not calculating showing as text
Formula is not working in Excel
We can solve most of our issues of calucation from the above methods.

Formatting text and numbers

This is how we can modify cells. 1. Select the cells you want to modify and selecting a range. 2. Click the drop down arrow next to the number format command on home tab. A drop down will appear from where we can change the format. 3. We have to then select the format we want based on our criteria from formatting options 4. After the selection of format 5. The selected cells will change the new formatting style.

What is Format cells in Excel

Format a cell in excel is using to change the appearance of a number withoug change the number itself, only the format would be changed.

Thursday, September 24, 2020

Your PC Ran into a Problem and Needs to Restart in Windows 10 | Tutorial 2020

The blue screen error as "Your PC ran into a problem and needs to restart" is a very common error, We would provide the solution to this probelm step wise, there are so many fixes to be try. We have to try each one until the problem fixes, however, we would discuss the first fix here. It can loss your data therefore try to recover the data trhough any application available on the internet.
It can be considered as the Your PC ran into a problem Fix
Your PC ran into problem windows 10
Your PC ran into problem causes
This error occurs due to memory problems, it can be because of corrupt system files or due to the system drivers. The problem "Your PC ran into a problem and needs to restart" can be because of power failure or malware/virus infection.
In order to fix the "Your PC ran into a problem and needs to restart", restart the system is required.

Boot your System or Boot Windows
You can boot your system, apply some troubleshooting steps to save from error again.
Boot your computer in safe mode and then boot normally 1. In Windows 10, click "Start" > "Settings" > "Update & Security" > "Recovery". 2. In the "Advanced startup" section, choose "Restart now". 3. After the restart, choose "Troubleshoot" > "Advanced Options" > "Startup Settings" > "Restart". 4. Now you will see the "Startup Settings" screen. You can choose one of the three Safe Mode options: "Enable Safe Mode", "Enable Safe Mode with Networking", or "Enable Safe Mode with Command Prompt". 5. Restart your computer and see whether it boots properly. Your PC ran into problem and needs to restart, we will restart for you, would be resolved.

What is Excel Worksheet

A worksheet is a collection of cells where you keep and manipulate the data. Excel Worksheets allow you to enter data. Each Excel workbook can contain multiple worksheets.

Tuesday, September 22, 2020

Excel Shortcut Series - Some useful shortcut keys in Excel, Part 2

Some useful shortcut keys in excel part 2 is below.

Excel Workbook

Excel Workbook is used for excel file, When excel has started, you have to click blank workbook to create a Excel Workbook.

Excel formulas and functions

Excel formulas and functions Formulas and functions are the bread and butter of Excel. They drive almost everything interesting and useful...