Delegate Pack

Pre course Reading

Defining a List, Sorting Lists, Filtering Lists, Using the Data Form

11m 3s

Module Assessment 1

Case Study: Managing Large Datasets with Sorting and Filtering in an Accounting Firm

Purpose of PivotTables, Building PivotTables, Getting Data Summaries, Data Cache, Using Named Ranges as Data Sources

9m 26s

Module Assessment 2

Case Study: Utilising Pivot Tables to Summarise Year-End Sales Data for Strategic Decision-Making

Rationale for Common Sizing and Other Uses of Common Sizing

3m 37s

Module Assessment 3

Case Study: Enhancing Financial Statement Comparability Using Common Sizing Techniques

Why Charts?, Charts that Show Time Series, Pivot Charts Vs Standard Charts and Budget Variances Over Time

10m 8s

Module Assessment 4

Case Study: Analysing and Reporting Budget Variances Using Charts

Explore essential tools, lists, and shortcuts for accountants

9m 8s

Module Assessment 5

Case Study: Streamlining Accounting Processes with Custom Lists and Macros

Scenerios and multiple inputs

8m 44s

Implicit Intersection

8m 33s

Module Assessment 6

Case Study: Utilising Scenarios and Goal Seek in Strategic Financial Planning

Payment Functions, Using a Function and Using the Function Wizard

3m 3s

Module Assessment 7

Case Study: Optimizing Loan Management with Excel's Payment Functions

Family of Depreciation Functions, SLN Function and Accelerated Depreciation

8m 48s

Module Assessment 8

Case Study: Implementing Excel's Depreciation Functions for Asset Management

IIF Import Files, Format of an IIF File, Exporting Data into an IIF File, Importing an IIF File and IIF File Keywords for Lists

9m 45s

Module Assessment 9

Case Study: Streamlining Accounting Processes with Custom Lists and Macros

Post Course Quiz 1

Post Course Quiz 2

Let's prepare for the Interview