Microsoft training videos created in 2014 by Wise Owl (page 1 of 4)

Showing videos 1-20 (out of 62)

C# Part 13 - Lists

Posted by Andrew Gould on 01 December 2014

A List is similar to an Array in that it allows you to store multiple items under a single variable name. The advantage of using lists is that they're designed to change their size dynamically as you add items to them. This video teaches you how to work with lists including how to declare, initialise and add items to them. You'll see several techniques for looping over the items in a list, including while loops, for loops and foreach loops. You'll also learn how to remove and find items in a list, including how to write basic Lambda expressions.

C# Part 12 - Arrays

Posted by Andrew Gould on 27 November 2014

This part of the Introduction to Visual C# series teaches you how to use arrays. You'll learn how to declare and set the dimensions of an array, how to initialise and change values in an array and how to read values from an array. You'll also see how to loop through an array using three different types of loop, as well as how to sort arrays and search an array for a particular value. Later in the video you'll learn how to work with multidimensional arrays and also find out how to resize an array (although this isn't something you should really be doing!).

C# Part 11 - Foreach Loops

Posted by Andrew Gould on 21 November 2014

You can use a Foreach loop in C# to process a collection of objects, which is a tremendously useful thing to be able to do in an object-oriented language! This video explains how the foreach statement works and covers examples such as looping over the collection of controls in a form, looping over the open forms in your application and looping over the items in a list. You'll also see a comparison of the foreach loop and for loop, including a couple of limitations of the foreach statement. The video also covers how to write nested foreach loops.

C# Part 10 - For Loops

Posted by Andrew Gould on 18 November 2014

For Loops in C#, along with While Loops, represent a technique for looping a set of instructions while a condition is met. This video teaches you how to write For Loops, starting with the basic syntax of the For statement. You'll see how to break out of and how to continue a loop, as well as how to avoid endless loops. After learning the basics you'll see how to apply the for loop in a practical context by looping over both all of the items in a list box as well as just the selected items.

C# Part 9 - While Loops and Do Loops

Posted by Andrew Gould on 17 November 2014

A While Loop in C# allows your code to repeat a set of instructions while a condition is met. This video starts by teaching you how to write a basic While statement and moves on to explain how to avoid endless loops, how to break out of a loop, how to continue to the next iteration of the loop and also how to use the Do statement to change where your condition is evaluated. The second half of the video demonstrates how to use While loops in a practical context by looping over the lines of a text file - as a bonus you'll learn a little about StreamReaders and how to use basic arrays too!

Excel VBA Part 11a - Application.InputBox

Posted by Andrew Gould on 03 November 2014

If you've used the generic InputBox function in VBA you may be frustrated by its limitations. This video shows you how to use the far superior Application.InputBox method. You'll learn how to specify the data type returned by the InputBox and how to use its built-in validation feature to control what users can enter. The video also covers how to return a simple formula and a more complex function from the InputBox and also how to allow users to select a range of cells which can then be referenced by your VBA code. The final part of the video covers a more complex example in which the InputBox returns an array of values which can be looped over and manipulated in various ways.

C# Part 8 - Switch Statements

Posted by Andrew Gould on 03 November 2014

A C# Switch Statement allows you to test if a value falls into one of a number of discrete categories. This video teaches you how to write simple Switch statements including how to add case labels, how to use the default case, several techniques to avoid falling-through cases and how to assign multiple labels to the same block of statements.

C# Part 7 - Writing Methods

Posted by Andrew Gould on 03 November 2014

Methods are a fundamental building block of C# programming. This video teaches you how to create your own methods, including how to specify what the method will return, how to define mandatory and optional parameters and how to create overloaded methods. You'll learn how to call methods from other procedures and how to pass arguments to the parameters of a method.

C# Part 6 - If Statements and Conditional Operators

Posted by Andrew Gould on 31 October 2014

If statements allow your code to perform different actions depending on whether or not conditions have been met. Part 6 of this series on Programming in Visual C# shows you how to write if statements and logical tests, how to perform multiple actions based on the result and how to include an else statement. You'll learn how to write nested, or cascading, ifs using a couple of different layouts, and you'll see how to use code snippets to save time when writing if statements. Towards the end of the tutorial you'll see how to test multiple conditions using compound operators and, finally, how to use the logical operator to write concise logical tests.

C# Part 5 - Variables and Data Types

Posted by Andrew Gould on 31 October 2014

This part of the Basic Programming in Visual C# series explains how to use variables - an integral part of any programming language. You'll learn how to declare a variable and choose its data type, how to assign values to and read from a variable and how to initialise a variable. You'll learn about working with different data types such as strings, numbers and dates and understand the importance of type-casting and converting data types.

C# Part 4 - Writing Basic C# Code

Posted by Andrew Gould on 31 October 2014

Part 4 of the Basic Programming in Visual C# series shows you how to get started with writing very simple C# code. You'll learn about how to attach code to the events of a form using event handlers and how to write simple instructions using the IntelliSense list. You'll learn the basics of some important C# keywords such as Namespace, Class, Object, Method and Property and begin to understand how those things define the code that you write.

C# Part 3 - Drawing Windows Forms

Posted by Andrew Gould on 31 October 2014

Part 3 of the Basic Programming in Visual C# series shows you how to create basic Windows Forms. You'll learn about the Toolbox and how to add controls to a form. The video also teaches you various techniques for aligning and distributing controls to create a professional-looking layout. You'll learn about form and control properties to alter the appearance and behaviour of your forms, and also how to run your application to test that everything works correctly.

C# Part 2 - Working with Projects and Solutions

Posted by Andrew Gould on 31 October 2014

The second part of this series on Basic Programming in Visual C# explains how to work with projects and solutions. You'll learn how to create a new Windows Forms Application and how to use the Solution Explorer window to work with the items contained in the project. You'll also learn how to add and remove items in a project, how to create folders to organise items and what happens when you rename things in a project.

C# Part 1 - Installing and Configuring Visual Studio

Posted by Andrew Gould on 31 October 2014

Part 1 of this series on Basic Programming in Visual C# explains how to get up and running the Microsoft Visual Studio. You'll discover how to obtain a free edition of Visual Studio and install it on your machine. The video also shows you how to work in the Visual Studio IDE including tips for configuring the appearance of the application and how to work with the various Visual Studio windows.

Excel VBA Part 39 - Dictionaries

Posted by Andrew Gould on 27 October 2014

The Dictionary class is similar to the Collection class in that it allows you to store a custom collection of objects. This video teaches you how to use dictionaries, including how to reference the Scripting Runtime Object Library, how to create a new Dictionary and add, remove, count and reference the items in it. You'll also learn about the Items and Keys arrays contained within a Dictionary and how to loop over these arrays in order to process all of the items that the Dictionary contains.

Excel VBA Part 37 - Custom Collections

Posted by Andrew Gould on 27 October 2014

Excel VBA is full of collections and you can even create your own custom collections using the Collection object. This video teaches you how to create a new custom collection, how to add items to it, how to reference those items individually and how to loop over all of the items in the collection. You'll also see how you can add items based on a custom class module to a collection.

Excel VBA Part 38 - Typed Collections

Posted by Andrew Gould on 27 October 2014

One of the issues with the Collection class in VBA is that it's untyped. This means you can add any kind of object to the collection which can lead to issues later on. This video explains how to use class modules to create strongly typed collections. You'll learn how to create a private collection variable in a class module, how to create a custom Add method to restrict the type of item that can be added to the collection and how to use a custom collection class in your other procedures.

Excel VBA Part 36 - Class Modules in Other Projects

Posted by Andrew Gould on 27 October 2014

One small limitation of VBA Class Modules is that, by default, you can only use them in the VBA Project in which they were created. This video explains how you can make your class modules available to other VBA projects. You'll learn about the Instancing property of a class, how to set references to VBA projects, how to write a function to return a new instance of a class and how to create an Excel Add-In as a convenient way to distribute your class modules.

Excel VBA Part 35 - Class Modules

Posted by Andrew Gould on 13 October 2014

Class Modules in VBA allow you to define your own classes of objects. This video explains why that's a useful and shows you how to go about creating a class. You'll learn about the two class events: initialise and terminate, you'll see how to define properties, including how to create read-only properties and set default values. You'll also find out how easy it is to create methods for your class and how to use your class in your regular code.

Excel VBA Part 34 - Type Declarations

Posted by Andrew Gould on 13 October 2014

The Type statement in VBA allows you to define your own static data structures which you can then use in your variable declarations. This video explains how to declare a type, how to employ the type in variable declarations, how to read to and write from the variable, as well as a couple of fun features such as using enumerations within a type declaration and nesting types.

This page has 0 threads Add post