Excel courses (cert.)  (Langenthal):
3 Provider

The following content is taught in an Excel Advanced course:

• Apply complex formulas and functions
• Linking tables
• Conditional table format (colored cells due to calculation)
• Graphic representations for advanced users
• Automate workflows
• Sort and filter lists
• Evaluate database
• Import and export of data

This Excel training course teaches you how to use Excel professionally.

To attend Excel courses for beginners, you need some computer skills including mouse operation and window technology. The use of the Ribbon and Explorer (file manager) is a prerequisite. To be on the safe side, find out about the admission requirements for each Excel course before attending.

In an Excel basic course I learn the following:

• Structure and mode of operation
• Creating, opening and saving tables and tabs
• Ribbon and its functions
• Help under Excel
• Working with formulas and predefined functions
• Examples with absolute and relative references
• Number and text formats

Learning Excel is quick with the right course.

To be able to learn Excel VBA, you already need in-depth experience with Excel. Only then can you get to know the basics of object-oriented programming VBA (Visual Basic for Applications). Everyday and recurring tasks can be solved efficiently with the VBA programming language. In an Excel Visual Basic course, participants learn the following:

• Basic concepts
• The Visual Basic Editor (VBE)
• Macros (write code)
• Basic syntax in modules
• Procedures and functions
• Variables and data types
• Operators
• Branches (IF... THEN... ELSE...)
• Loops (FOR...NEXT, Do...Loop)
• Error handling
• Input Box

If you are looking for the "Learn Excel Advanced" option, you must already have basic PC skills and basic Excel knowledge. Practical experience with Excel is also required for the Excel Advanced course.

Most Excel courses include a course confirmation or course certificate. This briefly summarizes the content taught and certifies course participation including the date.

However, if you are looking for a recognized Excel course certificate according to international standards and already have basic knowledge, you should complete the ECDL Excel Spreadsheet module. There you learn:

• Set up calculations of varying complexity
• Structure tables and make them meaningful
• Import and prepare data
• Manage, sort and filter Excel databases
• Evaluate data, even across multiple spreadsheets (pivot tables)
• Building what-if scenarios
• into meaningful diagrams
• Create forms with fields and input checks
• Automate processes
• know the versatile functions and applications of Excel
• use the efficient working methods

An alternative Excel course with certificate would also be the SIZ.

There are the following different Excel courses that can be completed at training providers and are frequently offered:

• Excel basics course
• Excel advanced course
• Excel for advanced learners course
• Excel refresher course
• Excel Controlling course
• VBA course
• Pivot tables course
• Power Pivot Course
• Word Excel course
• Microsoft Excel course or Microsoft Excel for Mac course