GET FREE CONSULTATION!
+1.416.500.0626
Wyatt McNabb authored this article on Feb 26. You can follow him on LinkedIn. As I have been reviewing a few dashboards from various sources over the past while, I am noticing a hidden performance killer in Power BI. That being the default setting of Power BI’s Auto Time Intelligence – Date/time intelligence setting: For…
DetailsIn part 1 I promised to show you how to link to the web. What if you have to grab that data every month? What if every day? Are you OK copying and pasting? I assume the answer is no. As computers and applications get progressively more complex, we humans have to pass the repetitive…
DetailsYou’ve carefully selected the data you need from a website and pasted it to Excel. Far too often, the result looks messy, various objects are included (hyperlinks, icons/images, etc.), wrap text explodes the row height, the text’s font and size rarely matches what you are looking for. You all know this looks ugly. For those…
DetailsWho doesn’t want to build Excel Pivot Tables fast and easy, and without rework? If you encounter difficulties, error messages and warnings, this article is for you.
DetailsIn this post I will show with you how to display multiple Excel files on one screen. Say you have one screen and you want to see 2 files at once for whatever reason (copy, compare, review, etc.). As always there are a number of scenarios within one setup: 1 screen 2 workbooks. Windows 7:…
DetailsWhat all the options in a ‘Create PivotTable’ dialog box mean?
DetailsThis article is meant for beginners that never heard of or never used a Pivot Table. Pivot Table (PT) is a powerful feature in Excel for analyzing, slicing and dicing data. Many people know about it, but have never used it. I met a professional with MBA credentials who said they (not to disclose the…
Details