V0 - Introduction and Objectives

V1 - introduction

V2 - Navigation shortcuts

V3 - Formatting part 1

V4 - Formatting part 2

V5 -Formatting part 3 (number formats)

V6 - Worksheet tabs and save As

V7 - quiz 1

V8 - Quickqaccess bar and ribbon

V9 - AutoComplete and AutoFill

V10 - quiz 2

V01 - Tables (part 1) - Inserting and editing

V02 - Tables (part 2) - Naming Ranges and Using Filters

V03 - Tables (part 3) - Filters' application

V04 - Tables (Part 4) - Aggregate Function

V05 - Quiz (part 1) - Logic and Len functionc

V06 - Quiz (part 2) and Subtotal function

V07 - Line Charts

V08 - Bar Charts and Pie Charts

V09 - Sparklines

V10 - Conditional Formatting

V11 - Vlookup and Hlookup

V12 - Quiz 2 (part 1) - Vlookup and Tables

V13 - Quiz 2 (part 2) - Vlookup and Tables

V14 - Vlookup true - part 1

V15- Vlookup True - part 2

V16 - Data Validation

V17- goal seek

V18 - scenario manager (part 1)

V19 - scenario manager (part 2)

V20 - Scenario manager 2 - practice

21 - Quiz 3 - (Tables,Scenarios, Functions)

V01 - solver - introduction

V02 - Solver 2 and SumProduct function - Lancaster Brewery (part 1)

V03 - Solver 2 and SumProduct Function - Lancaster Brewery (part 2)

V04 - Solver 3 - Practice question

V05 - Quiz 1 - Solver

V06 -Concatenate and TextToColumns

V07 - Paste Special and Removing Duplicates

V08 - Index and Match

V09 - Index and Match- practice

V10 - Pivot tables 1 - Introduction

V11 - Pivot tables 2 - Filters and Designs

V12 - Pivot Tables 3 - Slicer, Grouping, pivot charts

V13 - Quiz 2 - Pivot Tables

V14 - Macros - Part 1

V15 - Macros - part 2

V16 - Macros and VBA (part 1) - Running Macros, Macro types and VBA notations

V17 - Macros and VBA (part 2) - VBA widow, Hierarchies and statements

V18 - Macros and VBA (part 3) - Objects, VBA codes

V19 - Macros and VBA (part 4) - VBA Satements, Editing Macros

V20 - Macros and VBA (part 5) - Writing Macros

V21 - Modelling (Part 1)

V22 - Modelling (Part 2)

V23 - Influence diagrams

V25 - Modelling - question (part 1)

V26 - Modelling - question (part 2)

V27 - Modelling - question (part 3)

V28 - Form Controls (part 1)

V29 - Form Controls (Part 2)

V30 - Form Controls (Part 3)

V1 - insert and Delete cells

V2- hiding rows columns and. viewtab introduction

V3 - View tab (part 2)

V4 - Intro to insert tab

V5 - spreadsheets vs models

V6 - quiz 1

V7 - Simple Sum Function

V8 - Function types (part 1)

V9 - Function types (part 2)

V10 - Quiz 2 (Function- part 1)

V11 - Quiz 2 (Function- part 2)

V12 - relative and absolute refrencing

V13 - referncing example (part 1)

V14 - refrencing example (part 2)

V15 - rand len randbw

V16 - Intro to IF Ftn (part1)

V17 - if (part 2)

V18 - Quiz3 (if function)

V19 -sumif

V20 - averageif and countif

V21 - sumifs averagifs countifs

V22 - OR AND functions

V23 - Quiz4(and or)

V24 - Quiz5 (login functions)