Learnit Training
« Back to all themes

Microsoft Training


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.

Wil je meer weten over deze extra formules voor complexe berekeningen? In het webinar PowerPivot: draaitabel on steroids ging Learnit-trainer Roy hier verder op in. Kijk deze hier gratis terug.


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?

Voor controllers, managers, financieel directeuren en adviseurs is deze tool een uitkomst. Het gemakkelijk visualiseren van data is namelijk hét doel van Microsoft. Deze clouddienst is beschikbaar in twee versies: een gratis variant en een betaalde versie.

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


Ben je nieuwsgierig naar de mogelijkheden van deze tool binnen het bedrijf of de organisatie waar jij werkt? Learnit helpt je op weg met een gratis webinar, dat je hier kunt bekijken.


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!


The 8 most convenient Office 2016 features

Microsoft Office, for many known as Word, Excel, PowerPoint, Access and Outlook, has been completely revamped for the 2016 edition. As in every new version, a lot of changes have been made, and we like to put the 8 most convenient of these on a row.

1. Real-time co-authorship

Collaborating efficiently is one of the main objectives of Microsoft Office 2016. It will not surprise you that from this version you can work with different people simultaneously on the same document. While you are already reading the first paragraph in your Word document, your colleague can continue to write to the following paragraphs, without your work being overwritten by the other. The same goes for PowerPoint, but Word has a unique perk: Here you can even see each other in real-time typing.

2. Send larger files

Send your PowerPoint presentation of 300mb by mail? This is no longer a problem in the new Outlook. As soon as you add an Office 2016 product as an attachment to an email, it will be converted into a link where the recipient can easily download the file. The only condition for this is that the file is already synchronized with a OneDrive account or a SharePoint folder.

3. Smart Lookup

The Smart Lookup function ensures that you don't have to leave Word, Excel or PowerPoint when you want to look up the meaning of a word in your document. Simply select the word in question, right click and then select the option "Smart Lookup". The results you receive are generated by Bing and will be displayed in an "Insights" tab within your document.

4. One-click Forecasting

Excel-Ninjas will undoubtedly count this feature up to their favorites. In the chart section of Excel, you can now conjure up predictions with a simple mouse click. To this end, Microsoft uses the standard "Exponential Smoothing algorithm (ETS) to show effective reliable forecasts.

5. Skype Integration

As mentioned earlier, working together efficiently is very important in Office 2016 and that also proves the Skype integration in the various desktop apps. This allows you to start a Skype call within Word, Excel or PowerPoint, both with Instant messaging, voice calls and video calls. But you can also without leaving the document, share your screen via Skype.

6. Office groups in Outlook

This is perhaps the least discussed novelty of Office 2016, but therefore certainly not the least useful. Thanks to Office groups, it has been done once and for all with traditional distribution lists or cluttered mail conversations. You can now bring together the colleagues you collaborate with in one group, which has a shared Inbox, Calendar, File store, and even integrated OneNote notes.

7. New graphs

For those who are looking forward to the standard charts in Microsoft Office, there is good news. In fact, new chart types have been added that help you to visualize financial or hierarchical data better.

8. Better cross-device support

Finally Office 2016 also puts a big step forward in cross-device support of various programs. Create your Word document on your smartphone, update it on your tablet and add the finishing touch to your PC, all can be done easier than before.