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 9 September 2024 | 3 Days | Illustrator Basic-Intermediate | Provisional | Enquire |
| Monday 9 September 2024 | 3 Days | Microsoft Power BI Boot Camp | Provisional | Enquire |
| Monday 16 September 2024 | 2 Days | Critical Thinking | Provisional | Enquire |
| Monday 16 September 2024 | 5 Days | Skills Development Facilitator | Scheduled | Book Live Virtual Training |
| Monday 16 September 2024 | 3 Days | Analysing Data with Excel | Provisional | Enquire |
| Wednesday 18 September 2024 | 3 Days | Business and Report Writing | Provisional | Enquire |
| Wednesday 18 September 2024 | 2 Days | Business Writing that Works | Provisional | Enquire |
| Friday 20 September 2024 | 1 Day | Writing Reports and Proposals | Provisional | Enquire |
| Wednesday 25 September 2024 | 3 Days | Facilitator Training US117871 | Scheduled | Book Live Virtual Training |
| Monday 30 September 2024 | 1 Day | Microsoft Excel Fundamentals | Provisional | Enquire |
| Monday 30 September 2024 | 3 Days | Assessor Training US115753 | Scheduled | Book Live Virtual Training |
| Monday 30 September 2024 | 2 Days | Laravel Introduction | Provisional | Enquire |
| Monday 30 September 2024 | 4 Days | Laravel Bootcamp | Provisional | Enquire |
| Tuesday 1 October 2024 | 1 Day | Microsoft Excel: Intermediate | Provisional | Enquire |
| Wednesday 2 October 2024 | 1 Day | Microsoft Excel: Advanced | Provisional | Enquire |
| Wednesday 2 October 2024 | 2 Days | Laravel Intermediate | Provisional | Enquire |
| Thursday 3 October 2024 | 2 Days | Customer Centric Employee | Provisional | Enquire |
| Monday 7 October 2024 | 3 Days | SQL | Provisional | Enquire |
| Monday 7 October 2024 | 3 Days | Moderator Training US115759 | Scheduled | Book Live Virtual Training |
| Monday 7 October 2024 | 3 Days | Microsoft Power BI Boot Camp | Provisional | Enquire |
![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}
![Enquire](/enquiry?subject={"id":469,"certificate_template_id":1,"title":"Analyzing Data with Excel","description":"<p>After completing this course, students will be able to:<\/p>\r\n<ul>\r\n<li>Perform data analysis fundamentals.<\/li>\r\n<li>Visualize data with Excel.<\/li>\r\n<li>Analyze data with formulas and functions.<\/li>\r\n<li>Analyze data with PivotTables<\/li>\r\n<li>Present visual insights with dashboards in Excel.<\/li>\r\n<li>Create geospatial visualizations with Excel.<\/li>\r\n<li>Perform statistical analysis.<\/li>\r\n<li>Get and transform data.<\/li>\r\n<li>Model and analyze data with Power Pivot.<\/li>\r\n<li>Present insights with reports.<\/li>\r\n<\/ul>","audience":"<p>This course is intended for students who are experienced with Microsoft Excel and who wish to add Business intelligence techniques and visualization. <span style=\"font-family: Arial, sans-serif; font-size: 15.008px;\">The course will take students beyond the capabilities of tables and charts using Pivot Charts and Excel Data Model.<\/span><br \/><br \/><\/p>","prerequisites":"<p>Before attending this course, students must have:<\/p>\r\n<ul>\r\n<li>Basic knowledge of the Microsoft Windows operating system and its core functionality.<\/li>\r\n<li>Skills using Excel worksheets, particularly in creating formulas and functions.<\/li>\r\n<\/ul>","about":"<p>The main purpose of the course is to give students the ability to apply Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model and Power Pivot.<\/p>","durationunits":"days","outline":"<h4>Data Analysis Fundamentals<\/h4>\r\n<ul>\r\n<li>Introduction to Data Science<\/li>\r\n<li>Create and Modify Tables<\/li>\r\n<li>Sort and Filter Data<\/li>\r\n<\/ul>\r\n<h4>Visualizing Data with Excel<\/h4>\r\n<ul>\r\n<li>Visualize Data with Charts<\/li>\r\n<li>Modify and Format Charts<\/li>\r\n<li>Apply Best Practices in Chart Design<\/li>\r\n<\/ul>\r\n<h4>Analyzing Data with Formulas and Functions<\/h4>\r\n<ul>\r\n<li>Analyze Data with Formulas and Named Ranges<\/li>\r\n<li>Analyze Data with Functions<\/li>\r\n<li>Implement Data Validation, Forms, and Controls<\/li>\r\n<li>Create Conditional Visualizations with Lookup Functions<\/li>\r\n<\/ul>\r\n<h4>Analyzing Data with PivotTables<\/h4>\r\n<ul>\r\n<li>Create a PivotTable<\/li>\r\n<li>Analyze PivotTable Data<\/li>\r\n<\/ul>\r\n<h4>Presenting Visual Insights with Dashboards in Excel<\/h4>\r\n<ul>\r\n<li>Visualize Data with PivotCharts<\/li>\r\n<li>Filter Data Using Slicers and Timelines<\/li>\r\n<li>Create a Dashboard in Excel<\/li>\r\n<\/ul>\r\n<h4>Creating Geospatial Visualizations with Excel<\/h4>\r\n<ul>\r\n<li>Create Map Charts in Excel<\/li>\r\n<li>Customize Map Charts in Excel<\/li>\r\n<\/ul>\r\n<h4>Performing Statistical Analysis<\/h4>\r\n<ul>\r\n<li>Visualize Trendlines and Sparklines with Excel<\/li>\r\n<li>Analyze Data with the Data Analysis ToolPak<\/li>\r\n<\/ul>\r\n<h4>Getting and Transforming Data<\/h4>\r\n<ul>\r\n<li>Connect to Data with Queries<\/li>\r\n<li>Clean and Combine Data<\/li>\r\n<li>Shape and Transform Data<\/li>\r\n<\/ul>\r\n<h4>Modeling and Analyzing Data with Power Pivot<\/h4>\r\n<ul>\r\n<li>Install Power Pivot in Excel<\/li>\r\n<li>Create Data Models with Power Pivot<\/li>\r\n<li>Create Power Pivots<\/li>\r\n<li>Perform Advanced Data Analysis and Visualization<\/li>\r\n<\/ul>\r\n<h4>Presenting Insights with Reports<\/h4>\r\n<ul>\r\n<li>Plan a Report<\/li>\r\n<li>Create a Report<\/li>\r\n<\/ul>","image":"pexels-towfiqu-barbhuiya-90998221712650092.jpg","meta_desc":"Analyze data using Excel","keywords":"analysing data with excel course\r\npower pivot excel course\r\nData analysis course in Excel \r\nExcel Data Analyzing course","filename":"analyzing_data_with_excel","old_slug":null,"name":"Analysing Data with Excel","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"AnalysiDataExcel","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":168,"internal_comments":null,"created_at":null,"updated_at":"2024-04-09T08:08: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":469,"delivery_method_id":1,"created_at":"2020-03-31T11:06:15.000000Z","updated_at":"2024-01-31T12:46:12.000000Z","duration":3,"duration_units":"days","cost":"8250.00","minimum_delegates":null,"moodle_course_id":168}},{"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":469,"delivery_method_id":5,"created_at":"2020-04-06T12:02:50.000000Z","updated_at":"2024-01-31T12:46:12.000000Z","duration":3,"duration_units":"days","cost":"6750.00","minimum_delegates":null,"moodle_course_id":168}}]}&dates=16th Sep 2024 09:00 - 18th Sep 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=18th Sep 2024 09:00 - 20th Sep 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=20th Sep 2024 09:00 - 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=30th 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=30th Sep 2024 09:00 - 1st Oct 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=30th Sep 2024 09:00 - 3rd Oct 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=1st Oct 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=2nd Oct 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=2nd Oct 2024 09:00 - 3rd Oct 2024 16:00){kind=link}