Excel: VBA programming
Description Save time with our ‘Excel: VBA Programming’ training Excel is a powerful application. Have you encountered situations where you had to insert the same data or execute the same actions over and over? If so, you’ll be thrilled to hear that you can avoid these time-consuming repetitions. Create a user-friendly form? Set up the […]
Excel Power Query: Importing and editing data
Description Power Query: your tool to automate lists! You often have to re-edit the data you enter into PowerPivot: splitting up the text into different columns, converting text to upper case, adding extra columns with certain calculations, filling up blank cells and much more. This means that you can’t use certain sources straight away, because […]
Excel Power Pivot: 2. (DAX) Functions for powerful data analysis
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: 1. Introduction
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: hidden treasures
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: Increasing your efficiency (advanced users)
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
Excel: Introduction (starters)
Description Let your PC do the thinking: follow our Excel training for beginners. Do you have little experience with Excel, but does your job require you to use the software? Or do you already work with the software, without knowing everything you can do with it? Looking up everything yourself can take a lot of […]
Excel: Dashboards – Visualise your data (Excel 365)
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: Impress with charts
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: Power Query – Importing and editing data with Power Query
Description You often have to re-edit the data you enter into Power Pivot: splitting up the text into different columns, converting text to upper case, adding extra columns with certain calculations, filling up blank cells and much more. This means that you cannot use certain sources straight away, because you first need to delete unnecessary […]
Excel: Power Pivot
Description Are you already juggling with PivotTables in Excel? Then you will undoubtedly go wild with PowerPivot. In this session you will learn how to effortlessly merge an Excel list with an Access database. Or with a table originating from an SQL server. And not only that, this rock-solid tool has masses of new functions […]
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: Performing tricks with 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: Working with lists and 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: Introduction
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 […]
