MS Excel Tricks and Tips

MS Excel Tricks and Tips

If you're like most office workers, you probably use Microsoft Excel on a daily basis. But are you using it to its full potential? MS Excel is a powerful tool that can help you work more efficiently and effectively. Here are some tricks and tips to get the most out of MS Excel. Most people are familiar with the basic features of MS Excel, such as creating and editing spreadsheets. But Excel can do so much more. For example, did you know that you can use Excel to create charts and graphs? Or that you can use formulas to automate calculations? Excel is a versatile tool that can be used in a variety of ways. By learning some of the many tricks and tips available, you can make your work easier and more efficient.

1. Trick #1: How to quickly sum a column of numbers

2. Trick #2: How to insert the current date and time

3. Trick #3: How to quickly remove duplicates

4. Trick #5: How to use Autofill

5. Trick #6: How to change cells to uppercase or lowercase

6. Trick #7: How to quickly create a list of random numbers

7. By following the tutorial, you will be able to use Microsoft Excel to perform various tasks.

8. You can find the tutorial at the following link:

Excel Formula in Bangla, MS Excel Formulas and Functions, গুরুত্বপূর্ণ এক্সেল ফর্মুলা Technical Azad

MicrosoftExcel Bangla Tutorial | Ms Excel Bangla Tutorial | Technical Azad

SumIF, Count A, Count IF, Vlockup, Average IF, Roundup, Rounddown, Excel Formulain Bangla

রেজাল্ট সিট তৈরি করার নিয়ম, Student Result Sheet in Excel Bangla Tutorial, Part 01, Technical Azad

1. Trick #1: How to quickly sum a column of numbers

If you need to sum a column of numbers in Microsoft Excel, there is a quick way to do it. Simply click on the cell at the bottom of the column that you want to sum. Then, click on the AutoSum icon on the ribbon. Excel will automatically insert a sum formula in the cell.

2. Trick #2: How to insert the current date and time

One common task that people often do in Microsoft Excel is inserting the current date and time. There are a couple of different ways to do this, but one quick and easy way is to use the keyboard shortcut: CTRL + ; (semicolon). This shortcut will insert the current date in the cell that you have selected. If you want to insert the current time, you can use the shortcut: CTRL + Shift + ; (semicolon).

3. Trick #3: How to quickly remove duplicates

Removing duplicates is a common task when working with data in Excel. There are a few different ways to go about this, but the easiest is to use the built-in Remove Duplicates feature. To remove duplicates: 1. Select the data you want to check for duplicates. 2. On the Data tab, click Remove Duplicates. 3. In the Remove Duplicates dialog box, select the column or columns that contain the duplicates you want to remove, and click OK. Excel will then remove all of the duplicate rows from your data, leaving you with a clean, unique dataset. You can also use the Remove Duplicates feature to find and remove duplicate values in a single column. To do this: 1. Select the column you want to check for duplicates. 2. On the Data tab, click Remove Duplicates. 3. In the Remove Duplicates dialog box, select only the column you want to check, and click OK. Excel will then highlight any duplicate values in that column. You can then delete the duplicate values manually, or use the Copy/Paste feature to remove them from your dataset.

4. Trick #5: How to use Autofill

There are many times when you need to enter a series of numbers in Microsoft Excel and having the autofill feature can save you a lot of time. For example, if you need to enter the numbers 1 through 10, you could type 1 and 2 and then highlight those two cells and drag the fill handle down to cell 10 and Excel will autofill the rest of the cells for you. If you need to enter a series of numbers that are not in consecutive order, you can enter the starting number and ending number and then highlight those two cells and drag the fill handle. Excel will automatically fill in the numbers in between. You can also use autofill to enter a series of dates. For example, if you need to enter the dates for the month of January, you could type 1/1/2019 in one cell and 1/31/2019 in the next cell and then drag the fill handle. Excel will automatically fill in the rest of the dates for the month. There are many different ways that you can use autofill to enter data into Excel. Experiment with different options to see what works best for you.

5. Trick #6: How to change cells to uppercase or lowercase

There are a couple different ways that you can change the case of cells in Microsoft Excel. You can change them to all uppercase, all lowercase, or title case, which capitalizes the first letter of each word. To change the case of cells, first select the cells that you want to modify. Then, go to the Home tab and click the small arrow in the bottom-right corner of the Font section. This will open up the Font dialog box. Click the button next to Case, and then select the desired case option from the drop-down menu. For example, to change the cells to all uppercase, select the UPPERCASE option. Once you have the case option that you want, click the OK button to close the Font dialog box. The case of the cells will now be changed.

Given that Microsoft Excel is the most widely used spreadsheet program in the world, it’s no wonder that there are so many tips and tricks out there to help users get the most out of it. In this article, we’ve shared some of the best MS Excel tricks and tips to help you work smarter, not harder. Whether you’re a beginner or a pro, we hope you’ll find these tips helpful.