The following links describe a set of excel tutorials which are useful for learning basic, intermediate and advanced MS Excel. It includes tutorials about useful excel functions, excel macros, excel charts, excel dashboard, Infographics with Excel. It also covers how to apply most of the important mathematical and statistical techniques with Excel

Excel For Beginners

Advanced Excel Formulas

- Excel Array Formulas with Examples
- Custom Number Format Examples
- 3 Ways to extract unique values from a range
- 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?

Smart Charts

- Cool Excel Column Chart : Free Template 01
- Cool Excel Column Chart : Free Template 02
- Cool Excel Bar Chart : Free Template 03
- Create Pencil Bar Chart in Excel : Free Template 04
- Create Amazing Percentage Chart in Excel
- Professional-Looking Excel Chart
- Infographics with Excel [Part I]
- Infographics with Excel [Part II]

Learn VBA Programming in 4 Lessons

- Excel VBA : IF THEN ELSE STATEMENT
- Excel VBA : Select Case Statement (Alternative to IF THEN ELSE)
- Excel VBA : Message Box
- Excel VBA : FOR - NEXT LOOP
- Excel VBA : User Defined Functions(UDFs)
- Excel VBA : Worksheet Functions
- Excel VBA : Find Last Used Row and Last Used Column
- Excel VBA : How to debug a user defined function (UDF)

Excel Macros

- Convert Multiple Excel Files to PDF
- Convert Multiple PowerPoint Files into PDF with Excel VBA
- Filter Data Based on Drop Down Selection
- Calculating Partial Correlation Matrix with Excel VBA
- Excel UDF: Copy cell comment into another cell
- Excel UDF: Dependent cell comment
- Concatenate Text Based on Criteria

Statistical Analysis Using Excel

- Install Analysis ToolPak Add-In
- Calculate Frequency Distribution in Excel
- Calculating Partial Correlation Matrix with Excel VBA
- Correlation Matrix Using Excel
- Descriptive Statistics Using Excel
- Normal Distribution Using Excel
- Sample Size Calculator with Excel
- Compute Correlation Matrix
- Compute partial correlation matrix

Templates For Statistical Analysis

Mathematics Using Excel

- Check if a number is prime with Excel
- Generating prime numbers in an interval with Excel
- Counting prime numbers in an interval with Excel
- Calculating Intersection between curve and straight line with Excel
- Calculating Intersection of two linear straight lines with Excel
- Generating Unique Random Numbers in an interval with Excel