Microsoft Excel is the widely used tool for data analysis and manipulation across industries. With the use of MS Excel you can perform a basic calculation like multiplication to a complex statistical regression model. The following tutorials describe a set of in-depth excel lessons which are useful for learning basic, intermediate and advanced MS Excel. It covers topics such as functions, excel macros, excel charts, excel dashboards, Infographics with Excel. It also covers how to apply most of the important mathematical and statistical techniques with Excel.
In today's world knowing Excel is not a techincal skillset, it is must for all the professionals. It does not matter how many years of experience you have or if you work in a public sector or corporate, Excel is used everywhere. From a junior associate to CEO of the organisation, everyone use MS Excel for day to day tasks. Data Science is emerging these days, there are many other tools (like SAS, R and Python) available for carrying out analysis but Excel still holds its position and is being used as a deliverable for sharing output with others. It is also considered as a cheap tool for data storage for companies which cannot afford relational databases. You can also automate repetitive tasks using macros and writing VBA code. It's a general saying that there is no limit what Microsoft Excel can achieve.

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

- Lesson 1 : Getting Started with Excel VBA
- Lesson 2 : Record Your First Macro And Run It
- Lesson 3 : Writing Your Own VBA Code - 35 Examples
- Lesson 4 : Playing with Dynamic Ranges in Excel

**Excel VBA Tutorials**

- 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