Excel: Power Pivot (DAX)
Description Excel’s strong data analysis tool Power Pivot? Get to know it better during our training course ‘Excel Power Pivot – (DAX) Functions’! You may already have noticed that Power Pivot contains a lot of new functions. Some of these functions are fairly intuitive to use, but for most you may need the help of […]
Excel: Power Pivot
Description Excel’s rock-solid data tool? Get to know this tool during our training course ‘Excel Power Pivot Introduction’! Are you already juggling with PivotTables in Excel? Then you will undoubtedly go wild with Power Pivot. What is Power Pivot? It is an extremely powerful tool in Excel. What exactly does it do? It very quickly […]
Excel: Expert
Description Our ‘Excel Expert: Excel’s Hidden Treasures’ training teaches you how to format reliable, useful Excel documents and tackles the most advanced software features. If you already know all the ins and outs of Excel and are looking for a challenge to hone your skills, this course is perfect for you. Objectives After this training, […]
Excel: Advanced
Description Do you know how to use Excel fluently, but do you feel like you could still improve your skills? Do you still need to master certain functions? Are you looking for tips on how to work more efficiently? If you’ve answered yes to these questions, you’ve come to the right place. Our ‘Excel: How […]
Excel: Formulas and functions
Description You know your way around Excel and you know the most popular Excel functions, such as SUM. However, the more complex your Excel tasks become, the more functions you need. These functions are exactly what you’ll learn in our ‘Excel: Formulas and functions’ training. After this training, you’ll no longer need to waste time […]
Excel: Tables and PivotTables
Description Working with Excel lists can be a tedious job. Are you looking for ways to get more out of your data? If so, consider using tables or PivotTables. Once you start working with them, you won’t be able to live without them. They help you analyse tables and calculate totals quickly and effortlessly – […]
Excel: Charts
Description A graph is worth a thousand numbers; when dealing with numbers, a visual representation is often easier to remember. Do you process numbers in Excel regularly and do you want to create useful charts effortlessly? Be sure to register for our ‘Excel: Charts’ training. Objectives After this training, you’ll know: Which charts to use […]
Excel: Dashboards
Description Why would you create a dashboard in Excel? The reason is simple: you can use it to visualise all your data. Dashboards are the ideal tool to report or present numbers. In our online ‘Excel Dashboards’ course, we’ll guide you through all the necessary steps, from importing and processing data to visualising everything in […]
Excel: Charts (Advanced)
Description Converting figures into useful charts: that is the subject of this remote training! In 3 hours you will learn all about the different types of charts and how to use them in different contexts. A topic you should not miss if you want to present your information using a clear and attractive method. Content […]
Excel: Functions
Description Everyone knows the most popular Excel functions, SUM, AVERAGE and COUNT. But if it’s all you know, you’ll never get where you need to go. Because as your worksheets expand and become more complex, you’ll have to use other functions and formulas. After completing the remote training Excel Functions, you’ll master the most popular […]
Excel: PivotTables
Description You are working with a large list of data in Excel? If you cannot see the forest for the trees, PivotTables will provide you with a clear overview of all the data collected. After this part two, you will know at a glance how many items meet a specific condition. You will also learn […]
Excel: Tables
Description Understanding your Excel data Do you have a huge amount of data? Good! But how to transform it into a manageable whole in order to obtain a comprehensible analysis? In this first part we will focus on converting your list into a table and how to optimise it for a powerful analysis. Target Group […]
Excel: Basic
Description Thanks to this training, you’ll be able to learn the basic principles of Excel. Taking our Excel Introduction training course? Then you’ll have chosen the ultimate springboard to the other training courses like Excel Databases and PivotTables and Excel Functions & Formulas. Objectives Do complex calculations feature in your daily tasks? Once it’s finished, […]
Access: VBA Programming
Description Make impressive applications with our Access VBA Programming course Automating your Access databases with macros? It’s a possibility. But it won’t be long before you come up against the limitations of macros. Visual Basic for Applications (VBA) is the solution you’re looking for! In our Access VBA Programming course, you’ll get to know the […]
Access: Advanced
Description Challenge yourself to become an Access expert If you have already acquainted yourself with Access by following the three previous modules offered by Xylos, then sign up for this fourth Access advanced module and further optimize your knowledge. Can you gather information from tables, optimize your database and automate reports and forms in Access […]
Access: Reports and forms
Description Create order in your database with our Access training course on reports and forms Does your database lack an easy-to-use, intuitive interface or not have one at all? Or would you like to display the results of queries in a more structured manner? With this Access training course you will be able to create […]
Access: Queries
Description Retrieving data? It’s simple with our ‘Access Queries’ training course! There is no better program than Access for structured storage of data. But if you don’t know how to retrieve specific information, then it’s not going to be of much help. For this reason Xylos developed the ‘Access Queries’ training course to teach you […]
Access: Databases
Description Want to create professional databases? Take an Access training course! Do you want to link your customers’ contact details to their orders? Or combine data from several sources into one database? Then without doubt Access is the program for you. Perhaps you are thinking: what about Excel? Because it’s a spreadsheet program, Excel is […]
