MS Office blogs from Wise Owl (page 1 of 8)

Showing blogs 1-20 (out of 148)

Which Power BI course should you take - Excel Power BI or Power BI Desktop?

Posted by Andy Brown on 22 July 2016 | no comments

Microsoft are pursuing two separate BI lines at the moment: one for tools which run within Excel, and another for a standalone application called Desktop BI. This blog attempts to explain the difference!

Tags:   Excel | PowerPivot    |    Power BI - Excel 2013 | General    |    Power BI Desktop | General

Creating an exchange rate slicer in PowerPivot

Posted by Andy Brown on 11 March 2016 | no comments

A way to create a slicer in PowerPivot to choose which exchange rate to use (ie for which currency to show results).

How PowerPivot differs from SSAS Tabular, and using it to prototype data models

Posted by Andy Brown on 18 February 2016 | no comments

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).

Referring to a range using square brackets

Posted by Andy Brown on 17 December 2015 | no comments

This short blog shows that there is a third way to refer to a range, other than using the RANGE or CELLS keywords.

This blog explains the lesser known but better Excel VBA InputBox function

Posted by Andy Brown on 17 December 2015 | no comments

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.

A tutorial on how to create Power View reports based on SSAS tabular models

Posted by Andy Brown on 08 December 2015 | no comments

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.

Disabling Screen Updates in Excel VBA

Posted by Andrew Gould on 26 November 2015 | no comments

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.

Tags:   VBA macros | General

What's new in Microsoft Office 2016 (including Excel 2016 changes)

Posted by Andy Brown on 07 September 2015 | no comments

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.

Tags:   Outlook | General topics    |    Excel | General    |    Musings | Microsoft Office

Useful links and downloads for our video tutorials on Power BI applications

Posted by Andy Brown on 15 April 2015 | no comments

This blog is provided to support our series of tutorials on PowerPivot, Power Query, Power View and Power Map.

Once you've loaded a Power Query, how do you change your load options?

Posted by Andy Brown on 01 April 2015 | no comments

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!

Installing the Microsoft Date and Time Picker for VBA

Posted by Andrew Gould on 24 February 2015 | no comments

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!

Tags:   VBA macros | User forms

Using DAX Studio to edit calculated fields or measures in Excel

Posted by Andy Brown on 20 February 2015 | no comments

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.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | DAX

How to insert ActiveX controls after CANNOT INSERT OBJECT message

Posted by Andy Brown on 29 January 2015 | no comments

When using Excel, we owls have had problems inserting ActiveX objects after recent security updates. Here's a solution which worked for us!

VBA code to create a chart and textbox, and copy them to Word

Posted by Andy Brown on 03 October 2014 | no comments

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!

Programmatically searching websites using VBA

Posted by Andy Brown on 19 September 2014 | no comments

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.

Tags:   Excel | Excel Visual Basic    |    VBA macros | References

Revealing how Excel workbooks are actually stored as zipped XML files

Posted by Andy Brown on 16 May 2014 | no comments

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.

Tags:   Musings | Random musings    |    Excel | General

Flappy Bird in Excel VBA Part 13 - Playing Sounds

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial explains how to add sounds to the game using a Windows API function.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 12 - Managing Game State

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial implements a state system to make it easier to determine what actions to perform each time the game updates.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 11 - Detecting Collisions

Posted by Andrew Gould on 24 April 2014 | no comments

In this part of the tutorial you'll learn how to make the game detect collisions between the bird and the obstacles.

Tags:   VBA macros | General

Flappy Bird in Excel VBA Part 10 - Creating Obstacles

Posted by Andrew Gould on 24 April 2014 | no comments

This part of the tutorial shows you how to add obstacles to the game and how to make them move across the screen.

Tags:   VBA macros | General