MS Excel 2016 – Level 4

Request info

Excel 2016 Training

Course Description:

In this 1 day course will build on the previous Excel courses, introducing more advanced topics such as macros and Power Views.

Who is this course for:

Delegates who wish to extend your knowledge into more specialised and advanced capabilities of Excel by automating some common tasks using macros, use Power Views, and edit the ribbon.

Delegate Requirements:

• Use Data Validation
• Work with Statistical Functions
• Work with Text Functions
• Work with Financial Functions
• Use Auditing Tools
• Insert Illustrations
• Create PivotTables
• Create and work with Templates
• Collaborate with others

Objectives:

• Create macros to automate common tasks
• Use form controls
• Use advanced techniques to analyse data
• Import and export data
• Use Power Queries
• Create Power Views
• Customise the Ribbon

Course Content:

Creating Macros
Creating a Macro
Comparing Relative and Absolute Macros
Running a Macro
Editing a Macro
Assigning Shortcuts to Macros
Macro Security
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
Combine data from other sources
Run Power Queries
Power Views
Adding Power View Button
Inserting a Power View Sheet
Modifying the Power View Fields and Filters
Adding Additional Visualisations
Using PowerMap
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
Excel Options
General
Formulas
Proofing
Save
Language
Advanced
Customise Ribbon
Quick Access Toolbar
Add-ins
Trust Center

Duration: 1 Day

Cost: £235 + 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) >= '2019-04-19' ) ) 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 (10367) 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:

    2019
    DateCourse NameLocationPrice (Excluding VAT)Book
    27 SepMS Excel 2016 – Level 4Inverness£195Enquire Now
    1
    2018: