Learn Advance Microsoft Excel

What is Microsoft Excel :

Excel is a powerful tool to store our data and get the desired information using its inbuilt formula’s.

Let’s start the work on Excel as a beginner and will finish it by an advance excel user.

Best of Luck..

1. First we need to install the Microsoft office from the official Microsoft website – https://www.microsoft.com/en-in/download/office.aspx
2. These days Microsoft office is called Microsoft 365 which facilitates us with cloud solution also.
3. After sign up we can use the cloud version of Microsoft 365 and can download the offline setup also.
4. After installation of Office setup we can use the Excel.

Let’s start with basic Formulas –

• Sum –  We can sum multiple values in Microsoft Excel, Let’s take an example to understand it :

If i want to sum my all sales values during the dates 1-1-2024 to 10-1-2024 then we can use this formula :

=SUM(B2:B11)

Here in this example i am putting dates in “A” Column and Sales value in “B” Column

• Just like “Sum” formula we can use some more basic formula’s in Excel such as Average, Max, Min.

# Now we should go ahead and learn about the most importent and valuable tool of Microsoft Excel – Sort & Filter

We can use this tool when we need to works on raw and huge data because it helps to save our time and efforts. Let’s take an example and understand that how it works :
If we are having huge amount of data i.e. so many fruits name and we want to work on specific data then we can use this both options Sort and Filter, If we are having fruits name in column “P” and i want to work on only Apple or Papaya then i can use the “Filter” Option and if want to sort out the fruits from low to high cost then i can use the “Sort” Option. Now let’s think that i’ll work manually on this data to do this without these tools then how much time will it take ?

# Now we will learn about – Find and Select

If we are working on huge data and need to find any specific word then we can use these options to find that word quickly, Let’s suppose we need to find out “Orange” and “Papaya” then we will select the option “Find” and type the word “Apple” and then “Papaya”
If we need to replace any specific word then we can use “Replace” option, For example if i need to replace the word “Papaya” to “Papaya 1” and “Orange” to “Papaya” then instead of doing one by one i can replace all in one click or can select the cells in which i want to replace the word.