Excel Advanced (web course)

Sprache: Englisch
Office-Version: MS Office 2016 MS Office 2019 MS Office 365
Produktform: Webkurs
Hersteller bit media
Menge:
  CHF 50.00

Optionen


* Office Version:

Beschreibung

The tutorial is meant for those who use Microsoft Excel for complex calculations or for analysing data. Gain an in-depth understanding of formulas and functions and learn how conditional formatting or range names make it easy to structure complex calculations. The tutorial also focuses on importing and processing of (data) lists, or tables for analysing data. The tutorial explains how easy and effective it is to analyse data in Excel right from simple (table) filters to complex pivot tables. You also learn how to share workbooks in a team and adequately protect your data in the process.

Target audience

Users who are familiar with Microsoft Excel basics and want to gain an in-depth understanding.

Expected duration

8 hours (45 lessons)

Prerequisites (recommended)

Microsoft Excel basics

Course contents Excel Advanced

  • Course recommendation
  • Worksheets
  • Formulas
  • Excel functions
  • Working with tables
  • Importing data
  • Pivot tables
  • Working with charts
  • Workbooks in a team

Activating your online course(s) on the e-learning platform

After purchasing this online course, you will receive an e-mail providing you with a voucher code and a link to redeem it. You will then receive your login details to the e-learning platform, where your course will be available to you for 12 months after your first login. You must validate your code within 24 months.

 

Technical requirements

Operating System:
- MS Windows 7 or higher
- Apple Mac OS X 10.6 or higher

Browser:
- Internet Explorer version 9.0 or higher
- Mozilla Firefox  version 10.0 or higher
- Google Chrome version 19 or higher
- Safari version 5.1 or higher

Client:
- JavaScript activated
- PDF reader (optional)