Excel Experienced (conducted in English) kursus

Book kursus nu

2 dage

7.500 kr. ex moms

Spar penge med et 4D klippekort

Udbydes som virksomhedskursus

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 covered:

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 covered:

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 covered:

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 covered:

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 covered:

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 covered: