Advanced Excel Tutorials

MS Excel is the most popular tool for data analysis. It is widely used across domains and industries. Having advanced knowledge of MS Excel is an asset in the job market. You can perform a variety of analysis ranging from basic descriptive to advanced regression modeling. MS Excel is bread and butter for many professionals across industries. In finance, financial models are generally built in Excel. There are many companies which still use MS Excel for dashboarding despite existence of many online Business Intellingence and reporting tools like Power BI, Tableau etc.

If you want to plot some data, Excel is still the quickest way to do it. There are many small and medium sized organisations which still use MS Excel for data storage as it's one of the cheapest way for storing data. If you are a novice user and want to gain intermediate and advanced knowledge of MS Excel, check out the links below. The following links describe a set of advanced excel tutorials which are useful for learning advanced formulas, productivity excel tips, excel charts, excel infographics and excel dashboard.

Advanced Excel Formulas

1. Excel Array Formulas Examples
2. 3 Ways to extract unique values from a range
3. Count Unique Values in a column
4. Count Unique Values based on multiple columns
5. Select and Count Duplicate Values
6. Dynamic Vlookup Function Explained
7. 7 Ways to lookup a value based on multiple criteria
8. Count the number of cells containing a particular word
9. Find longest word in a cell 
10. Return Multiple Values for Lookup Value
11. Convert Data from Wide to Long Format
12. Convert Data from Long to Wide Format
13. Convert a numeric value into words using Excel Formula
14. Count Duplicate Values in a range
15. Next Specified Day of the Week
16. Conditional Formatting on a Chart
17. Count the number of words in a cell
18. Geeky and Creative Ways to Wish
19. Intersection between curve and straight line
20. Intersection of two linear straight lines
21. Lookup Top N values ignoring duplicates
22. Sum diagonal cells in a range
23. Sum of Digits in a Number using Non array Formulas
24. Excel Formula Explained: Correlation Matrix
25. Extract text from alphanumeric value using Excel Formula
26. Find Maximum Value Using Criteria in Excel
27. Find Minimum Value Using Criteria in Excel
28. Generating Unique Random Numbers in an interval in Excel
29. Using Excel formula to compute partial correlation matrix
30. Why two minus signs "--" in an excel formula?

Excel Charts & Dashboards Tutorials

1. Professional Looking Excel Chart
2. Pencil Bar Chart Free Template
3. Amazing Percentage Chart
4. Cool Excel Bar Chart Free Template
5. Cool Excel Column Chart Free Template
6. Interactive Up Down Arrows
7. Change Chart from Count to Percent
8. Interactive Chart using Check Boxes
9. Interactive Chart using List Boxes
10. ListBox ActiveX Control Explained
11. Creating Infographics with Excel [Part I]
12. Creating Infographics with Excel [Part II]

Spread the Word!
Share Share Tweet Subscribe