Ready for Microsoft Excel - Microsoft Excel training

Microsoft Excel is a powerful tool for creating spreadsheets and to analyze and share information. Microsoft features and functions can be enhanced through VBA programming (Visual Basic for Applications).

Microsoft Office contributes to your success by building connections between people, the information they possess and the business processes they support.
AS Computertraining offers custom Microsoft Office training. From beginner to expert we can help you unleash the power of Microsoft Office and unlock your full potential.

You can book Excel in English language as customized course or individual training. We tailor content, schedule, meeting place and date to your specific needs.

In addition we offer some specific topics as live online training in our public course program. Have a look:

 

Excel ONLINE Training - public classes - register now:

Course levels

We are offering a variety of different Microsoft Excel seminars. The intro level course does not require any previous knowledge. The other seminars are consecutive classes. Start at the level that fits your needs. Talk to us, if you are not sure, which class is the right one for you. We are happy to advise you.

Consecutive courses - Microsoft Excel classes, open enrollment, on-site courses, excel advanced, excel intro

Excel Course descriptions

Our MS Excel 2010, Excel 2013, Excel 2016 oder Excel 2019/365 courses will teach you to fully leverage the power and functionality of one of the world’s most important business applications. Have a look into some course outlines to decide which level you are at:

Microsoft Excel Workshop – Calculation/Worksheet techniques/Pivot tables

Training Objectives:

In this workshop, students will use the advanced features of Microsoft Excel to attain a high degree of proficiency as an Excel power user. We will show you all the powerful features and possibilities that allow you to quickly and effectively use calculation and spreadsheet functions as well as use and/or create advanced filters and Pivot tables.

Course Prerequisites: Basic Knowledge in Excel

Course Description:

  • Calculation and Spreadsheet functions
    • Working with large worksheets, outlining and grouping
    • Creating Complex formulas
    • Creating and editing Name ranges
    • Creating and editing Comments
    • Viewing formulas and printing
    • Relative and absolute reference
    • Using Excel Function wizard
    • Creating and editing conditional formatting
    • Creating Excel Templates
    • Creating, copy, move, edit and delete worksheets
    • Protecting cells, worksheets and workbook
  • Advanced filters, Subtotals and Pivot tables
    • Consolidating multiple Worksheets and Workbooks
    • Advanced filters
    • Evaluate data with Pivot tables and Pivot charts
    • Creating, editing and saving
    • View and Report Manager
    • Importing lists from other programs and using Import Manager

Duration: 1 day = 6 hours

MS Excel Basics

Training Objectives:

In this seminar you will learn how to work with Excel dependably. Participants at the end of the seminar will be able to create worksheets, run calculations, format worksheets, print them and present the values in graphs and charts.

Course Prerequisites: Basic knowledge of the PC and Windows operating system

Course Description:

  • The Excel application window
  • Structure of an Excel Worksheet and menus
  • Inserting and formatting Text and Numbers
  • Inserting, Deleting and Editing cells, rows and columns
  • Copy, Cut and deleting cell contents
  • Formatting Cells, Rows and Columns
  • Font styles, Font size, Borders and Shading
  • Cell References (relative and absolute)
  • Rules for mathematical operators
  • Constructing and using Excel-Functions (SUM, AVERAGE, COUNT)
  • Printing Worksheets
  • Defining print titles
  • Inserting Page breaks
  • Defining Headers and Footers
  • Working with large worksheets
  • Using AutoFilter functions
  • Sorting worksheets
  • Creating Charts
  • Formatting Excel Charts
  • Learning the various Chart types

Duration: 2 days

Excel Advanced

Training Objectives:

This Seminar will qualify the participants to use Excel professionally and as an effective tool. Participants will become familiar with the advanced math functions and statistical functions. Exercises will be used for large worksheets and how to evaluate them effectively. Learning professionally the association with graphic and charts and exchanging them with other Office applications.

Course Prerequisites: Basic Knowledge in Excel

Course Description:

  • Advanced References
  • Mixed References with relative and absolute
  • Using Name ranges
  • Links to other spreadsheets and files
  • Conditional Formatting for the cells
  • Conditional Formatting with Formulas
  • Calculating and using Excel Functions
  • Calculating with Date and Time functions
  • Text functions: RIGHT, SUBSTITUTE, LENGTH, TRIM
  • Logical and Statistical functions: IF, VLOOKUP, SUMIF, COUNTIF
  • Working with large worksheets
  • Export/Importing lists (WORD/SAP/ACCESS)
  • Text in Column, Transform Text into Numbers
  • Usage of Text functions
  • Using Filters and Subtotals
  • Usage of Excel application window
  • Inserting Pivot tables
  • Formatting Pivot tables
  • Formulas within Pivot tables
  • Grouping and Outlining worksheets
  • Report Manager

Duration: 2 days