JAN -APRIL EVENING VIDEOS 2026 (8-10PM)
INTRODUCTION TO BDA/FMDA AND PREDICTIONS FOR THE 23RD OF APRIL 2026 EXAMS
1.0 Introduction to Excel
Utilising the keyboard shortcuts in Excel
Conducting data analysis using data tables, pivot tables and other common
functions
Using advanced formulas and functions to enhance the functionality of financial
models
TOPIC 1 INTRODUCTION TO EXCEL FUNTIONS AND FORMULAS
CLASS FILE
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2026/02/INTRODUCTION-TO-EXCEL-FUNCTIONS-AND-FORMULAS-CLASS-SOLUTION.xlsx
3.0 Core application of data analytics
3.1 Financial accounting and reporting – Prepare financial statements; statement of profit or loss, statement of
financial position and statement of cash flow for companies and groups – Analyse financial statements using ratios, common size statements, trend
and cross-sectional analysis, graphs and charts
– Prepare forecast financial statements under specified assumptions – Carry out sensitivity analysis and scenario analysis on the forecast financial
statements – Data visualization and dash boards for reporting
PREPARATION OF PUBLISHED FINANCIAL STATEMENTS: INCOME STATEMENT, STATEMENT OF FINANCIAL POSITION
CLASS FILE
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2026/02/FINANCIAL-STATEMENTS-CLASS-SOLUTION.xlsx
FORECASTING OF FINANCIAL STATEMENTS
CLASS FILE
CLASS SOLUTION
TAXATION