What do I learn in Excel courses?

Excel courses introduce you to the use of the spreadsheet program MS Excel. The courses are usually divided into a basic or foundation level, an advanced level and various specializations at professional level.

In Excel basic courses you learn, for example:

• know the basic uses of Excel
• Create lists
• Enter numbers and texts
• Sort and filter tables
• Customize tables to your own needs
• work with workbooks and data sheets
• Create and edit diagrams
• apply simple formulas (such as addition, multiplication, percentages)
• work with cell references
• Set up pages and prepare them for printing

Excel basic or foundation courses enable you to create and format tables, perform simple calculations and display figures graphically. Basic knowledge of computers and Windows or macOS is generally required to attend the course.

In Excel advanced courses, for example, you will learn:

• Use complex formulas and functions
• Create pivot tables
• Apply conditional formatting
• Apply, customize and create stylesheets
• Importing and exporting data
• Data exchange with Word and PowerPoint
• Carry out what-if analyses

MS Excel advanced courses enable you to create sophisticated tables, format them, evaluate extensive data, create complex formulas and use functions in a solution-oriented manner.

In MS Excel courses for advanced users, you will cover topics such as:

• Protection mechanisms
• Release of workbooks
• Target value search
• Solver
• Multiple operations
• Matrix functions
• Programming language VBA

Advanced courses often focus on specific topics and areas of application. Depending on the learning objective, they enable you to program complex calculations and create sophisticated controlling tables, evaluate complex data sets, work with protection functions and much more.

To the overview of Excel training courses