EXCEL + BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR
Excel + blogs from Wise Owl (page 1 of 6)
Showing blogs 1-20 (out of 113)
Posted by Andy Brown on 30 November 2016
This blog summarises how to run SQL statements in a Power BI Desktop query, using dynamic SQL to pass in parameter values
Posted by Andy Brown on 06 October 2016
It's often challenging working out how to use DAX to solve specific problems. This blog shows how to produce a pivot table showing the first and last instances of any category.
Posted by Andy Brown on 26 September 2016
A short blog explaining how you can get Excel to read out values in cells every time that you recalculate a worksheet.
Posted by Andy Brown on 22 July 2016
Microsoft are pursuing two separate BI lines at the moment: one for the Power BI tools which run within Excel, and another for the standalone application called Desktop Power BI. This blog attempts to explain the differences between two applications with such confusingly similar names!
Posted by Andy Brown on 11 March 2016
A way to create a slicer in PowerPivot to choose which exchange rate to use (ie for which currency to show results).
Posted by Andy Brown on 18 February 2016
PowerPivot is virtually identical to SSAS Tabular underneatht the glossy exterior, but it has got a few extra features explained in this blog (which also shows how to import PowerPivot data models into Analysis Services, and why you might want to do this).
Posted by Andy Brown on 17 December 2015
This short blog shows that there is a third way to refer to a range, other than using the RANGE or CELLS keywords.
Posted by Andy Brown on 17 December 2015
There are two ways you can display an input box using Excel macros: the standard VBA InputBox function, or the much better (but lesser known, at least by this blog's author) Application.InputBox function.
Posted by Andy Brown on 08 December 2015
Power View is an add-in included within Excel 2013 and later versions. This tutorial shows how to create Power View reports based on Analysis Services tabular models.
Posted by Andrew Gould on 26 November 2015
You can give your VBA code a performance boost by simply turning off screen updating while your code runs. This blog explains how to achieve this and how to create a basic timer to test the results.
Posted by Andy Brown on 07 September 2015
The latest incarnation of Microsoft Office (2016) should be released on 22nd September 2015 (Microsoft are always a bit ahead of themselves with versions). This blog gives a detailed guide to what's new, the biggest changes being in Excel and Outlook.
Posted by Andy Brown on 15 April 2015
This blog is provided to support our series of tutorials on PowerPivot, Power Query, Power View and Power Map.
Posted by Andy Brown on 01 April 2015
When you've created a Power Query in Excel, you can close it and load the resultant data. But how do you then change how the query loads? This blog explains how!
Posted by Andrew Gould on 24 February 2015
Some versions of Windows don't include the very useful Date and Time Picker control. This blog explains how to install the mscomct2.ocx file to get it back!
Posted by Andy Brown on 20 February 2015
The editor for calculated fields in Excel (aka measures) isn't the greatest; this blog shows you how to install and use DAX Studio as a substitute editor.
Posted by Andy Brown on 29 January 2015
When using Excel, we owls have had problems inserting ActiveX objects after recent security updates. Here's a solution which worked for us!
Posted by Andy Brown on 03 October 2014
Charts in VBA are a bit weird: this blogs highlights some of their foibles, by showing how charts are really just special shapes, which contain shapes of their own!
Posted by Andy Brown on 19 September 2014
I've already pinched (with permission!) the ideas of Fergus Cairns to explain ways to run automatic searches on popular websites like Google; this blog gives an update on the same topic.
Posted by Andy Brown on 16 May 2014
Did you know that Excel workbooks are really just a collection of XML files, all zipped together? We didn’t either, so we thought we'd tell the world.