kpis

  1. M

    Where am I missing the Else without IF?

    Good morning. I have embedded a macro into Workbook_Open but in doing so I am prompted with 'Else without IF' error. It highlights the 'Else' line but I am unclear what further IF statement is needed? Any advice gratefully received. Private Sub Workbook_Open() Dim FR Dim answer As Integer Dim...
  2. G

    Which visual to make a boring old table of KPIs?

    Hi, I want to make the old fashioned table of KPIs that I would do in PPT or Excel. So something like the table below. I basically want a table where the first column is the measure name and the second the value. There would then be a slicer attached to it. Seems like this should be super...
  3. E

    Calculating KPIs by month/week

    Hi all, I'm relatively new to Excel (using 2016 version) and trying my best to figure out the best way to complete a task for my manager - so here's my issue... I've been asked to publish a daily insight into my department's activities and whether we are meeting our KPIs in terms of days taken...
  4. M

    Entering minutes and seconds in excel

    I am creating a new KPI (Key Performance Indicator) dashboard for my company. One of the stats included is our ASA (Average Speed of Answer) and I'm trying to input the weekly numbers for each department and they have a MTD & YTD portion that will give us the overall average. The format of this...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top