Learnit Training
« Back to all themes

Training Office 365

With Office 365, you have access to your e-mail, documents, contacts, and calendars virtually anywhere. This way you can work together more easily, save your time and also the software is completely safe. In this way, the new work is perfectly anticipated. Working wherever and whenever you want has never been easier.

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

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

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.