(E212) Excel 2013/2016 Tips for power user

Loading Loading...

Ajankohta According to agreement
Aika
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.

Kohderyhmä

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

Toteutus

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.

Sisältö

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

Formulas
-    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

Charts
-    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

Hinta

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

Peruutusehdot

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.

Koulutuspaikka

Amiedu
Valimotie 8
00380 Helsinki

Ilmoittautuminen

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
elina.bykling(at)amiedu.fi

Ilmoittaudu

Asiakaspalvelu

Avoinna ma-to 8-16, pe 8-14
puhelin 010 80 80 90
asiakaspalvelu@amiedu.fi