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
Products
Course
Section
chapter-4: More Advanced spreadsheet techniques (Exel 2013)
chapter-4: More Advanced spreadsheet techniques (Exel 2013)
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
18 Lessons
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