Formula Friday – Using Keyboard Shortcuts To See Precedent or Dependent Cells In Excel
Today let's look at how to use Excel keyboard shortcuts to see Precedent or Dependent Excel cells in an Excel workbook. I use these two commands to easily audit my Excel formulas. Cells that are...
Macro Mondays – Select And Format All Cell That Contain A Formula In Your Excel Workbook
Hello Excellers, I want to share with you a handy Macro that I use regularly. Do you ever have a worksheet where you need to format every cell that contains a formula? It can be a tedious task if...
Formula Friday – View All Of Your Calculated Fields And Items Contained In Your Excel Pivot Table
Welcome, Excellers. Almost everyone who has used Excel has had to work with Pivot Tables at some stage. I will show you how to list all the calculated fields and items in your Pivot table in today's...
I like to cut down on actions that constantly require you to manualy repeat them. I like to do things once, then just re-use the process of possible. That is why this is such a great time saving...
Formula Friday – Create A Dynamic Report Header Using The Concatenate Function
I like to automate processes as much as possible and creating report headers for updated monthly reports are no exception to this. If you have the same headers every month, but only the Month name...
Formula Friday -Using The Workday Function To Calculate Status Of An SLA
I dont know about you, but our IT department at work has an SLA turnaround time of 8 days. That is 8 working days, so we can't really chase them for any updates until that time has elasped. ...