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 Office trainings tailor-made, both individually and for groups.
Live OnlineCourse nameDuration
From creating a simple table to retrieving data using filters and queries, the possibilities in the Access program 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, you too can set up your own database as a (novice) user. 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 program 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, otherwise you will run into errors 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 last name "de Boer", the system will not see the difference between Eva de Boer and Emma de Boer, even though these are two different people. Such a unique name can make the difference in a table. This unique name could therefore be compared to a burgerservicenummer (BSN) or sofi 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. This 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. 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 would then be handy to create a separate file in which you can keep a record of who you have spoken to, in order to avoid any misunderstandings. In Access you can 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 details of all your employees, you will need a unique identifier. For example, this could be 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 feature 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 prevents you from accidentally making a mistake or deleting 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 Basics 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 useful forms to presenting information in various reports. After completing this course you will have the knowledge and skills you need to make working in Access a success. Click here for information about the course.Link
A crucial factor for the success of projects is good communication. Although emails 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 opt for 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 orderly storage system can cause a lot of confusion, delay and duplication of work. Your time as a project manager and employee 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 of the state of affairs. Unless someone specifically sends you an e-mail back or you ask the person in question on a regular basis, 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 monitored. The tasks can be described well and sorted by priority. This allows the project manager to easily track the status of the project, without sending an e-mail or requesting it 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, offers good support in the face of risk and uncertainty.
But what will be your best friend during projects? One system made especially for projects is Microsoft Project. Ms Project has been one of the leading workplace planning programs 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 programs 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 expand Excel. Do you want to know what features Excel has released recently (in 2019 and 2020)? Then read this blog and find out if there are interesting opportunities for you!
1. Basic functions
Some basic features introduced in the last two years include:
2. Pivot table functions
In addition to a number of basic functions, a number of handy 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?
Interactive webinar and Excel training
On 6 April between 9:30 - 12:30 Learnit organises an interactive webinar Excel. During this webinar you will work practically with an example of a sales file under the guidance of Learnit expert Roland. He will share his valuable knowledge and practical tips with you, so that you can extract important insights from your data. Click click click here for more information about this webinar. Did you know that Learnit also offers nine different Excel training courses? From the training Excel Basics 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 work with large data sets. Furthermore, it is also difficult to reproduce a previously used analysis, because it takes some effort to find out 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!
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 Continuation 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. We also offer a training SQL Report Builder training. SQL Report Builder offers various visualization options, allowing you to create a professional report from your data. Ideal if you want to make a management report, for example! 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
Power BI is a program from Microsoft that has seen a sharp increase in the number of users in recent years. Power BI is an excellent tool for creating management reports. With Power BI you will be able to perform relevant data analyses and visualize them right away, even if you are not a programmer or a data scientist. Read on to find out more about the different 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 Basics 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 Advanced 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]
In the meantime, it is slowly becoming clear that we will mostly be working from home until at least mid-2021. This means that for the coming year a lot of online work activities will be planned. 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 optimization (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 take place at a rapid pace. Online marketing is a theme that played an important role for many organizations last year, and it is expected that online marketing may play an even bigger role in 2021. Can your organization still learn a thing or two when it comes to online marketing? Then check out our new 7-day online marketing course. During this comprehensive course you will learn all the skills necessary to put your organization firmly on the (online) map. Topics that are covered during this course are: search engine optimization, Google Ads, Google Analytics, Facebook advertising, e-commerce, social media marketing and content marketing.
3. Power BI Basics. Now that we do not see or talk to each other physically anymore it can be difficult to communicate certain information to colleagues. Think about financial reports for example. For this kind of information it can be useful to use a visualization tool that allows you to easily show colleagues what is going on. One of the most popular visualisation tools is Power BI. Learnit offers a 2-day course Power BI, in which you learn to create effective management reports using your Excel data. In this way, you can use Power BI 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 else than 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 that many companies use this structured way of (online) working. Are you curious if 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, also the skills that are involved play an important role. Did you know 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
Excel has been a company's big favourite for analyzing and visualizing data for years, but this could change sooner or later. There is in fact an alternative on the market and it is promising. Power BI allows you to experiment with visualizations, statistical functions and calculations on a wide range of datasets in a much faster way, and the program also allows you to quickly create different solutions thanks to the smooth regrouping of the fields.
Below is a list of 5 reasons to start using Power BI:
1. Storage and access to a large amount of data
In Excel, most computers quickly find it difficult to open a file of, for example, 300 megabytes, or to open several small files at once. With Power BI you will have no problem with this thanks to the powerful built-in compression algorithms. This makes the exchange and opening of data a task that requires little effort and no adjustments. In addition, the software remembers the settings you use, such as relationships between tables, so you don't have to repeat them all the time.
2. Easy data visualization
Besides the fact that it goes very fast, your data will also look very nice in one of the many available graphs, tables, maps, workflows, etcetera. You can easily customize these to your wishes, which will make your reports look great in the end.
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 program can make the data smaller and divide it differently, your report will not only look good on the computer but also on the phone: ideal for the time in which we live.
4. Use one of the many templates
Power BI also offers a large overview of templates to work with. If you need a quick report or need some inspiration, Power BI can help you out. Power BI offers you an overview of predefined reports and dashboards that you can immediately take over and fill in with your data.
5. Integration with all Microsoft products
Power BI doesn't have to be a stand-alone thing, you can easily link it to other Microsoft software. For example, you can set up the program to receive alerts on your mail if a target in Power BI is not achieved and you also have seamless integration with Excel.
Webinar look back
Did this blog get you excited about Power BI? Then take a look herethe free webinar on Power BI back from 20 February 2020. Maaike will show you how to start using Power BI with examples.Link
A modern company that wants to keep up with the times is moving more and more of its operations to the cloud. It is therefore not so strange that the number of organizations that now use Microsoft Office 365 has strongly increased. But once you're at your digital workplace, do you take full advantage of the possibilities and benefits of this online software?
Whether or not you are familiar with this new version of Office, next February 14, you should keep it free in your diary. You will then be able to participate in a free webinar between 11.00 and 11.30 a.m. organised by Learnit. During this online meeting you will be fully updated on the latest developments regarding Office in the cloud and the new applications Teams, Flow, Planner and Forms. 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, that's the world and can be accessed from any device. You can get started from anywhere. That makes modern organisations dynamic and flexible.
Teams is a tool that enables collaboration in an online office. Are you on your way to an appointment? No problem, you log into Office's digital workplace, see if there are any new reports, look up something in a document and discuss the latest developments with a colleague in real time. So you arrive at your appointment completely up-to-date.
With Flow you bring order into your often chaotic information flows. By creating your own automatic workflow, you can put together various applications such as mails, tweets, Dropbox etc. in one place.
Thanks to planner It is easy to create a plan, form a team and assign yourself or others a task. For example, the whole team is aware of its task and everyone is informed about how the plan is being implemented.
Forms is an ideal tool to create a survey or quiz. This makes it easy to know if customers are satisfied with your product or service and how the staff thinks about the last reorganization, for example.
With these new, handy tools from Microsoft, a lot more is of course possible. Are you curious what they can do for your organization? Take a look at trainer Roy's webinar about Office 365 here.Link
How do you effectively set up Google Adwords? An advertising campaign that has been run poorly can cost an organization more than its love. It is important that you have enough knowledge of Adwords. So you can cleverly handle the campaigns. We've listed 3 common mistakes, so you're a step closer to a successful Adwords advertising campaign.
Error 1. Blindly trust in your own advertisement
Although you may love your own ad, the statistics may show you something completely different. You can't look into other people's heads, so you can't be sure that others will love your ad as well. 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 turnover.
Do not make the mistake of immediately falling in love with your ad while your target audience that the ad is for is not feeling a single click. Keep testing! Always try to beat your own ad, with a better version. Choose the version that provides the highest conversion rate or the lowest cost PER acquisition (CPA).
Error 2. Do not use negative keywords
Besides ' positive keywords ', keywords that you want to be found on, AdWords also gives you the opportunity to use ' negative keywords '. These are keywords that you don't want to be found on. An example: Learnit gives different trainings in the field of communication, management and IT. A positive keyword could be for us training . On the other hand, 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 ' below the list of keywords for your campaign or ad group. The negative keywords can be added for a specific ' ad group ' or for the entire advertisement.
But what words should you add to the negative keywords? It's best to find this through Google Analytics. Go to Acquisition > Adwords > matched Search Queries > Query Match Type > Choose from Broad match of phrase match. Throw a look at the keywords that don't work. Are there any negative keywords that you can add so that good working keywords are not deleted?
Error 3. Not being aware of your own competition
Another common mistake: you're 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 advertisement is most appealing? Which advertisement would you first click on?
Why is your competitor more familiar or less familiar? Don't just look at how the ads look, but also where they are referred to. How does this differ with your own advertisement and page? Is there a better design, text or keywords? Test the positive observations in the new version of your own advertisement. Is the conversion rate going up? Or maybe even down.. Again: Keep testing, an advertisement is never perfect!
Training Google AdWords Basic and professional
Need more tips? Learnit Training provides two training courses for Google AdWords: A basic training for the beginners and a professional training for the advanced. The Google AdWords Basics Training, in combination with the Google AdWords Professional Training, is Based on the Google AdWords certification, which can be done on its own initiative after completing this training.
In the training Google AdWords Basic you will learn step by step how Google AdWords works, how to set up the account and how to set up a campaign. In addition, we look at what your competitors do online and how your target group searches online for companies like yours. Finally, you will learn how to monitor and improve the performance of your campaigns, and how to create a dashboard and automatic reporting.
In Google AdWords Professional Training, you'll learn more strategically with Google AdWords, by making a better translation of your business goals into the organization of your campaigns. All the advanced features of Google AdWords pass through the revue, such as ad extensions, automatic bidding, and remarketing. In practice you will get to work with those parts that are especially interesting for you.Link
Grab your smartphone, start your internet and go to your website. What do you see? A website that fits well with your mobile, both portrait and landscape? Or not? In The latter case you have no responsive website. Sin! Mobile traffic has risen unprecedentedly in recent years and will continue to rise. 4 out of 5 Dutchmen has a smartphone and 90% used his or her phone to Internet. Visitors through a smartphone or tablet represent a large share of total Internet traffic. You should not lose sight of them!
Better User Experience
Many Internet traffic runs today via a smartphone or tablet. Do you have a website whose content is well readable on all different electronic devices? With a responsive website, the visitor is not concerned with zooming in and out of images and texts in order to read and see them properly. Your website automatically adapts to the visitor's screen, making the text always legible. If your visitor cannot find what they are looking for via a smartphone, the odds are 61% that the visitor leaves the website immediately. Do visitors have to wÃ © L with the texts and images? Visitors will drop off faster and leave your website. A responsive website is a must!
The importance of a fast website
Google recommends that loading your website page may take up to two seconds. A load time of more than four seconds is considered bad. Does loading a website take too long? Chances are that the visitor has disappeared again. The big bottleneck when loading a page are the images. When creating your responsive design, pay attention to the size of the images so that it will benefit the user experience.
Google Bonus points
With a responsive website you not only score with your visitors, but also with Google. Google loves responsive designs. A good online experience of the user is the starting point of the search engine. If visitors quickly click away from your website, this is not unknown to Google. In fact, Google uses this information as an indicator to determine whether your website is relevant or not. Google gives you penalty points if your website scores badly on the technical aspects. These penalty points make your website less easy to find.
When is a responsive website interesting for you?
Delivering a good mobile experience is interesting for any business. Whatever the way you go, Internet traffic through smartphones and tablets has a large share of total Internet traffic. Is it a fairly hefty investment for you? Look at where your visitors come from. Do you have a lot of visiting traffic via smartphones, but does this group quickly remove the website? Then it is advisable to start investing in a responsive design anyway.
Don't forget to test your website design on as many different electronic devices and screen sizes as possible. In addition, have your website reviewed by Google, to find out if your current website is suitable for mobile devices!
Want to make your own website suitable for mobile Internet or do you want to know more about developing applications? In Our introduction training responsive design You will learn everything you need to know about mobile internet and what comes to look at developing mobile websites.Link
Whether it's caring for structure, communicating clearly with your team or transferring a vision: Leaders of projects must be from many markets at home 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 goals, you avoid having to deal with things too much.2. Ensure a clear vision.
A good project manager ensures clarity and inspires the rest of the team. A useful tool in creating clarity is by using visual means (diagram, graph or drawing). A clear vision ensures that all the noses are on the same side.3. Ensure clear communication.
To work successfully within projects, clear, open communication is essential. Be clear about the goals and the progress of the project. This ensures a greater commitment of everyone who works on the project (client, project leader, team members, line managers and 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 likelihood that a project will be delayed. Good communication is therefore indispensable for a pleasant and effective cooperation.4. Take care of leadership.
In addition to setting up, structuring and mastering a project, leadership is giving the team members an important part of project leadership. Transfer project goals and ideas convincingly. This will inspire and motivate the team members. A positive attitude shows that you are committed to the project. Give the team members confidence by delegating certain things, for example.5. Care for structure.
A project can be complex and hectic. Structure is very important to keep the overview. Make use of a good folder structure that is accessible to the entire Project team and make a clear schedule using e.g. MS project.6. Evaluate the project.
Evaluation is a step that is regularly skipped, while it is an important learning moment. Make sure the whole team participates in the project assessment. What went well? What went less? What can we do better next time? Evaluation is needed at each milestone and not just at the end of the project. If not evaluated is the probability that a subsequent project will fail larger.
Wil je verder groeien in je rol als projectleider? Dan is onze driedaagse training Projectleiderschap iets voor jou. Tijdens deze training besteden we aandacht aan je persoonlijke leiderschapsstijl. Je leiderschap moet er immers voor zorgen dat je een project tot een succes kan maken. In deze training leer je ideeën overtuigend over te brengen. Zo kun je je teamleden enthousiasmeren en motiveren. Daarbij leer je het beste in mensen naar boven te halen en individuele kwaliteiten te herkennen. Ook wordt aandacht besteed aan het contact met de opdrachtgever; hoe zorg je er bijvoorbeeld voor dat dit zo effectief mogelijk verloopt? Na het volgen van deze training weet je hoe je de belangrijkste kracht in het team wordt en blijft!Link
Do you spend a lot of time looking for emails? Ideally, your inbox, or your digital workplace, should be as empty as possible. In this blog we'll give you three handy tips, taking the settings in Gmail as an example:
Almost all email programs allow you to personalize your inbox. By processing incoming e-mails in a structured way, you can keep the overview well. How often does it not occur that you have to search in your inbox for endless time to find that one email? Make use of 3 important labels: what to do, where to get answers and what you have completed. In Gmail, set this up as follows:
In the picture below you see an example of how your folder "To do" can be seen:
By using 3 labels on tip 1 You have already worked with tags, but you can extend this by creating additional labels of your different work. For example, customer contact, promotional business or work consultations. You set the labels the same way as with tip 1. These labels can also be coloured again.
In the picture below you see an example of how your label "Customers" can get out of it. In this way you can also see at a glance what the status is, because at tip 1 you have already created three folders for your incoming emails:
You know it: 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 or not you have received a response. This may result in you sometimes being too late to have to know something about 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 a filter in Gmail that all mail from your email address and where you put yourself in the BCC will be forwarded directly to you in Tip 1 created folder 02 | Waiting for reply:
In onze tweedaagse training Timemanagement leer je efficiënt met je tijd omgaan en ga je een stuk minder gestrest naar huis aan het einde van de dag. Je leert niet alleen praktische tips zoals in deze blog, maar je leert ook te reflecteren op je eigen denken en handelen. Wist je bijvoorbeeld dat assertiviteit en delegatievaardigheden ook een grote rol spelen? Ontdek het in onze training!
For approximately 90 employees of Nuon, Learnit Training has provided an extensive introductory course for both beginners and advanced people. Microsoft Office is, by its versatility, an indispensable software package for many office workers. But for the people ' in the field ' or ' on the floor ' this can be quite different – some have never even dealt with it. In order to make the staff more crisis-proof, Nuon decided to look for an Office training for both office and field staff and came out at Learnit Training.
The differences between the two groups were considerable. Employees from the operational, often somewhat less educated group, had hardly worked with any part of Office in some cases and were also not used for a longer period of time behind a computer. The often higher-skilled 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 parts Excel, Word and Outlook, was therefore taken care of at both start and expert level.
The choice of Learnit Training to offer this training class, which allowed all participants to perform 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 the employees who Certain tasks were more difficult to attract to colleagues. In this great incompanytraject, Learnit Training has also tried to emphasize why certain things work in Office as they work. There was, in short, attention to the logic behind the software, which was especially appreciated by the beginners.
"The training has given a good picture, how the basics of Office are assembled and how it can be used."
"The trainers was very good at his communication, had good prevalence and had clear pleasure in his work."
"I found it very useful information. I have become a piece of Office. "