Excel in Accounting

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

Text book

Level 3 - Spreadsheets for Accounting - Course Book.pdf

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

Preview

V2 Ch3 Illustration 1 (intro of spread sheet) 13 min.mp4

V3 Ch3 Illustration 2 (sing fill handle) 5 min.mp4

Preview

V4 Ch3 Illustration 3 (Copy & Paste) 2 min.mp4

V5 Ch3 Illustration 4, Paste special (2 min).mp4

V6 Ch3 illustration 5 insert, delete, hide,unhide, date & time (6 min).mp4

V7 Ch3 illustration 6 , naming cells (3 min).mp4

V8 Ch3 Illustration 7, Spreadsheet Construction (24 min).mp4

V9 ch3 Illustration 8 Comission calculation (4 min).mp4

V10 Ch3 Illustration 9 Actual & budgeted sales (5 min).mp4

V11 Ch3 Illustration 10 If function (5 min).mp4

V12 Ch3 Illustration 11 If Function (3 min).mp4

V13 Ch3 Count if , Counta & compound countif (6 min).mp4

V14 Ch3 Conditional formatting (5 min).mp4

V15 Ch3 Ranking (3 min).mp4

V16 Ch3 Charts & Graphs (16 min).mp4

V17 Ch3 Illustration 13, Simple data manipulation (4 min).mp4

V18 Ch3 Prining (13 min).mp4

V19 Ch3 Test your learning (6 min).mp4

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

V1 Ch4 Illustration 1 data security (13 min).mp4

V2 Ch4 illustration 2 Data validation (7 min).mp4

V3 Ch4 Illustration 3, Subtotal (6 min).mp4

V4 Ch4 Illustration 4 Filtering data (2 min).mp4

V5 Ch4 Illustration 5, Find & Replace (2 min).mp4

V6 Ch4 Pivot Table & chart, illustration 6 (6 min).mp4

V7 Ch4 Three dimensional worksheet, illustration 7 (7 min).mp4

V8 Ch4 Formatting data as table, isslutration 8 (5 min).mp4

V9 Ch4 Lookup tables (7 min).mp4

V10 Ch4 Data Table What if analysis (8 min).mp4

V11 Ch4 Scenarios (4 minn).mp4

V12 Ch4 Goal Seek (2 min).mp4

V13 Ch4 Combination of charts (5 min).mp4

V14 Ch4 Circular reference (4 min).mp4

V15 Ch4 Trace precedents & dependents (1 min).mp4

V16 Ch4 Rounding, illustration 14 (6 min).mp4

V17 Error checking (3 min).mp4

V18 Ch4 Test your learning (2 min).mp4

Practice materials

Spreadsheets-Coursebook 2020-2021.zip