Accessible IT Software Tutorials
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.
MS SQL Tutorial: How and why to use ROW_NUMBER. Includes PARTITION BY and ORDER BY examples.
SQL PIVOT - How do I write a SQL Pivot solution?
Excel OFFSET function. How the OFFSET function works and how to use it.
VLOOKUP vs Index & Match. Quick and concise Excel tutorial.
Excel Format as Table. How to format cells as a table. Why to, how to and the gotchas.
Naming Cells and Ranges in Excel. How to, why to and the gotchas.
Excel tutorial - How to use SUMIF and SUMIFS functions. Multiple criteria, greater than, examples.
Excel shortcuts - Let these shortcuts improve your Excel experience
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
MS Excel tutorial - Having vlookup problems? This will help.
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.
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
MS SQL Aggregate Functions for beginners - COUNT, SUM, MAX, MIN
MS Excel tutorial - TIME SAVING TIPS ON EVERYDAY USE OF EXCEL
MS SQL tutorial. WHAT IS A CROSS JOIN? I'll show you.
Excel tutorial - creating Pivot Tables for beginners
Excel introduction to functions - the basics
Excel tutorial - Introduction to formulas - writing maths formulas
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.
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.
MS SQL tutorial providing an introduction to joins (inner joins)
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.
MS SQL tutorial on an introduction to variables. Variables are awesome!!
MS SSQL tutorial showing various ways to concatenate results.