Excel Tutorials : Beginner to Advanced

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

1. Excel Keyboard Shortcuts Every Analyst Must Know
2. VLOOKUP Function and Its Uses
3. HLOOKUP Function and Its Uses
4. MID Function and Its Uses
5. OFFSET Function with Examples
6. CHOOSE Function and Its Uses
7. Handle Wrapped Text in Excel
8. Hide zeros in range in Excel

Advanced Excel Formulas

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

Smart Charts

1. Cool Excel Column Chart : Free Template 01
2. Cool Excel Column Chart : Free Template 02
3. Cool Excel Bar Chart : Free Template 03
4. Create Pencil Bar Chart in Excel : Free Template 04
5. Create Amazing Percentage Chart in Excel
6. Professional-Looking Excel Chart
7. Infographics with Excel [Part I]
8. Infographics with Excel [Part II]

Learn VBA Programming in 4 Lessons

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

Excel VBA Tutorials

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

Excel Macros

1. Convert Multiple Excel Files to PDF
2. Convert Multiple PowerPoint Files into PDF with Excel VBA
3. Filter Data Based on Drop Down Selection
4. Calculating Partial Correlation Matrix with Excel VBA
5. Excel UDF: Copy cell comment into another cell
6. Excel UDF: Dependent cell comment
7. Concatenate Text Based on Criteria

Statistical Analysis Using Excel

1. Install Analysis ToolPak Add-In
2. Calculate Frequency Distribution in Excel
3. Calculating Partial Correlation Matrix with Excel VBA
4. Correlation Matrix Using Excel
5. Descriptive Statistics Using Excel
6. Normal Distribution Using Excel
7. Sample Size Calculator with Excel
8. Compute Correlation Matrix
9. Compute partial correlation matrix

Templates For Statistical Analysis

1. Calculating Dependent Sample T Test : Excel Template
2. Calculating Independent Two Sample T Test : Excel Template
3. Pearson's Correlation Coefficient Formula Explained - Excel Template
4. Calculating Simple Linear Regression - Excel Template
5. Gain and Lift Charts - Excel Template

Mathematics Using Excel

1. Check if a number is prime with Excel
2. Generating prime numbers in an interval with Excel
3. Counting prime numbers in an interval with Excel
4. Calculating Intersection between curve and straight line with Excel
5. Calculating Intersection of two linear straight lines with Excel
6. Generating Unique Random Numbers in an interval with Excel

Spread the Word!
Share Share Tweet