Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.
| Start Date | Duration | Course | Status | |
|---|---|---|---|---|
| Monday 5 August 2024 | 1 Day | Microsoft Excel Fundamentals | Provisional | Enquire |
| Monday 5 August 2024 | 3 Days | InDesign Basic-Intermediate | Provisional | Enquire |
| Tuesday 6 August 2024 | 1 Day | Microsoft Excel: Intermediate | Provisional | Enquire |
| Wednesday 7 August 2024 | 1 Day | Microsoft Excel: Advanced | Provisional | Enquire |
| Monday 12 August 2024 | 2 Days | Change Management SAQA US252021 | Scheduled | Book Live Virtual Training |
| Monday 12 August 2024 | 3 Days | SQL | Provisional | Enquire |
| Thursday 15 August 2024 | 2 Days | Advanced SQL | Provisional | Enquire |
| Thursday 15 August 2024 | 2 Days | Microsoft Power BI Desktop Advanced Course | Provisional | Enquire |
| Monday 19 August 2024 | 3 Days | Project Management Tools and Techniques US120385 | Scheduled | Book Live Virtual Training |
| Thursday 22 August 2024 | 2 Days | Microsoft Project | Provisional | Enquire |
| Monday 2 September 2024 | 1 Day | Microsoft Excel Fundamentals | Provisional | Enquire |
| Monday 2 September 2024 | 2 Days | Laravel Introduction | Provisional | Enquire |
| Monday 2 September 2024 | 3 Days | Assessor Training US115753 | Scheduled | Book Live Virtual Training |
| Monday 2 September 2024 | 4 Days | Laravel Bootcamp | Provisional | Enquire |
| Tuesday 3 September 2024 | 1 Day | Microsoft Excel: Intermediate | Provisional | Enquire |
| Wednesday 4 September 2024 | 1 Day | Microsoft Excel: Advanced | Provisional | Enquire |
| Wednesday 4 September 2024 | 2 Days | Laravel Intermediate | Provisional | Enquire |
| Thursday 5 September 2024 | 2 Days | Customer Centric Employee | Provisional | Enquire |
| Monday 9 September 2024 | 3 Days | Microsoft Power BI Boot Camp | Provisional | Enquire |
| Monday 9 September 2024 | 3 Days | Illustrator Basic-Intermediate | Provisional | Enquire |
![Enquire](/enquiry?subject={"id":286,"certificate_template_id":1,"title":"Excel Basic course - virtual Instructor-led Midrand, Sandton, Johannesburg, South Africa","description":"<p>You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format.<\/p>\n<p> <\/p>","audience":"<p>This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel worksheets.<\/p>","prerequisites":"<p>Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.<\/p>","about":"You will create and edit basic Microsoft Office Excel Worksheets and\r\nWorkbooks.","durationunits":"Day","outline":"<ul>\r\n<li>Lesson 1: Getting Started with Microsoft Excel<br \/>\r\n<ul>\r\n<li>Navigate the Excel User Interface<\/li>\r\n<li>Use Excel Commands<\/li>\r\n<li>Creating and Save a Basic Workbook<\/li>\r\n<li>Enter Cell Data<\/li>\r\n<li>Use Excel Help<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 2: Performing Calculations\r\n<ul>\r\n<li>Creating Formulas in a Worksheet<\/li>\r\n<li>Insert Functions in a Worksheet<\/li>\r\n<li>Reuse Formula<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 3: Modifying a Worksheet\r\n<ul>\r\n<li>Manipulate Data<\/li>\r\n<li>Insert, Manipulate, and Delete Cells, Columns, and Rows<\/li>\r\n<li>Search for and Replace Data<\/li>\r\n<li>Use Proofing and Research Tools<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 4: Formatting a Worksheet<br \/>\r\n<ul>\r\n<li>Modify Fonts<\/li>\r\n<li>Add Borders and Color to Cells<\/li>\r\n<li>Apply Number Formats<\/li>\r\n<li>Align Cell Contents<\/li>\r\n<li>Apply Cell Styles and Themes<\/li>\r\n<li>Apply Basic conditional formatting<\/li>\r\n<li>Create and Use Templates<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 5: Printing Workbook Contents<br \/>\r\n<ul>\r\n<li>Preview and Print a Workbook <\/li>\r\n<li>Define the Page Layout<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 6: Managing Large Workbooks<br \/>\r\n<ul>\r\n<li>Manage Worksheets<\/li>\r\n<li>Manage the View of Worksheets and Workbooks<\/li>\r\n<li>Manage Workbook Properties <\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","image":"Excel_2013_logo.png","meta_desc":"Microsoft Office Excel Fundamentals course online virtual instructor-led training Johannesburg South Africa","keywords":"excel basic training in Joburg\r\nbasic excel course\r\nexcel basic training excel fundamental training course\r\nmicrosoft excel bas","filename":"excel_fundamentals","old_slug":null,"name":"Microsoft Excel Fundamentals","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"ExcelFundamental","bookstock":0,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2021-03-18 11:52:43","accountmanagerid":175,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":1,"youtube_video_intro":null,"moodle_course_id":8,"internal_comments":null,"created_at":null,"updated_at":"2023-12-07T12:43:06.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":286,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2023-06-21T14:57:33.000000Z","duration":1,"duration_units":"Day","cost":"2750.00","minimum_delegates":null,"moodle_course_id":8}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":286,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2023-06-21T14:57:33.000000Z","duration":1,"duration_units":"Day","cost":"2250.00","minimum_delegates":null,"moodle_course_id":8}}]}&dates=5th Aug 2024 09:00 - 16:00){kind=link}
![Enquire](/enquiry?subject={"id":287,"certificate_template_id":1,"title":"Excel Intermediate course - Joburg, Pretoria South Africa-Midrand, Sandton, Johannesburg, South Africa","description":"<p>This course is designed for students who already have foundation knowledge and skills in Microsoft Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.<\/p>\r\n<p> <\/p>","audience":"<p>The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web<\/p>","prerequisites":"<p>Microsoft Office Excel Fundamentals<\/p>","about":"<p>You will apply visual elements and advanced formulas to a worksheet to display data in various formats.<\/p>","durationunits":"Day","outline":"<p>Lesson 1: Working with Functions<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Work with Ranges<\/li>\r\n<li>Use Specialized Functions<\/li>\r\n<li>Work with Logical Functions<\/li>\r\n<li>Work with Date & Time Functions<\/li>\r\n<li>Work with Text Functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 2: Working with Lists<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Sort Data<\/li>\r\n<li>Filter Data<\/li>\r\n<li>Query Data with Database Functions<\/li>\r\n<li>Outline and Subtotal Data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 3: Analyzing Data<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Create and Modify Tables<\/li>\r\n<li>Apply Intermediate Conditional Formatting<\/li>\r\n<li>Apply Advanced Conditional Formatting<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 4: Visualizing Data with Charts <\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Create Charts<\/li>\r\n<li>Modify and Format Charts<\/li>\r\n<li>Use Advanced Chart Features<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 5: Using PivotTables and PivotCharts <\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Create a PivotTable<\/li>\r\n<li>Analyze PivotTable Data<\/li>\r\n<li>Present Data with PivotCharts<\/li>\r\n<li>Filter Data by Using Timelines and Slicers<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","image":"istockphoto-1582498355-612x6121713170948.jpg","meta_desc":"Microsoft Office intermediate excel provided by IT company in Johannesburg and Pretoria, South Africa, online virtual instructor-led training","keywords":"excel training course\r\nexcel training courses\r\nMicrosoft Excel intermediate\r\npivot table Excel training\r\nExcel logical function","filename":"excel_intermediate","old_slug":null,"name":"Microsoft Excel: Intermediate","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"Excel Int","bookstock":11,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2020-03-09 13:51:33","accountmanagerid":null,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":3,"youtube_video_intro":null,"moodle_course_id":123,"internal_comments":null,"created_at":null,"updated_at":"2024-04-15T08:49:08.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":287,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2024-03-11T10:05:52.000000Z","duration":1,"duration_units":"Day","cost":"2750.00","minimum_delegates":null,"moodle_course_id":123}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":287,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2024-03-11T10:05:52.000000Z","duration":1,"duration_units":"Day","cost":"2250.00","minimum_delegates":null,"moodle_course_id":123}}]}&dates=6th Aug 2024 09:00 - 16:00){kind=link}
![Enquire](/enquiry?subject={"id":288,"certificate_template_id":1,"title":"Excel Advanced course - Joburg, Pretoria South Africa - Midrand, Sandton, Johannesburg, South Africa","description":"<p>In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.<\/p>","audience":"<p>This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data.<\/p>","prerequisites":"<p>To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft Office Excel Basic and Microsoft Office Excel Intermediate<\/p>","about":"You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.","durationunits":"Day","outline":"<p>Lesson 1:Working with Multiple Worksheets and Workbooks<strong><br \/><\/strong><\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Use Links and External References<\/li>\r\n<li>Use 3-D References<\/li>\r\n<li>Consolidate Data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 2: Using Lookup Functions and Formula Auditing<strong><br \/><\/strong><\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Use Lookup Functions<\/li>\r\n<li>Trace Cells<\/li>\r\n<li>Watch and Evaluate Formulas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 3: Sharing and Protecting Workbooks<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Collaborate on a Workbook<\/li>\r\n<li>Protect Worksheets and Workbooks<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 4: Automating Workbook Functionality<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Apply Data Validation<\/li>\r\n<li>Search for Invalid Data and Formulas with Errors<\/li>\r\n<li>Work with Macros<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 5: Creating Sparklines and Mapping Data<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Create Sparklines<\/li>\r\n<li>Map Data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 6: Forecasting Data<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Determine Potential Outcomes Using Data Tables<\/li>\r\n<li>Determine Potential Outcomes Using Scenarios<\/li>\r\n<li>Use the Goal Seek Feature<\/li>\r\n<li>Forecasting Data Trends<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","image":"Excel_2013_logo.png","meta_desc":"In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.","keywords":"Excel advanced course in Johannesburg\r\nexcel advanced training South Africa,\r\nMicrosoft Excel Advanced Training\r\nExcel Advanced","filename":"excel_advanced_","old_slug":null,"name":"Microsoft Excel: Advanced","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"Excel Advanced","bookstock":26,"onorder":7,"expectedorderdate":null,"stock_last_updated":"2017-11-28 08:18:04","accountmanagerid":175,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":66,"internal_comments":null,"created_at":null,"updated_at":"2024-03-11T09:17:52.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":288,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2023-10-09T07:45:43.000000Z","duration":1,"duration_units":"Day","cost":"2750.00","minimum_delegates":null,"moodle_course_id":66}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":288,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2023-10-09T07:45:43.000000Z","duration":1,"duration_units":"Day","cost":"2250.00","minimum_delegates":null,"moodle_course_id":66}}]}&dates=7th Aug 2024 09:00 - 16:00){kind=link}
![Enquire](/enquiry?subject={"id":322,"certificate_template_id":1,"title":"Advanced SQL","description":"<p>In this course you will learn how to:<\/p>\r\n<ul>\r\n<li>Use loops and branches in queries<\/li>\r\n<li>Create user defined functions and stored procedures<\/li>\r\n<li>Manage constraints and triggers<\/li>\r\n<li>Control multiple simultaneous updates<\/li>\r\n<\/ul>","audience":"<p>Database Administrators, Programmers.<\/p>","prerequisites":"<ul>\r\n<li>At least one months experience using <a href=\"https:\/\/www.leadingtraining.co.za\/sql_database_training_course\">SQL<\/a><\/li>\r\n<li><a href=\"https:\/\/www.leadingtraining.co.za\/excel_level_intermediate_2013_training_course\">Intermediate Microsoft Excel<\/a> experience recommended <\/li>\r\n<\/ul>","about":"<p>Structured Query Language (SQL) is the most popular language used for querying relational databases. SQL supports a number of advanced features that make your queries more intelligent and efficient and take a lot of the work away from the middle ware.<\/p>\r\n<h2>This course is specifically only for Microsoft SQL Server. For an advanced SQL course focused on Oracle, please contact us.<\/h2>","durationunits":"days","outline":"<ul>\r\n<li><strong>Sequences<\/strong>\r\n<ul>\r\n<li>CREATE SEQUENCE<\/li>\r\n<li>Viewing sequence details<\/li>\r\n<li>NEXT VALUE FOR<\/li>\r\n<li>DROP SEQUENCE<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li><strong>Computed Columns<\/strong><\/li>\r\n<li><strong>Temporary Tables<\/strong><\/li>\r\n<li><strong>Derived Tables<\/strong><\/li>\r\n<li><strong>Procedural Language<\/strong><\/li>\r\n<li><strong>Variables<\/strong>\r\n<ul>\r\n<li>Declaration<\/li>\r\n<li>Assignment<\/li>\r\n<li>Displaying Variables<\/li>\r\n<li>Concatenating Variables<\/li>\r\n<li>Scope<\/li>\r\n<li>Using variables<\/li>\r\n<li>Table variables<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li><strong>IF ... ELSE<\/strong><\/li>\r\n<li><strong>CASE<\/strong><\/li>\r\n<li><strong>Converting rows into columns<\/strong>\r\n<ul>\r\n<li>Using CASE<\/li>\r\n<li>Using PIVOT<\/li>\r\n<li>UNPIVOT<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li><strong>IIF, COALESCE, ISNULL<\/strong><\/li>\r\n<li><strong>FOR XML<\/strong>\r\n<ul>\r\n<li>RAW mode<\/li>\r\n<li>PATH mode<\/li>\r\n<li>AUTO mode<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li><strong>FOR JSON<\/strong><\/li>\r\n<li><strong>Advanced Grouping<\/strong>\r\n<ul>\r\n<li>WITH ROLLUP<\/li>\r\n<li>WITH CUBE<\/li>\r\n<li>GROUPING SETS<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li><strong>Window Functions<\/strong>\r\n<ul>\r\n<li>OVER<\/li>\r\n<li>Creating a running total<\/li>\r\n<li>ROW_NUMBER, RANK and DENSE_RANK<\/li>\r\n<li>LEAD AND LAG<\/li>\r\n<li>FIRST_VALUE and LAST_VALUE<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li><strong>WHILE<\/strong><\/li>\r\n<li><strong>Cursors<\/strong><\/li>\r\n<li><strong>User Defined Functions<\/strong>\r\n<ul>\r\n<li>Restrictions on functions<\/li>\r\n<li>Table Valued Functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li><strong>CROSS APPLY and OUTER APPLY<\/strong><\/li>\r\n<li><strong>Common Table Expressions<\/strong><\/li>\r\n<li><strong>Stored Procedures<\/strong>\r\n<ul>\r\n<li>Parameters<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li><strong>Dynamic SQL<\/strong><\/li>\r\n<li><strong>Triggers<\/strong>\r\n<ul>\r\n<li>DML AFTER Triggers<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","image":"pexels-cottonbro-studio-80901401712649974.jpg","meta_desc":"Advanced SQL training using Microsoft SQL Server. This course includes sequences, computed columns, temporary tables, procedural language, advanced grouping, window functions, cursors, user defined functions, stored procedures and triggers.","keywords":"Advanced Sql Training Course\r\nAdvanced Sql Training course\r\nSql Advanced Course","filename":"adv_sql","old_slug":null,"name":"Advanced SQL","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"AdvSQL","bookstock":0,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2017-05-09 15:49:27","accountmanagerid":135,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":34,"internal_comments":null,"created_at":null,"updated_at":"2024-04-09T08:06:14.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":322,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2024-01-02T13:01:47.000000Z","duration":2,"duration_units":"days","cost":"5500.00","minimum_delegates":null,"moodle_course_id":34}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":322,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2024-01-02T13:01:47.000000Z","duration":2,"duration_units":"days","cost":"4500.00","minimum_delegates":null,"moodle_course_id":34}}]}&dates=15th Aug 2024 09:00 - 16th Aug 2024 16:00){kind=link}
![Enquire](/enquiry?subject={"id":383,"certificate_template_id":1,"title":"Microsoft Power BI Desktop Advanced Course","description":"<p class=\"MsoBodyText\"><span lang=\"EN-ZA\" style=\"font-family: 'Tahoma',sans-serif; mso-bidi-font-family: 'Lucida Sans';\">Please note that this course will only run when we have 6 confirmed delegates booked on the course. In this course, attendees will learn how to model tables, create relationships, calculated columns, calculated tables and measures that support better reporting for the business. We will use Power BI for all practical implementations but these skills are easily transferable to Excel and Analysis Services.<\/span><\/p>","audience":"<p class=\"MsoBodyText\"><span lang=\"EN-ZA\" style=\"font-family: 'Tahoma',sans-serif; mso-bidi-font-family: 'Lucida Sans';\">This course is intended for people who have been working with Power BI, Excel pivot tables or SSAS tabular and are looking to understand how to create richer data models to enable deeper insight into their data.<\/span><\/p>","prerequisites":"<p><span style=\"font-family: Tahoma, sans-serif;\">The Power BI boot camp course is a pre-requisite for the course. Alternatively, delegates should have at least 3 months experience in using Power BI Desktop for creating reports and dashboards<\/span>.<\/p>\r\n<p>The newest version of the Power BI Desktop software is required. If you want assistance in installing the software on your laptop, please ensure that you have Administration Privileges on your laptop. Please arrive 1h early on the first day of the course, so that we can assist you. <\/p>\r\n<p> <\/p>\r\n<p> <\/p>","about":"<p>You are an experienced user of reporting systems and need to use Microsoft Power BI to define and extend data models for use by business users of Power BI Desktop You need to define data models, enhance data with calculated columns and measures, clean data, use ETL and analyze data over time<\/p>","durationunits":"day","outline":"<p>\"M\" Language:<\/p>\r\n<ul>\r\n<li>ETL and Power Query<\/li>\r\n<li>Overview of Dimensional Modelling Techniques<\/li>\r\n<li>M Functions and Keywords<\/li>\r\n<li>Using M to Load and Transform data<\/li>\r\n<\/ul>\r\n<p>DAX<\/p>\r\n<ul>\r\n<li>DAX basis<\/li>\r\n<li>\"Evaluation Context\" for filters and queries<\/li>\r\n<li>Time Intelligence Calculations<\/li>\r\n<li>ABC (\"Pareto\") Charts<\/li>\r\n<\/ul>","image":"pexels-andrea-piacquadio-9270221712650781.jpg","meta_desc":"In this course you will obtain skills to use Microsoft Power BI Desktop to transform data, extend data columns and measures, clean data, create data models, use an ETL approach, and analyze data over time.","keywords":"Business intelligence training, Power BI Desktop course, \r\nPower BI Advanced Course\r\nBI Advanced Training\r\nPower BI Advanced Co","filename":"PowerBI_Advanced","old_slug":null,"name":"Microsoft Power BI Desktop Advanced Course","status":1,"type":1,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"PowerBI_Adv","bookstock":0,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2017-05-30 11:26:45","accountmanagerid":null,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":110,"internal_comments":null,"created_at":null,"updated_at":"2024-04-09T08:19:42.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":383,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2023-11-06T13:13:45.000000Z","duration":2,"duration_units":"day","cost":"5500.00","minimum_delegates":null,"moodle_course_id":110}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":383,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2023-11-06T13:13:45.000000Z","duration":2,"duration_units":"day","cost":"4500.00","minimum_delegates":null,"moodle_course_id":110}}]}&dates=15th Aug 2024 09:00 - 16th Aug 2024 16:00){kind=link}
![Enquire](/enquiry?subject={"id":290,"certificate_template_id":1,"title":"Microsoft Project Training Course - Johannesburg South Afri-Midrand, Sandton, Johannesburg, South Africa","description":"<p>In this course, you will learn to create project plans, track timelines, baselines, tasks, and resources of a project, understand the project life cycle to setting up and refining schedules analysing costs allocating resources and tracking progress.<\/p>","audience":"<p>This course is for project managers and users to assist them in developing plans, assigning resources to tasks, tracking progress, managing budgets, and analysing workloads.<\/p>","prerequisites":"<p>Computer Literacy <br \/><br \/>If you are bringing your own laptop please make sure you have the latest version of MS Project installed. <\/p>","about":"Microsoft Project is a project management software program developed and sold by Microsoft which is designed to assist project managers in developing plans, assigning resources to tasks, tracking progress, managing budgets, and analysing workloads.","durationunits":"Days","outline":"<ul type=\"disc\">\r\n<li class=\"MsoNormal\" style=\"color: #495057; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1;\"><span style=\"font-size: 11.5pt; font-family: 'Segoe UI',sans-serif; mso-fareast-language: EN-ZA;\">Starting with MS Project: Terminology and managing the interface<\/span><\/li>\r\n<li class=\"MsoNormal\" style=\"color: #495057; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1;\"><span style=\"font-size: 11.5pt; font-family: 'Segoe UI',sans-serif; mso-fareast-language: EN-ZA;\">Project Management Basics: Calendars, currencies, and saving the project<\/span><\/li>\r\n<li class=\"MsoNormal\" style=\"color: #495057; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1;\"><span style=\"font-size: 11.5pt; font-family: 'Segoe UI',sans-serif; mso-fareast-language: EN-ZA;\">Create and modifying Tasks: Entering, moving and deleting tasks<\/span><\/li>\r\n<li class=\"MsoNormal\" style=\"color: #495057; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1;\"><span style=\"font-size: 11.5pt; font-family: 'Segoe UI',sans-serif; mso-fareast-language: EN-ZA;\">Estimates: Set estimates for duration and work<\/span><\/li>\r\n<li class=\"MsoNormal\" style=\"color: #495057; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1;\"><span style=\"font-size: 11.5pt; font-family: 'Segoe UI',sans-serif; mso-fareast-language: EN-ZA;\">Linking Tasks: Create dependencies, linking and unlinking tasks, and adding lag and lead to the schedule<\/span><\/li>\r\n<li class=\"MsoNormal\" style=\"color: #495057; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1;\"><span style=\"font-size: 11.5pt; font-family: 'Segoe UI',sans-serif; mso-fareast-language: EN-ZA;\">Managing Project Resources: Allocating tasks, durations, costs, and identifying overallocated resources<\/span><\/li>\r\n<li class=\"MsoNormal\" style=\"color: #495057; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1;\"><span style=\"font-size: 11.5pt; font-family: 'Segoe UI',sans-serif; mso-fareast-language: EN-ZA;\">External Dependencies and Deadlines: Adding calendars, deadlines and contingency tasks<\/span><\/li>\r\n<li class=\"MsoNormal\" style=\"color: #495057; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1;\"><span style=\"font-size: 11.5pt; font-family: 'Segoe UI',sans-serif; mso-fareast-language: EN-ZA;\">Communicating the Plan: Formatting the interface, using reports and timelines<\/span><\/li>\r\n<li class=\"MsoNormal\" style=\"color: #495057; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1;\"><span style=\"font-size: 11.5pt; font-family: 'Segoe UI',sans-serif; mso-fareast-language: EN-ZA;\">Updating and Replanning: Use baselines, rescheduling the project plans and updating progress<\/span><\/li>\r\n<li class=\"MsoNormal\" style=\"color: #495057; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1;\"><span style=\"font-size: 11.5pt; font-family: 'Segoe UI',sans-serif; mso-fareast-language: EN-ZA;\">Closing the project: Close tasks and milestones, compare different project plan versions, and saving templates<\/span><\/li>\r\n<\/ul>","image":"Project-icon.png","meta_desc":"microsoft project training course by IT company in Johannesburg South Africa.\r\nPlan,track and manage your projects and communicate with your team members using Ms project","keywords":"microsoft project training\r\nmicrosoft project course\r\nmicrosoft project classes\r\nshort courses in Ms project 2007\r\nproject plan","filename":"ms_project_","old_slug":null,"name":"Microsoft Project","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"Project","bookstock":1,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2017-05-30 11:26:47","accountmanagerid":175,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":38,"internal_comments":null,"created_at":null,"updated_at":"2024-03-11T09:17:52.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":290,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2023-06-20T13:42:46.000000Z","duration":2,"duration_units":"Days","cost":"5500.00","minimum_delegates":null,"moodle_course_id":38}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":290,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2023-06-20T13:42:46.000000Z","duration":2,"duration_units":"Days","cost":"4500.00","minimum_delegates":null,"moodle_course_id":38}}]}&dates=22nd Aug 2024 09:00 - 23rd Aug 2024 16:00){kind=link}
![Enquire](/enquiry?subject={"id":286,"certificate_template_id":1,"title":"Excel Basic course - virtual Instructor-led Midrand, Sandton, Johannesburg, South Africa","description":"<p>You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format.<\/p>\n<p> <\/p>","audience":"<p>This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel worksheets.<\/p>","prerequisites":"<p>Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.<\/p>","about":"You will create and edit basic Microsoft Office Excel Worksheets and\r\nWorkbooks.","durationunits":"Day","outline":"<ul>\r\n<li>Lesson 1: Getting Started with Microsoft Excel<br \/>\r\n<ul>\r\n<li>Navigate the Excel User Interface<\/li>\r\n<li>Use Excel Commands<\/li>\r\n<li>Creating and Save a Basic Workbook<\/li>\r\n<li>Enter Cell Data<\/li>\r\n<li>Use Excel Help<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 2: Performing Calculations\r\n<ul>\r\n<li>Creating Formulas in a Worksheet<\/li>\r\n<li>Insert Functions in a Worksheet<\/li>\r\n<li>Reuse Formula<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 3: Modifying a Worksheet\r\n<ul>\r\n<li>Manipulate Data<\/li>\r\n<li>Insert, Manipulate, and Delete Cells, Columns, and Rows<\/li>\r\n<li>Search for and Replace Data<\/li>\r\n<li>Use Proofing and Research Tools<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 4: Formatting a Worksheet<br \/>\r\n<ul>\r\n<li>Modify Fonts<\/li>\r\n<li>Add Borders and Color to Cells<\/li>\r\n<li>Apply Number Formats<\/li>\r\n<li>Align Cell Contents<\/li>\r\n<li>Apply Cell Styles and Themes<\/li>\r\n<li>Apply Basic conditional formatting<\/li>\r\n<li>Create and Use Templates<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 5: Printing Workbook Contents<br \/>\r\n<ul>\r\n<li>Preview and Print a Workbook <\/li>\r\n<li>Define the Page Layout<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 6: Managing Large Workbooks<br \/>\r\n<ul>\r\n<li>Manage Worksheets<\/li>\r\n<li>Manage the View of Worksheets and Workbooks<\/li>\r\n<li>Manage Workbook Properties <\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","image":"Excel_2013_logo.png","meta_desc":"Microsoft Office Excel Fundamentals course online virtual instructor-led training Johannesburg South Africa","keywords":"excel basic training in Joburg\r\nbasic excel course\r\nexcel basic training excel fundamental training course\r\nmicrosoft excel bas","filename":"excel_fundamentals","old_slug":null,"name":"Microsoft Excel Fundamentals","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"ExcelFundamental","bookstock":0,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2021-03-18 11:52:43","accountmanagerid":175,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":1,"youtube_video_intro":null,"moodle_course_id":8,"internal_comments":null,"created_at":null,"updated_at":"2023-12-07T12:43:06.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":286,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2023-06-21T14:57:33.000000Z","duration":1,"duration_units":"Day","cost":"2750.00","minimum_delegates":null,"moodle_course_id":8}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":286,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2023-06-21T14:57:33.000000Z","duration":1,"duration_units":"Day","cost":"2250.00","minimum_delegates":null,"moodle_course_id":8}}]}&dates=2nd Sep 2024 09:00 - 16:00){kind=link}
![Enquire](/enquiry?subject={"id":377,"certificate_template_id":1,"title":"Laravel: Introduction Training Course","description":"<p>This course will give you all the essentials you need to know to get up and running with Laravel. You will learn how to download and install Laravel, how to use Composer to install PHP classes, how to use Artisan (the Laravel command line tool), how to work with Routes, Views, Blade templates, Controllers and Models. It will also show you how to work with Eloquent, the Laravel ORM used to perform SQL queries on Laravel Models.<\/p>","audience":"<p>PHP developers looking for a MVC framework to speed up their development<\/p>","prerequisites":"<p>A good understanding of PHP and classes<\/p>","about":"<p>Laravel is a PHP framework for rapid development. It uses the MVC (Model View Controller) design pattern to separates the web application into three different components. This course provides a great Laravel tutorial for beginners.<\/p>","durationunits":"days","outline":"<ol>\r\n<li>\r\n<h3>What is Laravel?<\/h3>\r\n<ol>\r\n<li>Notable Features<\/li>\r\n<li>Documentation<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Downloading and Installing<\/h3>\r\n<ol>\r\n<li>Pre-requisites<\/li>\r\n<li>Windows Development Environment<\/li>\r\n<li>Code Editor<\/li>\r\n<li>Composer\r\n<ol>\r\n<li>Running Composer<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>Installing Laravel Globally<\/li>\r\n<li>Creating a new Laravel Project<\/li>\r\n<li>Running your project<\/li>\r\n<li>Viewing your project files<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Using Composer<\/h3>\r\n<ol>\r\n<li>Getting a list of Composer commands<\/li>\r\n<li>Viewing Installed Packages<\/li>\r\n<li>Getting help in Composer<\/li>\r\n<li>Searching for packages<\/li>\r\n<li>Installing packages<\/li>\r\n<li>Removing packages<\/li>\r\n<li>Updating packages<\/li>\r\n<li>Installing packages from composer.json<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Artisan<\/h3>\r\n<ol>\r\n<li>Listing commands<\/li>\r\n<li>Show a list of routes<\/li>\r\n<li>Tinker<\/li>\r\n<li>Creating Controllers\r\n<ol>\r\n<li>Empty Controller<\/li>\r\n<li>Resource Controller<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>Creating Models\r\n<ol>\r\n<li>Empty Model<\/li>\r\n<li>Empty Model and Migration<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>Creating Migrations<\/li>\r\n<li>Migration to create a table<\/li>\r\n<li>Migration to update a table<\/li>\r\n<li>Executing Migrations\r\n<ol>\r\n<li>Run all<\/li>\r\n<li>Rollback last<\/li>\r\n<li>Reset all<\/li>\r\n<\/ol>\r\n<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Routing<\/h3>\r\n<ol>\r\n<li>Defining a route<\/li>\r\n<li>Route with a closure<\/li>\r\n<li>Route using a controller method<\/li>\r\n<li>Route Parameters<\/li>\r\n<li>Optional Route Parameters<\/li>\r\n<li>Regular Expression Constraints<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>REST<\/h3>\r\n<ol>\r\n<li>REST example<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Views<\/h3>\r\n<ol>\r\n<li>Loading a View<\/li>\r\n<li>Example<\/li>\r\n<li>Passing variables to a view<\/li>\r\n<li>Passing variables using the with method<\/li>\r\n<li>Passing variables using compact<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Blade Templates<\/h3>\r\n<ol>\r\n<li>Template Inheritance<\/li>\r\n<li>Example master layout<\/li>\r\n<li>Example child layout<\/li>\r\n<li>Including other views<\/li>\r\n<li>Displaying Data<\/li>\r\n<li>Displaying unescaped data<\/li>\r\n<li>Displaying a variable if it exists<\/li>\r\n<li>If Statements<\/li>\r\n<li>Foreach Loops<\/li>\r\n<li>$loop variable<\/li>\r\n<li>Comments<\/li>\r\n<li>Embedding PHP<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Controllers<\/h3>\r\n<ol>\r\n<li>Creating a Controller<\/li>\r\n<li>Dependency Injection<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Migrations<\/h3>\r\n<ol>\r\n<li>Default Migrations<\/li>\r\n<li>Migration Structure<\/li>\r\n<li>create_users_table migration<\/li>\r\n<li>Creating a Table<\/li>\r\n<li>Common Column Types<\/li>\r\n<li>Column Modifiers<\/li>\r\n<li>Creating Indexes<\/li>\r\n<li>Foreign Keys<\/li>\r\n<li>Creating a Database<\/li>\r\n<li>Configuring the Database<\/li>\r\n<li>Running the Migrations<\/li>\r\n<li>Result of the Migration<\/li>\r\n<li>Creating a Migration<\/li>\r\n<li>Edit the Migration File<\/li>\r\n<li>Run the migration<\/li>\r\n<li>Create an update migration<\/li>\r\n<li>Edit the Migration File<\/li>\r\n<li>Run the migration<\/li>\r\n<li>Rolling back a migration<\/li>\r\n<li>Resetting all migrations<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Eloquent<\/h3>\r\n<ol>\r\n<li>Creating a model<\/li>\r\n<li>Model structure<\/li>\r\n<li>Setting the table name<\/li>\r\n<li>Setting the primary key<\/li>\r\n<li>Timestamps<\/li>\r\n<li>Mass Assignment\r\n<ol>\r\n<li>Black listing fields<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>Inserting a new record<\/li>\r\n<li>Inserting using mass-assignment<\/li>\r\n<li>Retrieving All Records<\/li>\r\n<li>Retrieve a record by id<\/li>\r\n<li>Add a where clause<\/li>\r\n<li>Alternative comparison operators<\/li>\r\n<li>A where with an and<\/li>\r\n<li>A where with an or<\/li>\r\n<li>Where between<\/li>\r\n<li>Where in<\/li>\r\n<li>Where is null<\/li>\r\n<li>Sorting results<\/li>\r\n<li>Updating an existing Record<\/li>\r\n<li>Updating using mass-assignment<\/li>\r\n<li>Deleting a record<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Practical Exercise<\/h3>\r\n<ol>\r\n<li>Creating the Controller<\/li>\r\n<li>Setting up the routes<\/li>\r\n<li>Create a contacts table<\/li>\r\n<li>Create a Contact model<\/li>\r\n<li>Setup a master template<\/li>\r\n<li>Edit the Contact Controller<\/li>\r\n<li>Run your code<\/li>\r\n<li>Edit the index view<\/li>\r\n<li>Edit the Contact Controller<\/li>\r\n<li>Editing a Contact<\/li>\r\n<li>Create the Edit Form<\/li>\r\n<li>Edit the Contact Controller<\/li>\r\n<li>Deleting a Contact<\/li>\r\n<li>Edit the Contact Controller<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Conclusion<\/h3>\r\n<\/li>\r\n<\/ol>","image":"download (7)1713185812.jpg","meta_desc":"Laravel is a PHP framework for rapid development. This 2 day training course provides a good introduction to Laravel.","keywords":"Laravel training course, laravel introduction, laravel basics, laravel tutorial","filename":"laravel_intro","old_slug":null,"name":"Laravel Introduction","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"LaravelIntro","bookstock":0,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2017-04-20 11:11:29","accountmanagerid":135,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":null,"internal_comments":null,"created_at":null,"updated_at":"2024-04-15T12:56:52.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":377,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2021-09-01T12:52:14.000000Z","duration":2,"duration_units":"days","cost":"5500.00","minimum_delegates":null,"moodle_course_id":null}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":377,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2021-09-01T12:52:14.000000Z","duration":2,"duration_units":"days","cost":"4500.00","minimum_delegates":null,"moodle_course_id":null}}]}&dates=2nd Sep 2024 09:00 - 3rd Sep 2024 16:00){kind=link}
![Enquire](/enquiry?subject={"id":379,"certificate_template_id":1,"title":"Laravel Bootcamp","description":null,"audience":"<p>PHP developers wishing to learn the Laravel framework<\/p>","prerequisites":"<p>Good knowledge of PHP.<\/p>","about":"<p>Includes an introduction to the Laravel PHP framework as well as more intermediate topics.<\/p>","durationunits":"days","outline":"<ul>\r\n<li>Introduction to Laravel<\/li>\r\n<li>Intermediate Laravel<\/li>\r\n<li>Build an API with Laravel<\/li>\r\n<\/ul>","image":"images1713185692.png","meta_desc":"Includes an introduction to the Laravel PHP framework as well as more intermediate topics.","keywords":null,"filename":"Laravel_bootcamp","old_slug":null,"name":"Laravel Bootcamp","status":1,"type":1,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"Laravel Bootcamp","bookstock":null,"onorder":null,"expectedorderdate":null,"stock_last_updated":null,"accountmanagerid":null,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":null,"internal_comments":null,"created_at":null,"updated_at":"2024-04-15T12:54:52.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":379,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2020-04-02T09:44:34.000000Z","duration":4,"duration_units":"days","cost":"11000.00","minimum_delegates":null,"moodle_course_id":null}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":379,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2020-04-06T12:02:49.000000Z","duration":4,"duration_units":"days","cost":"9000.00","minimum_delegates":null,"moodle_course_id":null}}]}&dates=2nd Sep 2024 09:00 - 5th Sep 2024 16:00){kind=link}
![Enquire](/enquiry?subject={"id":287,"certificate_template_id":1,"title":"Excel Intermediate course - Joburg, Pretoria South Africa-Midrand, Sandton, Johannesburg, South Africa","description":"<p>This course is designed for students who already have foundation knowledge and skills in Microsoft Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.<\/p>\r\n<p> <\/p>","audience":"<p>The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web<\/p>","prerequisites":"<p>Microsoft Office Excel Fundamentals<\/p>","about":"<p>You will apply visual elements and advanced formulas to a worksheet to display data in various formats.<\/p>","durationunits":"Day","outline":"<p>Lesson 1: Working with Functions<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Work with Ranges<\/li>\r\n<li>Use Specialized Functions<\/li>\r\n<li>Work with Logical Functions<\/li>\r\n<li>Work with Date & Time Functions<\/li>\r\n<li>Work with Text Functions<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 2: Working with Lists<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Sort Data<\/li>\r\n<li>Filter Data<\/li>\r\n<li>Query Data with Database Functions<\/li>\r\n<li>Outline and Subtotal Data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 3: Analyzing Data<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Create and Modify Tables<\/li>\r\n<li>Apply Intermediate Conditional Formatting<\/li>\r\n<li>Apply Advanced Conditional Formatting<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 4: Visualizing Data with Charts <\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Create Charts<\/li>\r\n<li>Modify and Format Charts<\/li>\r\n<li>Use Advanced Chart Features<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 5: Using PivotTables and PivotCharts <\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Create a PivotTable<\/li>\r\n<li>Analyze PivotTable Data<\/li>\r\n<li>Present Data with PivotCharts<\/li>\r\n<li>Filter Data by Using Timelines and Slicers<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","image":"istockphoto-1582498355-612x6121713170948.jpg","meta_desc":"Microsoft Office intermediate excel provided by IT company in Johannesburg and Pretoria, South Africa, online virtual instructor-led training","keywords":"excel training course\r\nexcel training courses\r\nMicrosoft Excel intermediate\r\npivot table Excel training\r\nExcel logical function","filename":"excel_intermediate","old_slug":null,"name":"Microsoft Excel: Intermediate","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"Excel Int","bookstock":11,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2020-03-09 13:51:33","accountmanagerid":null,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":3,"youtube_video_intro":null,"moodle_course_id":123,"internal_comments":null,"created_at":null,"updated_at":"2024-04-15T08:49:08.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":287,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2024-03-11T10:05:52.000000Z","duration":1,"duration_units":"Day","cost":"2750.00","minimum_delegates":null,"moodle_course_id":123}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":287,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2024-03-11T10:05:52.000000Z","duration":1,"duration_units":"Day","cost":"2250.00","minimum_delegates":null,"moodle_course_id":123}}]}&dates=3rd Sep 2024 09:00 - 16:00){kind=link}
![Enquire](/enquiry?subject={"id":288,"certificate_template_id":1,"title":"Excel Advanced course - Joburg, Pretoria South Africa - Midrand, Sandton, Johannesburg, South Africa","description":"<p>In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.<\/p>","audience":"<p>This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data.<\/p>","prerequisites":"<p>To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft Office Excel Basic and Microsoft Office Excel Intermediate<\/p>","about":"You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.","durationunits":"Day","outline":"<p>Lesson 1:Working with Multiple Worksheets and Workbooks<strong><br \/><\/strong><\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Use Links and External References<\/li>\r\n<li>Use 3-D References<\/li>\r\n<li>Consolidate Data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 2: Using Lookup Functions and Formula Auditing<strong><br \/><\/strong><\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Use Lookup Functions<\/li>\r\n<li>Trace Cells<\/li>\r\n<li>Watch and Evaluate Formulas<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 3: Sharing and Protecting Workbooks<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Collaborate on a Workbook<\/li>\r\n<li>Protect Worksheets and Workbooks<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 4: Automating Workbook Functionality<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Apply Data Validation<\/li>\r\n<li>Search for Invalid Data and Formulas with Errors<\/li>\r\n<li>Work with Macros<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 5: Creating Sparklines and Mapping Data<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Create Sparklines<\/li>\r\n<li>Map Data<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p>Lesson 6: Forecasting Data<\/p>\r\n<ul>\r\n<li style=\"list-style-type: none;\">\r\n<ul>\r\n<li>Determine Potential Outcomes Using Data Tables<\/li>\r\n<li>Determine Potential Outcomes Using Scenarios<\/li>\r\n<li>Use the Goal Seek Feature<\/li>\r\n<li>Forecasting Data Trends<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","image":"Excel_2013_logo.png","meta_desc":"In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.","keywords":"Excel advanced course in Johannesburg\r\nexcel advanced training South Africa,\r\nMicrosoft Excel Advanced Training\r\nExcel Advanced","filename":"excel_advanced_","old_slug":null,"name":"Microsoft Excel: Advanced","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"Excel Advanced","bookstock":26,"onorder":7,"expectedorderdate":null,"stock_last_updated":"2017-11-28 08:18:04","accountmanagerid":175,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":66,"internal_comments":null,"created_at":null,"updated_at":"2024-03-11T09:17:52.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":288,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2023-10-09T07:45:43.000000Z","duration":1,"duration_units":"Day","cost":"2750.00","minimum_delegates":null,"moodle_course_id":66}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":288,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2023-10-09T07:45:43.000000Z","duration":1,"duration_units":"Day","cost":"2250.00","minimum_delegates":null,"moodle_course_id":66}}]}&dates=4th Sep 2024 09:00 - 16:00){kind=link}
![Enquire](/enquiry?subject={"id":378,"certificate_template_id":1,"title":"Laravel: Intermediate Training Course","description":"<p>This course will build onto what was covered on the Laravel Introduction course. We will cover error handling, Working with middleware, CSFR protection, Sessions, Validation, Localization, Pagination, Seeding, Accessors and Mutators, Working with email and Eloquent Relationships.<\/p>","audience":"<p>PHP developers with basic Laravel experience.<\/p>","prerequisites":"<p>A good knowledge of PHP, Laravel Introduction course.<\/p>","about":"<p>Laravel is a PHP framework for rapid development. It uses the MVC (Model View Controller) design pattern to separates the web application into three different components.<\/p>","durationunits":"days","outline":"<ol>\r\n<li>\r\n<h3>Introduction<\/h3>\r\n<\/li>\r\n<li>\r\n<h3>Route Model Binding<\/h3>\r\n<\/li>\r\n<li>\r\n<h3>Working with Middleware<\/h3>\r\n<ol>\r\n<li>Global Middleware<\/li>\r\n<li>Route Group Middleware<\/li>\r\n<li>Route Middleware\r\n<ol>\r\n<li>Assignment<\/li>\r\n<\/ol>\r\n<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Authentication<\/h3>\r\n<ol>\r\n<li>Generating authentication scaffolding<\/li>\r\n<li>Adding Bootstrap<\/li>\r\n<li>How the authentication scaffold works<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Validation<\/h3>\r\n<ol>\r\n<li>Displaying error messages<\/li>\r\n<li>Customizing the error messages<\/li>\r\n<li>Creating a Form Request<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Handling errors<\/h3>\r\n<ol>\r\n<li>HTTP Exceptions<\/li>\r\n<li>Catching Exceptions<\/li>\r\n<li>The Exception Handler<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>CSRF protection<\/h3>\r\n<\/li>\r\n<li>\r\n<h3>Seeding<\/h3>\r\n<ol>\r\n<li>Model Factories<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Pagination<\/h3>\r\n<ol>\r\n<li>Passing additional parameters<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Sessions<\/h3>\r\n<ol>\r\n<li>The global session helper<\/li>\r\n<li>Setting session variables<\/li>\r\n<li>Retrieving session variables<\/li>\r\n<li>Retrieving all session data<\/li>\r\n<li>Testing if a session variable exists<\/li>\r\n<li>Deleting a session variable<\/li>\r\n<li>Practical example<\/li>\r\n<li>Flashing data to the session<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Accessors<\/h3>\r\n<ol>\r\n<li>Accessors for existing attributes<\/li>\r\n<li>Accessors for non-existent attributes<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Mutators<\/h3>\r\n<\/li>\r\n<li>\r\n<h3>Query Scopes<\/h3>\r\n<\/li>\r\n<li>\r\n<h3>Localization<\/h3>\r\n<\/li>\r\n<li>\r\n<h3>Working with email<\/h3>\r\n<ol>\r\n<li>Mailables<\/li>\r\n<li>Sending an email<\/li>\r\n<li>Passing data to a mailable<\/li>\r\n<li>Writing Markdown Messages<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>\r\n<h3>Contact Updated<\/h3>\r\n<\/li>\r\n<li>\r\n<h3>Eloquent Relationships<\/h3>\r\n<ol>\r\n<li>One to Many\r\n<ol>\r\n<li>Defining the inverse relationship<\/li>\r\n<\/ol>\r\n<\/li>\r\n<li>Many to Many\r\n<ol>\r\n<li>Adding records to the bridging table<\/li>\r\n<li>Deleting records from the bridging table<\/li>\r\n<\/ol>\r\n<\/li>\r\n<\/ol>\r\n<\/li>\r\n<\/ol>","image":"download (6)1713185753.jpg","meta_desc":"Laravel is a PHP framework for rapid development.","keywords":"Laravel intermediate","filename":"laravel_intermediate","old_slug":null,"name":"Laravel Intermediate","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"LaravelInter","bookstock":0,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2017-03-02 09:35:04","accountmanagerid":135,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":null,"internal_comments":null,"created_at":null,"updated_at":"2024-04-15T12:55:53.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":378,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2021-09-01T13:14:56.000000Z","duration":2,"duration_units":"days","cost":"5500.00","minimum_delegates":null,"moodle_course_id":null}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":378,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2021-09-01T13:14:56.000000Z","duration":2,"duration_units":"days","cost":"4500.00","minimum_delegates":null,"moodle_course_id":null}}]}&dates=4th Sep 2024 09:00 - 5th Sep 2024 16:00){kind=link}
![Enquire](/enquiry?subject={"id":340,"certificate_template_id":1,"title":"Adobe Illustrator CC Training Course Sandton Midrand","description":"<p>This introductory course will illuminate the powerful vector tool that is Illustrator. It is more than applicable to first-time users and will provide a helpful foundation for more advanced designs.<\/p>","audience":"<p>Desktop publishers, graphic designers and aspiring digital artists.<\/p>","prerequisites":"<p>Basic computer literacy.<\/p>","about":"Adobe Illustrator is the industry standard vector graphics design tool, useful for corporate identity creation, including company logos and marketing\/advertising artwork.","durationunits":"Days","outline":"<p><strong>Getting to know the Workspace<\/strong><\/p>\r\n<p>• Choosing a workspace<\/p>\r\n<p>• Opening a file<\/p>\r\n<p>• The document window<\/p>\r\n<p>• Using Artboards<\/p>\r\n<p>• Navigating multiple artboards<\/p>\r\n<p>• Using the new Artboards panel<\/p>\r\n<p>• Creating New Artboards<\/p>\r\n<p>• Switching screen modes<\/p>\r\n<p>• Changing your view<\/p>\r\n<p>• Preview versus Outlines<\/p>\r\n<p>• Zooming and scrolling<\/p>\r\n<p>• Scrolling with the Hand tool<\/p>\r\n<p>• Changing views with the Navigator panel<\/p>\r\n<p>• The Tools panel<\/p>\r\n<p>• Using tools and panels<\/p>\r\n<p>• The Control panel<\/p>\r\n<p>• Moving the Control panel<\/p>\r\n<p>• Panel groups and the dock<\/p>\r\n<p>• Custom workspaces<\/p>\r\n<p>• Saving workspaces<\/p>\r\n<p>• Using the Manage Workspaces dialog box<\/p>\r\n<p><strong>Illustrator Essentials<\/strong><\/p>\r\n<p>• Using the shape tools<\/p>\r\n<p>• Repositioning and visually resizing the rectangle<\/p>\r\n<p>• Finding or changing the shape’s dimensions using the Transform panel<\/p>\r\n<p>• Rotating and shearing using the Transform panel<\/p>\r\n<p>• Constraining a shape<\/p>\r\n<p>• Entering exact dimensions<\/p>\r\n<p>• Selecting artwork<\/p>\r\n<p>• Helpful keyboard shortcuts for selections<\/p>\r\n<p>• The selection tools<\/p>\r\n<p>• Using shape and transform tools to create artwork<\/p>\r\n<p>• Using the transform tools<\/p>\r\n<p>• Adding a fill color<\/p>\r\n<p>• Viewing in Outline view<\/p>\r\n<p>• Using layers when building an illustration<\/p>\r\n<p>• Creating a new blank layer<\/p>\r\n<p>• Cutting and pasting objects<\/p>\r\n<p>• Moving objects from one layer to another<\/p>\r\n<p><strong>Adding Color<\/strong><\/p>\r\n<p>• Basics of the Appearance panel<\/p>\r\n<p>• Changing colors<\/p>\r\n<p>• Adding Effects<\/p>\r\n<p>• Creating a colorful illustration<\/p>\r\n<p>• Using Live Paint<\/p>\r\n<p>• Adding a symbol to your artwork<\/p>\r\n<p>• Expanding the symbol<\/p>\r\n<p>• Saving swatches<\/p>\r\n<p>• What is a Global Color?<\/p>\r\n<p>• Selecting the Same color<\/p>\r\n<p>• Saving a set of colors as a group<\/p>\r\n<p>• Creating a color group from selected colors<\/p>\r\n<p>• Using the Color panel<\/p>\r\n<p>• Adding Pantone colors<\/p>\r\n<p><strong>Working with the Drawing Tools<\/strong><\/p>\r\n<p>• Working with the Pen tool<\/p>\r\n<p>• Drawing straight lines<\/p>\r\n<p>• Drawing curved lines<\/p>\r\n<p>• Drawing hinged curves<\/p>\r\n<p>• Drawing curved lines to straight lines<\/p>\r\n<p>• Drawing straight lines to curved lines<\/p>\r\n<p>• Shape Tools<\/p>\r\n<p>• Using the Eraser tool<\/p>\r\n<p>• Editing existing paths<\/p>\r\n<p>• Adding and removing points<\/p>\r\n<p>• Cutting and joining paths<\/p>\r\n<p>• Working with Live Trace<\/p>\r\n<p>• Expanding Live Traced artwork<\/p>\r\n<p>• Working with Live Paint<\/p>\r\n<p>• Combining shapes using the new Shape Builder tool<\/p>\r\n<p>• Subtracting with the Shape Builder tool<\/p>\r\n<p><strong>Working with Text<\/strong><\/p>\r\n<p>• Formatting type<\/p>\r\n<p>• Paragraph formatting<\/p>\r\n<p>• Formatting imported type<\/p>\r\n<p>• Paragraph and character styles<\/p>\r\n<p>• Text on a path<\/p>\r\n<p>• Warping text<\/p>\r\n<p>• Text in a shape<\/p>\r\n<p>• Creating outlines<\/p>\r\n<p>• Check spelling<\/p>\r\n<p>• Find and Replace<\/p>\r\n<p><strong>Working with Symbols<\/strong><\/p>\r\n<p>• Cleaning out the symbol library<\/p>\r\n<p>• Creating symbols<\/p>\r\n<p>• Editing symbols<\/p>\r\n<p>• Importing a symbol library<\/p>\r\n<p>• Using the symbol sprayer tools<\/p>\r\n<p>• Editing nested symbols<\/p>\r\n<p>• Replacing symbols <\/p>\r\n<p><strong>Saving and Exporting<\/strong><\/p>\r\n<p>• Saving using the AI file format<\/p>\r\n<p>• Saving an illustration with layers<\/p>\r\n<p>• Saving a layered PDF<\/p>\r\n<p>• Integration with other applications<\/p>\r\n<p>• Saving as EPS<\/p>\r\n<p>• Save for Web<\/p>\r\n<p><strong>Whats New<\/strong><\/p>\r\n<p>• Getting into perspective<\/p>\r\n<p>• Defining the grid<\/p>\r\n<p>• Changing the plane<\/p>\r\n<p>• Using the Perspective Selection tool<\/p>\r\n<p>• Creating shapes with the<\/p>\r\n<p>• Shape Builder tool<\/p>\r\n<p>• To combine shapes<\/p>\r\n<p>• To delete shapes<\/p>\r\n<p>• To divide overlapping shapes<\/p>\r\n<p>• New Brush Controls<\/p>\r\n<p>• Advanced drawing controls<\/p>\r\n<p>• Artboard panel<\/p>\r\n<p>• Touch Type Tool<\/p>\r\n<p>• Images in Brushes<\/p>\r\n<p>• Font Search<\/p>\r\n<p>• Font Sync<\/p>\r\n<p>• Multiple-file place<\/p>\r\n<p>• CSS Extraction<\/p>\r\n<p>• Colour Sync<\/p>\r\n<p>• Area and Point Type Converion<\/p>\r\n<p>• File packaging<\/p>\r\n<p>• On-art free transform<\/p>\r\n<p> <\/p>","image":"illustrator.png","meta_desc":"Short practical Adobe Illustrator CC Training Course Sandton Midrand South Africa by an Adobe Certified Expert","keywords":"Adobe Illustrator, short course, courses in south africa, courses in johannesburg\r\nVector Graphic Design\r\nDesign training","filename":"illustrator_basic-intermediate","old_slug":null,"name":"Illustrator Basic-Intermediate","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"Illustrator Bas","bookstock":18,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2017-11-28 08:14:04","accountmanagerid":null,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":null,"internal_comments":null,"created_at":null,"updated_at":"2024-03-11T09:17:52.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":340,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2020-04-02T09:44:34.000000Z","duration":3,"duration_units":"Days","cost":"8250.00","minimum_delegates":null,"moodle_course_id":null}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":340,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2020-04-06T12:02:49.000000Z","duration":3,"duration_units":"Days","cost":"6750.00","minimum_delegates":null,"moodle_course_id":null}}]}&dates=9th Sep 2024 09:00 - 11th Sep 2024 16:00){kind=link}