How to Add Royalty Free Images and Icons in Microsoft 365

Microsoft 365 allows its subscribers to make the most of a library that contains thousands of royalty-free images and icons. You can use these icons and images in presentations, emails, workbooks, and documents in MS Office for PowerPoint, Word, Excel, and SharePoint online. For now, only Microsoft 365 subscribers can use these images and icons. But the company plans to make it an open platform so that other apps can also use the collections. Microsoft 365 also promises to refresh the library with more images frequently.

Here’s how you can add royalty free images, icons, and much more using Microsoft 365.

First, you need to sign in to your Microsoft 365 profile. Those who are not Microsoft 365 subscribers must create a new profile if they want to use these icons and images.

1. Open a Microsoft 365 file and go to Insert. From the dropdown list, select Pictures. You will get three options: This Device, Stock Images, and Online Pictures. Click on Stock Images.

2. This will open a whole bunch of options divided into four categories:

• Stock images
• Cutout People
• Icons
• Stickers

Stock images have various categories also like individuality, scenic, motion, dark, business, landscape, learning, symbol, and growth. You will also find various types of icons, such as holidays, commerce, analytics, arts, signs and symbols, nature, and tools.

3. Select one of the categories from stock images, cutout people, icons, and stickers. Microsoft 365 will narrow down the images and icons according to the category you choose. Alternatively, you can also use the search box on top to find any relevant image from the entire collection.

4. Once you find the images or icons, select the ones you need and click on Insert. You can now add the selected stickers, images, cutout people, and icons in your Excel and PowerPoint presentation.

This new update from Microsoft 365 is a blessing for many who want to create innovative content. The high-quality curated images can make your presentation look fantastic. Plus, if you want to give a humorous touch to your presentations, you can choose from the funny cutout people.

Microsoft 365 has also promised to add more premium content in the next few months. But you need to subscribe to Microsoft 365 first. The advantage of becoming a Microsoft 365 is you can enjoy these perks for your lifetime. Whether you want to use these images in your presentation or just make your Excel sheet look creative, all you need to do is find a few royalty free images from the library and use them in your file.

These icons and images are not only available for MS Office but also for Microsoft Outlook. You can now send emails to your employees with stickers and cutout people. It’s a fun way to interact with team members. In fact, you will find many stickers similar to the ones you see on WhatsApp. With so many benefits available, you should subscribe to Microsoft 365 now and start using these features right away.

How to Update Modern Home Pages for Classic Team Sites on Microsoft SharePoint?

The visible aspect of a site relies on its modern user interface. You need to use Microsoft SharePoint to enable your site to leverage this user interface for classic team sites. Sometimes you may unknowingly turn off the modern experience on SharePoint. But if you don’t, you will notice several pages on the modern interface, such as:

• Site usage page
• Site contents page
• Recycle bin pages
• List and library pages

On navigating your site further, you will notice that the home page and a few other site pages still use the classic interface. You can update these pages and modernize them for your team site.

Updating modern home pages

A modern home page for your team site allows you to post news directly from your mobile. But the classic team site needs to fulfill a few criteria to modernize the home page within a few seconds:

• Home page name may be in any language but it should end with ”home.aspx.”
• The classic team site should consist of STS#0 only.
• There should not be any text present.
• The classic team site should only contain a few default web parts, such as Newsfeed (SiteFeedWebPart), document library (XsltListViewWebPart), and getting started (GettingStartedWebPart).
• It shouldn’t use any custom master pages.
• It should not have the ModernizeHomepageOptOut feature activated.
• The classic publishing feature on the team site should be turned off.
• The display form template name should be “HomeEditForm.”

Remember, your classic team site should meet all the criteria mentioned above. Even failing to meet one of these criteria means you can’t modernize the home page. On the other hand, if the team site meets all these conditions, the home page will modernize on its own. You will not need to tweak anything manually. The automatic upgrade will take place the next time you visit the site.

Benefits of updating from classic home page to modern home pages

Over the years, SharePoint has introduced tons of new features in modern home pages. If you are using SharePoint to improve work productivity, using the modern home page makes sense because it allows you to collaborate with your team members quicker than before. Automatic upgrade to a modern home page gives you the opportunity to make the most of the powerful tools that SharePoint offers to boost work productivity.

Technical details about updating modern home page

• It applies to STS#0 site collections and other corresponding subsites.
• Your new modern home page will retain the name ”home.aspx” while the classic page will become ”home(old).aspx.”
• The automatic upgrade will only apply to your team site home page and not for any other classic page.
• The update will not automatically create an Office 365 group.
• The modern home page theme may not be identical to the classic theme. You may have to use custom colors and styles to change the appearance of the home page.

Make sure the classic page follows the criteria mentioned above for an automatic upgrade to a modern home page on Microsoft SharePoint. Learn more about other SharePoint features and experience enhancements!

Differences between Excel Power Query and Power BI and When to Use Them

Financial analysts need to prepare detailed accounting reports of different companies for different financial periods. It is almost impossible to do these things manually. That is why using Microsoft Excel makes more sense. They hit a formula, and it produces the desired reports quickly. But, is it always okay to use Excel to calculate different financial reports? Experts believe that Power BI is the closest competitor of Excel, and in some cases, it edges its competitor.

Understanding Power BI

Power BI is an application that helps to produce and also publish web-enabled reports for the clients. Once the user prepares and publishes a report, their clients can see them on their computers, laptops, mobiles, or any other device. But, how is it different from Excel Power Query? Here’s what everyone needs to know:

Power Query is also a data processing software application that helps to prepare various financial reports. They provide the following benefits:

• Connect several data sources, such as web pages, files, databases, APIS, etc.
• Combine different data and collate them together from different reports.
• Derive and use new columns of data.
• Remove, reduce, or format data.
• Reshape or edit data, including pivoting, grouping, un-pivoting, and transposing.
• Frame formulas for advanced manipulation of annual reports.
• Create and publish refreshable datasets.

Users can save their Power Query data either in Power BI or Excel. That is why users will find this function in both software applications. Power Query is a more flexible application that many financial analysts prefer. It helps them focus on real-life problems like where is the annual report, is the report up to the mark, what if there are missing values and things like that.

Difference between Power Query and Power BI

Both Power Query and Power BI can make interactive reports. But, there are a few differences between the two that users need to know:

• Power BI provides a more immersive interactive experience. Users can click on any option in the application and get an instant preview of what their report will look like. This application allows users to simplify complicated graphs and charts. They can export this data and use it in Excel for better visuals.
• This software application works better with large data sets. Power Query is more efficient in handling smaller data, while Power BI handles bigger data easily. So, if users have to make a lengthy report, they should use Power BI instead of Power Query. Moreover, it allows users to attach their business data set so that they can analyze volumes of data without checking any other application.
• Both Power Query and Power BI help to read and share reports quickly with the clients. However, Power BI allows users to share them in various formats so that even if the client doesn’t have Power BI, they can view the report without any obstruction.

The analyst is the best person to decide which software he/she likes the most. Both have their pros and cons, but it’s the comfort level of the user that matters the most.