This walk-through shows how to get started with creating a pivot table from a dataset in minute
YouTube video showing an introduction to Power Query and explanation of the relationship between Excel, Power Query and Power BI
Thanks to PowerQuery (free tool within Excel and Power BI) we can do clean “dirty data” in a matter of minutes with NO code.
Power Automate is getting more and more actions added each week, we can now generate a PDF from a Word document but unfortunately still not… Read More »How to use Power Automate to convert Excel sheet to PDF (and a third party App with #nocode)
In just a few clicks it can really give a large table of data a “spark” and show the actual progression of data within a timeline.
Use the Geography column type in Excel to expand your search without leaving Excel
As you used to do with Excel 2003. I just stumble upon this add-in, so forgive me if I am a bit late 😉… Read More »Continue to sync a Sharepoint list with Excel 2007
Found the answer in a post on EggHeadCafe.com.the problem was a column Date/Time format that must have got corrupted, once I change the type one… Read More »Off bug : Export a MOSS2007 list to Excel 2003 error – now fixed
And I can’t figure out why, when , how .. I knew that this feature is specific to Office 2003 Pro which is what I… Read More »My IE "Edit in Datasheet" has stopped working 🙁