All You Need to Know About

Excel Analysis Tutorials

Learn the various analytical tools inside Excel, like Conditional Formatting, Data Validation, Tables, Sort & Filter plus MORE!

This section shows how much you can do in analyzing data in Excel. Here are the top things you can do with Excel Analysis:

Top 10 Tutorials

  1. Create a Data Entry Form in Excel– Whenever I wanted to input data for my Tables in Excel, I would have a long time inputting the records one by one.  I discovered a handy trick in Excel that can turn my Table into a handy Data Entry Form!Read more
  2. How to Remove Formulas in Excel– There are times when I have an Excel worksheet full of formulas and I want to hard code the results and remove the formulas completely.Read more
  3. Excel Number Formats – Thousands & Millions– Large numbers in Excel can be formatted so they can be shown in “Thousands” or “Millions”.Read more
  4. Add Custom Symbols With Your Numbers in Excel– In our example below we want to enter a % Variance column in our data and insert the symbols ▲▼ to show a negative and positive variance.Read more
  5. Dynamic Data List using Excel Tables– Excel Tables have many great features to them and one of them is their ability to create a dynamic drop down list.Read more
  6. What Microsoft Excel Version Do I Have?– I will show you a few cool ways where you can determine the Excel Version right away!Read more
  7. Clear a #REF! Error in Excel– When your Excel workbook has formulas that are linked to other workbooks/cells that have been deleted, you will get a #REF! error.Read more
  8. Excel Table Slicers– In Excel 2013, Slicers have been extended to be used with Excel Tables.  WOW!Read more
  9. Top Excel Data Cleansing Techniques– Data cleansing is an important activity within Excel and one that we find ourselves doing day in day out, sometimes without even knowing itRead more
  10. How To Create A Custom List In Excel– A Custom List in Excel is very handy to fill a range of cells with your own personal list. It could be a list of your team members at work, countries, regions, phone numbers or customers.Read more

Read More

Latest Tutorials

Want to get better at Excel?

Join Our Excel Community

Get our Free Weekly Excel lesson plans that cover the must know Excel features and tips to make you better at Excel!