Excel in Accounting
- Buy now
- Learn more
Text book

Level 3 - Spreadsheets for Accounting - Course Book.pdf
Basic Excel: Introduction to spreadsheet (Excel 2013)

V1 Ch3 Introduction (5min).mp4
V2 Ch3 Illustration 1 (intro of spread sheet) 13 min.mp4
V3 Ch3 Illustration 2 (sing fill handle) 5 min.mp4
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

Excel in Accounting

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.