Science & Tech

Microsoft Excel 2021 – User Guide, Tips and Tricks

0
Microsoft Excel-Tips and Tricks

Microsoft Excel-Tips and Tricks and Important Excel Queries

Microsft Excel is the top and widely used tool for complex calculations, making graphs, histograms, bar graphs, pivot tables, etc., in the form of spreadsheets. Excel support VBA (Virtual Basic for Applications) programming language. In MS Excel, we have to input data then apply the relevant formula; excel will process within nanoseconds. 

Microsoft Excel has revolutionized the Accounting, Staistanaly, Data Analysis, Data Management field by its unique and diverse features. Data of Massive Business Industries are being processed in MS-Excel from simple Employee’s Salary management to Record-Keeping of Inputs and Outputs. 

Simple User Guide for using MS Excel

First of all, Download and Install MS Excel on your PC. Now open MS Excel and click “File,” then “NEW,” a spreadsheet will open. The columns are noted in a spreadsheet as A, B, C… while rows are indicated by numbers 1, 2, 3… Next is to write the amount /values in the cells and apply the excel formula accordingly. Using Excel is not simple as MS word; there are many formulas and tricks in Microsoft Excel which can process your work within a shorter time, but for that, you have a firm grip on MS Excel. Here are answers to frequently asked MS Excel Queries. 

How to Add in Excel

To add values in excel, select relevant cells, go to the “Formula” tab, click “AutoSum,” and choose “Sum.” 

How To Multiply In Excel

To multiply two or more cells in MS Excel, Check the Cell position of cells to multiply like. For example, if you want to multiple the value of cell C2 and D4, the put excel multiplication formula like =C2*D4.

How to Subtract in Excel

Click on a cell where you want the output and inset “=” followed by numbers or cells to be subtracted, like =59-89 OR =A4-Y6.

How To Wrap Text In Excel

To wrap your text in Excel, Go to the “Home” tab and tap on “Wrap Text Option.” 

How To Alphabetize In Excel

To arrange your text alphabetically in Microsoft Excel, Selects cells for arrangement, Go to the “Home” Tab, Find “Sort & filter,” and click it. Options will be open for alphabetical arrangement choose accordingly. 

How to Make a Histogram in Excel

To make a histogram in excel, select relevant cells, go to “Insert,” and click the “Insert Static Chart” icon, and the Histogram group will open. Now, Choose, “Histogram Chart” Icon.

How To Hide/Unhide Columns In Excel

To hide and Unhide a column in Excel, you need to select the relevant columns, tap right-click, choose “Hide a column,” to unhide the columns procedure is the same, Double lines present on the upper side of the spreadsheet will show hidden columns.

How To Hide/Unhide All Rows In Excel

If you want to hide & Unhide a row in Excel, select the relevant row, right-click it, and choose “Hide a Row,” The same is for unhiding.  

How To Move Columns In Excel

To move a column, select the column and drag the mouse towards the borders of Columns. For example, an arrow with four heads will appear, hold and drag it to move a column in excel.  

Count Unique Values in Excel or Remove Duplicate Values

If you have multiple duplicate values in your Sheet and want to remove them, choose the “Dataset,” Go to “Data,” click “Advanced,” select “filter the list; in place,” Tick. “Unique Records” only, and click “OK.” Another Procedure is to go to “Data,” and then in the “Data Tools” Tab, Click “Remove Duplicates.” 

How to Password Protect A file in Excel

To protect confideitaonal files in MS Excel, Choose this path 

File > Info > Protect Workbook > Encrypt with a Password > Enter and Re-Enter Password > Click OK. 

How To Split Cells In Excel

Select the cells (to be split), Then Go to “Layout,” Click “Split Cell” in “Merge Group” Tab, “Split Cells” Dialog will appear, input number of rows and columns for split, and click “OK.” 

How to Subscript In Excel

To Subscript a number or word in excel, you need to follow the pattern. 

Select a Word or Number > Click Ctrl+1 > Click Alt+B > Enter

How to Superscript in Excel

To Superscript a number or word in excel, you need to select words or numbers, then click “Ctrl+1”, then Tap “Alt+B > Enter.”

How To Add A Column In Excel

In order to add a column, select any cell, go to the “Home tab,” click on “Insert,” and Choose “Insert Sheet Columns.” 

How To Add A Row in Excel

To add a row in excel, Select any cell, go to the “Home tab,” click on “Insert,” and Choose “Insert Sheet Rows.” 

How To Delete a Column in Excel

To Delete a row in excel, Select any cell (Column to be deleted should be in the same Cell), go to the “Home” tab, click on “Delete,” and Choose “Delete Sheet Column.”

How to Delete a Row in Excel

In order to delete a row in Excel, Select any cell within a row or column(to be deleted), then go to the “Home” tab, click on “Delete,” and Choose “Delete Sheet Row.”

Find And Replace In Excel

If you want one word replaced with another, you don’t have to find them manually and then replace them. 

Just Click “Ctrl+F,” enter the word, and then press “Find all.” Then, if you want to replace it, enter the word you wish to replace and click “Replace All.”

Spell Check In Excel

To check Spelling in MS Excel, Go to “Review” and click “Spelling or Just Press F9”.

How To Make A Bar Graph In Excel

Select the concerned data, Go to the “Insert” tab, and click “Graphs Icon,” and then Choose “Bar Graph.”

New Line In Excel Cell

To create a new line or insert a line break in excel, click “Alt+Enter.”

How To Calculate Variance In Excel

For example, you want to find the variance of cells from “A1 to A10”. Put this formula to find variance in excel “=VAR.P(A1:A10).”

How To Copy Formula In Excel

Click “Ctrl+C” in Cell having formula and “Ctrl+V” to paste the formula in any other place in Sheet.

How To Group Worksheets In Excel

To group worksheets in Excel, Press “Ctrl” and Click Relevant Sheets.

How To Find Mean In Excel

Choose the cells and Go to “Home,” Click on “Σ” and choose “Average,” it will find the mean or average of that specified cells. 

Convert Excel To Google Sheets

To convert the Excel file into a google sheet, paste the excel file in good drive and tap on it to Open; now the option “open with google sheets” will appear; click it, then “save as” google sheets. 

Convert Excel To Word

To convert Excel into word, Use online conversion websites.

How To Capitalize Text In Excel OR how to change case in excel

If you want to change any column or Cell case, you must have an empty column or Cell in front of that. Then, write formulae in the next empty column accordingly, i.e., =PROPER (Row x Column: Like A1) to convert the case into Proper, =UPPER (Row x Column: Like A1) to convert cell case to Uppercase, and =LOWER (Row x Column: Like A1) to convert Cell’s case to lower case. 

How To Change Date Format In Excel

Change the Date format from Control Panel; Excel will automatically change the format in Excel. 

How To Search In Excel

Press “Ctrl+F,” dialog box will appear, write the word or statement you want to search in the excel sheet, and press “OK.” 

How to Calculate average in excel

Select the “Cells of Interest” and Go to the “Home” Tab, Click “Autosum,” and choose “Average.” 

How to Create PayPal Account in Pakistan

Previous article

How to buy Bitcoin in Pakistan – Crypto Currencies in Pakistan

Next article

You may also like

Comments

Leave a reply