Home » Advanced Excel Tutorials

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.
Advanced Excel Tutorials

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
Subscribe to: Posts (Atom)