Tiger Solutions/Excel Basics - Partner Level

  • £300

Excel Basics - Partner Level

Includes:
  • 27 x Excel Basics Core Excel Tutorial Videos
  • 10 x Excel Download Files
  • 1 x Excel Basics Course PDF Handbook, including:
- 27 learning templates, one per session
- learning outcomes for each session (72 in total)
- itemised Excel shortcuts for each session (Windows AND Mac)
- Excel shortcuts guide
  • 1 x Beginner Kickstart Video
  • 1 x Start Here Video
Total runtime: 6.5 hours approx
  • 1 x One-To-One 1 Hour Online Training With Chris (get in touch with us via the Contact page to arrange this)

Contents

Kickstart For Absolute Beginners.mp4
Tiger Excel Basics Course Handbook.pdf
Start Here.mp4

Part 1: Familiarisation And First Excel Formulae

In the first part of Excel basics, we get familiar with the Excel interface and start building some Excel formulae.
Excel Basics Part 1 START.xlsm
Excel Basics Part 1 END.xlsm
Excel Basics Part 1 Session 1.mp4
Excel Basics Part 1 Session 2.mp4
Excel Basics Part 1 Session 3.mp4
Excel Basics Part 1 Session 5.mp4
Part 1 Session 4.mp4

Part 2: Excel Modelling Basics

Modelling is what Excel is great at!  By creating relationships between cells using formulae, we can implement a chain of calculations to 'model' a real-life situation.  Let's see how in this module ...
Excel Basics Part 2 START.xlsm
Excel Basics Module 2 END.xlsm
Excel Basics Part 2 Session 1.mp4
Excel Basics Part 2 Session 2.mp4
Excel Basics Part 2 Session 3.mp4
Excel Basics Part 2 Session 4.mp4
Excel Basics Part 2 Session 5.mp4

Part 3: Excel Data Analysis Basics

Excel tends to hold data and it is often our job to make sense of it!  This is why data analysis is a fundamental skill for any Excel user.  Let's learn the basics in this module ...
Excel Basics Part 3 START.xlsm
Excel Basics Part 3 END.xlsm
Excel Basics Part 3 Session 1
Excel Basics Part 3 Session 2.mp4
Excel Basics Part 3 Session 3.mp4
Excel Basics Part 3 Session 4.mp4
Excel Basics Part 3 Session 5.mp4
Excel Basics Part 3 Session 6.mp4

Part 4: Excel Data Input Basics

Data input is the one thing you can guarantee happens in most spreadsheets.  So why don't we focus on it more?  Let's learn the basics in this module ...
Excel Basics Part 4 START.xlsm
Excel Basics Part 4 END.xlsm
Excel Basics Part 4 Session 1.mp4
Excel Basics Part 4 Session 2.mp4
Excel Basics Part 4 Session 3.mp4
Excel Basics Part 4 Session 4.mp4

Part 5: Excel VBA Automation Basics

In this module, we explore how to begin to automate time-consuming tasks using Excel VBA
Excel Basics Part 5 START.xlsm
Excel Basics Part 5 END.xlsm
Excel Basics Part 5 Session 1.mp4
Excel Basics Part 5 Session 2.mp4
Excel Basics Part 5 Session 3.mp4
Excel Basics Part 5 Session 4.mp4
Excel Basics Part 5 Session 5.mp4
Excel Basics Part 5 Session 6.mp4
Excel Basics Part 5 Session 7.mp4