Excel jatko

Duration: 1 days , Course language: finnish, Material language: finnish, Material: pdf
Excel jatko
1 Pcs
Excel jatko (1 days), 08.11.2018
490,00 €
+ vat.. 24%.
OPPIASOPIMUS Price: 367,50€

Description

Excel advanced

In this course you will learn how to use Excel’s more enhanced features. We will learn how to import data from different data sources, analyze it with functions and create Pivot tables. We will cover for example Vlookup, Sumif and database functions, effective ways to visualize your data with charts & sparklines and how to use database features effectively.

This cource is for people who already master Excel basics.

Versions

This training is for Excel Windows versions 2010, 2013, 2016 and for Excel Mac version 2016.

Content

Excel enhanced use

  • Number formatting, calculations and static references
  • Importing data from different sources. Use of a .csv files and import wizard.
  • How to process cell values? Flash fill and text to columns
  • Paste special feature, paste items in right format

Enhanced calculations

  • Calculation with condition functions like If and Sumifs
  • Fetching and combining information with Lookup and Vlookup functions
  • Inner functions: Index/Match

Databases

  • Basic features, sort, filter and format as table
  • How I can hide unneeded information? Grouping your
  • What is Pivot? Introduction into Pivot
  • Reporting and data analyzes with Pivot

Data visualization

  • How I can recognize values differences and their trends? Conditional formatting and Sparkline
  • Enhanced charts, for example use of a two axels

 



Schedule

Date
Start time
End time
Nb!
08.11.2018
09:00
16:00
Cancellation terms

Enrollment in any of our courses can be cancelled without extra charge when done a fortnight before the training or earlier. The price of the course will be charged for cancellations that are made later than this. If you are not able to take part in the training yourself, the participant can also be changed without surcharge at any point before the date of the course.

Your course or event to Oppia.fi?

Contact us!