Learnit Training offers various instructive and fascinating training courses in the field of Office: from basic training Access to expert training Excel. We offer Office training tailored to your needs, both individually and in groups.
Live OnlineCourse nameDuration
Most people have heard of Google Analytics and some have linked their website to it. Yet not everyone knows how it works and what benefits they can get out of it. With Google Analytics, you can measure all activities to, on and from your website and form a clear picture of visitor flows and profiles, among other things. This information can help you set up targeted marketing, in order to increase the flow of visitors and therefore your profits. Google Analytics is therefore a handy and effective programme; the following five advantages demonstrate this further!
1. Insight into traffic sources. Visitors arrive at a website via various routes and channels. This could be via a search engine, an advertisement or social media. If you know more about where visitors come from, you have a better idea of the effect of the marketing activities.
2. Keywords report. The keyword report allows you to see which keywords brought visitors to the website. You can then see which keywords are the most searched for and which generate the most website traffic. With this information, you can optimize the website by changing keywords.
3. Image of visitors. As mentioned before, Google Analytics offers insight into visitor profiles, which gives you information about where your visitors come from, how often they visit your website and how many new and returning visitors the website has. You can also see on which device visitors visited your website. All this information gives you a better picture of your target group, allowing you to apply targeted marketing.
4. Understanding bounce rate. The bounce percentage tells you more about how your web pages are doing. Which pages do visitors stay on and which do they click through quickly? A bounce is when a visitor leaves immediately after having visited one page on your website. A high bounce rate means that a landing page is less relevant to visitors. If you know which pages have a high bounce percentage, you can take targeted actions.
5. No obligatory costs. Google Analytics is a free programme from Google, but in spite of that it has as many functionalities as other programmes.
Google Analytics training
Did you know that Learnit offers a training on Google Analytics? During our training Google Analytics Basics you will learn the basic principles and how to use them in the right way to get clear insights. Click here for more information about the training or to register directly.link]
Power BI is a Microsoft programme that has seen a sharp increase in the number of users in recent years. The programme is extremely suitable for making management reports. With Power BI you will be able to perform relevant data analyses and visualise them immediately, even if you are not a programmer or data scientist. Read more about the advantages Power BI has to offer.
Power BI training
Did you know that Learnit offers two different training courses in Power BI? During our training Power BI Basic You learn how to make effective management reports in Power BI with data from Excel and how to use this to create interactive management dashboards. The core of the training Power BI Continuation lies in the numerous possibilities that the DAX functions in Power BI have to offer. Click on the training for more information or to register directly. link]
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!
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]
From creating a simple table to retrieving data using filters and queries, the possibilities in the Access programme are endless! Access is very similar to Excel, with the difference that in Access you can create relationships between different tables. Because the programme makes clever use of a graphical interface, even you as a (starting) user will be able to set up your own database. In this blog we will discuss the most important features of Access to give you a good idea of its capabilities. This will show you whether Access is the right programme for you!
The basis of almost all Access files consists of tables. In these tables you can enter information that you need and link different tables together. It is very important to set up the tables correctly in the beginning and to link them with each other properly, because otherwise you will run into inaccuracies later in the process. Each row in a table has a unique 'ID number', which you need to refer to something in the table. You need this ID number to refer to 'something' in your table with a unique name, because the rows themselves have no unique values.
The primary fields within a table contain a unique name that you need to distinguish the different rows in a table. The reason Access uses unique names in primary fields is because of the following. If the table contains names and there are several people with the surname 'de Boer', the system will not be able to distinguish between Eva de Boer and Emma de Boer, even though they are two different people. Such a unique name can make the difference in a table. You could therefore compare this unique name with a citizen service number (BSN) or national insurance number, with which the government has given each person a unique code in order to distinguish people from each other.
A referral field is used to refer to another table. It allows you to turn a column into a 'lookup and relationship' column, which allows you to refer to another table. You might wonder when you would make use of such a referral field. For example, in the following situation.
Suppose you want to conduct research into the corporate culture within a large national organisation and you have a file in which you have stored the details of all the employees of the organisation (name, address, employee number). At a certain point you decide to interview various people from this file in order to obtain more information about the working atmosphere. It is then handy to create a separate file in which you can keep a record of who you have spoken to each employee in order to avoid any misunderstandings. In Access, you could create a separate form in which you keep a record of who you have spoken to on what date and at what location the interview took place. To be able to link this to a person who can be found in the first file in which you have stored all the data of all employees, you will need a unique characteristic. This could be, for example, the unique employee number that each employee has. All you need to do then is enter this number in the reference field and Access will automatically link a name and address to it.
In the example above, we talked about forms. This is a function within Access that allows you to easily convert information from the desired columns of a table into a form. Once you've created this form, you can use a simple interface to enter all the data to add a new row without having to add it to the table linked to the form. This way you can't accidentally make a mistake or delete a previously added row. Handy, right?
Do you think after reading this blog that Access might be a useful program for you, but don't know the best way to start processing information using Access? Then we have the perfect training for you! In our two-day training course Access Basic you will learn all the basic skills you need to get started with Access. From creating a simple table to retrieving data using filters and queries, and from creating handy fill-in forms to presenting information in various reports. After completing this training course you will have the knowledge and skills to make working in Access a success from now on. Click here for information about the course.link]
A crucial factor for the success of projects is good communication. Although e-mails are widely used in business, an e-mail system is not the best choice for communication during a project. Here are three reasons why you should choose another tool during project management.
1. Central storage system
A project contains a lot of information. A lot of information. E-mail systems are not ideal for organising and storing this information. There is a lot involved in a project: not only one-to-one conversations and files, but also ideas, reports and statistics are often part of a project. The lack of a central and organised storage system can cause a lot of confusion, delays and duplication of work. Your time as a project manager and staff member is valuable, so make sure you use your time effectively!
2. Task management
A disadvantage of e-mailing is that you don't get a standard update on how things are going. Unless someone specifically sends you an e-mail in return or you regularly ask the person in question, it is not clear how the tasks are progressing exactly. In addition, only the people who actually receive the e-mail are kept informed; other team members can easily (unintentionally) be excluded from the update.
By using an effective project management tool, all tasks are clearly displayed and tracked. The tasks can be well described and sorted by priority. This allows the project manager to easily follow the status of the project without sending an e-mail or asking personally.
A project goes hand in hand with risks and unpredictability. As a project manager and project team, you must be well prepared for sudden change. In case of an emergency, the project manager must be able to quickly find a suitable solution with the available resources. Unfortunately, e-mail systems do not provide the overview that a team needs in an emergency. The use of a tool specifically made for projects, on the other hand, provides good support in the face of risk and uncertainty.
But what will be your best friend during projects? A system especially made for projects is Microsoft Project. Ms Project has been one of the most important planning programmes for the workplace for years. There are currently three versions: 2010, 2013 and 2016. Learnit Training offers various courses, so that you can quickly obtain the general project management knowledge you need to plan, manage and report on projects. Click on one of the years above for more information about Learnit's MS project training courses.link]
Excel is one of the most widely used software programmes in the workplace. It is therefore not entirely unexpected that it has millions of users worldwide. Over the years, there have been many updates to Excel. Would you like to know which features Excel has recently released (in 2019 and 2020)? Then read this blog and find out if there are any interesting possibilities for you!
1. Basic functions
Some of the basic functions introduced in the last two years include:
2. Pivot table functions
In addition to a number of basic functions, a number of useful pivot table options have been added in recent years:
3. Excel charts
Did you know that Excel has also added two new types of charts in the last two years?
Excel training courses
Did you know that Learnit offers nine different Excel training courses? From the training Excel Basic to Excel Expert and from Excel Pivot tables, formulas and functions to Excel PowerPivot, Learnit has it all! For a complete overview of our Excel training courses, click
Many people use Excel for (relatively simple) data analyses. When you want to perform more complicated analyses in Excel, you run into a number of problems. You can easily make a mistake which is difficult to trace and Excel is very slow when you are working with large data sets. Moreover, it is also difficult to reproduce a previously used analysis, because it takes some effort to trace which steps were taken earlier. You can easily avoid these problems by making smart use of the SQL programming language. Are you thinking of switching from Excel to SQL? Then it is important to take into account the following differences and properties!
SQL training courses
Did you know that Learnit offers various training courses in SQL? During our training SQL Basics you learn how to easily retrieve relevant data from your database. In the training SQL Advanced not only the basic concepts within SQL are dealt with, but we also play with deeper SQL commands, in the form of T(ransact)-SQL. In addition, we also offer a training SQL Report Builder training. SQL Report Builder offers various visualisation possibilities, allowing you to create a professional report from your data. Ideal, for example, if you want to make a management report! Click on the orange buttons below for more information about one of the SQL trainings mentioned or click here for the complete overview of SQL training courses from Learnit.link]
In the meantime, it is slowly becoming clear that most of us will be sitting at home until at least the middle of 2021 and will therefore have to work at home. This means that for the coming year, too, there will be many online work activities on the agenda. How can you best prepare yourself and your organisation for an online 2021? In this blog, we will explain which training courses are the perfect fit for online work!
1. Search engine optimisation (SEO). How do you ensure that you attract as many visitors as possible to your website? Search engine optimisation, also known as SEO, is the solution! Learnit offers a course in which not only the basic principles of search engine optimisation are shared with you, but in which you also work on your practical skills. For example, learn how to analyse and optimise your own website. This way, you can get the most out of your website and web traffic in 2021!
2. Online marketing. Developments on the Internet are taking place at a rapid pace. Online marketing is a theme that played an important role for many organisations last year, and the expectation is that online marketing will possibly play an even bigger role in 2021. Can your organisation still learn a thing or two when it comes to online marketing? Then take a look at our new 7-day online marketing course. During this comprehensive course, you will learn all the skills necessary to put your organisation firmly on the (online) map. Topics that are covered during this course are: search engine optimisation, Google Ads, Google Analytics, Facebook advertising, e-commerce, social media marketing and content marketing.
3. Power BI Basics. Now that we (almost) no longer see or speak to each other physically on the work floor, it can sometimes be difficult to convey certain information to colleagues. Think about financial reports for example. For this kind of information, it can be useful to use a visualisation tool that allows you to easily show colleagues what is going on from a distance. One of the most popular visualisation tools is Power BI. Learnit offers a 2-day Power BI course, in which you learn to create effective management reports using your Excel data. In this way, Power BI allows you to create an interactive management dashboard, in which you can easily visualise and share data with your colleagues. Ideal for transferring information!
4. Agile Scrum Basics. Scrum is nothing but an Agile framework, which stands for more effective and flexible work. The Agile way of working allows for working in self-managing teams, which is extremely useful for planning more complex projects. The focus of Scrum is on the communication within these projects, but also on the interaction between departments and towards customers. Now that online working is the order of the day, you see many companies making use of this structured way of (online) working. Are you curious whether working according to this style is something for your organisation? Then take a look at our Agile Scrum Basic training. During this training you will not only learn the theory around this method, but also the skills that come with it play an important role. Did you know that there is the possibility to take an official exam after the course, after which you can call yourself Scrum Master or Scrum Product Owner? Click on the training course or inquire about the possibilities.link]
For years, Excel has been the favourite of companies for analysing and visualising data, but this could be about to change. There is an alternative on the market and it is very promising. Power BI allows you to experiment with visualisations, statistical functions and calculations on a wide range of datasets in a much faster way, and it also offers you the possibility to quickly create different solutions thanks to the smooth regrouping of the fields.
Here is a list of 5 reasons to start using Power BI:
1. Storage and access to a large amount of data
In Excel, it is difficult for most computers to open a file of, say, 300 megabytes, or to open several small files at once. With Power BI, you won't have a problem at all thanks to powerful built-in compression algorithms. This makes exchanging and opening data a task that requires little effort and no adjustments. Furthermore, the software remembers the settings you use, such as relationships between tables, so you don't have to repeat them constantly.
2. Easy data visualisation
Besides being very fast, your data will also look very nice in one of the many available graphs, tables, maps, workflows, etc. You can easily customise these, which will ensure that your reports will ultimately look very nice. You can easily customise these to your liking, which ensures that your reports end up looking very nice.
3. Power BI on all platforms
A nice extra of Power BI is that you can also convert your report into something that is easy to see on the phone. Because the programme can make the data smaller and arrange it differently, your report will not only look good on the computer, but also on the phone: ideal for the times in which we live.
4. Use one of the many templates
Power BI also offers a wide range of templates to work with. So, if you need to write a report quickly or if you need some inspiration, Power BI can help you out. Power BI offers an overview of predefined reports and dashboards that you can take over immediately and fill with your data.
5. Integration with all Microsoft products
Power BI does not have to be a stand-alone application, you can easily integrate it with other Microsoft software. You can configure the programme so that you receive alerts in your mail when a goal in Power BI is not achieved and you also have seamless integration with Excel.
Watch the webinar
Did this blog make you enthusiastic about Power BI? Then please watch herethe free webinar about Power BI from 20 February 2020. Maaike will show you how to use Power BI with the help of examples.link]
A modern company that wants to keep up with the times is moving more and more of its work to the cloud. It is therefore not surprising that the number of organisations that now use Microsoft Office 365 has increased significantly. But once you are in your digital workplace, are you also taking full advantage of the possibilities and benefits of this online software?
Whether you are familiar with this new version of Office or not, you should save this coming 14 February in your agenda. Between 11.00 and 11.30 hours you can participate in a free webinar, organised by Learnit. During this online meeting, you will be completely updated on the latest developments regarding Office in the cloud and the new applications Teams, Flow, Planner and Forms. Are you not familiar with these tools? Here is a short introduction.
Working in a virtual environment, also known as the cloud, offers companies and organisations many new challenges. Thanks to an online subscription to Office, your workplace is no longer limited to that one desk in your office. Your workplace is the world and can be accessed from any device. You can get straight down to work anywhere. This makes modern organisations dynamic and flexible.
Teams is a tool that enables collaboration in an online office. Are you on the way to an appointment? No problem, you log into the digital Office workplace, check for new messages, look something up in a document and discuss the latest developments with a colleague in real time. This way, you arrive at your appointment completely up-to-date.
Flow brings order to your often chaotic information flows. By creating your own automatic workflow, you can bring together various applications such as e-mails, tweets, dropbox, etc. in one place.
Thanks to Planner, it is easy to make a plan, form a team and assign a task to yourself or others. This way, the whole team is aware of its task and everyone is aware of how the plan is implemented.
Forms is an ideal tool to create a survey or quiz. This makes it easy to find out whether customers are satisfied with your product or service and what the staff think about the latest reorganisation, for example.
With these new, handy tools from Microsoft, there are of course many more possibilities. Are you curious what they can mean for your organisation? Watch trainer Roy's webinar about Office 365 here.link]
How do you use Google Adwords effectively? An advertising campaign that is poorly executed can cost an organisation more than it likes. It is important that you have enough knowledge about Adwords, so you can handle the campaigns smartly. We have listed 3 common mistakes so that you are one step closer to a successful Adwords advertising campaign.
Mistake 1. Blindly trusting your own ad
Although you may love your own ad, the statistics can show you something completely different. You can't look inside other people's heads, so you can't be sure that others will love your ad. Make sure you test different versions of your ads. For example, vary your title or shorter content. This way you can see which version leads to more visitors and sales.
Don't make the mistake of immediately falling in love with your ad while your target audience doesn't feel a single click. Keep testing! Always try to beat your own ad, with an even better version. Choose the version that has the highest conversion rate or the lowest cost per acquisition (CPA).
Mistake 2. Not using negative keywords
In addition to 'positive keywords', keywords for which you do want to be found, AdWords also offers the possibility of using 'negative keywords'. These are keywords with which you do not want to be found. An example: Learnit provides various training courses in the field of communication, management and IT. A positive keyword for us could be training. Conversely, Spanish training could be a negative keyword for Learnit, because we do not provide training for the Spanish language. When someone searches for Spanish training, Learnit will not appear.
Negative keywords can be added via AdWords by clicking on 'Negative keywords' under the list of keywords for your campaign or ad group. Negative keywords can be added for a specific ad group or for the entire ad.
But which words should you add to the negative keywords? The best way to find out is to use Google Analytics. Go to Acquisition > Adwords > Matched Search Queries > Query Match Type > choose from broad match or phrase match. Take a look at the keywords that are not working. Are there any negative keywords that you can add that will not get rid of good working keywords?
Mistake 3. Not being aware of your own competition
Another common mistake: you are not aware of your competition, what search terms they use and how their ads and pages look. Put yourself in the shoes of your customers: which ad appeals the most? Which ad would you click on first?
Why is your competitor better known or lesser known? Look not only at how the ads look, but also at where they are referred to. How does this differ from your own ad and page? Is there a better design, text or keywords? Test the positive observations in the new version of your own ad. Is the conversion rate going up? Or maybe even down. Again: keep testing, an advertisement is never perfect!
Google AdWords Basic and Professional training
Need more tips? Learnit Training provides two training courses for Google AdWords: a basic training for beginners and a professional training for advanced users. The Google AdWords Basic training, in combination with the Google AdWords Professional training, connects to the certification of Google AdWords, which can be done on your own initiative after completing this training.
In the training Google AdWords Basis you learn step by step how Google AdWords works, how to set up your account and how to create a campaign. Thereby we look at what your competitors are doing online and how your target audience is looking for companies like yours online. Finally, you learn how to monitor and improve the performance of your campaigns, and how to create a dashboard and automatic reporting.
In the training Google AdWords Professional you learn to work more strategically with Google AdWords, by making a better translation of your business goals to the design of your campaigns. All advanced possibilities of Google AdWords are discussed, like ad extensions, automatic bids and remarketing. You get to work in practice with those elements that are specifically interesting to you.link]
Whether it is providing structure, communicating clearly with your team or communicating a vision: project leaders need to be versatile in order to lead their team to good results. Six important tips for today's project leaders.1. Determine the project goals.
Clear project objectives will determine the focus of your project: therefore be as specific as possible. By clearly formulating the project objectives, you prevent people from being too preoccupied with side issues.2. Have a clear vision.
A good project manager creates clarity and inspires the rest of the team. A useful tool in creating clarity is the use of visual aids (diagram, graph or drawing). A clear vision ensures that all noses are pointed in the same direction.3. Ensure clear communication.
To work successfully in projects, clear, open communication is essential. Be clear about the goals and the progress of the project. This ensures greater commitment from everyone working on the project (client, project leader, team members, line managers and the users). In addition, it is important that everyone is aware of his or her responsibilities within the project. If the responsibilities are not clear, there is a chance that a project will be delayed. Good communication is therefore indispensable for pleasant and effective cooperation.4. Provide leadership.
Besides setting up, structuring and controlling a project, providing leadership to the team members is an important part of project leadership. Convincingly communicate the project goals and ideas. This will enthuse and motivate the team members. A positive attitude shows that you are committed to the project. Give the team members confidence by, for example, delegating certain matters.5. Provide structure.
A project can be complex and hectic. Structure is then very important to keep the overview. Make use of a good folder structure that is accessible for the entire project team and make a clear planning using, for example, MS Project.6. Evaluate the project.
Evaluation is a step that is often skipped, while it is an important learning moment. Make sure the whole team participates in the evaluation of the project. What went well? What went less well? What can we do better next time? Evaluation is needed at every milestone, not just at the end of the project. If there is no evaluation, the chance that the next project will fail is higher.
Do you want to grow in your role as project leader? Then our three-day Project Leadership training is for you. During this training we pay attention to your personal leadership style. After all, your leadership must ensure that you can make a project a success. During this training you learn how to convincingly communicate your ideas. This way you can enthuse and motivate your team members. You also learn to bring out the best in people and recognise individual qualities. We also pay attention to contact with the client; for example, how do you ensure that this is done as effectively as possible? After following this training, you will know how to become and remain the most important force in the team!link]
Do you spend a lot of time searching for emails? Ideally, your inbox, or digital workspace, should be as empty as possible. In this blog we will give you three handy tips, using the settings in Gmail as an example:
Almost all e-mail programmes give you the opportunity to personalise your inbox. By processing incoming e-mails in a structured way, you can keep a good overview. How often do you have to search endlessly through your inbox to find that one e-mail? Use 3 main tags: what you need to do, what you need to reply to and what you have completed. In Gmail, set this up as follows:
The image below shows an example of what your "to do" folder might look like:
By creating 3 main labels at tip 1, you have already worked with labels, but you can expand this by creating additional labels for your various activities. Think for example of customer contact, promotional matters or work meetings. You set up the labels in the same way as in tip 1. These labels can also be given a colour.
In the image below you can see an example of how your label "customers" could look like. You can also see the status at a glance, because in tip 1 you already created three folders for your incoming e-mails:
You know the situation: you send an e-mail to someone with a request or question, but have not (yet) found a good way to keep track of whether you have received a response. This can result in the fact that it sometimes occurs to you too late that you still need to know something from someone.
You can prevent this by putting yourself in the BCC of e-mails in which you are waiting for a response from someone else. You can set up a filter in Gmail that sends all e-mail that comes from your e-mail address and where you have put yourself in the BCC, directly to the folder 02 | Waiting for reply created in tip 1:
In our two-day Time Management training, you learn to manage your time efficiently and go home a lot less stressed at the end of the day. You will not only learn practical tips like those in this blog, but you will also learn to reflect on your own thinking and actions. Did you know, for example, that assertiveness and delegation skills also play a major role? Discover it in our training!
Learnit Training provided an extensive introduction course for both beginners and advanced users for approximately 90 employees of Nuon. Because of its versatility, Microsoft Office is an indispensable software package for many office workers. But for people 'in the field' or 'on the floor' it can be very different - some have never even used it. To make its staff more crisis-proof, Nuon decided to look for an Office training for both office and field staff and ended up at Learnit Training.
The differences between the two groups were significant. Employees from the operational, often somewhat lower-educated group had in some cases hardly worked with any Office components and were also not used to sitting at a computer for long periods of time. The higher educated office workers were mostly advanced users of certain Office components. The training, which would take about eight days for both groups and consisted of the components Excel, Word and Outlook, was therefore provided at both beginner and expert level.
Learnit Training's decision to offer this training in a classroom setting, which meant that all participants carried out the same assignments at the same time, was well received: there was still enough room to work at a slightly higher or lower pace, and employees who found certain tasks more difficult could pull themselves up by their colleagues. During this large in-company training Learnit Training also tried to emphasise why certain things in Office work as they do. In short, there was attention for the logic behind the software, which was especially appreciated by the beginners.
"The training gave us a good idea of how the basics of Office work and how to use them.
"The trainers was very good in his communication, had good leverage and clearly enjoyed his work."
"I found it very useful information. I have become much wiser about Office."