Learnit Training
« Back to all themes

Microsoft Training


Course nameDuration


Course nameDuration


Microsoft PowerPivot as a tool for business intelligence

Are you an avid user of pivot tables? With Excel, you can easily read data, insert pivot tables, place fields in the right place, and use Presto. This allows you to quickly find the information you need.

Only drawback: You can only use Excel data. Ideally, you would like to combine those data with information from other databases and, for example, the CRM system. That's what Microsoft invented: With the PowerPivot add-in, which you only need to activate, you can merge a variety of files into a data model. Microsoft PowerPivot – English for powerful PivotTable – appears after you have installed the option as an additional tab in Excel.

Business Intelligence

PowerPivot is a useful tool if you want to collect data within your organization, or to do a first step towards business intelligence. That represents the process of converting data into information, which then leads to new knowledge. This makes it better to make strategic choices for your business.

To form a complete picture of your organization, it is important that you use data from different databases. You have to transform the data so you can use it all together. Dáárdoor creates valuable information. You will then want to display these results in a dashboard or report, after which you can make informed choices.

Data from different tables

PowerPivot is a handy tool to get to those choices, because you can combine data from different databases. You can import data from SQL, Access, and even text files — provided you give them the good features. This way your turntables become a lot more versatile and increase your possibilities.

What are the differences with Excel?

Although PowerPivot is much like Excel, the two programs differ in a number of respects. For example, as of Excel 2010, the maximum line count is more than one million. This seems to be a lot, but in larger databases it can cause problems. PowerPivot does not know that limit. The maximum line count is determined by your computer's memory.

Complex formulas

However, PowerPivot is unsuitable for modifying data. Want to change your data? Then do it in your source files. Pivot does have a number of other useful additional features compared to Excel. These additional options make it possible to do complex calculations.

Would you like to know more about these extra formulas for complex calculations? During the webinar PowerPivot: pivot table on steroids, Learnit trainer Roy explained this in more detail. Watch this here free of charge.


How to visualize data with Power BI

Within the company where you work, you will be happy to get started with data as effectively as possible. You want to move forward and this data increasingly plays a relevant role in decisions you make.

You don't just look at past figures, but you also like to develop as a company. By making data transparent, it is easier for you to take the right steps. Large amounts of data make you understand and visualize with Microsoft's Power BI.

What is Power BI?

Power BI is a Microsoft interactive tool for visualizing data. This tool converts your data from your company or organization into analyses and clear reports. You will make effective management reports.

Previously, you might have done that in Microsoft Excel, but with this tool that belongs to the past. Financial reports are converted into intelligible dashboards and this ultimately results in new insights.

How do you visualize data with this tool?

For controllers, managers, financial directors and consultants this tool is a godsend. The easy visualization of data is the main goal of Microsoft. This cloud service is available in two versions: a free version and a paid version.

From the tool you get the necessary data from a local server or computer and they are then converted into a reporting or dashboard. After that, the information is shared with those colleagues for which it is relevant.

Why is it convenient to use?

There are several reasons why it makes sense to get started with this tool from Microsoft. We put the various advantages for you in a row:

  • The tool is user-friendly and works very fast
  • A report or dashboard is easy to share, both internally and externally
  • A created dashboard is accessible anytime, anywhere
  • It makes every business more efficient


Are you curious about the possibilities of this tool within the company or organisation where you work? Learnit helps you on your way with a free webinar, which you can here can watch.


Perhaps the software release of the Year: Office 2019!

One of the most up-to-the-point releases of the IT area is Office 2019. A year ago, the new Office was already announced, but it really won't take long. The package is expected in the second half of 2018 and can already be seen for some companies.

Office 2019 vs. Office 365

So again, Microsoft launches the new software bundle. There are some notable changes compared to the 2016 version. These changes will remain, because unlike Office 365, there will be no major intermediate upgrades for this package. For Office 2019, you pay once for an perpetual license, where Office 365 charges a monthly or annual fee. Microsoft does use the same code base for Office 2019 as for 365. This is not a guarantee that Office 2019 will contain the same features, but it is obvious that there will be a large number of similarities. Therefore, for anyone familiar with Office 365, the changes will be minimal. Of course, compared to Office 2016, there is a change.

OneNote changes

This also changes the OneNote app, which is widely used to create annotations. Office 2016 includes a desktop version and a separate Windows app for Windows 10. OneNote's existing desktop app does not get new features, but Microsoft will still take care of the necessary security and bug maintenance until October 2020. On the other hand, the Windows 10 app will still follow updates with new features. Which updates are exactly what Microsoft does not want to release yet.

Realtime Excel

From Office 2016, you could work in Word, PowerPoint, and OneNote at the same time, when these files were in OneDrive or SharePoint. In Office 365, this ' collaboration tool ' was also added for Excel. The expectations are that this tool is also available in Office 2019. This will allow Excel files for multiple people to be processed at the same time. It is possible to choose participants and set an expiration date, after which the file is no longer editable for third parties.

Windows 10 and Mac

Unfortunately, Microsoft also want to develop rapidly. This means for users of earlier operating systems that Office 2019 on those systems will not work. For example, In Office 2019, only the Windows 10 version of OneNote is available. This kind of change will make this new package suitable only for Windows 10. "And Apple users then?", we hear your thinking. They can breathe safely, because Microsoft is also developing a MAC version of this package.

Business Preview

For those who really can't wait anymore, the Business Preview might be the solution. With this preview, Microsoft gives companies the opportunity to test the package right now. However, there are some requirements attached to this. Individuals will unfortunately have to be patient for a while.

More about SEO

Being able to cope well with the different facets of the Office Suite is anno 2018 a much needed skill. Updates such as Office 2019 make it even more useful for organizations to benefit from the Office software. Learnit Training offers several instructive and engaging training courses in the field of Office: from the basic training Access to the expert training Excel. We offer tailor-made trainings, both individually and for groups. Take a look at all the Office training courses that Learnit offers and who knows something is for you!