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: 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 […]
Access
