Wise Owl: Microsoft computer training videos (page 1 of 12)

Showing videos 1-20 (out of 239)

Excel VBA Part 53.3 - The Join Function and Concatenating Strings

Posted by Andrew Gould on 22 February 2017

This video explains how to join or concatenate strings in VBA. You'll learn about to different operators you can use to do this, and why one is better than the other. You'll also learn how to use the Join function to take the contents of an array and concatenate them into a single string. The final part of the video shows a couple of practical uses for these techniques with an example that writes data to text files.

Excel VBA Part 53.2 - Splitting Strings

Posted by Andrew Gould on 21 February 2017

This video explains how to use VBA functions to split strings into their constituent parts. You'll learn about the Left, Right and Mid functions for extracting parts of a string, how to identify the position of one string within another using the InStr and InstrRev functions and how to use the Split function to break a single string into multiple parts and store them in an array.

Excel VBA Part 53.1 - Working with Strings

Posted by Andrew Gould on 20 February 2017

This video explains the basics on working with text, or strings, in VBA. You'll learn about the String data type, how to use the $ type-declaration character and how to create variable and fixed-length strings. You'll see how to concatenate multiple values into a single string, including some string constants for special characters such as tab spaces and new lines - ever wondered why there are so many ways to create a new line in VBA? This video explains why! The final part of the video talks about comparing strings, including how to deal with case-sensitive comparisons and how to use wildcard characters to match paterns of text.

Report Builder 2016 Pt 3 - Saving to a Report Server

Posted by Andrew Gould on 20 February 2017

To allow others to view your Report Builder reports, you'll need to deploy them to a report server - this video explains how to do precisely that. You'll learn where to find your report server URL, how to connect Report Builder to a report server, how to deploy a report and how to view it in a web browser using the Reporting Services Web Portal application. You'll also learn a little about managing deployed reports, including how to download the report definition file, how to make changes to reports and re-upload them, and how to organise them on the report server using folders.

Report Builder 2016 Pt 2 - Creating Your First Report

Posted by Andrew Gould on 20 February 2017

This video shows you the basics of creating a report in Report Builder. You'll start with a blank report and learn how to create a data source to connect to a database, followed by a dataset to retrieve the results of a query. Next, you'll learn how to add a table to display the results, including how to assign dataset fields to table columns, how to sort and filter the table, along with how to use a variety of formatting options. The final part of the video explains how to save, close and reopen report files.

Excel VBA Part 52.3 - Adding Text to Shapes

Posted by Andrew Gould on 16 February 2017

You can add text to most shapes that you can draw in Excel. This video explains the basics of working with text in shapes, including how to add to text to a basic shape, how to format text inside shapes and how to change the text alignment and orientation.

SSRS 2016 - Comparing Report Builder with SQL Server Data Tools

Posted by Andrew Gould on 15 February 2017

If you're confused by whether to use Report Builder or SQL Server Data Tools to create your Reporting Services reports, this video might help you to work out which product to choose. You'll see a side-by-side comparison of creating a report from the very beginning, all the way through to deploying it to a report server using both pieces of software. Along the way we'll point out the major differences between the two applications, along with the pros and cons of each.

Excel VBA Part 52.2 - Formatting Shapes

Posted by Andrew Gould on 14 February 2017

The previous video in the series explained how to draw shapes on a worksheet - this one explains how to make them look more interesting by applying a variety of formatting effects to them.

Report Builder 2016 Pt 1 - Installing Report Builder 2016

Posted by Andrew Gould on 07 February 2017

This video takes you through the basics of installing Report Builder 2016, including a short introduction to what Report Builder is designed to do!

SSRS 2016 Pt 1 - Creating and Deploying Your First Report

Posted by Andrew Gould on 06 February 2017

This video gives an overview of creating and deploying a simple report using SQL Server Reporting Services 2016. The video is designed to give a basic guide to the process from start to finish (we'll save the details for later videos in this series) so that you can get up and running as easily as possible.

Excel VBA Part 52.1 - Introduction to Shapes

Posted by Andrew Gould on 06 February 2017

In this video you'll learn the basic of working with shapes in VBA. You'll see how to reference objects in the shapes collection using a variety of techniques. You'll learn about the properties which determine a shape's size and position and how to set these relative to other objects. You'll also learn how to add a variety of shapes to a worksheet, including basic autoshapes, pictures and form control buttons, as well as how to attach an action to a shape so that it runs a macro when a user clicks it.

Excel VBA Forms Pt 20 - Progress Bars

Posted by Andrew Gould on 06 February 2017

This video explains the basics of using progress bar controls on your VBA user forms. You'll see how to add the control to the toolbox and how to draw and edit progress bars on a form. Most importantly, you'll learn how to update the value of a progress bar at run time so that it indicates progress through a procedure.

SQL Server 2016 Pt 9 - Installing SQL Server Data Tools (SSDT)

Posted by Andrew Gould on 06 February 2017

This video explains how to install SQL Server Data Tools and the Business Intelligence Templates for Visual Studio 2015. This allows you to create projects for Reporting Services, Integration Services and Analysis Services.

Excel VBA Part 51.8 - Pivot Table Date Fields and Timelines

Posted by Andrew Gould on 15 December 2016

You can do several useful things with dates in Pivot Tables, including grouping, filtering and applying timelines. This video shows you how to do all those things using VBA.

Excel VBA Part 51.7 - Pivot Table Slicers

Posted by Andrew Gould on 15 December 2016

Slicers provide an interesting way to apply filters to pivot tables. This video explains how to write VBA code to create a slicer cache and a slicer, along with how to change the slicer's position and dimensions. You'll learn how to use a slicer to filter a pivot table and how to connect a slicer to multiple pivot tables to enable filtering of multiple pivots with a single slicer.

Excel VBA Part 51.6 - Pivot Charts

Posted by Andrew Gould on 15 December 2016

This video explains how to create and manipulate pivot charts in Excel VBA. You'll learn how to create a pivot chart based on a pivot table, how to create embedded chart objects and separate chart sheets and how to modify the fields of the pivot chart. The video also shows you how to apply and remove filters on the chart and how to quickly format the chart and chage its appearance.

Excel VBA Part 51.5 - PowerPivot Data Models

Posted by Andrew Gould on 15 December 2016

The PowerPivot Data Model allows you to combine data from a variety of sources into one single object in a workbook - you can then use this model to create pivot tables using the joined data. This video explains how to create and edit the PowerPivot data model using dat from Excel worksheets, Access databases and SQL Server databases. You'll learn how to create a data model, how to add and remove tables and how to import or create relationships between the different tables in the model. The final part of the video explains how to create a single data model which combines data from Excel, Access and SQL Server

Excel VBA Part 51.4 - Pivot Tables and Consolidation Ranges

Posted by Andrew Gould on 15 December 2016

This video explains how to create an Excel pivot table based on multiple ranges of data spread across several worksheets. You'll learn how to use the Pivot Table Wizard to create a pivot table based on multiple consolidation ranges, as well as how to write code to achieve the same results. The video explains how to use an array to hold references to the different ranges of cells involved and how to populat this array dynamically for all of the data sheets in a workbook.

Excel VBA Part 51.3 - Pivot Tables using a SQL Server Database

Posted by Andrew Gould on 15 December 2016

This video explains how to create an Excel pivot table based on a SQL Server database. You'll learn how to create connections to external data sources, how to edit connection strings and how to create a pivot cache using the external connection. The video also shows you how to create views in SQL Server Management Studio, along with how to write basic SQL statements in your VBA code to create flexible queries that you can use to create pivot tables.

Excel VBA Part 51.2 - Pivot Tables using an Access Database

Posted by Andrew Gould on 15 December 2016

This video explains how to create a pivot table based on an Access database. You'll learn how to create connections to external data sources, how to edit connection strings and how to create a pivot cache using the external connection. The video also shows you how to create queries in Microsoft Access, along with how to write basic SQL statements in your VBA code to create flexible queries that you can use to create pivot tables.

This page has 0 threads Add post