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 25 November 2024 | 5 Days | Accredited Business Leadership | Provisional | Enquire |
| Monday 25 November 2024 | 1 Day | Microsoft Excel Fundamentals | Provisional | Enquire |
| Monday 25 November 2024 | 3 Days | InDesign Basic-Intermediate | Provisional | Enquire |
| Monday 25 November 2024 | 2 Days | Leadership Essentials SAQA US120300 | Scheduled | Book Live Virtual Training |
| Tuesday 26 November 2024 | 1 Day | Microsoft Excel: Intermediate | Provisional | Enquire |
| Wednesday 27 November 2024 | 1 Day | Microsoft Excel: Advanced | Provisional | Enquire |
| Thursday 28 November 2024 | 2 Days | Customer Centric Employee | Provisional | Enquire |
| Monday 2 December 2024 | 3 Days | SQL | Provisional | Enquire |
| Monday 2 December 2024 | 3 Days | Illustrator Basic-Intermediate | Provisional | Enquire |
| Monday 2 December 2024 | 3 Days | Microsoft Power BI Boot Camp | Provisional | Enquire |
| Monday 2 December 2024 | 2 Days | Change Management SAQA US252021 | Scheduled | Book Live Virtual Training |
| Thursday 5 December 2024 | 2 Days | Advanced SQL | Provisional | Enquire |
| Monday 9 December 2024 | 2 Days | Critical Thinking | Provisional | Enquire |
| Tuesday 10 December 2024 | 1 Day | Python Statistics | Scheduled | Book Live Virtual Training |
| Wednesday 11 December 2024 | 3 Days | Business and Report Writing | Provisional | Enquire |
| Wednesday 11 December 2024 | 2 Days | Business Writing that Works | Provisional | Enquire |
| Friday 13 December 2024 | 1 Day | Writing Reports and Proposals | Provisional | Enquire |
| Monday 10 March 2025 | 2 Days | Python Statistical Modelling | Scheduled | Book Live Virtual Training |
| Monday 7 April 2025 | 4 Days | Python Regression | Scheduled | Book Live Virtual Training |
![Enquire](/enquiry?subject={"id":167,"certificate_template_id":1,"title":"Accredited Business Leadership training course bundle","description":"<p dir=\"ltr\" style=\"text-align: left;\">The first topic focuses on leadership - both its theories and in practice and is aligned to cover the specific outcomes of unit standard 120300 - Analyse leadership and related theories in a work context. The second topic moves on to effective management skills - through building teams, delegation and effective performace monitoring against set goals and objectives. This course meets the specific outcomes of two unit standards - 252037 - Build teams to achieve goals and objectives, and 15224 - Empower team members through recognising strengths, encouraging participation in decision making and delegating tasks. <\/p>\r\n<p class=\"western\" style=\"margin-bottom: 0.28cm; line-height: 108%;\"> <\/p>\r\n<p dir=\"ltr\" style=\"text-align: left;\"> <\/p>","audience":"<p>This would suit any person in management or leadership who needs a formal management qualification. The course blends leadership best-practice and current methodology and is taught by experienced and effective managers.<\/p>","prerequisites":"<p>Communication skills at NF level 4 is a pre-requisite for enrolment on this course.<\/p>\r\n<p>Some experience in leading people or teams in an organisation, is preferable.<\/p>\r\n<p>We work on an LMS to manage course content and assessments and so having your own laptop or computer, access to the internet and basic computer and word processing skills are essential.<\/p>","about":"<p>This Accredited Leadership bundle course comprises 2 courses: Topic 1 is Leadership Essentials and Topic 2 is The Professional Manager. Together they form Module 2 - Leadership, in the Generic Management Level 5 qualification ID 59201, Learning Programme 60269. The total duration is 5 days of training. This can be done as a webinar or as a classroom-based course, and assessments are included. The total credit value is 18 credits towards the Generic Management qualification.<\/p>","durationunits":"Day","outline":"<p>See each individual course's outlines<\/p>","image":"pexels-karolina-grabowska-85288521705391216.jpg","meta_desc":"Accredited Business Leadership training course bundle. This bundle course is Module 2 of Generic Management Level 5 qualification ID 59201 Learning Programme 60269.","keywords":"Accredited Business leadership, Management training, Leadership Course, Management Course, Accredited leadership training short","filename":"Accred_Business_Leadership","old_slug":null,"name":"Accredited Business Leadership","status":1,"type":1,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"GenManMod2BusLea","bookstock":0,"onorder":3,"expectedorderdate":null,"stock_last_updated":"2016-10-26 09:48:49","accountmanagerid":null,"supersededby":null,"softskills":"Y","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":130,"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":167,"delivery_method_id":1,"created_at":"2020-03-31T11:06:13.000000Z","updated_at":"2024-01-16T07:46:58.000000Z","duration":5,"duration_units":"Day","cost":"13750.00","minimum_delegates":null,"moodle_course_id":130}},{"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":167,"delivery_method_id":5,"created_at":"2020-04-06T12:02:48.000000Z","updated_at":"2024-01-16T07:46:58.000000Z","duration":5,"duration_units":"Day","cost":"11250.00","minimum_delegates":null,"moodle_course_id":130}}]}&dates=25th Nov 2024 09:00 - 29th Nov 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=25th Nov 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=26th Nov 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=27th Nov 2024 09:00 - 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=2nd Dec 2024 09:00 - 4th Dec 2024 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=5th Dec 2024 09:00 - 6th Dec 2024 16:00){kind=link}
![Enquire](/enquiry?subject={"id":144,"certificate_template_id":1,"title":"Business and Report Writing-Midrand, Sandton, Johannesburg, South Africa","description":"<ul>\r\n<li>To write for a specific audience with a defined purpose<\/li>\r\n<li>To use language structures and features<\/li>\r\n<li>To draft writing and edit using a variety of tools for clarity and effectiveness<\/li>\r\n<li>Identify personal areas for improvement.<\/li>\r\n<\/ul>\r\n<p>Practical elements to be done on a computer using a word processor of your choice.<\/p>\r\n<p>Please bring your own laptop if you have one.<\/p>","audience":"<p>Everyone in business who needs to communicate through media with others.<\/p>","prerequisites":"<p>MS Word or PC-based document formatting experience. This course requires the use of a computer. Kindly inform your sales representative if you are not able to bring a laptop as a computer can be hired for you at an additional cost.<\/p>","about":"<p>This course is a bundle of business Writing that works and Writing Reports and Proposals. By taking the bundle you are investing in both your writing skills and your understanding of report formats. The course covers style, grammar, formats and other key concerns for the average business person.<\/p>","durationunits":"Days","outline":"<ul>\r\n<li>Preparing to communicate<\/li>\r\n<li>The process of writing<\/li>\r\n<li>Language and Structure<\/li>\r\n<li>Active and Passive voice usage<\/li>\r\n<li>Up to date styles of writing<\/li>\r\n<li>Business documents and their preparation<\/li>\r\n<li>Emails, business letters, and SMS's<\/li>\r\n<li>Evaluating your writing<\/li>\r\n<\/ul>","image":"pexels-alex-green-56994561712578392.jpg","meta_desc":"This is designed to help people to compose all written documentation in the current business environment and includes writing reports for many different aspects of business.","keywords":"Business and Report Writing Training Course Business Short course English online webinar classroom Johannesburg Midrand Sandton","filename":"businessreportwriting","old_slug":null,"name":"Business and Report Writing","status":1,"type":1,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"BusinessReportBundle","bookstock":3,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2017-05-30 11:24:28","accountmanagerid":null,"supersededby":null,"softskills":"Y","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":"https:\/\/www.youtube.com\/embed\/VL7tbqQEQKY","moodle_course_id":null,"internal_comments":null,"created_at":null,"updated_at":"2024-04-08T12:13:13.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":144,"delivery_method_id":1,"created_at":"2020-03-31T11:06:12.000000Z","updated_at":"2021-06-24T20:05:17.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":144,"delivery_method_id":5,"created_at":"2020-04-06T12:02:47.000000Z","updated_at":"2021-06-24T20:05:17.000000Z","duration":3,"duration_units":"Days","cost":"6750.00","minimum_delegates":null,"moodle_course_id":null}}]}&dates=11th Dec 2024 09:00 - 13th Dec 2024 16:00){kind=link}
![Enquire](/enquiry?subject={"id":232,"certificate_template_id":1,"title":"Writing Reports and Proposals training course-Midrand, Sandton, Johannesburg, South Africa","description":"<p>Workshop objectives include:<\/p>\r\n<ul>\r\n<li>Learn the value of good written communications.<\/li>\r\n<li>Develop paragraphs that introduce, connect, develop, and conclude some part of an idea.<\/li>\r\n<li>Prepare reports and proposals that inform, persuade, and provide information.<\/li>\r\n<li>Learn how to proofread your work so you are confident it is clear, concise, complete, and correct<\/li>\r\n<li>Provide an opportunity to apply these skills in real work applications.<\/li>\r\n<\/ul>","audience":"<p>Anybody who writes proposals or reports for business would benefit from this course.<\/p>\r\n<p>This would suit admin and salespeople, supervisors, and junior managers in non-technical environments.<\/p>","prerequisites":"<p>Document formatting knowledge or MS Word experience. This is a computer-based course. Please let your sales representative know if you are not able to bring your own laptop with. A computer can be hired for you to use at an additional cost.<\/p>","about":"<p>A course on writing effective reports and persuasive proposals.<\/p>","durationunits":"Days","outline":"<p><span lang=\"EN-US\">The Stages of Report Writing<\/span><\/p>\r\n<p><span lang=\"EN-US\">This session will introduce the four stages of report writing: investigating, planning, writing, and revising.<\/span><\/p>\r\n<ul>\r\n<li class=\"ImportantPoint\"><span lang=\"EN-US\">The First Stage – Investigating<\/span>\r\n<ul>\r\n<li class=\"MsoNormal\"><span lang=\"EN-US\">The first step is to gather the information for your report. This session will give participants some guidelines to ensure that what they gather is accurate.<\/span><\/li>\r\n<\/ul>\r\n<\/li>\r\n<li class=\"ImportantPoint\"><span lang=\"EN-US\">The Second Stage – Planning <\/span>\r\n<ul>\r\n<li class=\"MsoNormal\"><span lang=\"EN-US\">Participants will learn how to plan a report based on information gathered during the first stage.<\/span><\/li>\r\n<\/ul>\r\n<\/li>\r\n<li class=\"ImportantPoint\"><span lang=\"EN-US\">The Third Stage – Writing <\/span>\r\n<ul>\r\n<li class=\"MsoNormal\"><span lang=\"EN-US\">Participants will practice writing a draft and check that their writing is clear, concise, complete, and correct.<\/span><strong><span lang=\"EN-US\" style=\"font-size: 12.0pt; font-family: 'Calibri',sans-serif; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;\"><br style=\"page-break-before: always;\" clear=\"all\" \/><\/span><\/strong><\/li>\r\n<\/ul>\r\n<\/li>\r\n<li class=\"ImportantPoint\"><span lang=\"EN-US\">The Fourth Stage – Revising<\/span>\r\n<ul>\r\n<li class=\"MsoNormal\"><span lang=\"EN-US\">In this session, participants will learn about the importance of revision, including spelling and grammar checks.<\/span><\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p><span lang=\"EN-US\">Using Headings<\/span><\/p>\r\n<ul>\r\n<li class=\"MsoNormal\"><span lang=\"EN-US\">This session will provide a brief introduction to organizing a report.<\/span><\/li>\r\n<\/ul>\r\n<p><span lang=\"EN-US\">Charts and Graphs<\/span><\/p>\r\n<ul>\r\n<li class=\"MsoNormal\"><span lang=\"EN-US\">Next, participants will learn the right way to add charts and graphs to their report.<\/span><\/li>\r\n<\/ul>\r\n<p><span lang=\"EN-US\">The Proposal<\/span><\/p>\r\n<ul>\r\n<li class=\"MsoNormal\"><span lang=\"EN-US\">During this session, participants will learn how writing a proposal is different from writing a report. Participants will also review the ten steps to successful proposal writing.<\/span><\/li>\r\n<\/ul>\r\n<p><span lang=\"EN-US\">Persuasion<\/span><\/p>\r\n<ul>\r\n<li class=\"MsoNormal\"><span lang=\"EN-US\">This session will look at the finishing touches for a report, including steps in the persuasion process, how to design your message, and how to deal with tough questions.<\/span><\/li>\r\n<\/ul>\r\n<p><span lang=\"EN-US\">Practical Application<\/span><\/p>\r\n<ul>\r\n<li class=\"MsoNormal\"><span lang=\"EN-US\">To summarize all that they have learned, participants will peer edit each others’ work.<\/span><\/li>\r\n<\/ul>\r\n<p><span lang=\"EN-US\">Giving Credit<\/span><\/p>\r\n<ul>\r\n<li class=\"MsoNormal\"><span lang=\"EN-US\">This final session will focus on documentation methods and styles.<\/span><\/li>\r\n<\/ul>","image":"Writing Reports and Proposals1712832724.jpg","meta_desc":"Writing reports, writing proposals. Training course on writing reports and proposals, webinar and classroom-based in Midrand, Gauteng, South Africa.","keywords":"writing reports, writing proposals, webinar training course, Midrand, Gauteng, South Africa","filename":"Writing_Reports_and_Proposals","old_slug":null,"name":"Writing Reports and Proposals","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"WRP","bookstock":3,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2017-05-30 11:32:13","accountmanagerid":135,"supersededby":null,"softskills":"Y","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-11T10:52:04.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":232,"delivery_method_id":1,"created_at":"2020-03-31T11:06:13.000000Z","updated_at":"2022-07-19T09:19:51.000000Z","duration":1,"duration_units":"Days","cost":"2750.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":232,"delivery_method_id":5,"created_at":"2020-04-06T12:02:48.000000Z","updated_at":"2022-07-19T09:19:51.000000Z","duration":1,"duration_units":"Days","cost":"2250.00","minimum_delegates":null,"moodle_course_id":null}}]}&dates=13th Dec 2024 09:00 - 16:00){kind=link}