Microsoft training videos created in 2015 by Wise Owl (page 1 of 2)

Showing videos 1-20 (out of 25)

Excel VBA - Data Labels in Scatter Charts

Posted by Andrew Gould on 27 November 2015

Labelling data points in a scatter chart in Excel 2010 or earlier is much more limited than in later versions of Excel. This video explains how to use VBA to label the points with any value you like using simple looping techniques. You'll learn how to label the points in a single chart, multiple charts and multiple data series in a chart.

Excel VBA - Save as PDF

Posted by Andrew Gould on 26 November 2015

This video explains how to use the ExportAsFixedFormat method to save various elements of an Excel file as a PDF document. You can apply this technique to the entire workbook, single worksheets and charts and even to a specific range of cells.

Excel VBA - Disable Screen Updates

Posted by Andrew Gould on 26 November 2015

You can give your VBA code a quick performance boost by simply disabling screen updates while your code runs. This video explains how to achieve that, as well as how to create a basic timer system to test the results.

Excel VBA Part 20a - Application Events

Posted by Andrew Gould on 26 November 2015

In an earlier video in the series we've seen how to write event-handlers for workbooks and worksheets; this video teaches you how to access events of the Excel application itself! You'll learn the significance of the WithEvents keyword, a couple of the basic application events such as the new workbook event, and how to use a basic class module to keep your application event handlers neatly organised.

C# Part 14 - Exceptions and Error Handling

Posted by Andrew Gould on 26 October 2015

Exceptions occur when something goes wrong when your code is running. If you don't write code to handle these exceptions your program crashes and users become angry and/or upset! This video teaches you the basics of handling exceptions in Visual C# using Try Catch statements. It shows how to test for different exception types, how to write multiple Catch blocks to handle specific types of exception and how to use a Finally statement at the end of a Try Catch block.

An overview of Power Map

Posted by Andy Brown on 16 June 2015

This tutorial gives an overview of how to use Power Map to create maps within Excel (it doesn't pretend to tell you everything about the software, but will show you enough to get you started, and to decide whether this is the mapping software for you).

Creating maps in Power View

Posted by Andy Brown on 16 June 2015

This tutorial shows how to create maps within Power View views (a separate tutorial shows how to use the separate Power Map application to create maps).

Creating charts in Power View

Posted by Andy Brown on 15 June 2015

How to create and format Power View charts (this tutorial includes how to create multiple charts, and also how to animate bubble charts over time).

Filters in Power View

Posted by Andy Brown on 15 June 2015

A tutorial on how to filter Power View reports using either slicers, filtering or tiles.

An Introduction to Power View

Posted by Andy Brown on 15 June 2015

Getting started with Power View reports within Excel, including creating tables (visualisations)

Creating KPIs (key performance indicators) within PowerPivot

Posted by Andy Brown on 09 June 2015

An overview of how to create KPIs (or key performance indicators) within pivot tables based on PowerPivot data models, to highlight how well your organisation is doing against internal targets.

Creating hierarchies within PowerPivot

Posted by Andy Brown on 09 June 2015

A short tutorial on how to create and use hierarchies within PowerPivot data models.

Using the DAX date functions within PowerPivot

Posted by Andy Brown on 08 June 2015

The DAX expression language used for PowerPivot formulae has lots of useful date functions - this tutorial introduces the most common, with names like TOTALYTD and PARALLELPERIOD.

Using calendars and dates in PowerPivot

Posted by Andy Brown on 08 June 2015

How to create a calendar in SQL Server or Excel for use within a PowerPivot data model, together with ideas for using calendars and creating additional aggregator columns.

The FILTER, RANKX and EARLIER functions in DAX

Posted by Andy Brown on 05 June 2015

Worked examples on some more advanced PowerPivot functions: filtering using FILTER, ordering using RANKX and the hard-to-understand EARLIER function.

Using the CALCULATE function in PowerPivot

Posted by Andy Brown on 05 June 2015

How to use the all-important CALCULATE function in Excel pivot tables built on PowerPivot data models, including replacing, removing and editing the query context.

Calculated fields (measures) in PowerPivot

Posted by Andy Brown on 04 June 2015

How to create measures (now known as calculated fields) within PowerPivot in the DAX expression language, including a detailed explanation of query context and a guide to how to use the PowerPivot formula editor, and also thoughts on other editors available

Creating calculated columns within PowerPivot

Posted by Andy Brown on 03 June 2015

How to create calculated columns within PowerPivot, including using functions like IF, SWITCH, RELATED and BLANK to create new aggregator columns in pivot tables.

Linking to and importing from other data sources

Posted by Andy Brown on 02 June 2015

This tutorial shows how to link to Excel tables, import from Excel workbooks, paste data in from Word tables, import from Access databases and how to import from SQL Server Analysis Services cubes.

Pivot tables based on PowerPivot data models

Posted by Andy Brown on 02 June 2015

Learn how to create and use Excel pivot tables based on PowerPivot data models, including creating slicers and timelines and using Quick Explore to drill down.

This page has 0 threads Add post