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 : 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