Back_Button.png

Back to Educations

Excel Courses

Excel Symbol.jpg

Excel Basic

Introductory Excel course, with the goal of creating a familiarity with the program so that the participants are able to work with it in the most suitable and effective way in real-life situations.

The course starts from the basics, showing Excel’s structure and logic, and then it advances to show its most important features, such as an overview of the functions inside of it, mathematical-, date- and time-related functions, chart creation and more.

The courses are always instructor-lead and available in live sessions in Gothenburg, at your location*, or online.

All our course contain examples and exercises in order to show the usage of the features in real-life situations.

The course has a total length of 16 hours, divided in four 4-hour sections, so that it can be taught both during the weekend, in two 8-hour sections or on evening in weekdays, in four 4-hour sections.

We provide trainings for single individuals or groups of any size. Students may be fitted into different groups. The ideal number of participants in one group is 10; however, classes may be booked with 8 to 12 participants.

 

The Excel Basic course is available both in English and Swedish. Courses in English are suggested for those who work with the Office package in English as there are different functions and shortcuts in both languages.

Price: 2 090 SEK (excl. moms)

*Additional self-cost charges for travel expenses

Introductory Content:

  • History, application and structure of Excel

  • Navigation in Excel

  • Mathematical operators

  • How to create and manage cell references

  • Options when copying and pasting in Excel

  • How to work with pictures and hyperlinks

  • How to define the layout of an Excel file as  seen in the computer

  • Important shortcuts to make work more effective with Excel

  • Calculation options

Mathematical functions:

  • Sum, Product, Average, Averagea, Min, Mina, Max, Maxa

  • Rank, Small, Large,

  • Round, Roundup, Rounddown

  • Count, Counta, Countblank

  • Sumproduct

Date and time-related functions:

  • Date, Year, Month, Day, Edate, Today, Eomonth, Days, Weeknum

  • Weekday, Workday, Workday.Intl, Networkdays, Networkdays.Intl

  • Time, Hour, Minute, Second, Now

Extra content:

  • How to create and edit charts

  • Naming groups of cells and advantages of doing so

  • Protection and visibility options of an Excel file

  • How to work with multiple files or worksheets

  • Groups, subtotals, filters and sorting

 

Excel Intermediate

Intermediate Excel course, improving prior knowledge in the program and showing the participant the most essential features.​

The concepts in this level allow a regular user to become its team Excel guru, by introducing more advanced concepts, such as: error handling, logical-, conditional- and lookup- functions, data validation, tables, .csv files, pivots and more.

The courses are always instructor-lead and available in live sessions in Gothenburg, at your location*, or online.

All our course contain examples and exercises in order to show the usage of the features in real-life situations.

The course has a total length of 16 hours, divided in four 4-hour sections, so that it can be taught both during the weekend, in two 8-hour sections or on evening in weekdays, in four 4-hour sections.

We provide trainings for single individuals or groups of any size. Students may be fitted into different groups. The ideal number of participants in one group is 10; however, classes may be booked with 8 to 12 participants.

 

The Excel Intermediate course is available both in English and Swedish. Courses in English are suggested for those who work with the Office package in English as there are different functions and shortcuts in both languages.

Price: 2 820 SEK (excl. moms)

*Additional self-cost charges for travel expenses

Features for complex analysis:

  • Error Types and error handling

  • Text to columns

  • Remove Duplicates

  • Conditional Formatting

  • Data Validation

  • Table Object

  • Mini Charts

  • Pivot Tables and Pivot Charts

Test functions:

  • Iserr, Isna, Iserror, Isblank, Islogical, Isnontext, Istext, Isnumber, Isref

 

Conditional/logical Functions:

  • If, Not, And, Or, Xor, Ifna, Iferror

  • Nested Ifs

Conditional Mathematical Functions:

  • Countif, Sumif, Averageif, Countifs, Sumifs, Averageifs

 

Lookup Functions:

  • Index, Match, Hlookup, Vlookup

  • Indexation for complex lookups

 

Excel Advanced

Advanced Excel course, introducing Excel as a live database, with advanced features of Pivot Tables,  relationships, connections to external data and scenario testing.​

The participant will acquire skills in complex features, such as advanced filters and sorting, array formulas, what-if analysis and more. The course ends with an introduction to our next set of courses, VBA, Visual Basic for Applications, which allows the participant to transcend from the existing features and create more automated solutions and workflows.

The courses are always instructor-lead and available in live sessions in Gothenburg, at your location*, or online.

All our course contain examples and exercises in order to show the usage of the features in real-life situations.

The course has a total length of 16 hours, divided in four 4-hour sections, so that it can be taught both during the weekend, in two 8-hour sections or on evening in weekdays, in four 4-hour sections.

We provide trainings for single individuals or groups of any size. Students may be fitted into different groups. The ideal number of participants in one group is 10; however, classes may be booked with 8 to 12 participants.

 

The Excel Advanced course is available both in English and Swedish. Courses in English are suggested for those who work with the Office package in English as there are different functions and shortcuts in both languages.

Price: 3 800 SEK (excl. moms)

*Additional self-cost charges for travel expenses

Advanced Features:

  • Advanced filtering

  • Advanced sorting

  • Custom Number Formats

 

Text-related functions:

  • Concatenate, Upper, Lower, Proper, Len, Trim, Find, Search, Left, Right, Mid, Substitute, Replace, Text

Features for database analysis:

  • Connected Pivot Tables

  • Relationships

  • Connections

  • Slicers

What-if-analysis:

  • Solver

  • Goal seek

  • Scenarios

Array formulas

Power Query

 

Power Pivot

Introduction to Visual Basic for Application (VBA):

  • Macro recording and playing

  • Basics of Macro understanding