Relative, Absolute & Mixed Cell Referencing using Structured & Normal Ranges

This is a Live Online class on Cell Referencing Styles in Excel. We shall handle everything you need to know about Cell Referencing, what a range reference is, relative cell referencing, absolute cell referencing, and mixed cell referencing as well as structured Table References and Named Ranges. Timestamps to help you navigate to the desired topic of your choice 00:00 Introduction to Cell Referencing 01:35 Cross Cross-referencing in Excel (how does it work?) 07:18 Circular Referencing in Excel 12:54 3D Referencing in Excel (How to write 3D formulas) 23:18 Structured Table References in Excel 27:17 How to Create a Structured Table Reference in Excel 36:16 How to Create a Named Range in Excel 44:32 Relative, Absolute and Mixed Cell References To Grab the files so that you can follow along click this link. https://docs.google.com/spreadsheets/... To Register for our Free Excel Classes or join our WhatsApp Group us this link below https://linktr.ee/opentrainingcamp To Call me or Text me or WhatsApp me for Business +256 773 523 826