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 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.
Dat is alles. Je geeft aan waar de gegevens staan en Excel geeft je alle gewenste informatie. Wanneer je de informatie niet als cijfers maar als een grafiek wilt zien voer je exact dezelfde procedure uit, maar dan selecteer je een draaigrafiek in plaats van een draaitabel.
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
20 Tips for Excel 2013-part II
TIP 8: Macros
You do this as follows:
Use an orange fill color for the cell A1.
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)Link
: Is the range of cells in which to search (blue lines).
– Is The column number of the table array to be returned (red dotted lines).
TRANS. SEARCH (A19; A2: C6; 3; WHERE
Tip 10: Autosomal
To quickly create a SUM function, the button with the sum character (Home tab) exists. This allows us to quickly add a few cells with just a few clicks.Enter the cell where you want the answer to occur.
Click the button with the sum character
Use the mouse to select the cells to be added.Exit with ENTER.
When the arrow next to the Somteken is clicked, the following function choices appear: Average, number of numbers, Max and Min.Tip 11: Tricky formulas
If you need to create tricky formulas, it is useful to fill them in the ' Functieargumenten' ' screen. This way, you increase the chance to make the formula correct, because special characters are automatically filled in. There is also a short explanation for each argument. This screen can be called using the ƒx button (to the left of the formula bar) when the cell is active.Tip 12: Select Special
When data needs to be selected for editing, you can use ' Select Special '. Here you can think of empty cells, comments, formulas and differences in rows or columns.Select the area to search for.
Press F5.In the Select Special window, specify where to select.
Tip 13: Merge data "text"For example, if you want to create new usernames using FirstName, last name and year of birth, this is possible with text formulas such as RIGHT, MIDDLE, and LEFT. In the figure below we see in the top row the data of Pieter, in row 2 The function that is used and underneath, in row 3, we see the result.
To quickly create a SUM function, the button with the sum character (Home tab) exists. This allows us to quickly add a few cells with just a few clicks.Enter the cell where you want the answer to occur.
The Syntax for LINKS is:
= LEFT (D1; 2)
Tip 14: Remove Duplicate values
Now that the conditional formatting has been created, we can select and delete the rows by using a filter (by color). Note: Click the rows with Ctrl (control), or you will delete intermediate rows as well!
20 Tips for Excel 2013-part I
Excel has now become even smarter in recognizing patterns. If we follow the example in the screenshot, we see that in cell B2 when you type the FirstName from cell A2, a supplementary list is shown. By pressing ENTER, we can accept this list.
This also works inverted (in column B, type the last name)
Add a character (type in column B: FirstName? SurnameChange 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.
Select the cells that you want to display in a chart.
Choose Insert > recommended graphs
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.Link
Select the cells you want to create a pivot table for.
Choose Insert > recommended pivot tables.
The PivotTable Wizard is still usable if you want to customize the PivotTable. To view it, click the PivotTable that appears on the right side of your window.
Choose Analyze > insert timeline.
In the Insert Timelines window, select the date fields that you want, and then click OK.
Tip 6: Templates
Tip 7: Absolute and Relative cell reference
Now it is also possible to set a cell (absolute) when copying a formula. In the figure below we want to continue to use the 15% bonus (cell C1) If we copy the formula from cell C4 down. The formula of C4 then becomes: = B4 * $C $1. The $ character indicates that the character is behind it. In this case the C and the 1 are fixed. When we copy the formula from C4, we get the result in cell C5: = B5 * $C $1. In cell C6: = B6 * $C $1.
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 '.
Every year you go to the same destination via a fixed route, you take the goods with you and the budget is determined accurately by the years of experience. This is routine. If you routinely find ' boring ' and want more spontaneity and adventure, then you choose to improvise. Your global desire is ' where the sun is shining ', so you get in the car and drive. The course is regularly adjusted to the circumstances. New ideas arise during the trip. It is not good to prepare therefore you take different stuff with it and lots of money.
When you approach your holiday planning project, you have a more outlined goal (culture in France, alternating with relaxation). You first determine the functional requirements (castles and beach) and operational requirements (solar hours per month in the region and maximum distance). Then you will find out what choices are available for holiday destinations. You make a choice, determine the route and pick up the necessary stuff and leave. Minor changes are possible at any time of choice.
' Something ' lends itself to a project if there is a comprehensive description of a demonstrable, desired end result beforehand. In addition, the specific effort comes to an end, after reaching the end result. Thirdly, there is a considerable degree of uncertainty as to the end result and/or the road.
Course Project Management
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.
What is difficult is to include both portrait and landscape pages in one and the same document. Often it is an entire drive to print the landscape pages with a graph, for example, so that the chart fits. Printing this landscape page separately will display problems with page numbers.
The right way to solve this neatly and easily is to make use of sections. A document can be divided into multiple sections. For each section, various settings, such as a portrait or landscape page, can be set. Before inserting sections, it is useful to make the sections visible as well. By right-clicking the ' Status Bar ' (bottom bar, next to the word ' done '), the display of the sections can be turned on. Now it is visible in which section the cursor is.
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.Link
Do you want to master the most basic possibilities of Word and make it easy to compose all kinds of documents? Then follow our training Word Basis. At the end of our two-day training you will understand how the interface works, you have learned what Word has to offer and you can easily put the most important functions of the program into practice.
Managing E-mail with Outlook
I regularly talk with participants about the increase in e-mail as a means of communication. A large part of the working time available goes to answering e-mail. One participant even indicated that she received so much e-mail during the day that she was doing her actual work at home in the evening. This may never have been the intention of email. E-mail is intended as support, not as a primary task. I don't think there is even one employee in his job description that email answering is the main task.
During conversations with my participants I always ask who receives a lot of e-mail. Then I ask if these many-receivers also always give equal answers. This is usually answered in the affirmative. If you have a question and you have the choice to ask several colleagues by e-mail, do you always mail to the one who gives the fastest answer? This way you create your own environment. I always advise you to handle your mailbox only at fixed times, for example around 10.00 and 15.00. Colleagues get used to this quickly and if it is really urgent, the phone is in use.
Also within OutlookThere are various resources available to manage the large amount of e-mail. Because Outlook uses MS word as an editor, it also works in Word: When you need to use the same text in e-mail regularly, an old e-mail is usually searched for and copied. A quicker way is to make use of the ' Quick Parts ' (Quickparts). When a new e-mail is created, the selected text can be saved from the ' Insert > Text > Quick Parts ' tab in the ' Gallery quick Parts '. When the text is needed, the text can be selected in the same way and pasted into the email. In addition to text only, all selected elements, such as images in the building block, can be included and inserted. This still saves the search for the e-mail with the necessary text.
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
1. Real-time co-authorshipLink
Send your PowerPoint presentation of 300mb by mail? This is no longer a problem in the new Outlook. As soon as you add an Office 2016 product as an attachment to an email, it will be converted into a link where the recipient can easily download the file. The only condition for this is that the file is already synchronized with a OneDrive account or a SharePoint folder.
3. Smart Lookup
The Smart Lookup function ensures that you don't have to leave Word, Excel or PowerPoint when you want to look up the meaning of a word in your document. Simply select the word in question, right click and then select the option "Smart Lookup". The results you receive are generated by Bing and will be displayed in an "Insights" tab within your document.
4. One-click Forecasting
5. Skype IntegrationLink
6. Office groups in Outlook
This is perhaps the least discussed novelty of Office 2016, but therefore certainly not the least useful. Thanks to Office groups, it has been done once and for all with traditional distribution lists or cluttered mail conversations. You can now bring together the colleagues you collaborate with in one group, which has a shared Inbox, Calendar, File store, and even integrated OneNote notes.
7. New graphs
8. Better cross-device supportLink
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.
If you want to practice with filters once, you can use this Excel file .
Learnit offers various courses in Excel, which will allow you to further expand your skills within Excel! Are you interested in a course in Excel? Take a look at our courses here. here.
Learning by falling and getting up
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.Link
To experience success, the project approach asks for a focus on one particular result, other areas remain outside the shot. In addition, all project stakeholders must have the right results in mind and keep it. When you create good conditions, the project takes other areas in the right direction in the wake.
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.
What is open source software?
Open source software is not developed by one large company such as Microsoft Office, but is often developed in a public and common way. Different programmers and companies work together to develop the software and it is completely free of charge. Characteristic of this computer software is that the source code is released. This allows users to independently study, modify and possibly improve the software. The supply of open source software is large. For example, there are entire operating systems that can replace Windows, such as Ubuntu and Debian. There are also open source CMS systems, such as Drupal, Wordpress and Joomla, which make it relatively easy to build a professional website. Then there are the OpenOffice.org software packages. This is the free counterpart of Microsoft's Office package and contains programs like Writer to type in, Calc to create spreadsheets and Draw to draw with.
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."Link
Frequently Asked Questions