I have created this channel to hopefully provide some helpful short tutorials on a number of different software applications. Each tutorial will look at a specific element of the software and will range from basic to advanced.

This channel will include tutorial videos on Excel, MS SQL and SSRS.

I plan to add new content once a week on Sundays.

Excel shortcuts - Let these shortcuts improve your Excel experience
14:08
Excel shortcuts - Let these shortcuts improve your Excel experience
MS SQL server CHARINDEX function - explanation and demonstrations (beginner to advanced)
25:48
MS SQL server CHARINDEX function - explanation and demonstrations (beginner to advanced)
How to budget using Excel. How to build a simple expenses worksheet in under 15 mins
13:41
How to budget using Excel. How to build a simple expenses worksheet in under 15 mins
MS Excel tutorial - Having vlookup problems? This will help.
6:16
MS Excel tutorial - Having vlookup problems? This will help.
SQL. Understanding SQL statements. Breaking down statements into their individual elements.
9:00
SQL. Understanding SQL statements. Breaking down statements into their individual elements.
SQL. A really quick way of creating a delimited string using STRING_AGG. Quick comma separated list.
3:41
SQL. A really quick way of creating a delimited string using STRING_AGG. Quick comma separated list.
SQL IN statement. Using multiple conditions. SQL with subquery. SQL with a nested select.
8:05
SQL IN statement. Using multiple conditions. SQL with subquery. SQL with a nested select.
SQL get part of string, extract text within string using RIGHT, LEFT, LEN, SUBSTRING, CHARINDEX
12:04
SQL get part of string, extract text within string using RIGHT, LEFT, LEN, SUBSTRING, CHARINDEX
MS SQL Aggregate Functions for beginners - COUNT, SUM, MAX, MIN
10:47
MS SQL Aggregate Functions for beginners - COUNT, SUM, MAX, MIN
MS Excel tutorial - TIME SAVING TIPS ON EVERYDAY USE OF EXCEL
11:39
MS Excel tutorial - TIME SAVING TIPS ON EVERYDAY USE OF EXCEL
MS SQL tutorial. WHAT IS A CROSS JOIN? I'll show you.
7:01
MS SQL tutorial. WHAT IS A CROSS JOIN? I'll show you.
Excel tutorial - creating Pivot Tables for beginners
17:25
Excel tutorial - creating Pivot Tables for beginners
Excel introduction to functions - the basics
10:15
Excel introduction to functions - the basics
Excel tutorial - Introduction to formulas - writing maths formulas
8:01
Excel tutorial - Introduction to formulas - writing maths formulas
Excel tutorial - How do I copy comments to other cells? SOLVED! - Quick solution.
2:50
Excel tutorial - How do I copy comments to other cells? SOLVED! - Quick solution.
This is a SQL tutorial on outer joins. Left/Right/Full and Inner comparison.
9:35
This is a SQL tutorial on outer joins. Left/Right/Full and Inner comparison.
Excel tutorial on Xlookup. The very cool alternative to Vlookup
11:24
Excel tutorial on Xlookup. The very cool alternative to Vlookup
MS Excel tutorial on an introduction to macros. A simple guide on how to create and amend macros.
14:07
MS Excel tutorial on an introduction to macros. A simple guide on how to create and amend macros.
MS SQL tutorial providing an introduction to joins (inner joins)
10:55
MS SQL tutorial providing an introduction to joins (inner joins)
MS SQL tutorial - variables part 2. Variables are tremendous.
7:08
MS SQL tutorial - variables part 2. Variables are tremendous.
MS SQL tutorial on inner joins, multiple inner joins and joining to same table multiple times.
10:07
MS SQL tutorial on inner joins, multiple inner joins and joining to same table multiple times.
MS SQL tutorial on an introduction to variables. Variables are awesome!!
10:25
MS SQL tutorial on an introduction to variables. Variables are awesome!!
MS SSQL tutorial showing various ways to concatenate results.
5:36
MS SSQL tutorial showing various ways to concatenate results.
MS SQL tutorial on inserting missing data into table
9:45
MS SQL tutorial on inserting missing data into table
MS Excel VBA tutorial - using VBA to automatically create and delete worksheets
11:22
MS Excel VBA tutorial - using VBA to automatically create and delete worksheets
MS SQL tutorial on inserting into a table but checking if a duplicate entry already exists
6:36
MS SQL tutorial on inserting into a table but checking if a duplicate entry already exists
MS SQL tutorial - introduction to tables. Create, insert data and delete.
15:57
MS SQL tutorial - introduction to tables. Create, insert data and delete.
MS Excel Tips and tricks about the Ribbon / Toolbar. Stuff you should know.
9:08
MS Excel Tips and tricks about the Ribbon / Toolbar. Stuff you should know.
MS Excel tutorial - tricks that you did not know about
5:28
MS Excel tutorial - tricks that you did not know about
MS Excel tutorial on font and cell formatting (colours, border, format painter etc)
8:11
MS Excel tutorial on font and cell formatting (colours, border, format painter etc)