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.
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
- 13 online modules
- Modern teaching methods
- Learning files
- Course certificate
- Free e-mail and phone support
