📽 New Video Upload : Introduction to Excel Pivot Tables
This walk-through shows how to get started with creating a pivot table from a dataset in minute
Excel
📽 Introduction to Power Query: it’s simple than you may think
YouTube video showing an introduction to Power Query and explanation of the relationship between Excel, Power Query and Power BI
How to fix a dirty data in Excel? (using PowerQuery)
Thanks to PowerQuery (free tool within Excel and Power BI) we can do clean “dirty data” in a matter of minutes with NO code.
How to use Power Automate to convert Excel sheet to PDF (and a third party App with #nocode)
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)
1 min: Use Excel sparklines to highlight a trend in a report table
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.
Become a data scientist using Excel Geography data type
Use the Geography column type in Excel to expand your search without leaving Excel
Excel services not loading on Project server 2010 environment
While in EPM 2010 Administration training this week the Excel Services webparts refused to load and threw a Javascript error. A quick search and we… Read More »Excel services not loading on Project server 2010 environment
Continue to sync a Sharepoint list with Excel 2007
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
Off bug : Export a MOSS2007 list to Excel 2003 error – now fixed
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
My IE "Edit in Datasheet" has stopped working :-(
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 🙁