Microsoft Excel online: Working with formulas and functions

Training Objectives

In this Excel online training, you 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. Participants will become familiar with the advanced math, statistics and lookup functions.

Course Prerequisites

The course is for individuals with basic Excel knowledge who are responsible for managing and creating large worksheets and models in Excel.

Our live online training is interactive, hands-on, taught by a live instructor, just like our in-person classes.

You can hear the instruction, see the teachers screen, ask questions, and share your screen—all in real-time.

Online Trainings mit echtem Live Trainer. Wir empfehlen die Nutzung eines HeadsetsOther prerequisites:

  • The product software, Excel on your computer
  • Internet connection
  • Either speakers and microphone, headset with microphone, or a speakerphonePC

Course Description

  • Working with large worksheets,
  • Creating complex formulas
  • Relative and absolute reference
  • Using Excel function wizard
  • Creating and editing conditional formatting
  • Logical and Statistical functions: IF, VLOOKUP, SUMIF, COUNTIF
  • Useful tips and tricks


These courses could also be of interest to you

Course Details at a glance


0,5 days

Live Online Training

Price per Student

374,85 € incl. 19% VAT
315,00 € net

Next Dates


13:00 - 16:00



09:00 - 12:00



13:00 - 16:00



Keine Weitergabe Ihrer Daten. Stornierung ist bis 2 Wochen vor Beginn des Seminars jederzeit kostenlos möglich.

Print course info

On site training

For your customized - on site training we tailor the course to your needs by adapting the schedule, meeting place and applications to fit with your particular agenda. For fast problem solving you can also schedule individual time with one of our instructors (training on the job).

Keywords for this seminar

Excel formulars, Excel formulas, Excel functions, Excel online, Excel online training, Excel workbooks, Microsoft, hands-on, instructor-led