We use cookies and similar technologies to improve the user experience on our website. To find out more, please read our Privacy Policy. By continuing to use this website, you agree to our use of cookies and similar technologies. More details

Online Academy

Springe zur Kursbeschreibung
Excel (Office 2016) in depth – online course
Learn about all the features of Excel with this online course – from anywhere, at any time!
Do you want to gain a comprehensive overview of Excel? The ‘Excel (Office 2016) in depth’ online course will teach you how to use all the functions offered by the software. The web-based training allows you to gain this knowledge wherever and whenever you want.
Whether you want to create diagrams, lists and formulas, or perform calculations and analyses – with Excel, you can complete all these tasks efficiently and successfully. Discover the benefits of this spreadsheet software as an essential tool for invoices, address lists, budgets, calculations, account management and other data collections.
The online course combines video lessons with practical and theoretical exercises that are completed directly in the virtual application.
  • The course offers the following advantages:
    • Varied, interactive multimedia lessons with video, audio and subtitles
    • Practical exercises with real-time analysis of actions and results directly in the Office application
    • Flexible access to course content, 24 hours a day
    • Certificate of participation following successful completion of the course
  • Content
    The course consists of 140 video lessons plus 140 practical and 18 theoretical exercises. Estimated time to complete the essential modules: 19 hours (the course remains open 6 months):
    • Level 1 – Basics: Discover Excel, perform basic calculations, print workbooks and adjust page set-up, manage sheets and data display, edit headers and footers, colours and formatting
    • Level 2 – Consolidation: Set up complex tables, create diagrams, create and use pivot tables
    • Level 3 – Advanced: Increase efficiency, use advanced calculation functions, discover less well-known functions, protect and share workbooks, macros
    • Digital reference material
  • Target group
    This course is designed for all Excel users who want to learn or revise the basics and would also like to learn about the advanced functions.
  • Your profile
    • No knowledge of Excel is required. Some prior knowledge will enable faster progress.
    • Experience of using a computer is an advantage.
  • System requirements
    • Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista, Windows XP SP3, Mac OS X 10.6 or later (Our recommendation for Mac users: Install Chrome free of charge)
    • Browser: Internet Explorer 10 or later, MS Edge, Firefox, Chrome, Safari (for Mac users, we recommend the use of Chrome because not all functions are available with Safari
    • Resolution: 1280 x 960 or higher, standard text size 100% (96 dpi)
    • High-speed internet connection (at least 20 Mbps)
    • It is not possible to use iPads or tablets.
  • Learning objectives
    At the end of this course, you will:
    • be familiar with all the functions of Excel.
    • be able to process data using advanced calculation functions.
    • know how to create and present diagrams.
    • be able to manage tables and pivot tables.
    • be familiar with sharing and security settings.
Details
Course start immediately
Duration of course 6 Months
Course location Online
Price incl. VAT CHF 300.00