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 3 June 2024 | 3 Days | Finance for Non Financial Managers | Provisional | Enquire |
| Friday 7 June 2024 | 2 Days | Managing Workplace Relationships SAQA US252027 | Scheduled | Book Live Virtual Training |
| Monday 10 June 2024 | 2 Days | Analyse Financial Information SAQA US252036 | Scheduled | Book Live Virtual Training |
| Monday 10 June 2024 | 1 Day | Microsoft Excel Fundamentals | Provisional | Enquire |
| Monday 10 June 2024 | 2 Days | Managing Workplace Relationships SAQA US252027 | Scheduled | Book Live Virtual Training |
| Monday 10 June 2024 | 3 Days | Assessor Training US115753 | Scheduled | Book Live Virtual Training |
| Tuesday 11 June 2024 | 1 Day | Microsoft Excel: Intermediate | Provisional | Enquire |
| Wednesday 12 June 2024 | 1 Day | Microsoft Excel: Advanced | Provisional | Enquire |
| Wednesday 12 June 2024 | 3 Days | Manage Finances SAQA US252040 | Scheduled | Book Live Virtual Training |
| Thursday 13 June 2024 | 2 Days | Microsoft Power BI Desktop Advanced Course | Provisional | Enquire |
| Wednesday 19 June 2024 | 3 Days | Illustrator Basic-Intermediate | Provisional | Enquire |
| Wednesday 19 June 2024 | 3 Days | SQL | Provisional | Enquire |
| Monday 24 June 2024 | 2 Days | Critical Thinking | Provisional | Enquire |
| Wednesday 26 June 2024 | 2 Days | Business Writing that Works | Provisional | Enquire |
| Wednesday 26 June 2024 | 3 Days | Business and Report Writing | Provisional | Enquire |
| Friday 28 June 2024 | 1 Day | Writing Reports and Proposals | Provisional | Enquire |
| Monday 1 July 2024 | 3 Days | Photoshop Basic-Intermediate | Provisional | Enquire |
| Monday 8 July 2024 | 1 Day | Microsoft Excel Fundamentals | Provisional | Enquire |
| Monday 8 July 2024 | 2 Days | Time Management | Provisional | Enquire |
| Tuesday 9 July 2024 | 1 Day | Microsoft Excel: Intermediate | Provisional | Enquire |
![Enquire](/enquiry?subject={"id":286,"certificate_template_id":1,"title":"Excel Basic course - virtual Instructor-led Midrand, Sandton, Johannesburg, South Africa","description":"<p>You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format.<\/p>\n<p> <\/p>","audience":"<p>This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel worksheets.<\/p>","prerequisites":"<p>Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.<\/p>","about":"You will create and edit basic Microsoft Office Excel Worksheets and\r\nWorkbooks.","durationunits":"Day","outline":"<ul>\r\n<li>Lesson 1: Getting Started with Microsoft Excel<br \/>\r\n<ul>\r\n<li>Navigate the Excel User Interface<\/li>\r\n<li>Use Excel Commands<\/li>\r\n<li>Creating and Save a Basic Workbook<\/li>\r\n<li>Enter Cell Data<\/li>\r\n<li>Use Excel Help<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 2: Performing Calculations\r\n<ul>\r\n<li>Creating Formulas in a Worksheet<\/li>\r\n<li>Insert Functions in a Worksheet<\/li>\r\n<li>Reuse Formula<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 3: Modifying a Worksheet\r\n<ul>\r\n<li>Manipulate Data<\/li>\r\n<li>Insert, Manipulate, and Delete Cells, Columns, and Rows<\/li>\r\n<li>Search for and Replace Data<\/li>\r\n<li>Use Proofing and Research Tools<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 4: Formatting a Worksheet<br \/>\r\n<ul>\r\n<li>Modify Fonts<\/li>\r\n<li>Add Borders and Color to Cells<\/li>\r\n<li>Apply Number Formats<\/li>\r\n<li>Align Cell Contents<\/li>\r\n<li>Apply Cell Styles and Themes<\/li>\r\n<li>Apply Basic conditional formatting<\/li>\r\n<li>Create and Use Templates<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 5: Printing Workbook Contents<br \/>\r\n<ul>\r\n<li>Preview and Print a Workbook <\/li>\r\n<li>Define the Page Layout<\/li>\r\n<\/ul>\r\n<\/li>\r\n<li>Lesson 6: Managing Large Workbooks<br \/>\r\n<ul>\r\n<li>Manage Worksheets<\/li>\r\n<li>Manage the View of Worksheets and Workbooks<\/li>\r\n<li>Manage Workbook Properties <\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>","image":"Excel_2013_logo.png","meta_desc":"Microsoft Office Excel Fundamentals course online virtual instructor-led training Johannesburg South Africa","keywords":"excel basic training in Joburg\r\nbasic excel course\r\nexcel basic training excel fundamental training course\r\nmicrosoft excel bas","filename":"excel_fundamentals","old_slug":null,"name":"Microsoft Excel Fundamentals","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"ExcelFundamental","bookstock":0,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2021-03-18 11:52:43","accountmanagerid":175,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":1,"youtube_video_intro":null,"moodle_course_id":8,"internal_comments":null,"created_at":null,"updated_at":"2023-12-07T12:43:06.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":286,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2023-06-21T14:57:33.000000Z","duration":1,"duration_units":"Day","cost":"2750.00","minimum_delegates":null,"moodle_course_id":8}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":286,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2023-06-21T14:57:33.000000Z","duration":1,"duration_units":"Day","cost":"2250.00","minimum_delegates":null,"moodle_course_id":8}}]}&dates=10th Jun 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=11th Jun 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=12th Jun 2024 09:00 - 16:00){kind=link}
![Enquire](/enquiry?subject={"id":383,"certificate_template_id":1,"title":"Microsoft Power BI Desktop Advanced Course","description":"<p class=\"MsoBodyText\"><span lang=\"EN-ZA\" style=\"font-family: 'Tahoma',sans-serif; mso-bidi-font-family: 'Lucida Sans';\">Please note that this course will only run when we have 6 confirmed delegates booked on the course. In this course, attendees will learn how to model tables, create relationships, calculated columns, calculated tables and measures that support better reporting for the business. We will use Power BI for all practical implementations but these skills are easily transferable to Excel and Analysis Services.<\/span><\/p>","audience":"<p class=\"MsoBodyText\"><span lang=\"EN-ZA\" style=\"font-family: 'Tahoma',sans-serif; mso-bidi-font-family: 'Lucida Sans';\">This course is intended for people who have been working with Power BI, Excel pivot tables or SSAS tabular and are looking to understand how to create richer data models to enable deeper insight into their data.<\/span><\/p>","prerequisites":"<p><span style=\"font-family: Tahoma, sans-serif;\">The Power BI boot camp course is a pre-requisite for the course. Alternatively, delegates should have at least 3 months experience in using Power BI Desktop for creating reports and dashboards<\/span>.<\/p>\r\n<p>The newest version of the Power BI Desktop software is required. If you want assistance in installing the software on your laptop, please ensure that you have Administration Privileges on your laptop. Please arrive 1h early on the first day of the course, so that we can assist you. <\/p>\r\n<p> <\/p>\r\n<p> <\/p>","about":"<p>You are an experienced user of reporting systems and need to use Microsoft Power BI to define and extend data models for use by business users of Power BI Desktop You need to define data models, enhance data with calculated columns and measures, clean data, use ETL and analyze data over time<\/p>","durationunits":"day","outline":"<p>\"M\" Language:<\/p>\r\n<ul>\r\n<li>ETL and Power Query<\/li>\r\n<li>Overview of Dimensional Modelling Techniques<\/li>\r\n<li>M Functions and Keywords<\/li>\r\n<li>Using M to Load and Transform data<\/li>\r\n<\/ul>\r\n<p>DAX<\/p>\r\n<ul>\r\n<li>DAX basis<\/li>\r\n<li>\"Evaluation Context\" for filters and queries<\/li>\r\n<li>Time Intelligence Calculations<\/li>\r\n<li>ABC (\"Pareto\") Charts<\/li>\r\n<\/ul>","image":"pexels-andrea-piacquadio-9270221712650781.jpg","meta_desc":"In this course you will obtain skills to use Microsoft Power BI Desktop to transform data, extend data columns and measures, clean data, create data models, use an ETL approach, and analyze data over time.","keywords":"Business intelligence training, Power BI Desktop course, \r\nPower BI Advanced Course\r\nBI Advanced Training\r\nPower BI Advanced Co","filename":"PowerBI_Advanced","old_slug":null,"name":"Microsoft Power BI Desktop Advanced Course","status":1,"type":1,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"PowerBI_Adv","bookstock":0,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2017-05-30 11:26:45","accountmanagerid":null,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":110,"internal_comments":null,"created_at":null,"updated_at":"2024-04-09T08:19:42.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":383,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2023-11-06T13:13:45.000000Z","duration":2,"duration_units":"day","cost":"5500.00","minimum_delegates":null,"moodle_course_id":110}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":383,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2023-11-06T13:13:45.000000Z","duration":2,"duration_units":"day","cost":"4500.00","minimum_delegates":null,"moodle_course_id":110}}]}&dates=13th Jun 2024 09:00 - 14th Jun 2024 16:00){kind=link}
![Enquire](/enquiry?subject={"id":340,"certificate_template_id":1,"title":"Adobe Illustrator CC Training Course Sandton Midrand","description":"<p>This introductory course will illuminate the powerful vector tool that is Illustrator. It is more than applicable to first-time users and will provide a helpful foundation for more advanced designs.<\/p>","audience":"<p>Desktop publishers, graphic designers and aspiring digital artists.<\/p>","prerequisites":"<p>Basic computer literacy.<\/p>","about":"Adobe Illustrator is the industry standard vector graphics design tool, useful for corporate identity creation, including company logos and marketing\/advertising artwork.","durationunits":"Days","outline":"<p><strong>Getting to know the Workspace<\/strong><\/p>\r\n<p>• Choosing a workspace<\/p>\r\n<p>• Opening a file<\/p>\r\n<p>• The document window<\/p>\r\n<p>• Using Artboards<\/p>\r\n<p>• Navigating multiple artboards<\/p>\r\n<p>• Using the new Artboards panel<\/p>\r\n<p>• Creating New Artboards<\/p>\r\n<p>• Switching screen modes<\/p>\r\n<p>• Changing your view<\/p>\r\n<p>• Preview versus Outlines<\/p>\r\n<p>• Zooming and scrolling<\/p>\r\n<p>• Scrolling with the Hand tool<\/p>\r\n<p>• Changing views with the Navigator panel<\/p>\r\n<p>• The Tools panel<\/p>\r\n<p>• Using tools and panels<\/p>\r\n<p>• The Control panel<\/p>\r\n<p>• Moving the Control panel<\/p>\r\n<p>• Panel groups and the dock<\/p>\r\n<p>• Custom workspaces<\/p>\r\n<p>• Saving workspaces<\/p>\r\n<p>• Using the Manage Workspaces dialog box<\/p>\r\n<p><strong>Illustrator Essentials<\/strong><\/p>\r\n<p>• Using the shape tools<\/p>\r\n<p>• Repositioning and visually resizing the rectangle<\/p>\r\n<p>• Finding or changing the shape’s dimensions using the Transform panel<\/p>\r\n<p>• Rotating and shearing using the Transform panel<\/p>\r\n<p>• Constraining a shape<\/p>\r\n<p>• Entering exact dimensions<\/p>\r\n<p>• Selecting artwork<\/p>\r\n<p>• Helpful keyboard shortcuts for selections<\/p>\r\n<p>• The selection tools<\/p>\r\n<p>• Using shape and transform tools to create artwork<\/p>\r\n<p>• Using the transform tools<\/p>\r\n<p>• Adding a fill color<\/p>\r\n<p>• Viewing in Outline view<\/p>\r\n<p>• Using layers when building an illustration<\/p>\r\n<p>• Creating a new blank layer<\/p>\r\n<p>• Cutting and pasting objects<\/p>\r\n<p>• Moving objects from one layer to another<\/p>\r\n<p><strong>Adding Color<\/strong><\/p>\r\n<p>• Basics of the Appearance panel<\/p>\r\n<p>• Changing colors<\/p>\r\n<p>• Adding Effects<\/p>\r\n<p>• Creating a colorful illustration<\/p>\r\n<p>• Using Live Paint<\/p>\r\n<p>• Adding a symbol to your artwork<\/p>\r\n<p>• Expanding the symbol<\/p>\r\n<p>• Saving swatches<\/p>\r\n<p>• What is a Global Color?<\/p>\r\n<p>• Selecting the Same color<\/p>\r\n<p>• Saving a set of colors as a group<\/p>\r\n<p>• Creating a color group from selected colors<\/p>\r\n<p>• Using the Color panel<\/p>\r\n<p>• Adding Pantone colors<\/p>\r\n<p><strong>Working with the Drawing Tools<\/strong><\/p>\r\n<p>• Working with the Pen tool<\/p>\r\n<p>• Drawing straight lines<\/p>\r\n<p>• Drawing curved lines<\/p>\r\n<p>• Drawing hinged curves<\/p>\r\n<p>• Drawing curved lines to straight lines<\/p>\r\n<p>• Drawing straight lines to curved lines<\/p>\r\n<p>• Shape Tools<\/p>\r\n<p>• Using the Eraser tool<\/p>\r\n<p>• Editing existing paths<\/p>\r\n<p>• Adding and removing points<\/p>\r\n<p>• Cutting and joining paths<\/p>\r\n<p>• Working with Live Trace<\/p>\r\n<p>• Expanding Live Traced artwork<\/p>\r\n<p>• Working with Live Paint<\/p>\r\n<p>• Combining shapes using the new Shape Builder tool<\/p>\r\n<p>• Subtracting with the Shape Builder tool<\/p>\r\n<p><strong>Working with Text<\/strong><\/p>\r\n<p>• Formatting type<\/p>\r\n<p>• Paragraph formatting<\/p>\r\n<p>• Formatting imported type<\/p>\r\n<p>• Paragraph and character styles<\/p>\r\n<p>• Text on a path<\/p>\r\n<p>• Warping text<\/p>\r\n<p>• Text in a shape<\/p>\r\n<p>• Creating outlines<\/p>\r\n<p>• Check spelling<\/p>\r\n<p>• Find and Replace<\/p>\r\n<p><strong>Working with Symbols<\/strong><\/p>\r\n<p>• Cleaning out the symbol library<\/p>\r\n<p>• Creating symbols<\/p>\r\n<p>• Editing symbols<\/p>\r\n<p>• Importing a symbol library<\/p>\r\n<p>• Using the symbol sprayer tools<\/p>\r\n<p>• Editing nested symbols<\/p>\r\n<p>• Replacing symbols <\/p>\r\n<p><strong>Saving and Exporting<\/strong><\/p>\r\n<p>• Saving using the AI file format<\/p>\r\n<p>• Saving an illustration with layers<\/p>\r\n<p>• Saving a layered PDF<\/p>\r\n<p>• Integration with other applications<\/p>\r\n<p>• Saving as EPS<\/p>\r\n<p>• Save for Web<\/p>\r\n<p><strong>Whats New<\/strong><\/p>\r\n<p>• Getting into perspective<\/p>\r\n<p>• Defining the grid<\/p>\r\n<p>• Changing the plane<\/p>\r\n<p>• Using the Perspective Selection tool<\/p>\r\n<p>• Creating shapes with the<\/p>\r\n<p>• Shape Builder tool<\/p>\r\n<p>• To combine shapes<\/p>\r\n<p>• To delete shapes<\/p>\r\n<p>• To divide overlapping shapes<\/p>\r\n<p>• New Brush Controls<\/p>\r\n<p>• Advanced drawing controls<\/p>\r\n<p>• Artboard panel<\/p>\r\n<p>• Touch Type Tool<\/p>\r\n<p>• Images in Brushes<\/p>\r\n<p>• Font Search<\/p>\r\n<p>• Font Sync<\/p>\r\n<p>• Multiple-file place<\/p>\r\n<p>• CSS Extraction<\/p>\r\n<p>• Colour Sync<\/p>\r\n<p>• Area and Point Type Converion<\/p>\r\n<p>• File packaging<\/p>\r\n<p>• On-art free transform<\/p>\r\n<p> <\/p>","image":"illustrator.png","meta_desc":"Short practical Adobe Illustrator CC Training Course Sandton Midrand South Africa by an Adobe Certified Expert","keywords":"Adobe Illustrator, short course, courses in south africa, courses in johannesburg\r\nVector Graphic Design\r\nDesign training","filename":"illustrator_basic-intermediate","old_slug":null,"name":"Illustrator Basic-Intermediate","status":1,"type":0,"show_on_website":1,"accredited":0,"full_qualification":0,"maxpeople":null,"shortname":"Illustrator Bas","bookstock":18,"onorder":0,"expectedorderdate":null,"stock_last_updated":"2017-11-28 08:14:04","accountmanagerid":null,"supersededby":null,"softskills":"N","earlybird":"Y","pc_hire":null,"tier":2,"youtube_video_intro":null,"moodle_course_id":null,"internal_comments":null,"created_at":null,"updated_at":"2024-03-11T09:17:52.000000Z","delivery_methods":[{"id":1,"name":"Classroom","description":"Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.","pivot":{"course_id":340,"delivery_method_id":1,"created_at":"2020-03-31T11:06:14.000000Z","updated_at":"2020-04-02T09:44:34.000000Z","duration":3,"duration_units":"Days","cost":"8250.00","minimum_delegates":null,"moodle_course_id":null}},{"id":5,"name":"Live Virtual Training","description":"This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.","pivot":{"course_id":340,"delivery_method_id":5,"created_at":"2020-04-06T12:02:49.000000Z","updated_at":"2020-04-06T12:02:49.000000Z","duration":3,"duration_units":"Days","cost":"6750.00","minimum_delegates":null,"moodle_course_id":null}}]}&dates=19th Jun 2024 09:00 - 21st Jun 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=26th Jun 2024 09:00 - 28th Jun 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=28th Jun 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=8th Jul 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=9th Jul 2024 09:00 - 16:00){kind=link}