ANALYSIS OF BDA COURSE CONTENTS AND PREDICTIONS (FOR BDA EXAMS ON 21ST AUGUST 2025)
TOPIC 1 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
CLASS FILE
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/05/INTRODUCTION-TO-EXCEL-FUNTIONS-AND-FORMULAS-CLASS-FILE-1.xlsx
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/05/INTRODUCTION-TO-EXCEL-FUNTIONS-AND-FORMULAS-CLASS-SOLUTION-6.xlsx
https://vimeo.com/1081943716/302b423526?share=copy
https://vimeo.com/1082299355/df98ecb51c?share=copy
https://vimeo.com/1083648272/41c11ac129?share=copy
https://vimeo.com/1084018664/98b407e9df?share=copy
https://vimeo.com/1084382347/955a40ed89?share=copy
https://vimeo.com/1085810523/2b41d668f9?share=copy
TOPIC 3 CORE APLLICATIONS 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
CLASS FILE
CLASS SOLUTION
https://rcmonlinecollege.co.ke/wp-content/uploads/2025/05/FINANCIAL-STATEMENTS-CLASS-SOLUTION-2.xlsx
https://vimeo.com/1087819935/bee7467aa6?share=copy
https://vimeo.com/1088171093/a11b21c665?share=copy
https://vimeo.com/1088531050/8a588aa28f?share=copy