Facebook

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

Work sheets and work books

In this module you will learn how to use several work sheets and work books. You will learn how to manage multiple work sheets efficiently and create formulas across work sheets. You will learn how to create links between work books and how to share and protect work sheets and work books.
The subjects are:
  • Creating and managing multiple sheets
  • Formulas on multiple sheets in the same work book
  • Arranging multiple work books and creating links between work books
  • Saving multiple work books in a work space
  • Merging data from different work sheets or different work books, using consolidation
  • Sharing the work book and permitting multiple users to work simultaneously
  • Protection of cells, sheets and work books
Validation and special tools

In this module you will learn how to control the data entry in your work sheet and how to copy and paste different properties from a copied cell or range of cells.
  • Data validation - check that the data entries on the work sheet are correct - automatically
  • Concatenate cells with text – merge entries from different cells into one entry
  • Insert and paste special options – ex. convert formulas to values
  • Select specific areas in the work sheet – ex. highlight specific cells - automatically
Revision of formulas

In this module you will learn several efficient tools when you want to review formulas in a complex work sheet. It can be a visual overview with lines and colors. In addition, tools for error control are explained.
  • Visual overview of the connection between the formulas on the work sheet – arrows pointing to the cells used in a formula
  • Methods of error control
  • Automatic marking of invalid data in connection with validation of data
  • Evaluate formulas – a tool to find the calculation levels in a formula
  • Value control chart – an overview of all the cells in the work sheet
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:
  • Math functions – often used in other formulas ex. if you want to change your numbers into whole numbers – NOT a format, as a format is only what you SEE on the screen - Excel always calculate the exact number, unless you use a build-in mathematical function
  • Statistic functions – ex. average, maximum, minimum and count
  • Text functions – when you want to extract a part of a cell content
  • Date functions – if you must calculate on dates
  • Financial functions – ex. to calculate the mortgage on your house
  • Logical functions – using the IF functions when you must incorporate conditions in your formulas
  • Information functions – if you want to replace an error message with a text of your own choice
  • Lookup functions – when you must look up a value in a data list

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.
  • Creating your own formats for your numbers
  • Conditional formatting – automatic formatting of cells based on your criteria
  • Combining text and numbers in one cell
Data analysis and calculation tools

In this module you will be introduced to some useful tools when working with large work sheets and huge amounts of data.
  • Removing duplicates in a list
  • Grouping of rows and columns – to make an overview of large amount of data
  • Combination Functions with criteria (ex. SUMIF, COUNTIF – how many meet a criteria)
  • PivotTables - analysis, grouping and calculation tool and PivotCharts
  • Goal Seek – to be used in order to meet a certain goal with one unknown factor
Help and keyboard short cuts

In this module you will get an overview of keyboard short cuts and key tips.
  • Using Excel help
  • Excel standard keyboard short cuts
  • Accessing all commands from the keyboard using key tips

Kontaktoplysninger

Adresse
Amagertorv 21
1160 København K