Excel hacks

Collection by Phillip Fagg • Last updated 9 weeks ago

218 
Pins
 • 
31 
Followers

Angle Cells in Excel

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

How to Create a Flowchart in Microsoft Excel | Flow chart template, Microsoft excel, 7 habits

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

#Excel #Drop #Down: Learn how to make data validation lists that can sort and update auto

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

Vlookup with a Drop Down List in Excel

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.

[FREE PDF DOWNLOAD] 333 Excel Keyboard Shortcuts!

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

Budget vs Actual Variance Reports with "In the Cell Charts" in Excel - PakAccountants.com

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 […]

How to use SORTBY Formula in Excel?

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

#Excel #Drop #Down: Learn how to make data validation lists that can sort and update auto

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

Create Excel Charts with Bands or Threshold in the background - [How To] - PakAccountants.com

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 […]

MyExcelOnline Academy - Learn Macros, VBA, Formulas, Pivot Tables, Charts, Power BI, Access + More!

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!

How to use ADDRESS Formula in Excel?

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

Add a Zero in Front of a Number in Excel – 3 Ways (+ video tutorial)

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.

Advanced PivotTables: Combining Data from Multiple Sheets

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 #Functions: SUMIF Introduction + Examples

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 […]

Make Waffle Charts in Excel using Conditional Formatting - How To - PakAccountants.com

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 […]

How to Split Column by Number of Characters Using Power Query?

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.