Forum

Hi Mohamed, When you get data from a folder containing files that need cleaning before appending, you do the transformations in the 'Transform Samp...

Hi Erwin, Welcome to our forum! Try removing all filters from the PivotTable, then apply the formatting. If that doesn't work, please share your...

Hi Andrew, Yes, see this tutorial on slope charts in Excel. Warning, there's no shortcuts! Mynda

Great to hear, Karlin! Please consider my PivotTable Quick Start course, or if you want to dive deep, our Xtreme PivotTables course. Mynda

No, there was no file attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the file size ...

Glad you like the look of Power Query, Rod. It's a game changer. If you'd like to learn more, please consider my Power Query course.

Hi Mohammad, Welcome to our forum. Please provide an example Excel file that illustrates your question, the data you're working with and your de...

Hi Rod, Sounds like you could be using Power Query to automate this whole process. Mynda

Hi Karlin, Welcome to our forum! You can and should use a PivotTable for this. See the Pivot sheet of the attached file for an example. You can ...

Hi Meyanui, For this you must put your data in the correct tabular layout in a single sheet. You can use Power Query to consolidate the data into o...

Hi Rod, You don't need VBA to do this. You can use a dynamic named range. You can use INDEX and MATCH to find the last value in a column and define...

Hi Ridwan, The NETWORKDAYS.INTL function's first two arguments are the start date and end date. If you want a different range calculated, then chan...

Hi Matt, You should be able to use COUNTIF on column U to count the different license types? Or COUNTIFS for multiple criteria which would enable y...

Hi Ridwan, Welcome to our forum! You can use NETWORKDAYS.INTL for this, but you need to list your holiday dates. See file attached. Mynda

Hi Thomas, That depends what you want this chart title to say? e.g. Do you want it to say 'Employees in Office between Monday and Friday', or 'Empl...