Excel Experienced (conducted in English) kursus

  • Hjem
  • Office
  • Excel
  • Excel Experienced (conducted in English) kursus

You will learn

On this Excel course you will learn to create more advanced and automated Excel work sheets and be able to use a lot of Excel’s many build-in functions. After the course you have become an even more efficient user of Excel. This course is meant for you who work with bigger amount of data.

After the course you will be able to:

  • Handle several work books and create formulas between them – and ensure that values you enter are validated to avoid errors
  • Build advanced formulas using some of the most useful build-in functions such as IF in several levels
  • Use VLOOKUP+MATCH – functions to be used when you want to look up values in big data lists
  • Handle formulas which return errors
  • Use conditional formatting as a tool to highlight desired key figures or figures that meet your criteria
  • Create an overview of and make calculations on long lists, ex. using functions such as Subtotals, SUMIFS
  • Create PivotTables – an overview of your vast amount of data
In the section, ”Course Details” below, you will find more details about the content of this course in Excel.

We will give you tools for working with sheets and work books, ex. functions, consolidation and protection, as well as how to ensure correct entries by using data validation. We also go through advanced copying, and automatic selection of many cells containing formulas or fixed values.

You will get a thorough review of build-in functions, where we look at logical functions, such as "IF" to test, "LOOKUP" to find values in other data lists and "YEAR", "MONTH" and "DAY" to extract values on dates.

We also look at conditional formatting, which enhance your number material with automatically colored columns or different types of icons. We look at the many criteria for when a conditional format should be performed, and we will look further at their settings and how conditional formulas are used.

In addition, we will look at larger lists and how we can use different tools on them such as grouping, subtotals and the build-in functions: SUMIFS, COUNTIFS and AVERAGEIFS. You also get an introduction to Pivot tables - the fastest tool for grouping your data and making related calculations.

You get

Before the course
  • The opportunity to speak with one of our instructors about finding the right course for you.
During the course
  • Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
  • A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
  • A course material you can use as an encyclopedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant on Gråbrødretorv, cake, candy and off cause Wi-Fi to your devices.
  • A course certificate as a proof of your new skills.
After the course
  • Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
  • We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course.

Get the best benefit from the course

This Excel course is a part of 4D's unique collection of English conducted courses and we recommend that you have participated in our Excel Basic or have the knowledge equivalent to the content covered in the above-mentioned course.

Course Details

Worksheets and workbooks
In this module you will learn how to use several worksheets and workbooks. You will learn how to manage multiple worksheets efficiently and create formulas across worksheets. You will learn how to create links between workbooks and how to share and protect worksheets and workbooks.

The following will be coverd
  • Creating and managing multiple sheets
  • Formulas on multiple sheets in the same workbook
  • Arranging multiple workbooks and creating links between workbooks
  • Saving multiple workbooks in a work space
  • Merging data from different worksheets or different workbooks, using consolidation
  • Sharing the workbook and permitting multiple users to work simultaneously
  • Protection of cells, sheets and workbooks

Validation and special tools
In this module you will learn how to control the data entry in your worksheet and how to copy and paste different properties from a copied cell or range of cells.

The following will be coverd
  • Data validation - check that the data entries on the worksheet are correct
  • Merge entries from different cells into one
  • Insert and paste special options – ex. convert formulas to values
  • Select specific areas in the worksheet – ex. Formulas or number values

Using build-in functions
Using the build-in functions is an easy way to manage advanced calculations in Excel and can be used to handle several problems. In this module you will learn some of these functions. Here are some of the build-in functions you will learn:

The following will be coverd
  • Statistical functions – ex. Average, Max, Min and Count
  • Text functions – ex. extract first name and last name from a cell with a full name
  • Date functions – ex. calculate year, weekday, weeknumber from a date
  • Logical functions – use criteria’s when something must be calculated
  • Information functions – ex. return an error message if a formula fails
  • Lookup functions – get data from big lists or compare lists

Advanced formatting
In this module you will learn how to make your own customized formats and how to make formats based on a cell content or a formula.

The following will be coverd
  • Create your own formats for numbers or for date
  • Conditional formatting – automatic formatting of cells with fill color, columns or icons based on the content
  • Controlling the format when combining text

Data analysis and calculation tools
In this module you will be introduced to some useful tools when working with large worksheets and huge amounts of data.

The following will be coverd
  • Removing duplicates in a list
  • Grouping of rows and columns
  • “Functions with criterias” as SUMIFS and COUNTIFS
  • Introduction to PivotTables – with a few click you can get a calculation of totals with similar data

Keyboard shortcuts
In this module you will get an overview of keyboard shortcuts and key tips.

The following will be coverd
  • Excel standard keyboard shortcuts

Hold dig opdateret med vores nyhedsbrev

Modtag nyheder, gode tilbud, tips og tricks med vores månedlige nyhedsbrev.

Vi har både et Office/Adobe nyhedsbrev og et nyhedsbrev for vores tekniske Microsoft kurser.

Her bor vi

Hovedindgang
Amagertorv 21
1160 København K
Kursusindgang
Læderstræde 22-26
1201 København K
Åbningstider
Mandag: 08.00 - 16.30 (Indgang for kursister i Læderstræde åbner 8.30) 
Tirsdag: 08.30 - 16.30
Onsdag: 08.30 - 16.30
Torsdag: 08.30 - 16.30
Fredag: 08.30 - 16.30

 

Kontaktoplysninger

 
Amagertorv 21
1160 København K