Delivered either online or onsite, these instructor-led live Excel training courses use interactive discussion and hands-on practice to demonstrate how to leverage Excel for financial computations, data analysis, and more.
Excel training is offered as 'online live training' or 'onsite live training'. Online live training (also known as 'remote live training') is conducted via an interactive, remote desktop. Onsite live training can be hosted directly on customer premises in Durban or at NobleProg corporate training centres in Durban.
NobleProg – Your Local Training Provider
Garden Court South Beach
Durban, South Africa
Way to get there
From Durban city centre: follow the beachfront/Marine Parade south toward South Beach.
By car/taxi: give the driver the address 73 O.R. Tambo Parade, South Beach, Durban 4001.
From King Shaka International Airport: the hotel is roughly 30 km ;from the airport.
This live-led Excel program in Durban supports users in progressing from fundamental data entry to sophisticated automation methods. Learners will gain mastery over formulas, PivotTables, and VBA through practical, hands-on tasks. It is an excellent choice for developing strong professional reporting and analytical abilities.
This live training in Durban is designed for intermediate Excel users aiming to gain mastery over inventory control, budgeting, and reporting. Participants will learn to analyze datasets with over 5,000 rows using formulas, pivot tables, and macros, while building practical skills through hands-on lab exercises to automate workflows.
This instructor-led, live training in Durban (online or in-person) is designed for data analysts at beginner to advanced levels who wish to use Excel to perform a variety of tasks such as data entry, formula creation, data analysis, and advanced automation.
By the end of this training, participants will be able to:
Navigate Excel’s interface and perform basic data entry, formatting, and calculations.
Apply advanced formulas, functions, and conditional formatting for data analysis.
Create and manage pivot tables and charts for data visualisation.
Use tools like Power Query, Power Pivot, and perform data analysis.
Automate tasks using macros and VBA to streamline workflows.
This instructor-led, live training in Durban (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.
By the end of this training, participants will be able to:
Navigate and utilize the core features of Excel and Google Sheets.
Perform data analysis and create actionable insights using advanced spreadsheet techniques.
Collaborate in real-time using Google Sheets for seamless teamwork.
Create reusable templates for reporting, tracking, and project management.
Participate in this live Excel modelling course in Durban to cultivate advanced data analysis competencies. Master structured problem-solving strategies, sophisticated functions, and core model design principles. Through hands-on practice, you will learn to construct scalable models suitable for scenario analysis and effective business reporting.
Excel is a popular spreadsheet program developed by Microsoft. It is used to store, organise, and analyse data in tabular form. Here are some key features and functions of Excel:
1. Spreadsheets:
Consists of sheets, where each sheet is an array composed of cells arranged in rows and columns.
Allows the creation of multiple sheets within one file, enabling the organisation of various data sets.
2. Calculations and formulas:
Enables various mathematical, statistical, and logical calculations using formulas.
Includes a wide range of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc.
3. Data formatting and appearance:
Provides tools for formatting data, including changing fonts, colours, styles, as well as creating charts, pivot tables, and diagrams.
4. Sorting, filtering, and grouping:
Allows sorting data according to specific criteria.
Enables filtering data to display only selected information.
Capability to group data depending on requirements.
5. Data analysis:
Tools for performing advanced analyses, such as scenario analysis, trend analysis, forecasting, and creating macros.
6. Data sharing:
Facilitates sharing and collaborating on data in real time, allowing multiple users to work on the same data simultaneously.
7. Task automation:
Ability to create macros and automate tasks using the VBA (Visual Basic for Applications) programming language.
Excel is widely used in various fields, from business to science and education. Its versatile functions allow for data analysis, report creation, budgeting, scheduling, data management, and many other applications.
This instructor-led, live training in Durban (online or onsite) is designed for data analysts who want to utilise advanced VBA in Excel for task automation.
Upon completion of this training, participants will be able to:
This instructor-led, live training in Durban (online or on-site) is designed for data analysts who wish to learn techniques for preparing data in Excel, then visualizing it in Power BI.
By the end of this training, participants will be able to:
Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
Use DAX formulas in Power BI for complex calculations.
Create and use visualizations and charts for particular analysis cases.
Import with Power View to move from Excel based Power BI to independent Power BI.
Streamline operations and develop robust desktop applications using VBA within Microsoft Excel and Access. This in-depth programme in Durban covers programming essentials, object-oriented principles, SQL database architecture, and user interface creation through hands-on practice for data management.
Acquire core Microsoft Excel competencies through this introductory training in Durban. The program addresses data input, styling, formulas, functions, tabular structures, and graphical representation, equipping participants with a solid basis for practical data examination and reporting.
Elevate your financial analysis capabilities through this comprehensive Excel course in Durban. Gain proficiency in advanced functions, pivot tables, and external data workflows, while exploring practical applications such as time value of money, forecasting models, and securities analysis to facilitate data-driven decision-making.
Acquire advanced Excel skills for financial analysis, including INDEX-MATCH, PivotTables, VBA, and Solver, at Durban. Gain proficiency in Goal Seek, database queries, and external data integration to automate workflows and convert raw data into actionable insights and forecasts.
This intermediate Excel 2019 course in Durban expands on fundamental skills by covering data analysis, advanced functions, and visualization techniques. Learners will develop the ability to manage lists, generate dynamic charts, and leverage PivotTables to convert raw data into actionable insights that support better decision-making.
Establish a robust Excel base in Durban through this introductory course. Acquire the skills to construct workbooks, execute calculations, and style sheets efficiently. This training equips you to organize, examine, and present data, thereby enhancing decision-making processes within your organization.
This Excel Advanced training in Durban empowers you to streamline complex processes and achieve proficiency with advanced formulas. You will learn to facilitate collaborative workbook management, conduct in-depth data analysis, and predict future trends, thereby unlocking the complete potential of Microsoft Excel for your organisation.
This hands-on Excel course in Durban delves into data entry, formatting, formulas, functions, and chart development. Learners will gain the skills to execute calculations efficiently, automate routine spreadsheet tasks, and secure sensitive information from unauthorized modifications or accidental errors.
This Excel Advanced with VBA course in Durban equips you to optimize data management through advanced formulas and VBA automation. You will learn to build custom functions, design user forms, and streamline workflows using macros and external data integration to boost productivity.
This instructor-led programme in Durban assists Excel users in advancing their VBA proficiency to an intermediate level. Participants will design custom interfaces, gain mastery over complex data types, and implement robust error handling and debugging methods. This training is ideal for professionals aiming to achieve efficient workflow automation.
Advance your Excel expertise in this comprehensive 14-hour session held in Durban. Acquire skills in advanced formulas, precise formatting, chart creation, and PivotTable management to enhance your productivity. This course is perfectly designed for professionals seeking to effectively elevate their data analysis and reporting capabilities from an intermediate to an expert level.
This instructor-led live training in Durban (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.
By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.
This 5-day Advanced Excel for Sales Professionals course is tailored to empower sales teams with the essential skills to manage, analyze, and automate sales data effectively. Participants will master advanced Excel functions, data analysis techniques, and automation tools to improve reporting precision, construct dynamic dashboards, and forecast sales outcomes. Through practical, hands-on exercises, sales professionals will acquire actionable insights into developing interactive sales reports, automating routine tasks, and utilizing advanced utilities such as Power Query, Power Pivot, and Macros. This programme is ideally suited for individuals aiming to harness Excel to propel data-driven sales strategies.
This instructor-led live training in Durban (online or onsite) is designed for beginner to intermediate-level business analysts and data analysts who wish to leverage Excel for data analysis and reporting in their projects and daily tasks.
Upon completing this training, participants will be able to:
Utilise Excel formulas and functions to perform calculations and manipulate data.
Employ Excel data analysis tools, such as PivotTables, What-If Analysis, and Forecasting, to summarise and visualise data effectively.
Create and customise data visualisations using Excel charts and graphs.
Implement Excel data validation and conditional formatting to ensure data quality and highlight key insights.
Use Excel data import and export features to connect with external data sources and share data with others.
Read more...
Last Updated:
Testimonials (9)
Flexibility in the course delivery and the interactive approach. The trainer was open to questions, clarified doubts clearly and also considered participants suggestions during the sessions. The training was well structured and informative.
Soundarya Mohan - Mizuho Bank Europe N.V.
Course - Financial Analysis in Excel
Every step of the way, I was learning something.
GEORGE BRUSSE - martinrea.com
Course - Excel - Intermediate
the trainer's patience,
Agata Halubicka - Sad Rejonowy w Krosnie Odrzanskim
Course - Microsoft Office Excel - poziom średnio zaawansowany
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Visual Basic for Applications (VBA) w Excel - wstęp do programowania
Well structured. Good teaching techniques. Course well documented!
Sorin
Course - VBA For Access & Excel
very clear, very good explanation, wishing more teachers would train like this
Mihaela - Phillip Morris
Course - Excel Basics
trainer was expalning everything step by step which was very good as it was easy to follow if there was anything unclear trainer helped
Daria - LKQ Polska Sp. z o. o.
Course - Excel Modelling
What I liked most about the training was the trainer’s knowledge of Excel. I appreciated learning useful things like shortcuts and formulas that I can use every day.
Martin
Course - Visual Basic for Applications (VBA) for Analysts
Online MS Excel training in Durban, Excel training courses in Durban, Weekend Excel courses in Durban, Evening Microsoft Excel training in Durban, Excel instructor-led in Durban, Microsoft Excel classes in Durban, Online Excel training in Durban, Excel private courses in Durban, Excel trainer in Durban, Microsoft Excel one on one training in Durban, Excel on-site in Durban, Evening Microsoft Excel courses in Durban, MS Excel boot camp in Durban, Weekend MS Excel training in Durban, Excel coaching in Durban, Microsoft Excel instructor in Durban, Microsoft Excel instructor-led in Durban
