Login
Accounting Lecture/Excel in Accounting
Buy now

  • 3 monthly payments of £33

Excel in Accounting

  • Course
  • 39 Lessons

This is a must course for accounting students, prospective & real life accountants, specially AAT,CAT,FIA,ACCA & university students. This course will help you to learn Spreadsheet Excel from beginning to advanced level. You will start from copy paste & end with PIVOT tables, V Look ups, Data manipulation and many more important accounting Excel tools.
Buy now

Contents

Text book

Level 3 - Spreadsheets for Accounting - Course Book.pdf
  • 14.6 MB

Basic Excel: Introduction to spreadsheet (Excel 2013)

You Specifically gonna learn:

1: Excel interface

2: Copy paste insert delete

3: How to put date & time , header & footer

4: Construction of real life accounting in spreadsheet

5: Commission, Variance analysis & budgets

6: If function, Count if, counta, compound if

7: Conditional formatting

8: Ranking

9: Charts & Graphs (Pie,Bar, Column, Line)

10: Data manipulation

11: Printing of Excel files

12: Data security

13: Data validation

14: Subtotals

15: Filtering

16: Find & replace

17: Pivot table & Pivot Charts

18: V look up H look up

19: Data table, Goal seek, Scenarios, Circular referencing 20: Combination of charts.

20: Error checking & many more.

Enroll & feel the confidence.

What you’ll learn

  • Total 37 small & medium videos on Excel covering accounting tools

  • Total course covered in 3.5 hours (Basic spreadsheet to advanced).

  • Online access to course materials (Detailed course instruction).

  • Plenty of practice on accounting excel.

  • Excel questions are downloadable.

  • Course book is downloadable.

Sit Back, watch, practice & master your Excel skills.

V1 Ch3 Introduction (5min).mp4
  • 5 mins
  • 21.9 MB
Preview
V2 Ch3 Illustration 1 (intro of spread sheet) 13 min.mp4
  • 13 mins
  • 69.1 MB
V3 Ch3 Illustration 2 (sing fill handle) 5 min.mp4
  • 5 mins
  • 17.1 MB
Preview
V4 Ch3 Illustration 3 (Copy & Paste) 2 min.mp4
  • 2 mins
  • 9.22 MB
V5 Ch3 Illustration 4, Paste special (2 min).mp4
  • 2 mins
  • 10.9 MB
V6 Ch3 illustration 5 insert, delete, hide,unhide, date & time (6 min).mp4
  • 7 mins
  • 33.1 MB
V7 Ch3 illustration 6 , naming cells (3 min).mp4
  • 4 mins
  • 11.3 MB
V8 Ch3 Illustration 7, Spreadsheet Construction (24 min).mp4
  • 24 mins
  • 133 MB
V9 ch3 Illustration 8 Comission calculation (4 min).mp4
  • 5 mins
  • 16.2 MB
V10 Ch3 Illustration 9 Actual & budgeted sales (5 min).mp4
  • 5 mins
  • 17 MB
V11 Ch3 Illustration 10 If function (5 min).mp4
  • 5 mins
  • 16.7 MB
V12 Ch3 Illustration 11 If Function (3 min).mp4
  • 3 mins
  • 11.6 MB
V13 Ch3 Count if , Counta & compound countif (6 min).mp4
  • 7 mins
  • 21 MB
V14 Ch3 Conditional formatting (5 min).mp4
  • 6 mins
  • 21.7 MB
V15 Ch3 Ranking (3 min).mp4
  • 3 mins
  • 11 MB
V16 Ch3 Charts & Graphs (16 min).mp4
  • 16 mins
  • 77.1 MB
V17 Ch3 Illustration 13, Simple data manipulation (4 min).mp4
  • 4 mins
  • 23.6 MB
V18 Ch3 Prining (13 min).mp4
  • 13 mins
  • 72.5 MB
V19 Ch3 Test your learning (6 min).mp4
  • 6 mins
  • 13.5 MB

chapter-4: More Advanced spreadsheet techniques (Exel 2013)

V1 Ch4 Illustration 1 data security (13 min).mp4
  • 14 mins
  • 81 MB
V2 Ch4 illustration 2 Data validation (7 min).mp4
  • 7 mins
  • 24.4 MB
V3 Ch4 Illustration 3, Subtotal (6 min).mp4
  • 6 mins
  • 20.3 MB
V4 Ch4 Illustration 4 Filtering data (2 min).mp4
  • 2 mins
  • 10.2 MB
V5 Ch4 Illustration 5, Find & Replace (2 min).mp4
  • 2 mins
  • 6.69 MB
V6 Ch4 Pivot Table & chart, illustration 6 (6 min).mp4
  • 6 mins
  • 32.7 MB
V7 Ch4 Three dimensional worksheet, illustration 7 (7 min).mp4
  • 7 mins
  • 35.8 MB
V8 Ch4 Formatting data as table, isslutration 8 (5 min).mp4
  • 5 mins
  • 31.6 MB
V9 Ch4 Lookup tables (7 min).mp4
  • 7 mins
  • 22 MB
V10 Ch4 Data Table What if analysis (8 min).mp4
  • 9 mins
  • 26 MB
V11 Ch4 Scenarios (4 minn).mp4
  • 4 mins
  • 22.3 MB
V12 Ch4 Goal Seek (2 min).mp4
  • 2 mins
  • 6.57 MB
V13 Ch4 Combination of charts (5 min).mp4
  • 6 mins
  • 23.7 MB
V14 Ch4 Circular reference (4 min).mp4
  • 5 mins
  • 15.3 MB
V15 Ch4 Trace precedents & dependents (1 min).mp4
  • 2 mins
  • 4.58 MB
V16 Ch4 Rounding, illustration 14 (6 min).mp4
  • 7 mins
  • 22.7 MB
V17 Error checking (3 min).mp4
  • 3 mins
  • 11.2 MB
V18 Ch4 Test your learning (2 min).mp4
  • 2 mins
  • 5.91 MB

Practice materials

Spreadsheets-Coursebook 2020-2021.zip
  • 1.02 MB