Accessible IT Software Tutorials

873 subscribers

227 videos

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 sp...

Latest Videos

Excel SPILL functions explained. How to fix the #SPILL error.

Excel MODE.SNGL. It works for words too. Let me show you. (includes MATCH and INDEX).

This is an Excel video showing the use of the consolidate facility.

Excel WRAPCOLS & WRAPROWS functions. How to use and its gotchas.

Excel functions. How they work and how to work with multiple functions in one formula.

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. LeftRightFull 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.