Excel Tutorials : Beginner to Advanced

In today's world, knowing Microsoft Excel is not a technical 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 junior associates to CEOs of organizations, everyone uses MS Excel for day-to-day tasks.

Microsoft Excel is the widely used tool for data analysis across industries. Using MS Excel, you can perform anything from basic mathematical calculations to complex statistical regression models.

Excel For Beginners

The following tutorials provide useful MS Excel lessons for beginners to get started with Excel.

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

The following tutorials describe a comprehensive set of intermediate and advanced MS Excel lessons that are useful for learning Excel beyond the basics.

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?

Professional Charts with MS Excel

The following tutorials provide lessons on how to create beautifully professionally designed charts in MS Excel.

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]

Do you know the power of MS Excel?

You can automate repetitive tasks using Excel Macros by writing VBA code. It's a general saying that there are no limits to what Microsoft Excel can achieve. Data Science is emerging these days, there are many other tools like Python and R 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 cost-effective solution for data storage for companies that cannot afford expensive relational databases.

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

The following tutorials provide various macros which are utilities to automate tasks. You can use them as per your needs.

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

The following MS Excel tutorials provide a step by step guide on how to perform various statistical analyses.

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

You can use the following MS Excel templates to automate various statistical tests and models.

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

The following tutorials would show how to perform simple to complex mathematical calculations using MS 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