E-learning

EXCEL Advanced

In Excel advanced you will learn how to use the program’s extended functions.

The course consists of 13 online modules which each contain a number of learning videos.

Enkeltbruger

fra 189 kr. + moms
  • pr. bruger pr. måned

Virksomhed

Bestil et tilbud Få en gratis demo
  • Kontakt os for et uforpligtende tilbud

E-learning: Excel advanced

In Excel Advanced you will learn how to use the program’s extended functions, so you can work with numbers, calculations, lists, and the processing of large quantities of data in an easy way.

Course prerequisites

The course is for advanced Excel users and require a good prior knowledge of the program matching our Basic Excel course.

Duration

 The course consists of 13 onlines modules which each contain a number of learning videos of approx. 2 mins. each. The course takes approx. 90 minutes in total.

Course content

1.1 Introduction to the course

2.1 Formulas with absolute references

2.2 Formulas with partial absolute reference

3.1 Naming cells

3.2 Edit and delete name

3.3 Format as table

3.4 Table names – dynamic formulas

4.1 Finding and inserting functions

5.1 IF with Numeric Calculations

5.2 IF with text

5.3 AND- OR Functions

6.1 Embedded Functions

7.1 IFS

7.2 COUNTIFS

7.3 SUMIFS

8.1 Round functions

9.1 VLOOKUP (Exact Lookup)

9.2 VLOOKUP (Interval Lookup)

9.3 XLOOKUP (Exact Lookup)

9.4 XLOOKUP (Interval Lookup)

10.1 WEEKDAY

10.2 NETWORKSDAYS.INTL

10.3 YEARFRAC + TODAY

10.4 ISOWEEKNUM

11.1 Rules for Highlighting Cells 

11.2 Rules for Highest/Lowest

11.3 Data Bars

11.4 Icon Set

11.5 Conditional Formatting (with AND function)

11.6 Editing and deleting conditions

12.1 Check Entered Numbers

12.2 Drop-down list with fixed values

12.3 Drop-down list from a cell range

13.1 Protect Cells from Changes

Det får du på e-learning kurset