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.
Excel is een van de meest gebruikte softwareprogramma’s op de werkvloer. Het is dan ook niet geheel onverwacht dat het wereldwijd miljoenen gebruikers kent. Door de jaren heen zijn er veel updates geweest om Excel uit te breiden. Wil jij weten welke functies Excel in 2019 en 2020 heeft vrijgegeven? Lees dan deze blog en kom erachter of er interessante mogelijkheden voor jou tussen zitten!
Een aantal basisfuncties die de afgelopen twee jaar zijn geïntroduceerd zijn onder andere:
2. Draaitabel functies
Naast een aantal basisfuncties zijn er de afgelopen jaren ook een aantal handige draaitabel mogelijkheden bijgekomen:
3. Excel grafieken
Wist je dat Excel de laatste twee jaar ook twee nieuwe soorten grafieken heeft toegevoegd?
Wist je dat Learnit negen verschillende Excel trainingen aanbiedt? Van de training Excel Basis tot aan Excel Expert en van Excel Draaitabellen, formules en functies tot aan Excel PowerPivot, Learnit heeft het allemaal in huis! Voor een compleet overzicht van onze Excel trainingen, klik
Inmiddels wordt het langzamerhand duidelijk dat we zeker tot halverwege 2021 veelal thuis zullen zitten en dus ook thuis zullen moeten werken. Dit betekent dat er ook voor komend jaar veel online werkactiviteiten op de planning zullen staan. Hoe kun jij jezelf en je organisatie het beste voorbereiden op een online 2021? In deze blog leggen we je uit welke trainingen perfect aansluiten op online werken!
1. Zoekmachine optimalisatie (SEO). Hoe zorg je ervoor dat je zoveel mogelijk bezoekers naar je website trekt? Zoekmachine optimalisatie, ook wel SEO genoemd is hiervoor de oplossing! Learnit biedt een cursus aan waar niet alleen de basisprincipes rondom zoekmachine optimalisatie met je gedeeld worden, maar waarbij ook wordt gewerkt aan je praktijkvaardigheden. Leer bijvoorbeeld hoe je je eigen website kunt analyseren en optimaliseren. Op deze manier kun jij het maximale uit je website en webverkeer halen in 2021!
2. Online marketing. De ontwikkelingen op het internet verlopen in een razendsnel tempo. Online marketing is een thema dat het afgelopen jaar een belangrijke rol speelde voor veel organisaties, en de verwachting is dat online marketing mogelijk een nog grotere rol gaat spelen in 2021. Kan jouw organisatie nog wel wat leren op het gebied van online marketing? Bekijk dan eens onze nieuwe 7-daagse cursus online marketing. Tijdens deze allesomvattende cursus leer je alle vaardigheden die nodig zijn om jouw organisatie sterk op de (online) kaart te zetten. Onderwerpen die aan bod komen tijdens deze training zijn: zoekmachine optimalisatie, Google Ads, Google Analytics, Facebook advertising, e-commerce, social media marketing en contentmarketing.
3. Power BI Basis. Nu we elkaar (bijna) niet meer fysiek zien of spreken op de werkvloer, kan het soms lastig zijn om bepaalde informatie over te brengen naar collega’s. Denk bijvoorbeeld aan financiële rapportages. Voor dit soort informatie kan het handig zijn om een visualisatietool te gebruiken waardoor je op afstand gemakkelijk aan collega’s kunt laten zien wat er speelt. Een van de populairste visualisatie tools is Power BI. Learnit biedt een 2-daagse cursus Power BI aan, waarin je leert om effectieve managementrapportages te maken met behulp van jouw Excel gegevens. Op deze manier kun je met Power BI vervolgens een interactief management dashboard creëren, waarin je gemakkelijk gegevens kunt visualiseren en delen met je collega’s. Ideaal om informatie over te brengen dus!
4. Agile Scrum Basis. Scrum is niets anders dan een Agile raamwerk, dat symbool staat voor effectiever en flexibeler werken. De Agile manier van werken zorgt ervoor dat er in zelfsturende teams gewerkt kan worden, wat uitermate handig is voor de planning van complexere projecten. De focus van Scrum ligt op de communicatie binnen deze projecten, maar ook op de interactie tussen afdelingen en naar klanten toe. Nu online werken aan de orde van de dag is, zie je dat veel bedrijven gebruik maken van deze gestructureerde manier van (online) werken. Ben jij benieuwd of werken volgens deze stijl iets is voor jouw organisatie? Bekijk dan eens onze training Agile Scrum Basis. Tijdens deze training leer je niet alleen de theorie rondom deze methode, ook de vaardigheden die erbij komen kijken spelen een belangrijke rol. Wist je dat er de mogelijkheid is om na de training een officieel examen af te leggen, waarna je jezelf Scrum Master of Scrum Product Owner kan noemen? Klik op de training of informeer naar de mogelijkheden.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.
Do you want to grow further in your role as project leader? Then our three-day training course Project Leadership is for you. During this training we pay attention to your personal leadership style. After all, your leadership must ensure that the project is a success. In this training you will learn to convincingly convey ideas. This way you can enthuse and motivate your team members. In addition, you learn to bring out the best in people and to recognize individual qualities. Attention is also paid to the contact with the client: how do you ensure that this is as effective as possible? After attending the training you will know how to become and remain the most important force in the team!Link
The way in which service companies come into contact with potential customers is changing, and faster than ever. Research in THE US has shown that in 2014 46% of the decision-makers of B2B purchases in the age of 18 to 34 sat, the so-called millenials. That was 27% in 2012, a growth of almost 70%! And that group grew up with the Internet. They use the internet for everything, and therefore also to orient themselves when purchasing services.
For SMEs, it is therefore important to develop an online marketing strategy as quickly as possible. Make sure that you are literally in the picture, make a good impression and start a conversation with the potential customer. Traditional market positions often do not apply online. Online it is often other companies that are easy to find and make a good impression. They don't need to have a large market share yet, but they have one thing in common: they are growing fast! But how do you deal with that, developing an online marketing strategy as an SME?
I have noticed that this is a difficult process for many SMEs. Marketing is one of the cores of a company. As Peter Drucker said, marketing and innovation are the basic functions of a company. And within a company there has historically been an acquisition method that has proven its worth in the past, and has become embedded in the organization. It is reflected in the description of the services, the pricing, the distinguishing points and the conditions under which the services are offered. All this will have to be reviewed and reconsidered if you want to effectively promote the services online. This is a different playing field, with different promotion channels, different competitors and a different relationship with potential customers.
And the internet is not only a collection of new promotional channels, it is an interactive medium that allows a group of interested parties to be built (a community) and which can be used to start up a (digital) conversation. That is so different from how marketing used to be that it requires a complete new vision of the SME company. To continue this change, an SME company has to go through a number of steps.
The first step is that a problem owner is designated in the company. That is going to pull the cart from this folder. He makes the goals clear, determines the approach and monitors the progress. The second step is to get the knowledge needed to bring this to a good end. Also, if finally decided to outsource large parts of the implementation, the basic knowledge must be in-house. The internet Marketing training courses of Learnit training are of course a good basis. There are training courses for beginners and advanced students in the field of Facebook advertising, Google Analytics, social media marketing, e-commerce and content marketing.
The following steps are on the fly:
An elaboration of these steps can be read in our free Internet marketing course for service companies. It clearly explains the steps that need to be taken to successfully implement internet marketing in a service company. It also describes the biggest pitfalls in this process and how to avoid them.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 our two-day Timemanagement training you will learn how to use your time efficiently and you will go home a lot less stressed at the end of the day. You will not only learn practical tips like in this blog, but you will also learn to reflect on your own thoughts and actions. Did you know, for example, that assertiveness and delegation skills also play an important role? Discover it in our training.
Sharon Faber, Department of Communication & ManagementLink
In the summer of 2015, there has been a large-scale research into the use of Excel worksheets in America. Many thousands of sheets have been viewed. And what turned out? Most of these worksheets do not contain any formula. This apparently means that Excel is mainly used to store data without being counted.
In practice I also come across many Excel users who create all sorts of lists or list in Excel. I understand that too, because the pane layout is useful and simple with filters the correct data can be selected. The problems occur when data from a worksheet needs to be linked to other worksheets. This is not possible with a few simple formulas and is often almost impossible. Although Excel has a number of database functions (DSUM, DCOUNT,..), they are again meant to be counted.
The solution that is not obvious, but often much better, is to import the data into MS Access. This is generally problem-free and Access creates tables. Establishing relationships between data is now easy. In the ' Relationships ' menu option, lines between fields from different tables can be drawn to create relationships. Various options can be used to ensure the integrity of the data. For example, only an order can be added if a customer has been created first. This data integrity is not present in Excel.
Access makes it easy to create forms (input screens) to make it even easier for users. Also to export is thought. Through reports, the information can be printed very flexibly to paper or PDF. It can also be easily exported to Excel. In Access, even most Excel functions can be used to create calculations.
It is always important to use the right tool when working. This also applies in the office. When an EXCEL worksheet does not contain formulas, it is usually better to choose Access.
If there were a top 40 of best features in Excel, the pivot tables would undisputedly come first. Shortly after that, the pivot charts. Why am I so excited about the pivot charts? Learnit explains it to you.
When you want to calculate something in Excel, you have to indicate exactly what the purpose is. Count the contents of A2 with the contents of B2 and multiply it with the contents of C2. Excel counts this fine for you and shows the result. With more complex functions such as vertical search or nested functions, it becomes more difficult to select the correct values in the correct cells. The pivot tables do not require this.
For example, Excel automatically groups the data by location, region, department etc. Then, all kinds of functions such as Sum, Average, max, and Min can be used to display information by group. Consider the total sales by region or the average cost per department.
The starting point is the data table. This is a worksheet of data, divided into columns, where each column contains the same type of information. For example, names, phone numbers, and addresses are columns. There must be a name above each column. These names are used in the pivot table.
Select a single cell in the data table and choose the PivotTable function from the Insert tab. Confirm the next screen so that the pivot table is created on a new worksheet. Left is the space reserved for the report and on the right side the fields, the column names, can be placed in the appropriate boxes. A column name placed in the row labels allows for grouping of the data among each other. The column labels are placed next to each other. In The Values box, the numbers are placed and the desired function can be chosen for each field. This can be by clicking on the list arrow and selecting the desired function at the Values field settings.
That's all. You indicate where the data is and Excel gives you all the information you want. If you don't want to see the information as numbers but as a graph, perform the exact same procedure, but then select a PivotChart instead of a pivot table.
At Learnit we are convinced that when you start using turntables you will be as enthusiastic as we are. Good luck using them!
Do you want personal guidance, feedback and practice with your own situations? Sign up for our one-day training Excel pivot tables, formulas and functions. You can follow this training in versions 2007, 2010, 2013 or 2016Link
Already make good use of Excel 2013 after the tip list in our previous blog? We'd like to give you a helping hand to increase the ease of use. That's why below are six more tips to get you started with one of the most important calculation and presentation tools for the workplace.
The fill handle allows you to quickly copy formulas and series. When you hover the cursor over an active cell at the bottom right, your cursor changes to a cross and you can copy it to the desired direction. In the figure below, the fill handle is shown in red. When you double-click instead of dragging, the formula/series is automatically copied. In the figure below this will be to cell C5.
When you work with many worksheets in Excel, you can quickly navigate with the following keyboard shortcuts:
When navigating a lot between different windows, ALT + TAB is the solution. This allows you to switch quickly between the last two screens used. If you hold down ALT and press TAB repeatedly, you will switch through all windows. By releasing ALT + TAB, the selected window becomes active.
As described in Tip 7, we can definitely make cell references. When we move the cursor in the formula bar to the appropriate cell, we make this cell absolutely with the F4 button. By pressing F4 repeatedly, you can switch between the following options: $A $1, A $1, $A 1 and A1. The next character after the $ character is absolute.
Large files often want to select large ranges. This can be a tricky task with the mouse. When the CTRL + SHIFT + arrow buttons are pressed, you can quickly extend the selection by row and column. CTRL + SHIFT + * Selects all cells around it until Excel encounters an empty cell.
A training Excel 2013 Base/Proceed/Expert at Learnit Training will help you broaden your knowledge. In our training you will learn to work with Excel 2013 at your own pace. You will be supervised by an experienced trainer. If you have already encountered problems with Excel, it can be enlightening to bring an example from your work environment to the training. You can then work in an even more practical way. Colleagues or employees who want to follow the training? We also give this training very tailor-made and (in-company) for large groups.
You can click below to view the other tips:Link
Already make good use of Excel 2013 after the tip list in our previous blog? We are happy to help you further increase the ease of use, so below are seven more tips for working with one of the most important calculation and presentation tools for the workplace.
When you often have to do recurring work, a Macro is the solution. An example of such a kind of common job may be that every Monday you have to create a report of data from a database. The next time you do this, you're going to record a macro, with every mouse click and keyboard attack recorded. Then, the recorded actions can be performed with a single mouse click.
You do this as follows:
Now you have a macro recorded and you can make any cell, using the hotkey, orange. Of course, you can make the macro much longer and it is also possible to have it referenced relatively.
Vertical search looks for a value in an array that returns a value from the same row. This is often used to look up associated data from a large database. The function we use is called VERT. SEARCH and we can query through formulas > Search and refer > VERT. Search.
Trans. SEARCH (search value; table matrix; Kolomindex_getal; approximate)
Lookup_value– Is the value that we want to search for in the matrix table (cell A9).
Table_array: Is the range of cells in which to search (blue lines).
Kolomindex_getal– Is The column number of the table array to be returned (red dotted lines).
Access: Choice of
FALSE: Exact as Search value
WHERE: Looks like search value
TRANS. SEARCH (A19; A2: C6; 3; WHERE
If we enter the syntax above in cell B9, let's search for "Week 2" in the Matrix table. When this is found the result of column 3 is displayed. In the figure below is that 95.
This also works inverted (in column B, type the last name)
Change data (type in column B: Last name)
Data is analyzed faster in Excel 2013. Make a selection of the data you want to analyze. The Quick Analysis button appears in the lower right. This button creates quick analyses, see the figure below.
Choose Insert > recommended graphs
In the Insert Chart window, click the chart that you want, and then click OK.
Now that the graph is created, there are three buttons visible. The filter button now also allows you to quickly filter the data to be included in the chart.TIP 4: Recommended pivot Tables
Select the cells you want to create a pivot table for.
TIP 5: Pivot table timeline
For pivot tables, a new function has been inserted to create a time filter. This works roughly the same way you might be used to using slicers. Please Note: A column of dates must be present in the source data!
Click the PivotTable to display the pivot table tools.Link
Now that the timeline is inserted we can adjust it in the desired unit of measurement. We Use the timeline to select a period.
Tip 6: Templates
Choose File > New.
So, those were the first seven tips around using Excel 2013. You can click below to view the other tips:
Is it a project?
Since 1980, project-based work has become increasingly important due to the increasing dynamism and complexity of society and the organisations themselves. Nowadays almost every job is called a project; Even cleaning up the filing cabinet is a project. I think it comes through the time spirit, project management is trendy. That every activity is called a project is clearly a trap ' the bells are heard, but do not know where the clapper hangs '.
Project work is between routine and improvising: there is no guarantee that the predetermined result will be achieved by following established procedures, but there is sufficient experience in (type) equal situations to make a road Which is likely to bring the formulated objectives closer.
It may also be that the parent organisation performs very regularly activities in the form of a project, for example in the case of renewal of products and research. From the top these activities are seen as routine. The executive researchers work on a project basis. Different layers can be judged on routine and project work.
Are you convinced that your projects are real projects? Then a course Project management maybe something for you!
The buzzing sound of printing printers is becoming less common. Documents are no longer printed but are mainly sent via e-mail or shared across platforms such as SharePoint. However, MS Word is still widely used to compose documents. Things like formatting, headers and automatically generating a table of contents are still favorite features of MS Word.
Managing E-mail with Outlook
Do you want to master the most basic features of Outlook and organize your business in a clear and easy-to-understand environment? Then follow us the training Outlook Basis. At the end of our two-day training you will understand how the interface works, you have learned what Outlook has to offer and you can easily put the most important functions of the program into practice.
The 8 most convenient Office 2016 features
Click the PivotTable to display the pivot table tools.Link
Many of our students use Excel to make large amounts of data transparent. With Excel, you can arrange and present large amounts of data in different ways. You can fill graphs with it, summarize the data in pivot tables, etc.
One of the way to search in large amounts of data is by using filters. Using filters, you can quickly hide (or show) some of the rules so that you only see the rows that are relevant to you at that time. How that works we explain below. If you want to work with filter you have to turn on this first. You do this on the Data tab by clicking the Filter option, also see the image below.
The filter buttons (gray squares with a black triangle) are added to each cell in the selected row (in older Excel versions, it is in the upper cell of a block of data). When you click on the filter you will see the window shown. Depending on what is in the selected column, you will see other data.
Clicking or selecting checkboxes can make a selection of the rows to be displayed.
When a column contains numbers, this window also gives you the option to make a selection based on certain values. Then choose Number Filters and enter the desired range.
When a column contains text, a similar filter appears that allows a selection on specific text. A column that allows a date can be selected in the same way at a specific time period.
By using a filter you hide the unselected rows, these rows are not deleted or erased. In The line numbers you will still see the original numbers. The advantage of this is that you can show the hidden data here later. However, if you want to copy the filtered data, this may be a problem. Copying also copies the unshowed lines so that the filter does not affect what you copy.
Fortunately, in Excel there is a rather hidden option to copy only the displayed (filtered) rows. This option is located on the Home tab in the find and select group. Choose the go to option and choose Specialin that window. The dropdown window then allows you to select the only visible cells option . Now when you copy the selected area to a new worksheet, the rows get new consecutive line numbers and the unselected rows are not copied with them.
In this blog I would like to share my first project experience with you. At my then employer, the colleagues from the 'Policy' department were in charge of the projects and the colleagues from our department were project team members within the projects. Because there were no more hours available in the policy department to carry out a certain project, they proposed to the director, the client in this one, that I should lead this project. The colleague from whom I was handed over the project gave me a project management booklet. Full of enthusiasm, motivation and inspiration, I set to work on this new challenge; after all, I had never carried out a project before.
After some time I found out in a painful way that you do not approach a project in a regular way, as you are used to doing your daily work or just doing it. One lid after the other on my nose. Everything that could go wrong went wrong: at the time during the execution of the project was asked whether the project could be presented for an important commission of the client, I said without enquiring to do full "YES!". Upon enquiry it turned out that the project team members had little to nothing what could be presented. The team members gave priority to their regular work.
Project work was done when one had time. Everyone worked part-time, appointments were not fulfilled and deadlines were not met. The client was not aware of the claims, interfered at the wrong moments with the project and did not take the right decision. During the project I have sighed more often, I have been frustrated and cursed my client and project team members.
What have I been angry with the client and the project team, to find out that this was unjustified and the realization got that the dramatic course of the project was entirely my own fault. Although the project was not satisfactory, I found projects and leading them very interesting. Tóén I have the Project management booklet, which untouched had stayed before and during the project, but once unfolded. While reading had in continuous ' aha moments ' and I found out what I have all failed to do.Link
Working in the project could be fun if the people involved were purposeful and practical, and they knew what they were doing and what needed to be done. When you collaborate intensively with each other, it creates a bond and a pleasant working atmosphere. The pleasant course of interaction with the environment, stakeholders, is motivating.
Project management is really a profession and requires a structured way of thinking and working. It is not only leadership, but also structuring. These skills are taught during our training project Management, which is an interactive way of preparing, organizing, structuring and managing a project. To further develop the skills you do by applying them in practice.
Save with open source software
Green Links believes that the government can save billions with open source software. That says GL-MP Arjan El Fassed in an interview with nu.nl. But that applies not only to the government, but also to companies and organizations that make a lot of use of computers can save huge amount by using open source.Link
Back to politics. In The interview, El Fassed indicates that various studies have been carried out into possible savings in the ICT field. The General Court of Auditors believes that 88 million euros can be saved on an annual basis with the open source software. The internal estimates of domestic affairs are even more favourable: they believe that EUR 3 to 4 billion per year can be saved. No childish figures. Savings are also possible in your organisation. Except that it can be very advantageous to switch to open source software, there is another advantage. The use of open source software would be safer than the usual systems. A comparison made is this: someone takes no medication without having read the package leaflet, which is too unreliable. This also applies to the computer software. Because the source code is known, you know how the program is put together. Another advantage is that many viruses are only harmful to Windows. These viruses cannot cause damage to open source software.
Learnit closely follows developments in open source and makes clever use of the software itself. For example, our own employees have been using the Ubuntu operating system for some time now and documents are created with the free LibreOffice. Learnit also offers various open source training courses, such as our Office training courses. It is also possible to have a training Wordpress to follow at Learnit. Interested or questions? Feel free to contact us on 020-6369179 or send an email to firstname.lastname@example.org.
Office for Nuon Introductory course
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.
From acquaintance to improvement
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.
Experience of the Employees
"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. "
Training and Training
Office, Excel, and WordLink
De verschillen tussen de twee groepen waren flink. Werknemers uit de operationele, vaak wat lager opgeleide groep hadden in sommige gevallen nauwelijks met enig onderdeel van Office gewerkt en waren ook niet gewend langere tijd achter een computer te zitten. De vaak wat hoger opgeleide kantoormedewerkers waren veelal vergevorderde gebruikers van bepaalde Office-onderdelen. De training, die voor beide groepen zo’n acht dagen in beslag zou gaan nemen en bestond uit de onderdelen Excel, Word en Outlook, werd daardoor op zowel begin- als expertniveau verzorgd.
De keuze van Learnit Training om deze training klassikaal aan te bieden, waardoor alle deelnemers tegelijk dezelfde opdrachten uitvoerden, werd goed ontvangen: er was nog steeds genoeg ruimte om in een iets hoger of lager tempo te werken en de medewerkers die bepaalde taken wat moeilijker vonden konden zich optrekken aan collega’s. Learnit Training heeft in dit grote incompanytraject ook de nadruk geprobeerd te leggen op waarom bepaalde dingen in Office werken zoals ze werken. Er was, kortom, aandacht voor de logica achter de software, hetgeen vooral door de beginners werd gewaardeerd.
“De training heeft een een goed beeld gegeven, hoe de basis van Office in elkaar zit en hoe dit gebruikt kan worden.”
“De trainers was zeer goed in zijn communicatie, had goed overwicht en had duidelijk plezier in zijn werk.”
“Ik vond het erg nuttige informatie. Ik ben een stuk wijzer geworden omtrent Office."