Excel + blogs from Wise Owl (page 1 of 7)

Showing blogs 1-20 (out of 121)

Combine all the files in a folder into a single table using Power Query

Posted by Andy Brown on 21 February 2017

Sure, you can use Power Query (or Get & Analyze, as it's now called) to load and transform data, but did you know you can loop over all of the files in a folder, combining their data into a single set of results? This blog explains how to do this for CSV files, and gives a lead for how to proceed with Excel ones.

The new functions in Excel 2016, including IFS, SWITCH and TEXTJOIN

Posted by Andy Brown on 18 February 2017

Excel 2016 has a few interesting new functions! TEXTJOIN allows you to concatenate all the cells in a range, and IFS and SWITCH provide other ways to make choices.

Tags:   Excel | Formulae

Updates made in February 2017 to Power BI Desktop.

Posted by Andy Brown on 16 February 2017

A summary of the most important changes for Power BI Desktop users in the February 2017 update.

Power BI Desktop - January 2017 update

Posted by Andy Brown on 08 February 2017

A summary of the (small) changes in Microsoft's January 2017 Power BI Desktop update.

Want to be get at the file path for an Excel workbook easily? Here's how!

Posted by Andy Brown on 26 January 2017

This short blog explains how you can customise your quick access toolbar to display the path of the file that you are currently working on.

Tags:   Excel | General

A summary of the Power BI Desktop Updates going back to November 2016

Posted by Andy Brown on 19 December 2016

This blog differs from the Microsoft update summary in two ways: it omits preview and obscure changes, but goes into more detail (and gives practical examples) on mainstream updates.

The main new features for BI workers in the November 2016 Power BI update

Posted by Andy Brown on 19 December 2016

A summary of the new features in the November 2016 Power BI Update, omitting things which are still only in preview.

How to create running totals or cumulative figures in Power BI Desktop

Posted by Andy Brown on 19 December 2016

There are a host of date-based functions in Power BI Desktop for producing cumulative figures, but how do you get running totals for non-date columns? This blog explains!

Passing parameters to SQL stored procedures in Power BI Desktop

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

How to pick out the first and last dates for a given group using DAX

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.

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

How to get Excel to read out cell values on calculation

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.

Tags:   Writing VBA | Other    |    VBA macros | Working with ranges

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

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!

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

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

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

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

Tags:   Writing VBA | Other    |    VBA macros | Working with ranges

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

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.

Tags:   Writing VBA | Other    |    VBA macros | Input/message boxes

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

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.

Disabling Screen Updates in Excel VBA

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.

Tags:   VBA macros | General    |    Writing VBA | Other

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

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.

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

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

This page has 0 threads Add post