EXCEL Basic - in English

This Excel 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 course in Excel spreadsheets are offered. We also offer company customized courses. 

Excel Basic - conducted in English

Through this course 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 amounts of data. 

Requirements

You can participate in this course whether you use Excel 2019, 2016, 2013 or Office 365.

No prior knowledge to Excel is needed to participate in this course.

If you have a certain degree of knowledge to Excel or you want a quicker review or a brush up, we can offer you a 1 day course.

Duration

2 days from 09:00 to 16:00

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
Company course
8.950 kr. ex. moms
  • Held in your company
  • Up to 12 participants
  • Adaptable course content
15.950 kr.excl. VAT
Solo course
8.950 kr. ex. moms
  • Held in your company
  • Course for you + 1 colleague
  • Adaptable course content
5.950 kr.excl. VAT
Open course
8.950 kr. ex. moms
  • Held at our locations
  • Max. 8 participants
  • See dates below
4.950 kr.excl. VAT

Choose between a company-, solo- or open course

Company course

This course is a company course for 3-12 employees from your company. The course is typically held at your location, but can also be in one of our locations, if you prefer that.

The course content can be adapted to your needs and interests.

15.950 kr. excl. VAT
  • Up to 12 participants
  • Adapted course content
  • Flexible course planning
  • Free support after the course

Solo / Duo course

In a solo course you will receive 1:1 education – the course can also be a duo course, where you can bring 1 colleague for free.

We can adapt the course content to your interests and needs.  The course will typically be held at your company’s location.

5.950 kr. excl. VAT
  • For you (+ one colleague)
  • Adapted course content
  • Flexible course planning
  • Free support after the course

Open courses

An open course is a course where you participate with course participants from other companies. You can sign up to an open course on a date and location that fits your schedule through our open course calendar. In an open course you will be taught in the planned course content, but you are always welcome to ask questions during the course.

4.950 kr. excl. VAT
  • Max. 8 participants
  • Scheduled dates
  • Incl. catering
  • Free support after the course

Open course calendar

No event found!
Se flere datoer
Har du spørgsmål?

Vi sidder klar til at hjælpe.

Related courses

Du kan se hele Excel kursus oversigten her. Se også vores Excel kursus i KøbenhavnOdense og Aarhus
eller tilmeld dig vores online Excel kurser.