top of page
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 Basic

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 Intermediate

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

Excel Advanced
bottom of page