Stay versatile as a management assistant: Excel and OneDrive for Business

  • Course types: Calendar course / In company
  • Takes place in: Antwerp, Brussels
  • Duration: 1 day
  • Price: € 365 VAT excl. / Cheaper course?

Description

If you’re a management assistant, you probably receive lots of Excel files to process. If that’s the case, knowing how to use Excel efficiently is an essential skill for you. Unfortunately, the data in these files are often not structured optimally, so you’ll need to tweak the document a bit to process them efficiently. But don’t panic: Xylos is here to help! During this training, you’ll learn how to effortlessly restructure data and how to visualise and analyse them. To conclude, you’ll learn how to share your finished files with your manager or colleagues; that’s where Cloud applications such as OneDrive for Business come in handy.

Choose a date and location

Objectives

After this training, you’ll be able to optimise Excel lists and analyse and visualise data easily. You’ll also know how to share data through Cloud applications.

Target Group

Everyone who wants to use Excel lists more efficiently and execute basic analyses.

Prerequisites

Basic knowledge of Excel and Word required.

Content

Part 1 Optimising, analysing and visualising data

Optimising Excel lists (tables):

  • Turning a list into a table
  • Using Flash fill
  • Excel functions

Analysing and visualising data

  • Grouping data/creating overviews
  • Setting up conditional formatting
  • PivotTables and PivotCharts

Part 2 Cloud applications (1 hour)

  • How to share Excel and other files in an O365 environment

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning
  •  

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

Practical info

The practical info and applicable cancellation conditions related to this training course.

 

Choose a date and location

€ 365 VAT excl.
Cheaper course?

Requesting a quotation

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request

Discount

SEVERAL PARTICIPANTS
If you enrol several employees for the same course on the same date, you will get a discount:

  • 2 employees: 15% discount on the 2nd subscription
  • 3 or more employees: 15% discount on the 2nd subscription and 40% on further participants

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com