Ms.Lara Mellor

Unlike most functions which provide a result in a single cell that can then be auto filled, dynamic array functions automatically produce a result that spills into adjacent cells. Amongst the functions covered in this session are FILTER, SORT and SORTBY which ...

PivotTables are one of Excel’s most powerful tools for data analysis. This webinar introduces the core concepts and practical steps to start using PivotTables effectively, even if you’re new to data manipulation. It will cover details on what pivot tables are ...

This beginner-friendly webinar is your gateway to mastering the building blocks of Excel calculations. Whether you're working with budgets, reports, or performance metrics, understanding how Excel handles maths is essential. We’ll start with the logic behind ...

Power BI is Microsoft’s powerful business analytics tool that transforms raw data into meaningful insights through interactive dashboards and reports. This introductory webinar is designed for those who are new to Power BI and want to understand its core capab ...

Excel just got a whole lot smarter. With Copilot Chat, you can now interact with your spreadsheets using natural language—no more hunting for the right formula or spending hours formatting data. This session will walk you through how to use Copilot Chat to st ...