Microsoft Excel 2016 – Level 2 (Advanced)

Microsoft Excel 2016 – Level 2 (Advanced)

70   0   2   0   0   0
Kommentare (0)
Veranstalter bewerten
Kalender

Unterkategorie - Rund um Dein Tier

Tierart

Details

Adresse
The British School in The Netherlands - Campus TBC, 640 Vrouw Avenweg, 2493 WZ, Den Haag, Netherland

Datum

Datum
16 Januar, 2019
Start
8.00
Ende
16.00

Microsoft Excel 2016 – Level 2 (Advanced)

Microsoft Excel 2016 – Level 2 (Advanced)

Learn in this course in a fast and efficient way to calculate with Excel. You will learn to make calculations through advanced features, databases and PivotTables. In addition, it will be explained how this data can be presented in an optimal way.

Who is this course for? This course is designed for those who want to enhance their working knowledge of Excel. This course is suitable for those who have an understanding of Excel to the extent of the Level 1 course.

What’s Involved? With a group of no more than ten participants, you will explore Excel focussing specifically on the areas below:

Formats

Modify Number format Create and modify Cell styles Create Table styles Conditional formatting Copy formatting

Working with databases

Creating and formatting Tables Sort lists (or tables) Filter lists (or tables) Group and outlines of data Using subtotals

Calculating with advanced functions

Working with cell names Creating calculations over more worksheets and files Calculate with Date and Time functions Calculate with Financial functions Calculate with Statistical functions Calculate with Lookup functions Calculate with Logical functions Calculate with Database functions

Presenting data with Charts

Creating a chart Modify a chart Formatting a chart Moving a chart Sparklines

Introduction to Pivot Tables

Creating a PivotTable Creating a PivotChart

Graphical objects

Insert a picture Creating shapes Formatting graphical elements Changing the following order of objects Grouping objects Moving, duplicating and changing the size of objects Using SmartArt

Modify the Excel environment

Creating a new workbook using a template Using themes Insert, create, modify and delete Custom lists Inserting, modifying en removing hyperlinks

Programme Dates Wednesday 16th January 2018

Programme Cost €195 Euros

Programme Facilitator Westhaghe Training & Advies

Cancellation Cancellation can be made up to six weeks before the first day of delivery by contacting us directly at info@bsnila.com . Any participant cancellation after this time is non-refundable.


Karte

Start/Ziel tauschen


Benutzer-Kommentare

Es gibt noch keine Benutzer-Kommentare.
Bitte registrieren Sie sich oder Sie sich ein, um einen Kommentar abzugeben.