Learnit Training
« Back to all themes

Microsoft Training

Classroom

Course nameDuration






E-Learning

Course nameDuration




























link]

The main differences between Linux and Windows

Since time immemorial, there has been rivalry between two or more parties, and this is also true in the field of technology. The proliferation of systems, software and other features is increasing by the day, as knowledge about computer technology continues to grow and everyone wants to provide the best service. Similarly, there is a battle between operating systems Linux and Windows, but what are the features and benefits of both? In this blog we will tell you more about the differences between these two operating systems.

What is Linux?

Lunix is a free operating system that is not linked to any particular person or company. It is not necessary to have a licence to use its services. Linux is equipped with a command interface and a graphical interface. Because the software is free, everyone can customise it to their liking. One of the most powerful features of Linux is the separation of the user and the central part of the operating system (the kernel), which encourages the system to convert commands into understandable information and instructions.

What is Windows?

Windows is one of the largest operating systems in the world and has been launched in 137 languages. It is not only responsible for computers, but also for smartphones, tablets and other devices. Windows is from Microsoft and has different versions available for the target group. Unlike Linux, it has a paid licence, but can also be obtained free of charge.

Differences between Linux and Windows

Linux and Windows have a number of differences. The most important differences are listed below.

  • Windows is in part more advanced than Linux because it offers many different features such as Cortana Digital Assistant, Microsoft Window Edge and Microsoft 3D Lab;
  • Linux is free and Windows in most cases has a paid license. Unless you upgrade to a new version of Windows within 12 months of launch, you have to pay money, which can vary between €145 and €259. If you upgrade within 12 months you can often do so for free;
  • In contrast to Linux, Windows can be secured. Linux is an open source software, but in itself has a good security. With Windows, it is immediately recommended to install an antivirus programme;
  • Linux leaves the software free to change as desired, unlike Windows. With this option, every aspect of the operating system can be changed to suit your own taste;
  • Linux is especially interesting for people who know how to program or who like open software, because everything can be modified;
  • Linux can be much faster than Windows, allowing you to breathe new life into an old PC. This is because Linux generally needs fewer system resources so it feels faster;
  • Installing and updating systems remotely is easier with Linux than with Windows and at desktop level Linux has become very user-friendly.

Of course, Linux and Windows also have a lot in common. For example, they are both operating systems and can run multiple applications at the same time. They are compatible with any network and can develop both applications. However, despite their similarities, the differences are important and make them work slightly differently and are suitable for different issues.

Windows training

Would you like to refresh your knowledge of Windows? During our 2-day training Windows Basics you will learn the basic principles of Windows and you will be able to start working with the operating system! Click here for more information about the training or to register now.

link]

What are the advantages of SharePoint?

The decision whether or not to use SharePoint can be a difficult one for organisations. Especially if you are not completely familiar with the programme. The possibilities with SharePoint seem endless and the applications are fairly diverse. In order to make the right choice, it is important to look at the needs of the users. Learnit has listed a number of SharePoint advantages for you, which may make the choice whether or not to use SharePoint easier for you!

  • Intranet in the cloud. The fact that SharePoint is available in the cloud is one of its greatest advantages. Regardless of your location, the intranet can be accessed via desktop, tablet, smartphone or laptop. This makes the programme attractive and simple now that working from different locations is the new norm. In addition, SharePoint is always up-to-date, which means less time and cost spent on maintenance and updates.
  • Smart collaboration. Sharing documents is easy because SharePoint is a social platform. You can create different team sites where people from the same team can create and share documents. This makes collaboration effective and efficient.
  • One integral platform. SharePoint is integrated with Microsoft Teams, the Microsoft Office Suite and back-office systems. As a result, all necessary information is accessible via one portal, making information management a lot easier.
  • Work safely. Business information, personal data and sensitive documents need the best security. SharePoint has taken various safety measures to prevent data leaks, for example. In addition, documents can be safely shared with external parties such as clients or partners.
  • Personalisation without a developer. With SharePoint, the Intranet can be set up entirely according to your own wishes and needs, without the help of a developer. In addition, you no longer have to enter data manually, which means you avoid incorrect and duplicate data.
  • Smart search function. In large, complex intranet sites, it can be difficult to find the right, specific information. SharePoint has an extensive search function that immediately shows documents or intranet pages that match the search query.
  • Intelligent workplace. SharePoint has interesting features through the use of Artificial Intelligence, such as the chatbot to which employees can put questions. The functionalities offered by AI are being developed further and further as more data is available and there are more users.

Training or E-learning SharePoint

Did you know that Learnit offers both trainings and an E-learning in SharePoint? During our training SharePoint Basic you will get to work with the possibilities for end users as well as setting up and designing a site yourself. The core of the training SharePoint Advanced The core of the training is setting up and managing more complex sites. Would you rather work with SharePoint at your own pace? Then take a look at our E-learning SharePoint. link]

Microsoft PowerPivot as a tool for business intelligence

Are you an avid PivotTable user? With Excel you can effortlessly read data, insert pivot tables, place fields in the right place and use presto. This allows you to find the information you need in no time.

Only disadvantage: you can only use Excel data. Ideally, you would like to combine that data with information from other databases and, for example, the CRM system. Microsoft has thought of a solution for this: with the PowerPivot add-in, which you only have to activate, you can combine all kinds of files into a data model. Microsoft PowerPivot appears as an extra tab in Excel after you install it.

Business Intelligence

PowerPivot is a useful tool if you want to collect data within your organisation, in other words, if you want to take the first step towards business intelligence. This stands for the process of converting data into information, which should then lead to new knowledge. This allows you to make better strategic choices for your business.

In order to form an overall picture of your organisation, it is important that you use data from different databases. You have to transform that data, so that you can use it all together. This creates valuable information. You then want to display the results in a dashboard or report, after which you can make informed choices.

Data from different tables

PowerPivot is a useful tool for making these 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 right attributes. This way, your pivot tables become more versatile and your possibilities increase.

What are the differences with Excel?

Although PowerPivot is very similar to Excel, the two programmes differ in a number of ways. An example: starting with Excel 2010, the maximum number of lines is over one million. That may seem a lot, but it can cause problems with larger databases. PowerPivot has no such limit. The maximum number of lines is determined by your computer's memory.

Complex formulas

However, PowerPivot is not suitable for modifying data. Do you want to change data? Then do it in your source files. Pivot does have a number of other useful extra functions compared to Excel. These extra 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 discussed this in more detail. Watch this here free of charge.

link]

How to visualise data with Power BI

Within the company where you work, you like to work with data as effectively as possible. You want to move forward, and data is playing an increasingly relevant role in the decisions you make.

After all, you don't just look at figures from the past, but you also want to develop as a company. By making data transparent, it becomes easier for you to take the right steps. You can make large quantities of data transparent and visualise them with Power BI from Microsoft.

What is Power BI?

Power BI is an interactive tool by Microsoft for visualising data. This tool converts data from your company or organisation into analyses and clear reports. Among other things, you make effective management reports.

Previously, you might have done this in Microsoft Excel, but with this tool that is a thing of the past. Financial reports are converted into comprehensible dashboards and this ultimately results in new insights.

How do you visualise data with this tool?

For controllers, managers, financial directors and consultants, this tool is a godsend. After all, the easy visualisation of data is Microsoft's main goal. 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 these are then converted into a report or dashboard. The information can then be shared with those colleagues for whom it is relevant.

Why is it useful?

There are various reasons why it makes sense to use this Microsoft tool. We list the various advantages for you:

  • 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 and anywhere
  • It makes any business more efficient

Webinar

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.

link]

Perhaps the software release of the year: Office 2019!

One of the most anticipated IT releases for some time now is Office 2019. The new Office was already announced a year ago, but it won't be long now. The package is expected in the second half of 2018 and is already available to some companies.

Office 2019 vs. Office 365

Just a little longer and Microsoft will launch the new software bundle. There are a number of noticeable changes compared to the 2016 version. However, these changes will be the last, because unlike Office 365, there will be no major interim upgrades for this package. For Office 2019, you pay once for a perpetual licence, whereas with Office 365 you pay a monthly or annual fee. Microsoft does use the same code base for Office 2019 as for 365. This is no guarantee that Office 2019 will contain the same features, but it is obvious that there will be many similarities. For anyone familiar with Office 365, the changes will therefore be minimal. Compared to Office 2016, there are of course some changes.

OneNote changes

The OneNote app, which is widely used for taking notes, is also changing. Office 2016 includes a desktop version of this and a separate Windows app for Windows 10. The existing OneNote desktop app will therefore not receive any new functions, but Microsoft will continue to provide the necessary maintenance in terms of security and bugs until October 2020. The Windows 10 app, on the other hand, will receive updates with new features. Which updates these will be exactly, Microsoft will not disclose yet.

Real-time Excel

As of Office 2016, it was already possible to work in Word, PowerPoint and OneNote simultaneously when these files were in OneDrive or SharePoint. In Office 365, this 'collaboration tool' was also added for Excel. It is expected that this tool will also be available in Office 2019. This will soon make Excel files editable for several people at once. It is possible to choose participants and to set an expiry date, after which the file can no longer be edited by third parties.

Windows 10 and Mac

Unfortunately, Microsoft also wants to continue developing at a rapid pace. This means for users of earlier operating systems that Office 2019 will not work on those systems. For example, only the Windows 10 version of OneNote will be available in Office 2019. Changes such as these ensure that this new package is only suitable for Windows 10. They can breathe easy, because Microsoft is also developing a Mac version of this package.

Business Preview

For those who really can't wait any longer, the Business Preview may offer a solution. With this preview Microsoft gives companies the chance to test the package now. However, there are some requirements attached to this. Private individuals will unfortunately have to be patient a little longer.

More about SEO

Being able to handle the various facets of the Office package is a much sought-after skill in 2018. Updates such as Office 2019 mean that organisations benefit even more from the Office software. Learnit Training offers various instructive and fascinating training courses in the field of Office: from the basic training Access to the expert training Excel. We offer customised training, both individually and for groups. Take a look at all the Office training Learnit offers and who knows, maybe there is something for you!