*VIRTUAL* – MS Excel 2016 – Level 4

Request info

Online Excel 2016 Training

Course Duration: 1 day

Course

In this virtual, Instructor-Led course, you will learn how to create macros to automate your work, use the security features to protect your data, use analytic tools and consolidate data, import and export data, use the Power Views option, create form controls and edit the ribbon.

Course Aim

Enable delegates to examine the more complex components of Excel 2016 and better manipulation of data.

Target Student:  This course is meant for those desiring to gain advanced skills necessary for working with Excel data.

Prerequisites: Before starting this course, students are recommended to take the Excel 2016 Level 2 and/or Excel 2016 Level 3 course or have equivalent knowledge.

Objectives:

  • create and use Macros
  • learn how to collaborate and analyse data
  • use Power View
  • create and use form controls
  • editing the ribbon

Creating Macros

  • Macro Security
  • Creating a Macro
  • Comparing Relative and Absolute Macros
  • Running a Macro
  • Editing a Macro
  • Assigning Shortcuts to Macros

Collaborating With Others

  • Security Features in Excel
  • Protecting Data
  • Protected Views
  • Tracking Changes
  • Workbook Merging

Analysing Data

  • Creating a Single Input Data Table
  • Creating a Two-Variable Data Table
  • Creating Scenarios
  • What If Analysis using Goal Seek
  • Consolidating Data

Import and Export Data

  • Exporting Excel Data
  • Importing Delimited Text
  • Importing a Web Query

Power Views

  • Inserting a Power View Sheet
  • Modifying the Power View Fields and Filters
  • Adding Additional Visualisations

Using Form Controls

  • Creating a Form
  • Creating a Custom Form
  • Protecting Controls and Linked Cells

Editing the Ribbon

  • Editing the Tab wording
  • Adding a new Tab
  • Adding a new Group
  • Adding buttons to a group
  • Adding Macro buttons

Cost: £150 + Vat

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2020-10-25' ) ) AND wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (18022) AND wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC

Scheduled Courses:

    2020
    DateCourse NameLocationPrice (Excluding VAT)Book
    9 Dec*VIRTUAL* – MS Excel 2016 – Level 4Online - Remote£150Enquire Now
    1
    2018: