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