Learnit Training
« Back to all themes

Training Office

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.

Classical

Course nameDuration




































E-Learning

Course nameDuration




































Link

5 reasons to switch from Excel to Power BI today

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.

Free webinar

Did this blog get you excited about Power BI? Then write here in front of the free webinar on February 20th at 1:00 p.m. In this webinar Maaike will show you how to use Power BI with examples.

Link

Office 365: Four handy tools

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?

Webinar Office 365 from Learnit

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.

Access your work anytime, anywhere

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.

Collaborate online with your team

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.

Organize your workflow

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.

Create your plan

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.

Measurement satisfaction

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.

Discover the benefits of Teams, Forms, Flow and planner

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

3 Common Google AdWords errors

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

How much you might like the advertisement yourself, the statistics can bring you a whole different opinion. You can't look in someone else's heads, so you can't be sure that others will find your ad great too. Make sure you test different versions of your ads. Vary for example with your title or just with a shorter content. This allows you to see which version leads to more visitors and sales.

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 aware of your 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

Is your website mobile friendly?

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!

Need help?

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

From vision to evaluation: Tips for project leaders

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 Jerol as a project leader? Then our three-day training Project Leadership is something for you. During this training we devote attention to your personal leadership style. After all, your leadership must ensure that the project becomes a success. In This training you learn to convey ideas convincingly. This way you can inspire and motivate your team members. You learn to get the most out of people and 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 following the training you will know how to become the most important force in the team and stay!

Link

Internet Marketing for SME service companies

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:

  • Getting online customer clear
  • Improve proposition
  • Build Funnel
  • Online promotion
  • Measuring and improving

An elaboration of these steps can be read in our free internet Marketing course for service companies. It clearly explains the steps to be taken to successfully implement Internet marketing in a service company. The biggest pitfalls of this process are also described and how to avoid them.

Link

Grip on your mailbox with 3 handy tips

Are you spending a lot of time looking for mail? Ideally, your inbox, or your digital workstation, should be as empty as possible. In this blog, we'll give you three helpful tips, taking the settings in Gmail as an example:

Tip 1: Make use of 3 labels

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:

  1. Go to the Gear icon and select ' Settings '
  2. Go to the Tags tab and click ' Create new label '
  3. Set the labels, for example: 01 | To do, 02 | Waiting for reply and 03 | Completed
  4. If you want to quickly distinguish between your folders at a glance, you can give color to the labels. You can do this by hovering your mouse over the label (left in your Inbox) and selecting the color there. For example, give the color red to what you still have to do (to do), yellow to current affairs (waiting for answer) and green to tasks that are ready (abyss).

In the picture below you see an example of how your folder "To do" can be seen:

TIP 2: Make use of sub-labels

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:

Tip 3: Put your own in the BCC in case of a visit

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:

  1. Go to the Gear icon and select ' Settings '
  2. Go to the ' Filters and blocked Addresses ' tab and click ' Create New Filter '
  3. Fill in "from" and "to" your own email address, and click "Create Filter with this search".
  4. Select "Skip Inbox" and select "Apply the label". Choose (for example) the label "02 | Wait for answer "and click" Create Filter ". All messages you have sent with questions or requests can now be found in this folder. Once you have a response you can move the email to for example "03 | Completed ".

In our two-day training time Management you will learn to handle your time efficiently and go home a lot less stressed at the end of the day. You will learn not only practical tips as in this blog, but also learn to reflect on your own thinking and acting. Did you know, for example, that assertiveness and delegation skills also play a major role? Discover it in our training.

Sharon Faber, Department of Communication & Management

Link

Excel-Access 0:1

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.

Muhammad Nadeem

Office Trainer

Do you want personal guidance, feedback and practice with your own situations? Sign up for an Excel training or Access training You can follow our Office training in versions 2007, 2010, 2013 or 2016

Link

Pivot tables: Excel's best Feature

If a top 40 would exist of best functions in Excel, the pivot tables would be in the first place uncontested. As for me in any case. Shortly thereafter followed by the pivot charts. Why am I so excited about the pivot tables? I'll explain 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.

I'm sure when you're going to use pivot tables you'll agree with me that the topper within Excel are the pivot tables. Good luck with using it!

Muhammad Nadeem

Office Trainer

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 2016

Link

20 Tips for Excel 2013-part III

Already can make good use of Excel 2013 after the tiplijst in our previous blog? We will gladly help you to increase the ease of use. That's why there are six tips below to help you get on with one of the most important computing and presentation programs in the workplace.

Tip 15: The fill handle

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.

TIP 16: Shortcut keys Worksheets

When you work with many worksheets in Excel, you can quickly navigate with the following keyboard shortcuts:

  • Worksheet to the right: Ctrl + PageDown
  • Worksheet to the left: Ctrl + PageUp

TIP 17: Shortcut keys workbooks

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.

Tip 18: Make the cell absolute shortcut

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.

Tip 19: Keyboard Shortcuts for selections

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.

TIP 20: Excel 2013 Knowledge widening

A training Excel 2013Basic/continued/Expert at Learnit training helps you to broaden your knowledge. In our training you learn to work with Excel 2013 at your own pace. You will be accompanied by an experienced trainer. If you have already run into problems with Excel, it can be enlightening to take an example from your work environment to the training. You can get even more practice-oriented. Colleagues or employees who want to follow the training? We also give this training very tailor-made and (Incompany) for large groups.

You can click below to view the other tips:

Link

20 Tips for Excel 2013-part II

Already can make good use of Excel 2013 after the tiplijst in our previous blog? We are happy to help you increase the ease of use and therefore follow seven more tips for working with one of the most important computing and presentation programs in the workplace.

TIP 8: Macros

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:

  • Go into the cell where you want to start recording the macro (eg. cell A1).
  • Choose View > Macros > Macro recording.
  • In the Record Macro window, enter a macro name and keyboard shortcut.
  • Use an orange fill color for the cell A1.
  • Stop the macro by clicking the Stop button at the bottom left of the screen.

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.

Tip 9: Vertical Search

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.

Syntax: 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
Syntax: 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.

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.

The Syntax for LINKS is: = LEFT (D1; 2). Or: From the text in cell D1 we want to return the left two characters. In cell E4, all data from Row 3 is joined together as a new user name. The formula for this is shown at the top of the picture. The "" Returns a space between Pian and 75.

Tip 14: Remove Duplicate values

If your data has been contaminated with duplicate values, it can be corrected in a few steps. We do this on the basis of a conditional format, as shown in the figure below.

  • Select the area where the duplicate values occur.
  • Choose Start > Conditional formatting > Cell marker Rules > duplicate values.
  • In the Double Values window, specify a format.

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!

And that was the second part of this tip list around using Excel 2013. You can click below to view the other tips:

If you want to learn more about Excel, take a look at our Excel Training courses (also to be followed via e-learning).

Link

20 Tips for Excel 2013-part I

Microsoft Excel has been one of the most important calculation and presentation programs for the workplace for many years. Excel is a program that is used to process data and present this data clearly. Excel 2013 is very similar to its predecessor 2010 in terms of interface, but in terms of style and design the software has moved towards the so-called 'metro interface' of Windows 8. In addition, this version comes with a large number of templates that immediately assist the user with the creation of specific tables (reports, calendars, budgets, etc.). And finally, it is easier than ever to share created work online and work together on certain documents at the same time.

In this tiplijst (part I) We'll discuss some of these new features, so you can get even more out of Microsoft Excel.

Tip 1: Quick Completion

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? Surname
  • Change data (type in column B: Last name)

TIP 2: Quick analysis

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.

In This example, a ' Sum-analysis ' is chosen as a result. Analysis can include: formatting, charts, totals, tables, and Sparklines.

TIP 3: Recommended graphs

The chart recommendation creates several recommendations based on the selected data.

  1. Select the cells that you want to display in a chart.
  2. Choose Insert > recommended graphs
  3. 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

Pivot tables allow you to analyze a large number of data-this helps to make better decisions. As a beginner, it can be difficult to get to the point when there are many data points. Excel helps you to automatically generate pivot tables and works in the same way as recommended graphs (Tip 3).

  1. Select the cells you want to create a pivot table for.
  2. Choose Insert > recommended pivot tables.
  3. In the recommended Pivot Tables window, click the PivotTable you want.

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.

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!

Inserting the timeline:

  1. Click the PivotTable to display the pivot table tools.
  2. Choose Analyze > insert timeline.
  3. In the Insert Timelines window, select the date fields that you want, and then click OK.

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

When formatting is not your strongest side, you can use preset templates. Excel has a large number of templates for budgets, invoices, calendars, lists, loans, and schedules. By using these templates you can focus on the calculation section and Excel provides very nice spreadsheets.

  1. Choose File > New.
  2. Under suggested searches, click one of the suggestions, or type a suggestion in the search bar.

Tip 7: Absolute and Relative cell reference

We use this when formulas are copied to multiple cells. Relative cell reference lets the cells in the formula change with it. In the figure below, the formula of cell D3 can be copied down to calculate the totals of the weeks. The formula for cell D4 then becomes: = B4 + C4

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.

So, those were the first seven tips around using Excel 2013. You can click below to view the other tips:

If you want to learn more about Excel, take a look at our Excel Training courses (also to be followed via e-learning).

Link

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 '.

You know the memory game of the past: ' I'm travelling and I'll take it.. '. The first player says, "I'm going to travel and I'll take it: a swimsuit". The second player repeats this and adds something. The third player repeats the word of player one and two and adds something, and so on. By means of a holiday planning I outline the choice of ways of working and the distinction.

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.

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.

Within an organisation there are several ways to look at projects and project work. For example, building a house, designing and building is seen as a project in which the architect and the contractor work together. From the top the whole is seen as a project. Masons and carpenters work routinely. From the execution it is seen as routine.

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.

' 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.

When you are again instructed to be involved in a "project", it will stop at this foot light and make a conscious and critical assessment of whether it is an activity or whether it is actually a project. A project is a temporary work of a number of people – usually different disciplines – to achieve a predefined goal with a set budget.

Link

Print landscape pages using sections

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.

Inserting sections goes through the Page Layout tab and then from the Page Setup group, the option "End markers". This option allows you to choose ' next page '. This option causes the section to always start on a new page. When the cursor is placed in this section, you can choose ' Landscape ' in page layout > ' orientation '. This section now has this orientation. Remember to place a stop marker at the end of this section so that the next section can be selected for a portrait orientation.

Word Training

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.

Link

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.

Outlook Training

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.

Link

The 8 most convenient Office 2016 features

Microsoft Office, for many known as Word, Excel, PowerPoint, Access and Outlook, has been completely revamped for the 2016 edition. As in every new version, a lot of changes have been made, and we like to put the 8 most convenient of these on a row.

1. Real-time co-authorship

Collaborating efficiently is one of the main objectives of Microsoft Office 2016. It will not surprise you that from this version you can work with different people simultaneously on the same document. While you are already reading the first paragraph in your Word document, your colleague can continue to write to the following paragraphs, without your work being overwritten by the other. The same goes for PowerPoint, but Word has a unique perk: Here you can even see each other in real-time typing.

2. Send larger files

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

Excel-Ninjas will undoubtedly count this feature up to their favorites. In the chart section of Excel, you can now conjure up predictions with a simple mouse click. To this end, Microsoft uses the standard "Exponential Smoothing algorithm (ETS) to show effective reliable forecasts.

5. Skype Integration

As mentioned earlier, working together efficiently is very important in Office 2016 and that also proves the Skype integration in the various desktop apps. This allows you to start a Skype call within Word, Excel or PowerPoint, both with Instant messaging, voice calls and video calls. But you can also without leaving the document, share your screen via Skype.

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

For those who are looking forward to the standard charts in Microsoft Office, there is good news. In fact, new chart types have been added that help you to visualize financial or hierarchical data better.

8. Better cross-device support

Finally Office 2016 also puts a big step forward in cross-device support of various programs. Create your Word document on your smartphone, update it on your tablet and add the finishing touch to your PC, all can be done easier than before.

Link

Filters in Excel

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 .

Link

Learning by falling and getting up

In this blog I like to share my first experience with project work within my first project with you. At my former employer, the colleagues in the ' policy ' department were in charge of executing the projects and the colleagues of our department were within the projects project team members. Because there were no more hours available in the policy department to carry out a particular project, they proposed to the Director, the client in this, to nominate me to lead this project. The colleague from whom I got the project transferred, gave me a project management booklet. Full of enthusiasm, motivation and inspiration, I started to work energetically with this new challenge; After all, I had never done 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.

In order not to lead to a loss of face during the presentation, I was responsible for the project, I have drawn everything to me days before the start and have cobbled the presentation together with the help of the communication officer. Astonishingly, the Commission was impressed by the project. What a relief, I have not fallen by the basket. Upon entering the office, the project team asked how it was gone. When they heard that the Commission was impressed, one project team member said, and proudly, "so! We did well! ". In My head i exploded ' WE?! ' ' WE!? '

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.

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.

Link

Save with Open source

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 created in a public and common way. Collaboration is done by various programmers and companies to develop the software and is completely free. 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 offer of open-source software is great. For example, there are whole operating systems that can replace Windows such as Ubuntu and Debian. There are also open source CMS systems, such as Drupal, Wordpress and Joomla! This makes 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 includes programs like Writer to type In, Calc to Create spreadsheets and draw to draw with.

Save

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.

Training

Learnit follows the developments around open source and also makes clever use of the software. For example, our own employees have been using the Ubuntu operating system for some time and documents are compiled with the free LibreOffice. Learnit offers several open source training courses, such as Creating Websites with Joomla! and several open Office training courses. It is also possible to follow a training in WordPress and Drupal at Learnit. Interested or asking? Feel free to contact us via 020-6369179 or send an email to info@learnit.nl.

Link

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.

Custom

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. "