Forgot bit locker pin, forgot bit locker recovery key, 5 Easy ways to fix

-
Image
 Did you forgot your bit locker pin and recovery key. Try these methods, I hop it help you. 1. When you see this screen, Press "Esc" key in your keyboard for more recovery option. It will say preparing BitLocker recovery, You will see the screen bellow in few minute. Here we will click on "Skip the drive", You will see the screen bellow. Here you need to Turn off your PC, and then enter the BIOS of your PC. In order to enter BIOS, check for your PC brand and model and search on google, how to enter BIOS for your particular brand and model of your PC. Search for "Secure Boot" Enable it and check it, if it works for you. If it do not work, come back to same place and Disable "Secure Boot" and try again, see if it work for you. 2. If the above method do not work for you, try resetting your PC, You can choose any of the two option for resetting your PC, "Keep my files" or "Remove everything" whichever works for you. 3. If the abov...

How to Do Aggregate Calculations in Excel

-

The AGGREGATE function in Excel allows you to perform a variety of aggregate calculations (e.g. SUM, AVERAGE, MAX, MIN, COUNT) on a range of cells, while ignoring any errors or hidden cells. This function is particularly useful when working with large data sets that may contain errors or blank cells.

The syntax for the AGGREGATE function is: AGGREGATE(function_num, options, array, [k])

Where:

  • function_num is the number that specifies which aggregate function to use (e.g. 1 for AVERAGE, 2 for COUNT, 3 for MAX, etc.)
  • options is a number that specifies which values to ignore in the calculation (e.g. 2 to ignore any error values, 3 to ignore any hidden cells, 4 to ignore both errors and hidden cells)
  • array is the range of cells or array constant to perform the calculation on
  • k is an optional argument that specifies which value to return when function_num is set to 5 (which calculates the k-th largest value in the range). If k is omitted, the function returns the largest value.

For example, the following formula calculates the average of a range of cells (D1:D10), ignoring any hidden cells:

the following formula calculates the average of a range of cells (D1:D10), ignoring any hidden cells:

To find maximum value, follow the formula:

How To find maximum value, follow the formula:

To find summation of the values, follow the formula:

How To find summation of the values, follow the formula

Note that the function_num and options arguments can be combined to create a variety of aggregate functions with different behavior. For example, using function_num = 6 and options = 1 calculates the median of the range, while function_num = 9 and options = 1 calculates the mode of the range.