image

This Excel 2016 Introduction Course will give you the basic skills for working with Excel spreadsheets

To the right and below you can see where and when the next courses in Excel spreadsheets are offered.

We also offer company customized courses

Navigation

Select here if you are looking for another application

Select here if you are looking for another type of Excel Courses

Company customized courses

If you have up to 10 Colleagues for the same course, we have a special offer whether you provide a suitable training location or want us to arrange it all.

If needed we can also provide portable computers.

Price: 15.950,- DKK. excl. VAT

Look here for other courses in your company and book an offer

Solo - Duo kursus

If you prefer being on your own or perhaps with a Colleague, or if you have special wishes, then a solo/duo course might be the right choice for you. Together we will design the content for your education.

Price: 5.950,- DKK excl. VAT per day.

Look for more individual courses and book an offer

Open courses (open for all)

In the calendar to the right and below, you will find dates for open courses. Please notice the different locations.

Price: 4.950,- DKK excl. VAT.

Purpose

You will learn how to format and arrange your data for improved readability, how to create and format charts, how to use formulas and calculations and use some of Excels tools for handling large amount of data.

Duration

2 days from 09:00 to 16:00

Requirements

No prior knowledge to Excel is needed to participate in this course.
Do you have a certain degree of knowledge to Excel or do you just want a quicker review or a brush up, we can offer you a course a 1 day course. Then you can chose:

Excel 2013 Basic Course - Intensive (duration, 1 day).

How we teach

You will be introduced to each topic interactively, which will allow you to learn both by seeing, hearing and practice simultaneously.

Each topic will be followed by relevant exercises. If you have any questions or if you have any Excel examples, our instructor will be pleased to help you.

Content

Introduction to Excel

  • Intro to Excel
  • Review of the user interface
  • Customizing the user interface

Building Excel spreadsheet

  • Entering, editing and deleting data in Excel
  • Adjusting rows and columns
  • Delete, insert columns and rows
  • Naming, inserting and deleting sheets
  • Insert comments in the cells

Selecting and Navigating in Excel

  • Navigating within the spreadsheet
  • Navigating between sheets
  • Selecting Data

Formulas and functions

  • Building and editing formulas
  • Locking cell references
  • Introduction to built-in functions such as:
  • Sum - Average - Count - Min - Max - IF
  • Copying formulas and functions
  • Formulas across sheets

Formatting

  • Numbers and date formatting
  • Font and cell formatting
  • Formatting borders and lines
  • Conditional formatting
  • Zero format

Presentation af data

  • Creating and editing charts
  • Formatting charts
  • Copying of charts and pasting into Word / PowerPoint using links

Working with large amounts of data

  • The use of Filters for selecting specific topics
  • Sorting Data
  • Freeze panes (lock viewing to top rows / leftmost columns)
  • Use of Table styles

Printing Spreadsheets

  • Using print preview
  • Create and manage page layouts
  • Repeating headings on all printed pages

Shortcut keys

  • Using Keyboard Shortcuts

Subsequent courses

After this course, we recommend the following:

Excel 2016 Pivottabeller
Excel 2016 Videregående - 2 dage
Excel 2016 Videregående - 1 dag

Back to overview Excel courses

Se mulighederne for et firma kursus

Referencer

"Kurset var rigtig godt tilrettelagt, og så var det en dygtig og kompetent underviser. -- Ole Christian Dalvang, Rambøll Management
SE ALLE REFERENCER