prospen.co.za

ProspenAfrica | Training and Consulting Services Provider

Microsoft Excel Intermediate

2 Day Training

Dates: 20 – 21 May | 15 – 16 July 2024
Locations: Johannesburg, South Africa
Platform: Available In-Class / Online

Price: Available on Request

Non-Accredited Course

Course Introduction

Master using formulas and functions to make Excel work for you with this free online Excel Intermediate course.

Microsoft Excel 2013 intermediate course starts where our Microsoft Excel 2013 for Beginners course finishes. It will introduce you to a number of basic Excel concepts such as commenting, navigating the workbook, and working with printing. You’ll get an overview of the formulas and functions used in excel, learn the tips and tricks in working with multiple workbooks and finding errors, and study Excel as a Data Analysis tool.

Course Objectives

  1. Advanced Formulas and Functions: Intermediate Excel covers more complex functions (e.g., INDEX/MATCH, CONCATENATE, IFERROR) allowing for more sophisticated calculations and data manipulation.

  2. Data Analysis Tools: Learning intermediate Excel introduces tools like PivotTables and Pivot Charts, enabling powerful data analysis and visualization.

  3. Data Validation and Protection: Intermediate Excel teaches methods to validate data entries and protect sensitive information within spreadsheets, enhancing data accuracy and security.

  4. Conditional Formatting: Understanding intermediate Excel includes learning about conditional formatting, allowing you to highlight and visualize data based on specific criteria, making trends and anomalies more apparent.

  5. Advanced Charting and Graphing: You’ll be able to create more complex and customized charts and graphs to present data in a more visually appealing and understandable way.

  6. Managing Larger Datasets: Techniques for managing and handling larger datasets more efficiently, such as using tables and advanced sorting/filtering options, are covered in intermediate training.

  7. Automation with Macros: Delve deeper into macros to automate more complex tasks, saving time and reducing errors in repetitive processes.

  8. Collaboration and Sharing: Intermediate Excel skills include understanding how to collaborate effectively on workbooks, track changes, and merge data from different sources.

  9. Decision Support Analysis: Gain skills in creating scenarios and performing what-if analysis to support decision-making processes.

  10. Advanced Formatting Techniques: Learn advanced formatting techniques to make your spreadsheets more visually appealing and professional-looking.

Who should attend?

All Excel users. Anyone interested in learning excel and saving huge amounts of time in their daily use of Excel.

Training methodology

Training Methodology

Our diverse instructional approaches ensure effective learning:

– Lectures & Presentations: Engage with expert-driven, stimulating content.
– Course Material: Access well-crafted supporting resources.
– Group Work: Collaborate on discussions and case studies for practical insights.
– Workshops & Role-Play: Participate in immersive, scenario-based activities.
– Practical Application: Focus on applying theoretical knowledge in real situations.
– Post-Training Support: Receive extensive support after training for skill implementation.

Training Outline

Course Overview

Session 1 – Introduction to Formulas

Identify the elements of a formula, identify the default order in which calculations occur, match absolute, relative and mixed references, inserting an Excel formula and choosing the correct formula.

 

Session 2 – Data Cleaning

Excel puts special emphasis in cleaning data which comes in either text or numerical format. It has built a whole host of TEXT and DATA functions to allow us to manipulate large amounts of information.

 

Session 3 – Charts & Objects

Analyze and communicate the data in spreadsheets more efficiently with charts in Excel.

 

Session 4 – Advanced Formulas

How to create advanced formulas and nested functions.  Nested functions refer to one or more functions being placed inside another. Doing this extends the capabilities of the formula.

 

Session 5 – Decision Tables

Show how to share data between multiple worksheets, including tips for adding, moving, and navigating worksheets. Produce a structured Excel Workbook with advanced formulas.

 

Session 6 – Pivot Tables

Excel has put special emphasis in using PIVOT TABLES to analyze large data sets.

Request a Call

    Enquire Now

    Related Courses

    Advanced Excel and Dashboards Training
    Dates: 18 - 19 Jun | 22 - 23 Aug 2024

    A Complete Introduction To Power BI Desktop

    View Course
    Basic Microsoft Word
    Dates: 19 Jul 2024

    Microsoft Word Basic

    SAQA ID: 117924, NQF L2

    View Course
    Intermediate Microsoft Word: SAQA ID: 119078, NQF L3
    Dates: 16 - 17 May | 22 - 23 Aug | 14 - 15 Oct 2024

    Microsoft Word Intermediate

    SAQA ID: 119078, NQF L3

    View Course
    Basic Microsoft Word
    Dates: 12 Jun | 19 Aug 2024

    Microsoft Word Advanced

    SAQA ID: 116942, NQF L3

    View Course

    Open chat
    Need Help? Chat with Us
    Scan the code
    Powered by Prospen Africa
    Welcome to Prospen Africa!
    Check out our 15% Off sale when you purchase QCTO Training Material