Fully booked - Microsoft Excel 2016 – Level 2 (Advanced) 

Professional Development Academy, BSN

<H1>Learn on 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.</H1>
<H2>Who is this course for?</H2>
<P CLASS="MsoNoSpacing">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.</P>
<H2> What’s Involved?</H2>
<P CLASS="MsoNormal" STYLE="margin-bottom: .0001pt; line-height: normal;">With a group of no more than ten participants, you will explore Excel focussing specifically on the areas below:</P>
<P CLASS="MsoNormal" STYLE="margin-bottom: .0001pt; line-height: normal;"> </P>
<H3>Formats</H3>
<UL>
<LI>Modify Number format</LI>
<LI>Create and modify Cell styles</LI>
<LI>Create Table styles</LI>
<LI>Conditional formatting</LI>
<LI>Copy formatting</LI>
</UL>
<P CLASS="MsoNormal" STYLE="margin-bottom: .0001pt; line-height: normal;"> </P>
<H3>Working with databases</H3>
<UL>
<LI>Creating and formatting Tables</LI>
<LI>Sort lists (or tables)</LI>
<LI>Filter lists (or tables)</LI>
<LI>Group and outlines of data</LI>
<LI>Using subtotals</LI>
</UL>
<P CLASS="MsoNormal" STYLE="margin-bottom: .0001pt; line-height: normal;"> </P>
<H3>Calculating with advanced functions</H3>
<UL>
<LI>Working with cell names</LI>
<LI>Creating calculations over more worksheets and files</LI>
<LI>Calculate with Date and Time functions</LI>
<LI>Calculate with Financial functions</LI>
<LI>Calculate with Statistical functions</LI>
<LI>Calculate with Lookup functions</LI>
<LI>Calculate with Logical functions</LI>
<LI>Calculate with Database functions</LI>
</UL>
<P CLASS="MsoNormal" STYLE="margin-bottom: .0001pt; line-height: normal;"> </P>
<H3>Presenting data with Charts</H3>
<UL>
<LI>Creating a chart</LI>
<LI>Modify a chart</LI>
<LI>Formatting a chart</LI>
<LI>Moving a chart</LI>
<LI>Sparklines</LI>
</UL>
<P CLASS="MsoNormal" STYLE="margin-bottom: .0001pt; line-height: normal;"> </P>
<H3>Introduction to Pivot Tables</H3>
<UL>
<LI>Creating a PivotTable</LI>
<LI>Creating a PivotChart</LI>
</UL>
<P CLASS="MsoNormal" STYLE="margin-bottom: .0001pt; line-height: normal;"> </P>
<H3>Graphical objects</H3>
<UL>
<LI>Insert a picture</LI>
<LI>Creating shapes</LI>
<LI>Formatting graphical elements</LI>
<LI>Changing the following order of objects</LI>
<LI>Grouping objects</LI>
<LI>Moving, duplicating and changing the size of objects</LI>
<LI>Using SmartArt</LI>
</UL>
<P CLASS="MsoNormal" STYLE="margin-bottom: .0001pt; line-height: normal;"> </P>
<H3>Modify the Excel environment</H3>
<UL>
<LI>Creating a new workbook using a template</LI>
<LI>Using themes</LI>
<LI>Insert, create, modify and delete Custom lists</LI>
<LI>Inserting, modifying en removing hyperlinks</LI>
</UL>
<P CLASS="MsoNormal" STYLE="margin-bottom: .0001pt; line-height: normal;"> </P>
<H2>Programme Date</H2>
<P CLASS="MsoNormal">Thursday 11th June 2020</P>
<H2>Programme Cost</H2>
<P CLASS="MsoNormal">€195 Euros</P>
<H2>Programme Facilitator</H2>
<P CLASS="MsoNormal" STYLE="margin-bottom: .0001pt; line-height: normal;">Westhaghe Training & Advies</P>
<H2>Cancellation</H2>
<H1><SPAN STYLE="font-size: 10pt; line-height: 115%; font-family: Calibri, sans-serif;">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.</SPAN><BR></H1>
<P> </P>
<P><IMG ALT="BSN ILA General Skills" SRC="https://cdn.evbuc.com/eventlogos/195994687/ilageneralskills.png"></P>

<P><BR></P>

<P><BR></P>

Fully booked - Microsoft Excel 2016 – Level 2 (Advanced)

More events from Professional Development Academy, BSN

Discover more events from Professional Development Academy, BSN, from Family & Education to other experiences you might love.

Still looking for the right event?

Explore all events in Den Haag and filter by date, category, and more to find the perfect fit.

Fully booked - Microsoft Excel 2016 – Level 2 (Advanced)

More events from Professional Development Academy, BSN

Discover more events from Professional Development Academy, BSN, from Family & Education to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Den Haag and filter by date, category, and more to find the perfect fit.