If you want to plot some data, Excel is still the quickest way to do it. There are many small and medium sized organisations which still use MS Excel for data storage as it's one of the cheapest way for storing data. If you are a novice user and want to gain intermediate and advanced knowledge of MS Excel, check out the links below. The following links describe a set of advanced excel tutorials which are useful for learning advanced formulas, productivity excel tips, excel charts, excel infographics and excel dashboard.
Advanced Excel Formulas
- Excel Array Formulas Examples
- 3 Ways to extract unique values from a range
- Count Unique Values in a column
- Count Unique Values based on multiple columns
- Select and Count Duplicate Values
- Dynamic Vlookup Function Explained
- 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?
Excel Charts & Dashboards Tutorials
- Professional Looking Excel Chart
- Pencil Bar Chart Free Template
- Amazing Percentage Chart
- Cool Excel Bar Chart Free Template
- Cool Excel Column Chart Free Template
- Interactive Up Down Arrows
- Change Chart from Count to Percent
- Interactive Chart using Check Boxes
- Interactive Chart using List Boxes
- ListBox ActiveX Control Explained
- Creating Infographics with Excel [Part I]
- Creating Infographics with Excel [Part II]