Invalid quantity. Please enter a quantity of 1 or more.
The quantity you chose exceeds the quantity available.
Please enter your name.
Please enter an email address.
Please enter a valid email address.
Please enter your message or comments.
Please enter the code as shown on the image.
Please select the date you would like to attend.
Please enter an email address.
Please enter a valid email address in the To: field.
Please enter a subject for your message.
Please enter a message.
You can only send this invitations to 10 email addresses at a time.
$$$$ is not a properly formatted color. Please use the format #RRGGBB for all colors.
Please limit your message to $$$$ characters. There are currently ££££.
$$$$ is not a valid email address.
Please enter a promotional code.
N/A
Sold Out
Unavailable
Please enter a password with at least 8 characters.
You have exceeded the time limit and your reservation has been released.
The purpose of this time limit is to ensure that registration is available to as many people as possible. We apologize for the inconvenience.
This option is not available anymore. Please choose a different option.
Please read and accept the waiver.
All fields marked with * are required.
Please double check your email address. The email address format does not appear valid.
Please double check your email address. Your emails do not match.
$$$$ requires a number between ££££ and §§§§
US Zipcodes need to be 5 digits.
Postal code may contain no more than 9 letter or number characters.
Please double check your website URL.
All fields marked with * are required.
Your card expiration date is in the past.
Your card CSC needs to be 4 digits.
Please confirm your order: $$$$ You have selected to Pay by Check.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay at the Door.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay upon Receiving an Invoice.
Click OK to confirm your order.
Your card CSC needs to be 3 digits.
Sofort is only available in Germany and Austria.
Boleto Bancario is only available in Brazil.
OXXO is only available in Mexico.
PagoFacil is only available in Argentina.
Rapipago is only available in Argentina.
Please enter a valid IBAN number.
You need to accept to charge your bank account.
Your billing zip code needs to be 5 digits.
Please double check your CEP info. The CEP format should be something like 12345-678.
Please double check your tax identifier.
There was a problem saving your address.
There was a problem saving your card info.
There was a problem saving your personal information.
Please select the date you would like to attend.
McAfee Secure sites help keep you safe from identity theft, card fraud, spyware, spam, viruses and online scams.
Copying Prohibited by Law - McAfee Secure is a Trademark of McAfee, Inc.
Unknown card type.
No card number provided.
card number is in invalid format.
Wrong card type or card number is invalid.
card number has an inappropriate number of digits.
Please enter numbers here.
Please enter an integer value.
Numbers must be less or equal to $$$$
All the required fields have not been filled out. Click OK to proceed without all the required information, or click Cancel to finish entering the missing data.
Job titles must be less than 50 characters.
There is currently an issue with card submission on Safari with iOS7. Please try again with a different browser or device.
Sorry, invalid event registration form.
Sorry, invalid event or database error.
Sorry, quantity must be a positive integer.
Sorry, you did not select a valid ticket.
Sorry, invalid event organizer email address.
Your order was canceled.
Thank You. Your order has been successfully completed. Your name and email address have been added to the list of event attendees.
Sorry, that option is sold out.
Sorry, that option is no longer available.
Sorry, you entered an invalid quantity. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, you did not select any tickets to purchase. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, there are no tickets left for this event.
The tickets, ticket quantity or date and time you've requested are no longer available, due to previous sales. Please choose a different date, time or number of tickets and place your order again.
Sorry, one or more of the tickets you requested are no longer available for purchase.
Sorry, you need to select the date you want to attend.
Sorry, the promotional code you entered is not valid yet.
Sorry, the promotional code you entered has expired.
Sorry, the promotional code you entered is not valid.
Your session has expired. Try ordering again.
Sorry, your requested ticket quantity exceeds the number provided by your promotional code.
Sorry, the payment type chosen is invalid for this event.
Sorry, there is only 1 ticket left for this event.
We're sorry, this invitation is invalid.
We're sorry, this invitation has already been used.
We're sorry, you already have an order being processed for this event. Please wait a few minutes and try again.
We're sorry, there is a problem with your invitation. Please try again.
Invalid quantity of tickets selected.
Invalid donation amount.
Sorry, the promotional code you entered has been claimed.
The payment was cancelled.
The payment was declined by the bank.
The payment failed.
The payment expired.
Bummer! This team is full. Please join a different team.
Sorry, the tickets you've selected are no longer available.
We couldn't process your order because you have this event open on multiple tabs in your browser. Please try again with only one browser tab open.
Based on the quantity selected we are unable to seat your group together. Please try a smaller quantity.
Your browser does not support picking your own seat. Please select a quantity and the best available seats will be assigned to you.
Sorry, we can't complete your order in preview. Please make your event live to complete your order.
Group registration has been disabled for this event.
Sorry, you cannot reserve seats when your event is in draft mode.
There was a problem submitting your order. Code 17
Sorry, the payment type chosen is invalid for this event.
Sorry, your billing address was not saved properly, please try again.
Sorry, we experienced an internal error, please try again.
The captcha you entered is invalid. Please try again.
Invalid card selected. You have been logged out.
Sorry, your team selection was not valid.
It looks like this event organizer is unable to process your order through their payment processor. Please try again later, or contact the organizer directly
Sorry, the payment type chosen is invalid for this event.
Sorry, your billing address was not saved properly, please try again.
Sorry, we experienced an internal error, please try again.
Please double check your email address. The email address format does not appear valid.
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.
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 Date
Thursday 15th June 2021
Programme Cost
€195 Euros
Programme Facilitator
Westhaghe Training & Advies - Bert Roos
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.
Share Microsoft Excel 2016 – Level 2 (Advanced)
Email Share Tweet