# Excel hacks

## Collection by Phillip Fagg • Last updated 9 weeks ago

218
Pins
•
31
Followers

Angle cells in Excel to make your spreadsheet more visually interesting and professional. See how to angle cells in Excel - instructions + video tutorial.

Did you know that you can create flowcharts in Microsoft Excel? Here's how to set up a flowchart in Excel right away.

To make a workable and practical drop down list in Excel we need to get a sorted unique data for from the data range that is unsorted and has duplicates. An...

Excel VLOOKUP with Drop Down - The VLOOKUP function in Excel can become interactive and more powerful when applying a Data Validation as the Lookup_Value.

Get our Free Excel Shortcuts | 333 Excel Keyboard Shortcuts for Windows & Mac. Compatible with Excel 2007, 2010, 2013, 2016, 2019 & Office 365

In life we all want to be in control. And usually we measure or judge whether things under control by comparing whats happening with what should be happening. In other words, we tend compare the actual events/results with planned events/results. Though more interestingly most of us don’t really know if the “plan” is really under control or not. Anyways […]

Previously in Excel Formulas: How to use UNIQUE Formula in Excel?

To make a workable and practical drop down list in Excel we need to get a sorted unique data for from the data range that is unsorted and has duplicates. An...

Just the other day I was teaching my ACCA F5 students about variance analysis and there we learnt that not every variance needs to be investigated and only those should be probed that breach a certain threshold which was explained with a chart. That’s where I had a light bulb moment to have it done […]

Get 1,000+ Excel training videos for all levels. Our online Excel courses will teach you Formulas, Macros, VBA, Pivot Tables, Power BI, Microsoft Office plus MORE!

Previously in Excel Formulas: How to use AND Formula in Excel?

3 Ways to add a zero in front of a number in Excel. It can be tricky to add a leading zero in Excel without having the zero disappear. Step by step instructions + video tutorial.

When you want to create a PivotTable, what do you do if you have data in different worksheets? If you’re using Excel 2013, you have a streamlined method of doing this. There’s a technique called th…

Excel conditional functions are part of almost every worksheet. The logical test functions help us carry out different operations easily. While discussing SUMIF we learnt to sum the values based on one criteria i.e. date. However, what if we want to sum up the values not only on the basis of date but also the […]

To get the inspiration for better charts and Excel dashboards one must be observant of such pieces of information that are often found in newspapers and the internet. For that matter, Pinterest and The Economist are my routine sources of inspiration among several others. This is why today we are learning to make waffle charts […]

If you have columns that you need to split by an equal number of characters, say ID numbers then it will be helpful for you.