(E212) Excel 2013/2016 Tips for power user

Loading Loading...

Ajankohta According to agreement
Kesto 1 day
Ilmoittautuminen/ Hakeminen Ongoin application time

Tavoitteet ja hyödyt

Are you annoyed with Excel troubles? Come and get the best tips and tricks easy using of Excel.


Excel users who are familiar with the basics and need more practice in taming Excel.


The course starts at 9.00 and ends at 16.00.

The course can be tailored according to customer’s wishes and can be held in customer’s premises or at Amiedu also with versions 2007 and 2010. Ask for an offer.


Tricks for creating a table faster
-    Series and custom lists
-    Short cut keys
-    Data validation
-    Find and replace

Solving common problems
-    Showing insignificant digits
-    Clear all formats at the same time
-    Problems with number formats (i.e. dates)
-    Comment and error indicators
-    Custom number formats
-    Hiding zero values in formulas

Paste special and paste options

-    Using AutoSum in many ways
-    Copying formulas
-    Show formulas
-    Formula auditing
-    Add operators to Quick Access Toolbar
-    Customize Status Bar

Grouping spreadsheets and 3D calculating

-    Custom charts
-    Sparklines

Managing large spreadsheets
-    Moving around
-    Freeze panes (keep title rows and columns visible) and Print titles
-    Synchronous scrolling
-    Split windows
-    Hide and unhide rows, columns and tables
-    What to consider when sorting
-    Split one column to multiple columns
-    Importing data from other sources


The course price is 241,80 € / person (incl. VAT 24 %). The price includes course materials, certification and lunch with morning and afternoon coffees.


The course  can be canceled free of charge 2 weeks prior to the agreed start date. Cancellation a week prior to the agreed start date will be charged 50 % of the course fee. Cancellations made after this will be charged of 100 % of the course fee.


Valimotie 8
00380 Helsinki


Fill in the registration form on our website. Training will require a minimum of 6 persons enrolled. We send the invitation and other detailed instructions by email.

Registration is binding.

Kysy lisätietoja

Elina Byckling
instructor, team leader
Tel. 020 7461 657



Avoinna ma-to 8-16, pe 8-14
puhelin 010 80 80 90