Login
Tiger Solutions/Excel Basics - Analyst Level
Buy now

  • £80

Excel Basics - Analyst Level

Includes:
  • 27 x Excel Basics Core Excel Tutorial Videos
  • 10 x Excel Download Files
  • 1 x Beginner Kickstart Video
  • 1 x Start Here Video
Total runtime: 6.5 hours approx
DOES NOT INCLUDE EXCEL BASICS COURSE HANDBOOK
Buy now

Contents

Kickstart For Absolute Beginners.mp4
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 4.mp4
Excel Basics Part 1 Session 5.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
Excel Basics Part 2 Session 3.mp4
Excel Basics Part 2 Session 1.mp4
Excel Basics Part 2 Session 2.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 v2.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