Excel Experienced (conducted in English)

Kursusmål The goal is to learn more advanced and commonly used features which most people use as conditional formatting and formulas using functions.
Deltagere The course is made for you who want to work independently and effectively with the extended topics in Excel.

It will be an advantage if you already have knowledge of Excel equivalent to our Excel Basic course.
Kursusmateriale We have made this course as an alternation between theory, questions and many practical hands-on exercises, as we know that this is the way you get the most optimal outcome.

You will, at course start, get a completed course material and the opportunity to get the associated course files if you want to practice the assignments again after the course.

If you have questions about any of the reviewed topics you are welcome, to contact our instructors by mail or phone afterwards.
Kursus indhold 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 ...

Vis mere

... 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:
  • Excel standard keyboard shortcuts
Du kan finde alle informationer om dette kursus ved at gå ind på http://www.4d.dk/Kurser/Office/Excel/Ikke_angivet/1086

Har du spørgsmål?

Hvis du har yderligere spørgsmål til dette produkt eller ønsker at få fremsendt materiale i forbindelse med produktet, er du velkommen til at benytte kontaktformularen herunder.

Excel Experienced (conducted in English)

Forhandler
4D konsulenterne
Normalpris
7.500,00 kr
Udsalgspris
7.500,00 kr
Normalpris
Udsolgt
Pris pr. stk.
pr. 
Eksklusiv moms.

Efter aftale / Kontakt for pris

Hvis du har valgt Efter aftale, kan du udfylde formularen nedenfor og så vender vi tilbage til dig og aftaler nærmere.

Har du spørgsmål?

Hvis du har yderligere spørgsmål til dette produkt eller ønsker at få fremsendt materiale i forbindelse med produktet, er du velkommen til at benytte kontaktformularen herunder.