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 Formulas
- Excel Array Formulas Examples
- 3 Ways to extract unique values from a range
- Count Unique Values in a column
- Count Unique Values based on multiple columns
- Select and Count Duplicate Values
- Dynamic Vlookup Function Explained
- 7 Ways to lookup a value based on multiple criteria
- Count the number of cells containing a particular word
- Find longest word in a cell
- Return Multiple Values for Lookup Value
- Convert Data from Wide to Long Format
- Convert Data from Long to Wide Format
- Convert a numeric value into words using Excel Formula
- Count Duplicate Values in a range
- Next Specified Day of the Week
- Conditional Formatting on a Chart
- Count the number of words in a cell
- Geeky and Creative Ways to Wish
- Intersection between curve and straight line
- Intersection of two linear straight lines
- Lookup Top N values ignoring duplicates
- Sum diagonal cells in a range
- Sum of Digits in a Number using Non array Formulas
- Excel Formula Explained: Correlation Matrix
- Extract text from alphanumeric value using Excel Formula
- Find Maximum Value Using Criteria in Excel
- Find Minimum Value Using Criteria in Excel
- Generating Unique Random Numbers in an interval in Excel
- Using Excel formula to compute partial correlation matrix
- Why two minus signs "--" in an excel formula?
Excel Charts & Dashboards Tutorials
- Professional Looking Excel Chart
- Pencil Bar Chart Free Template
- Amazing Percentage Chart
- Cool Excel Bar Chart Free Template
- Cool Excel Column Chart Free Template
- Interactive Up Down Arrows
- Change Chart from Count to Percent
- Interactive Chart using Check Boxes
- Interactive Chart using List Boxes
- ListBox ActiveX Control Explained
- Creating Infographics with Excel [Part I]
- Creating Infographics with Excel [Part II]
Share Share Tweet