Excel Pivot Tables Date GroupingDates can be a bit tricky. For the best solution to working with dates in our Pivot Table […] November 5, 2022 in Excel tagged data / ungroup / table / client / date / tools / model / pivot / hide / calendar / group / dates / power by Mike
Excel Protect SheetDo you have an Excel template for others to fill out and you want to make sure that […] November 5, 2022 in Excel tagged format / password / security / find / lock / protect / secure / unprotect by Mike
Excel Table RelationshipsSuppose you have two tables of data in Excel that are related. As an example, you might have […] November 5, 2022 in Excel tagged power / table / link / join / left / model / relationship / pivot by Mike
Create a Pivot Table from Multiple Sheets using Power QueryDo you have an Excel workbook (file) that has multiple worksheets of data that you need to combine […] November 5, 2022 in Excel tagged power / append / union / sheets / table / combine / merge / query / pivot / multiple / many / Excel Pivot Tables by Mike