Close

Intermediate Excel 2016

  • 7th July 2020
    9:30 am - 5:00 pm

Course duration: 1 day

Additional notes for course:

Venue:  

Course overview

The Intermediate Excel 2016 training course builds on the techniques and concepts presented in the Excel Introduction course. It focuses on how to work more efficiently with calculations, how to further enhance the appearance of the data in the spreadsheet and introduces some data analysis features of Excel.

Aims and objectives

This course will demonstrate how to control more complex formulae and functions and how to use formulae auditing. It will cover the use of various tools to analyse data such as sorting, filtering and a basic introduction to Pivot tables. You will also learn how to organize and present your data using tables, charts and conditional formatting.

Who should attend

This course is designed for Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.

Course content

WORKING WITH MORE ADVANCED CALCULATIONS AND FUNCTIONS
Use of Brackets in Calculations.
Use of Absolute References (Dollar Signs) In Calculations
Building “3-D” Calculations by Linking Formulas across Sheets or across
Workbooks. Controlling 3-D Links.
Using Formula Auditing
Using some Statistical Functions – Average, Max, Min, Count and CountA
Use of Dates in Calculations.
Some basic Date and Time Functions
An introduction to Logical Functions IF, AND, OR
Basic Use of VLOOKUP and HLOOKUP

USING EXCEL TABLE FEATURE
Advantages of Table feature and applying it to data.
How to working with Data Tables
Creating Calculated Columns
Filtering and Sorting in Tables

CONDITIONAL FORMATTING
How to applying basic Conditional Formatting
Using “Traffic Lights” Conditional Formats
Sorting and Filtering based on Conditional Formats

AN INTRODUCTION TO PIVOT TABLE REPORTS
What are Pivot Table Reports?
Creating a basic Pivot Table Repot
The Design Window and how to use it
“Pivoting” and Refreshing the Data
Using the Pivot Table Ribbons

WORKING WITH GRAPHIC OBJECTS
More Advanced Charting:
Formatting Charts.
Adding trend lines to Charts.
Use of Spark lines.
Dual Axis charts and combination charts.
Using SmartArt
Use of Screenshot Tool

Corona Virus Update

Positive2Work Skillnet is fully supportive of the Government’s efforts to effectively address and limit the spread of COVID-19 and to safeguard the protection of public health and that of our stakeholders.

Positive2Work Skillnet management team are continuing to work and are available to discuss any queries that our businesses or trainees have regarding our scheduled training programmes and supports for businesses.

In support of this national effort, Positive2Work Skillnet has postponed its public training courses until 19th April 2020.

Positive2Work Skillnet will continue to take bookings for programmes commencing at a later date in 2020, and for our online programmes.

We are also available to discuss your queries about any other future programmes we offer to our members.

Our Network contact details are.
NAME: Mark Brennan
PHONE: 085 1745779
EMAIL: mark@p2w.ie

We would remind our stakeholders that the HSE website www.hse.ie is the authoritative source of information and advice on the situation regarding COVID-19 in Ireland.

We will keep this information updated in the coming weeks. Further information is also available on the Skillnet Ireland website at www.skillnetireland.ie