• Home – Twasa eLearning
  • Register / Login
  • Profile
  • Courses
  • POE
  • Checkout
  • Contact Us
      • Cart

        0
    Have any question?
    011 792 3674
    admin@twasa-elearning.co.za
    RegisterLogin
    Twasa-eLearning
    • Home – Twasa eLearning
    • Register / Login
    • Profile
    • Courses
    • POE
    • Checkout
    • Contact Us
        • Cart

          0
      • Home
      • All courses
      • excel
      • Excel Intermediate 2016 (SAQA 116940)

      Excel Intermediate 2016 (SAQA 116940)

      User Avatar
      Michael Nyoni
      excel
      (0 review)
      R1,490.00
      e97226e549ea094f44ee5e30354dd1b3
      • Overview
      • Curriculum
      • Instructor
      • Reviews

      Welcome To Excel Intermediate 2016 . To view the course outline click on Curriculum Tab.

      To enrol on a course click on the “Buy This Course”. If you have already registered, it will take you to the course, if not, it will redirect you to the learner registration page were you will be required to fill in your details and create your free account.

      To start with your course click on Curriculum tab and Read Instructions that follow

      Related

      Course Features

      • Lectures 41
      • Quizzes 8
      • Students 5
      • Certificate Yes
      • Assessments Self
      CoursesexcelExcel Intermediate 2016 (SAQA 116940)
      • Read Instructions

        Please read instructions below

        1
        • Lecture1.1
          Instructions 30 min
      • Session One

        PREPARE AND PRODUCE A SPREADSHEET TO PROVIDE A SOLUTION TO A GIVEN PROBLEM.

        4
        • Lecture2.1
          An outline solution is developed to meet the requirements of a given brief 30 min
        • Lecture2.2
          The spreadsheet produced addresses the given problem 30 min
        • Lecture2.3
          Excel 1 Int 2016 Video 30 min
        • Quiz2.1
          Excel 2 Quiz 1 3 questions
      • Session Two

        ADJUST SETTINGS TO CUSTOMISE THE VIEW AND PREFERENCES OF THE SPREADSHEET APPLICATION TO SUITE THE SOLUTION CREATED FOR THE GIVEN PROBLEM.

        8
        • Lecture3.1
          Toolbar menus are switched off and on 30 min
        • Lecture3.2
          The view of the spreadsheet is enlarged and made smaller 30 min
        • Lecture3.3
          The way that the spreadsheet is viewed is changed 30 min
        • Lecture3.4
          Cells are frozen to prevent scrolling 30 min
        • Lecture3.5
          The default file location is changed 30 min
        • Lecture3.6
          A user name is added to the file 01 hour
        • Lecture3.7
          Excel 2 Int 2016 Video 30 min
        • Quiz3.1
          Excel 2 Quiz 2 6 questions
      • Session Three

        WORK WITH MULTIPLE WORKSHEETS TO SUITE THE SOLUTION TO THE GIVEN PROBLEM.

        7
        • Lecture4.1
          The purpose of using multiple worksheets within one spreadsheet file are explained with examples 30 min
        • Lecture4.2
          New worksheets are opened 30 min
        • Lecture4.3
          Worksheets are renamed in terms of their purpose within the solution to the given problem 30 min
        • Lecture4.4
          Cells are manipulated between worksheets 30 min
        • Lecture4.5
          A worksheet within a workbook (or spreadsheet) is deleted 01 hour
        • Lecture4.6
          Excel 3 Int 2016 Video 30 min
        • Quiz4.1
          Excel 2 Quiz 3 5 questions
      • Session Four

        APPLY FORMULAE TO WORKSHEETS TO PROVIDE ALTERNATIVE SOLUTIONS TO THE GIVEN PROBLEM.

        8
        • Lecture5.1
          Formulae are entered taking into consideration the natural order of operation 30 min
        • Lecture5.2
          Formulae are entered to deliberately change the natural order of operation 30 min
        • Lecture5.3
          Formula error messages are correctly interpreted and the formula corrected accordingly 30 min
        • Lecture5.4
          The difference between relative and absolute cell addressing is demonstrated by using it in a formula 30 min
        • Lecture5.5
          Data are changed to test possible solutions to the given problem without having to change formulae 30 min
        • Lecture5.6
          Scenarios are created that demonstrate different possible outcomes 30 min
        • Lecture5.7
          Excel 4 Int 2016 Video 30 min
        • Quiz5.1
          Excel 2 Quiz 4 7 questions
      • Session Five

        APPLY SIMPLE BUILT-IN FUNCTIONS OF THE SPREADSHEET APPLICATION TO THE GIVEN PROBLEM.

        5
        • Lecture6.1
          Functions are explained in terms of their purpose, use and construct 30 min
        • Lecture6.2
          Simple Mathematical functions are applied to the given problem 30 min
        • Lecture6.3
          Statistical functions are applied that achieve the anticipated result 30 min
        • Lecture6.4
          Excel 5 Int 2016 Video 30 min
        • Quiz6.1
          Excel 2 Quiz 5 4 questions
      • Session Six

        APPLY FORMATTING TO A SPREADSHEET APPLICABLE TO THE GIVEN PROBLEM.

        6
        • Lecture7.1
          Methods of automatically formatting a spreadsheet are explained 30 min
        • Lecture7.2
          A spreadsheet is created using a template 01 hour
        • Lecture7.3
          Cells are formatted using styles 30 min
        • Lecture7.4
          Formats are copied between cells 30 min
        • Lecture7.5
          Excel 6 Int 2016 Video 30 min
        • Quiz7.1
          Excel 2 Quiz 6 6 questions
      • Session Seven

        USE SPECIAL EFFECTS TO IMPROVE THE PRESENTATION OF THE SPREADSHEET.

        6
        • Lecture8.1
          Text is centered across a cell range 30 min
        • Lecture8.2
          Orientation of text within a cell is changed 30 min
        • Lecture8.3
          A border is applied to cells and removed from cells 01 hour
        • Lecture8.4
          Fill (shading) is applied to cells and removed from cells. 30 min
        • Lecture8.5
          Excel 7 Int 2016 Video 30 min
        • Quiz8.1
          Excel 2 Quiz 7 4 questions
      • Session Eight

        EVALUATE A SPREADSHEET TO COMPLY WITH THE GIVEN PROBLEM.

        4
        • Lecture9.1
          The spreadsheet is evaluated for compliance with a given problem, appropriate formatting, readability, legibility, presentation, accuracy, and data integrity 30 min
        • Lecture9.2
          The spreadsheet is modified if required and compliance with the brief is confirmed 30 min
        • Lecture9.3
          Excel 8 Int 2016 Video 30 min
        • Quiz9.1
          Excel 2 Quiz 8 4 questions
      • Excel Intermediate Portfolio of Evidence (POE)
        1
        • Assignment10.1
          Excel 2016 Intermediate Portfolio of Evidence (POE) 3 days
      author avatar
      Michael Nyoni

        Twasa Training Level 1 BEE Rated & SETA accredited

        Reviews

        Average Rating

        0
        0 rating

        Detailed Rating

        5
        0%
        4
        0%
        3
        0%
        2
        0%
        1
        0%
        • Overview
        • Curriculum
        • Instructor
        • Reviews
        R1,490.00
        • Share:

        You May Like

        Assertiveness Workshop Read More
        Michael Nyoni

        Assertiveness Workshop

        3
        0
        R1,450.00
        Basic Computer Technology Read More
        Michael Nyoni

        Basic Computer Technology

        2
        0
        R1,450.00
        Build Effective Teams (SAQA 252037) Read More
        Michael Nyoni

        Build Effective Teams (SAQA 252037)

        4
        0
        R2,950.00
        Business Ethics (SAQA 113924) Read More
        Michael Nyoni

        Business Ethics (SAQA 113924)

        7
        0
        R2,950.00
        Business Writing (SAQA 115790) Read More
        Michael Nyoni

        Business Writing (SAQA 115790)

        3
        0
        R2,950.00

        All Courses

        • business
        • communication
        • computer training
        • Employment Equity
        • excel
        • finance
        • General
        • Leadership
        • management
        • operations
        • PowerPoint
        • sales
        • service
        • Supervisory
        • word

        Latest Courses

        Assertiveness Workshop

        Assertiveness Workshop

        R1,450.00
        Basic Computer Technology

        Basic Computer Technology

        R1,450.00
        Build Effective Teams (SAQA 252037)

        Build Effective Teams (SAQA 252037)

        R2,950.00

        Stay in touch

        • Facebook
        • Google Plus
        • LinkedIn

        Twasa e-Learning by Twasa Corporate Training

        Connect with:

        Login with Facebook Login with Google Login with LinkedIn

        logo


        Login with your site account

        Connect with:

        Login with Facebook Login with Google Login with LinkedIn

        logo



        Lost your password?

        Not a member yet? Register now

        Register a new account

        Are you a member? Login now

        Modal title

        Message modal