This live webinar is approved by the Engineering Council of South Africa (ECSA). Complete the course to earn 2 ECSA CPD Points. PMP Certificate holders will also receive 14 PMI PDUs.
This comprehensive course takes you from the basics to advanced techniques, ensuring you can confidently manage large datasets, streamline reporting, and apply analytical methods to support data-driven strategies. With hands-on training in functions, formulas, Power Query, PivotTables, and predictive analytics, you'll gain the skills to turn raw data into actionable insights—critical for professionals in finance, business, operations, and beyond.
Excel Beginners to Advanced
✅ Master essential and advanced Excel functions – Develop a strong foundation in Excel, from basic spreadsheet navigation to advanced formulas that streamline calculations and automate workflows.
✅ Enhance data analysis with formulas, tables, and conditional operations – Learn how to efficiently organize, manipulate, and analyze data using powerful functions like SUMIFS, VLOOKUP, INDEX-MATCH, and logical formulas that improve decision-making.
✅ Extract, clean, and transform data from various sources using Power Query – Connect Excel with multiple data sources (CSV, databases, PDFs, and web data), perform transformations, and automate data preparation to create accurate, structured datasets for reporting.
✅ Utilize PivotTables and PivotCharts for interactive and insightful reporting – Learn to summarize and visualize data dynamically, filter key insights, and create interactive reports with slicers, timelines, and calculated fields to drive better business decisions.
✅ Create visually compelling dashboards and automate workflows with Macros – Design professional dashboards that present complex data in an easy-to-read format using charts, sparklines, and dynamic reports. Automate repetitive tasks with Excel Macros and VBA to improve efficiency.
✅ Apply predictive analytics techniques for forecasting and business insights – Use advanced forecasting tools, regression analysis, and time series modeling to predict trends, optimize budgets, and support data-driven decision-making with confidence.