How to learn advanced excel free.
Advanced excel has a simple meaning of all features and functions of Microsoft Excel is used by users to handle large calculations and data processing. Large data analysing and solving big issues related to any data in Excel. Microsoft Excel is a champion among the least demanding and weighty programming applications open out there.
![]() |
Advanced Excel |
Now we will discuss advanced excel in detail but before proceeding let s understand what is basic excel also.
Basic excel consists of some of the basic functions or formulas in excel Now we used the word basic so it does not mean that basic excel is nothing or not needed to learn. Basic excel has also an important role because if we do not understand basic steps or functions in excel then, of course, we will have an issue understanding advanced excel.
Basic Excel
Now as we said basic excel is also important to learn so here we will add some basic functions first to understand.
Basic functions consist of those functions that we can see below. Let us have a look here.
Sum: This function is very nice as we can use it to add the numbers as a sum means we can add any columns or rows that consist of numbers.
Count: We can use this function easily to count the cells or rows if there is data in cells.
For example.
![]() |
Count Function |
Average: This function counts the cells and calculates the average of the total cells that consists of numbers not texts, Let us take an example here.
If we mention any numbers in cells in rows or columns like this below.
A1: A10 = Average(A1: A10)
This function will only calculate the cells where numbers are mentioned in the data and if we mentioned some texts in there then the text will be ignored.
![]() |
Average Function |
Now we have seen that in the image above all data has been calculated as per the Average function and the outcome is 537 finally which is an average of the total data that we have in the above cells in excel. Also, we can see texts in some cells which were ignored by this average function.
Though there are many basic functions in excel which are very important to learn before we go to an advanced level in excel. Now here we will discuss advanced excel with formulas and examples.
Advanced Excel Topics
- Pivot Table & Reporting
- Pivot Charts
- VBA & Macros
- Conditional Formatting
- Data Validation
- Creating a Dashboard in Excel
- Advanced Vlookup
- Advanced Hlookup
- Advanced Excel tricks
- Data Tables
- Tables & Formatting
- Index+Match
- Formula Auditing
- Array Formulas
- Sumifs
![]() |
Advanced Excel- IF function |
When this Pivot-table is ready then we can simply create a Pivot-Chart by using an INSERT tab and create a Pivot-Chart as it is there in the drop-down option OR When you will click anywhere in the chart then it will easily appear as a chart ribbon.
Data Validation is also one of the best advanced excel functions as it helps users to put conditions in data like as per numbers or texts. For example:- If we need numbers from 01 to 250 then we can put this condition so that numbers will appear above 250 in the column or row accordingly.
=SUM(B2: B7)
![]() |
Advanced Excel - Sum Function |