Ms Excel

Basic Bookkeeping in MS Excel

Recording transactions, profit or loss statements, and balance sheets in Excel

Basic Costing in MS Excel

Cost allocation, cost gap analysis, and pricing templates in Excel

Basic Inventory Management in MS Excel

Inventory tracking, VLOOKUP, SUMIFS, reorder points, and stock valuation

Budget vs Actual (BVA) Analysis in MS Excel

Variance reporting, conditional formatting, and budgetary control templates

Creating a Dashboard in Excel

Formulas, chart formatting, and dashboard design from raw data

Data Analytics for Auditors in MS Excel

Trend analysis, descriptive statistics, correlation, and audit dashboards

Data Validation and Conditional Formatting

Restricting cell input and applying rule-based visual formatting

Designing a Form in Excel

Data entry forms, printable form design, and form controls

Making Your Spreadsheets Visually Appealing

Layout, colour, alignment, and design tips for professional spreadsheets

Microsoft Excel: Advanced Formatting

Cell display, cell protection, and advanced formatting techniques

Microsoft Excel: Formatting Data

Fonts, styles, number formats, currencies, and date display

Microsoft Excel: Pivot Tables and Workbook Management

Creating pivot tables and managing multi-sheet workbooks

Microsoft Excel: Sorting, Checking & Importing Data

Data integrity, sorting techniques, and moving data between files

Microsoft Excel: Spreadsheet Functions

Formulas, IF logic tests, VLOOKUP, HLOOKUP, and cell references

Microsoft Excel: Spreadsheet Know How

Introduction to spreadsheet navigation, data entry, and basic tools

Microsoft Excel: Statistical Functions

COUNT, SUMIF, AVERAGE, rounding functions, and data analysis

Microsoft Excel: Using Charts

Creating, modifying, and choosing the right chart types in Excel

Using Slicers in Excel

Visual filters for tables, pivot tables, and charts in Excel