Open Excel and go to File
Select Info
Click Manage Workbook
Choose Recover Unsaved Workbooks
Open the file you need
Save it immediately with Save As
Check the AutoRecover file...
To calculate a percentage of a value: `=A1*10%`
To find what percentage one value is of another: `=A1/B1`
To format the result as a percentage: select...
Enable the Developer tab: File > Options > Customize Ribbon > check Developer > OK
Go to Developer > Insert
Under Form Controls, select the Checkbox
Click...
To calculate a percentage: `=Part/Total`
To convert the result to a percentage, format the cell as Percentage
To find what percent one number is of another:...
Use `=A2=B2` to check if two cells match exactly
Use `=IF(A2=B2,"Match","No Match")` to return a custom result
Use `=EXACT(A2,B2)` for a case-sensitive match
Use Conditional Formatting to...
Use the `UPPER` function: `=UPPER(A1)`
Press Enter
Copy the formula down for other cells if needed
Copy the results
Paste Special as Values to replace formulas with capitalized...
Open a new Excel workbook
Create column headers such as Employee ID, Employee Name, Department, Designation, Basic Salary, Allowances, Deductions, Gross Salary, Net Salary
Enter employee...
Open Microsoft Excel
Create a new blank workbook
Rename the first sheet to Marksheet
Enter column headers such as Roll No, Name, Subject 1, Subject 2, Subject...
Use the formula `=UPPER(LEFT(A1,1))&LOWER(MID(A1,2,LEN(A1)))`
Replace `A1` with the cell containing the text
Press Enter
Copy the formula down for other cells if needed
Copy the results and use...
Open Excel and create a new workbook
Rename the first sheet to Salary Sheet
Create column headers such as Employee Name, Employee ID, Department, Basic Salary,...
Enable the Developer tab: File > Options > Customize Ribbon > check Developer > OK
Go to the Developer tab
Click Insert
Under Form Controls, select Checkbox
Click...
Select the cell or range you want to lock
Right-click and choose Format Cells
Go to the Protection tab
Check the Locked box
Click OK
Go to the Review...
Select the range of cells you want to transpose
Copy the selected cells
Click the destination cell where you want the transposed data to start
Right-click and...
Select the first column you want to move
Press Ctrl+X to cut the column
Right-click the destination column header
Choose Insert Cut Cells
Repeat for the second column...
To calculate a percentage of a value: `=A1*10%`
To find what percentage one value is of another: `=A1/B1`
To increase a value by a percentage: `=A1*(1+B1)`
To...
Right-click the sheet tab you want to hide
Click Hide
To hide multiple sheets, select the sheet tabs first, then right-click and click Hide
To hide a...
Use `=MONTH(A1)` to return the month number from a date in cell A1
Use `=TEXT(A1,"mmmm")` to return the full month name
Use `=TEXT(A1,"mmm")` to return the...
Select the cells containing the dates
Right-click and choose Format Cells
Go to the Number tab
Select Date from the Category list
Choose the date format you want
Click...
To find a percentage of a value: `=A1*B1%`
To find a percentage of a total: `=Part/Total`
To convert a decimal to a percentage: `=A1*100%`
To calculate percentage...
Select the range of cells you want to check
Go to the Home tab
Click Conditional Formatting
Choose Highlight Cells Rules
Select Duplicate Values
Pick a formatting style
Click OK
Review...
Open Excel
Go to the View tab
In the Show group, check Formula Bar
If the Formula Bar is still hidden, go to File
Select Options
Click Advanced
Under Display,...
Open your Excel workbook
Go to the Insert tab
Click Shapes
Select a line shape
Click and drag on the worksheet to draw the line
Hold Shift while dragging...
Use the `UPPER` function: `=UPPER(A1)`
Replace `A1` with the cell containing the text
Press Enter
Copy the formula down for more cells if needed
To convert text permanently,...
Select the range of cells you want to transpose
Copy the selected cells
Click the destination cell where you want the transposed data to start
Right-click and...
Enter your data in a single column
Click an empty cell where you want the result
Use `=STDEV.S(range)` for a sample standard deviation
Use `=STDEV.P(range)` for a...
Select the range of cells or the entire table
Go to the Data tab
Click Remove Duplicates
Choose the columns to check for duplicate values
Check or uncheck...
Open Excel and create a new worksheet
Create column headers such as Employee Name, Employee ID, Department, Basic Salary, Allowances, Deductions, Gross Salary, Net Salary,...
