Kurser

Kursusadministration

Brug for hjælp?

  • Gregersensvej 8
  • 2630 Taastrup
Google MapsApple MapsRejseplanen
  • Forskerparken Fyn, Forskerparken 10F
  • 5230 Odense M
Google MapsApple MapsRejseplanen
  • Teknologiparken Kongsvang Allé 29
  • 8000 Aarhus C
Google MapsApple MapsRejseplanen
  • NordsøcentretPostboks 104
  • 9850Hirtshals
Google MapsApple MapsRejseplanen
  • Gammel Ålbovej 1
  • 6092Sønder Stenderup
Google MapsApple MapsRejseplanen
87618 - Excel 2010 - Advanced

Excel 2010 - Advanced

Learn how to handle an analysis of larger amounts of data, to create advanced, but user-friendly spreadsheets, and how to structure more complex economic models, and develop your skills on the more advanced functions in Excel. The course is taught in English.

More about the course

Do you want to use Excel rationally and professionally to make advanced analyses and sheet operations? Then this course, on which hundreds have already participated, is relevant for you. Excel is much more than just to add or subtract numbers. Often it gets much easier, if you let Excel do the work for you – you will learn how to on this course. It will cover the more advanced functions and the improved functions in Excel 2010 – for example the improved pivot tables.

Content

  • Short repetition of basic Excel – with a focus on absolute and relative cell references
  • To protect formula and text cells against changes
  • Excel’s function wizard with predefined formulas like VLOOKUP, IF and ROUND
  • Advanced conditional formatting – use of data bars and icons instead of colours
  • To print sheets with headers and footers and other elements
  • Use of the new Page Layout view
  • Use the group and outline function
  • Use sparklines (charts in cells)
  • Advanced use of charts and formatting tools
  • Create links between data and copies of them
  • To name cells and use them instead of absolute references ($ signs) in formulas
  • Use of data table and create scenarios and goal seek
  • How to handle dates and time
  • Create hyperlinks and save as a website
  • Import of data from other programs
  • Data analysis with filter, subtotals, forms and database functions
  • Improved sorting tools
  • Pivot tables and charts and use of filters and sorting tools in pivot tables
  • Data validation
  • Create macros
  • Create templates and use of Microsoft templates
  • To consolidate data – to combine data from different divisions into one main sheet
  • Controls

Instructor

The course is provided by an experienced instructor from Teknologisk Instituts instructor network.

Har du faglige spørgsmål så kontakt
Andre kurser