Trusted Training Partners

Quick Look Course Summary:Excel Training Courses Pretoria / Advanced excel course Pretoria, Jhb, Cpt Expert Course
  • Next Public Course Date:

  • Length: 1 day(s)

  • Price (at your venue): 1 Person R 4,475.00 EX VAT 3 Person R 3,399.06 EX VAT 10 Person R 2,529.41 EX VAT

  • Certification Type: Non-Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Get Free & personalised
Training Advice

    Excel 2016 Expert Course: Introduction: Excel Training Courses Pretoria / Advanced excel course Pretoria, Jhb, Cpt

    The Excel Training Courses Pretoria / Advanced excel course Pretoria, Jhb, Cpt follows on from the Intermediate course. Participants cover Excel comprehensively in this course. We also offer this course in all centres across South Africa.

    Excel 2016 Expert Course :Course Outline

    BOTI warmly welcomes participants to the third and final workshop on Excel 2016 (Excel Training Courses Pretoria / Advanced excel course Pretoria, Jhb, Cpt, Dbn) This workshop is designed to give advanced users of Excel 2016 an even deeper understanding of the application. We strongly suggest that beginners and novices to Excel 2016 attend our Essentials and Advanced workshops first before attempting this workshop. This is a practical workshop where participants will practice what they learn on computer, we also hand out our pre workshop review form as usual. Some of the workshop objectives are: Understanding permissions, versions and Excel options; tracking changes and sharing workbooks; performing advanced formula auditing and calculation; creating arrays, creating customised macros; using trend lines and chart templates and creating and manipulating a Power View sheet. Module two introduces participants to the Information tab and the Backstage view, students will also learn about permissions, marking workbooks as final and encrypting workbooks with passwords. Participants will also learn how to add a digital signature and they will learn how to set advanced options and properties in the dialog box. Participants will also learn how to save the workbook as a template. Templates are a way of pre-designing a workbook so that a new workbook can be created quickly without having to start from scratch. Templates include many elements such as formatting and calculation options. In module four we focus on performing advanced formula and function tasks, participants will learn how to use the Watch Window to monitor results. The Watch Window is user friendly and can be moved around on screen, it can also be docked on the left or right hand side of the screen. Participants will also learn how to use IFERROR to evaluate formulas and results and display specific results if the formula contains an error. Module five focuses on array formulas and some of the advantages, disadvantages and rules for using array formulas as well as array constants. Array formulas are known as CSE formulas because the short-cut keys are CONTROL+SHIFT+ENTER. Participants will also learn about one dimensional arrays and two dimensional arrays. In module eight students will learn about applying advanced chart features such as trend lines and how to add a trend line. Students will also be taught to plot a data series on a secondary axis.TIP: Some of the trend lines that are available in Excel 2016 are: Linear; logarithmic; polynomial; power; exponential and moving average. The type of data being used determines the trend line that should be used. In module nine we focus on slicers and timelines. We will explain what slicers are and teach participants different ways to use them. The new timeline feature creates a better filter for date ranges. When slicers were added to Excel 2010, the function was to filter Pivot table data. In Excel 2016 (Excel Training Courses Pretoria / Advanced excel course Pretoria, Jhb, Cpt, Dbn) slicers can be used to filter any table data. We round off our workshop with a module on multiple tables, connecting to external sources, creating pivot tables using an external data connection and lastly working with the new Power View, which is a presentation ready way to work with data.

    Excel 2016 Expert Course: Course Duration

    1 day/s

    Who should attend: Excel 2016 Expert Course

    Excel Training Courses Pretoria / Advanced excel course Pretoria, Jhb, Cpt, Dbn is intended for advanced users of Microsoft Excel.

    **Quote does not include Any Exam Fees (if applicable)

    IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

    Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Please Contact Us Now - We Will Respond in 15 Minutes


      Accredited Courses

      Additional Courses

      Leadership & Management Courses

      Software & IT Courses

      Top Rated