Hello Excellers and welcome back to my #Excel #FormulaFriday blog post in my Excel 2020 series. Today's formula calculates how far you are from a goal. This is sometimes referred to as a percentage of target or forecast. It is easy with an Excel formula. The math in the formula is simple to divide the goal or target by the actual. So, it doesn't matter if you need to calculate how far you are away from your travel destination or near your sales target. The formula … [Read more...]
Create A Self Expanding Chart In Excel
Hello Excellers, welcome back to another Excel tip today. I will show you how to create a self-expanding chart. This tip is also a YouTube Video. Why not check it out in the link below. So, it is really easy to create a self-expanding chart in Excel. Is it?. YES!. Normally a chart is set up to only display what is currently on the datasheet. But, by a few tweaks and Excel magic, we can set up a chart differently. We can allow a chart to automatically accommodate new data as it is … [Read more...]
How To Check A Folder Exists. Macro Solution.
Hello Excellers and welcome back to another #McaroMonday #Excel blog posit in my Excel Macro 2020 series. Today I will show you how to write some code that will allow you to check if an Excel folder exists. It's very useful, and I have used it many times. Starting The VBA Macro. First, you will need to open the Visual Basic Editor. There are two ways to do this. Either by hitting ALT +F11 orSelecting the Developer Tab | Code Group | Visual Basic. Both methods have the … [Read more...]
Absolute References With Excel Tables.
Hello, Excellers. Welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. Today's blog will show you all you need to know about how to use Absolute (and Relative) references when you are using an Excel table and structured references. Absolute Cell References. I think one of the most useful and first thing we learn when using Excel is the value of using the $ symbol. (Or the F4) key. This allows you to freeze a column or row, so when dragging a formula down a … [Read more...]
Disable Or Enable GetPivotData.
Hello Excellers and welcome back for another #Excel #MacroMonday blog post in my Excel 2020 series. This small simple Excel VBA macro will allow you to quickly enable or disable the GetPivotData function in Excel. The GetPivotData Function. The Excel GETPIVOTDATA function can query a Pivot Table and retrieve specific data based on the Pivot Table structure, instead of cell references. Syntax There are three parameters or arguments that are used in GetPivotData. Data_field: … [Read more...]
- 1
- 2
- 3
- …
- 90
- Next Page »
Recommended Excel Resources
