Connect with us

Technology

Ultimate Microsoft Office Mastery: 90+ Tips, Tricks, and Tutorials for You

Published

on


Use Microsoft Office every day? Check out our tips, tricks, and tutorials that’ll turn you into an efficiency machine with both Microsoft Word and Microsoft Excel.

Microsoft Office is powerful; there’s a reason why nearly every serious business in the world relies on it for office productivity. Yes, Microsoft Office can be daunting to learn, what with all of its crazy menus and features—but it doesn’t have to be difficult at all.

If you use either Microsoft Word or Microsoft Excel on a regular basis and want to become a more fluent user, we have all kinds of tips, tricks, and tutorials that’ll help you effortlessly learn the ins and outs of each program. You’ll be a master in no time!

Getting Started With Microsoft Office

If you’re a new user, or if you don’t even have Microsoft Office yet, you may want to check out our articles on how to acquire a copy of Microsoft Office for free—without breaking the law. Did you know you can even use Microsoft Office on Linux computers?

Once Microsoft Office is installed, you may also want to make a few tweaks and install a few add-ins that’ll ease your overall experience:

Mastering Microsoft Word

microsoft-word-auto-update

Beginner Tips for Microsoft Word

The first step to getting comfortable with Microsoft Word is making sure it’s set up properly. With a few tweaks to the settings, and some familiarity with basic features, you’ll feel much more at home when using the software:

And then once you’re comfortable with Microsoft Word, that’s when you’ll want to check out our various tutorials on how to do things with it, which will give you a quick boost to productivity:

Advanced Tips for Microsoft Word

After acquainting yourself with the basics of Microsoft Word, that’s when you’ll be ready to try full-fledged projects that are more than just simple essays and typed reports. Here are some of the cooler things you can do with Microsoft Word:

Useful Templates for Microsoft Word

Don’t have time to make new documents from scratch? You aren’t alone. That’s why you should check out our roundups of the best Microsoft Word templates for all kinds of needs and use-cases:

Mastering Microsoft Excel

For many, Excel is the much tougher software compared to Word. Numbers and formulas will do that to you. That’s why before you dive into our Excel tips and tricks, we recommend starting with these introductory articles:

Beginner Tips for Microsoft Excel

The first and most important skill to learn in Microsoft Excel is understanding worksheets and tabs. Check out our beginner articles that teach you how to set up, edit, recover, and compare Excel worksheets with ease:

And then learn the other essential skills that’ll give you a leg up when it comes to creating and modifying Excel spreadsheets. There’s a lot of cool stuff you can do, and most of it’s quite easy once you know how to do them:

Advanced Tips for Microsoft Excel

Microsoft Excel is a powerhouse application, and with a bit of know-how, you can effortlessly pull off some crazy cool tasks. Here are some of the more advanced techniques you can use to manage your Excel worksheets:

And there are plenty of more advanced tricks you can use to automate much of the process when dealing with complex Excel spreadsheets, and these automations will save a ton of time over the long run:

Useful Templates for Microsoft Excel

Who has the time to build new Excel spreadsheets from scratch? Whether for personal or business use, you should consider downloading one of the many free templates available on the web and customizing it to your specific needs:

Read the full article: Ultimate Microsoft Office Mastery: 90+ Tips, Tricks, and Tutorials for You



Source link

قالب وردپرس

Technology

Apple’s AR glasses just hit a key developmental milestone

Published

on



  • Apple’s rumored AR glasses recently hit a key developmental milestone
  • Apple’s AR glasses may arrive as soon as 2022.
  • Tim Cook has long been a fan of Augmented Reality and believes the technology’s impact could rival that of the iPhone.

Amid rumors that Apple may release a pair of Augmented Reality-powered glasses in early 2022, a new report from The Information relays that work on the highly anticipated product continues to move forward. The report specifically claims that a key developmental milestone was recently reached as semitransparent lenses for the device recently “passed the prototype stage and entered trial production.”

The report indicates that mass production is still a good two years away, which aligns with previous reports we’ve seen. Of course, there’s no guarantee Apple’s AR glasses will hit the market given that the entire project has been subject to various delays in recent years. There was even a brief period of time, rumor has it, where Apple canceled the project altogether.

That notwithstanding, The Information adds:

The lenses use a polarized system, similar to the technology in 3D movie glasses, which create the illusion of depth using stereoscopic images, the person said. The technology is similar to that in other AR and VR devices already on the market from Microsoft, Magic Leap and Facebook…

The person said making the AR lenses is especially challenging because they are composed of multiple, extremely thin layers of different synthetic materials, each of which is susceptible to bubbles, scratches and other marks. To reduce defects, the lenses must be manufactured in dust-free zones known as clean rooms.

Apple reportedly has upwards of 1,000 employees currently working the project. You might also recall that code in an iOS 13 build from last September contained references to AR-based applications and devices.

As to what type of functionality Apple’s AR glasses will bring to the table, the device will include a microphone to allow users to call Siri into action and, of course, field and make calls. There are also indications that the device will ship with a built-in accelerometer so that the device can register commands when a user moves his or her head in a particular direction.

The first incarnation of Apple AR glasses will likely not include a camera due to battery life and design considerations. Subsequent models, however, may feature a camera module.

Design-wise, it’s believed that Apple’s AR glasses will support both polarized and prescription lenses. Further, different sizes will be available for both men and women. Aesthetically, rumor has it that the product will look like a regular pair of glasses with thicker than average frames which will contain the battery and assortment of chips.

It’s far too soon to know how much Apple’s AR glasses might cost, but an alleged Foxconn insider a few years ago suggested it might be in the range of $600.

Incidentally, Tim Cook has long been a champion of Augmented Reality, with the Apple CEO a few years ago stating that it remains a “core technology” Apple continues to invest in.

“I think AR is extremely interesting and sort of a core technology,” Cook said back in 2016. ” So, yes, it’s something we’re doing a lot of things on behind that curtain that we talked about.”

All told, it will be interesting to see how the market reacts to Apple’s AR Glasses if and when it’s released. Recall that Google Glass, while intriguing, was more of a gimmick with few real-world applications. In turn, Google Glass didn’t gain any traction in the market. If Apple’s AR glasses, in contrast, can prove itself to be more than a gimmick, perhaps Apple will have another breakout hit on its hands.



Source link

قالب وردپرس

Continue Reading

Technology

Microsoft Teams takes on Zoom with bizarre new feature

Published

on


{“@context”:”https://schema.org”,”@type”:”VideoObject”,”name”:”Metro.co.uk”,”duration”:”T55S”,”thumbnailUrl”:”https://i.dailymail.co.uk/1s/2020/07/10/08/30607208-0-image-a-59_1594367601294.jpg”,”uploadDate”:”2020-07-10T08:52:47+0100″,”description”:”Together mode is a new meeting experience in Teams that uses AI segmentation technology to digitally place participants in a shared background, making it feel like you’re sitting in the same room with everyone else in the meeting or class.”,”contentUrl”:”https://videos.metro.co.uk/video/met/2020/07/10/4451065279760546166/640x360_MP4_4451065279760546166.mp4″,”height”:360,”width”:640}

To view this video please enable JavaScript, and consider upgrading to a web
browser that
supports HTML5
video

Microsoft is adding a virtual auditorium view to its Teams communication platform in a bid to make video meetings feel more natural during lockdown.

The firm has developed AI technology that places participants alongside one another, digitally seated with the same background, creating the impression everyone is in the same room.

‘Together mode’ is designed to help people feel more connected and less fatigued by video meetings, which have become commonplace among those working from home since coronavirus lockdown measures came into place in March.

The feature – which rolls out on Thursday before becoming generally available in August – is one of a number of improvements the tech giant is introducing on Microsoft Teams.

Users can expect to find video filter enhancements and emoji-based live reactions to pop up on screen among the raft of updates.

It’s like being back at uni – only with video calling (Microsoft 365)

Microsoft Teams displays, a new category of device for the firm, has also been announced amid a surge in demand for video communication tools and growing competition from the likes of Zoom, Facebook and Google.

These Teams-focused devices will have an ambient touchscreen and a hands-free experience powered by Cortana.

Microsoft teams turns meetings into virtual auditoriums

This is…strange (Microsoft 365)

The Lenovo ThinkSmart View will be the first Microsoft Teams display to be made available



Source link

قالب وردپرس

Continue Reading

Technology

How to Post a YouTube Video on Instagram

Published

on


One of the best ways to reach out to family, friends, and strangers is through Instagram. However, if you want to share a video with someone on the platform, you’ll need to know how to post a YouTube video on Instagram.

So, in this article, we’ll show you how to post a YouTube video on Instagram using either your mobile device or desktop computer.

How to Post a YouTube Video on Instagram From Your Smartphone

Using a smartphone to post a YouTube video on Instagram isn’t as easy as it sounds. The process is different for both Android and iPhone users, which only complicates matters even more.

Step 1: Install TubeMate

If you have an iPhone, please refer to our article detailing how to download YouTube videos to your iPhone Camera Roll. As for Android users, we’ll let you in on how you can download YouTube videos to your device using TubeMate.

This app isn’t available through the Google Play Store, so you’ll have to download it directly from the TubeMate site. Before you install TubeMate, you’ll need to tweak a security setting that lets your device download apps that aren’t on the Google Play Store. Just make sure to only use this setting for apps you trust.

To enable this setting, head to Settings > Apps > Special access > Install unknown apps. From here, select the browser that you’re downloading TubeMate from, and toggle on “Allow from this source.”

Now, you can go ahead and download TubeMate from any of the links listed on its site.

Download: TubeMate for Android (Free)

Step 2: Download the YouTube Video on Your Android Device

TubeMate writes over the original YouTube app, and adds a download feature. Simply open TubeMate, search for the YouTube video you want to download, and then click the red download button in the bottom-right corner of the video.

You’ll get the option to choose from several different video qualities. If you want to download a 1080p video (the max resolution for Instagram videos), you’ll have to download the MP3 video converter app that TubeMate directs you to.

Step 3: Shorten the Video

In addition to putting a limit on your video’s max resolution, Instagram also has a length restriction for videos—you can only upload videos between three and 60 seconds long. If your video is already within these limits, you can skip this step.

You can easily shorten your video using your phone’s built-in video editor or by using a third-party app—for this part, I used my phone’s built-in editor. After accessing the video, I hit the pencil icon at the bottom of the video, and then selected the scissors icon. From here, I dragged the white bars to fit the portion of the video that I wanted to keep, and then hit Save.

Step 4: Post the YouTube Video on Instagram

When you’re ready to make your post, open the Instagram app, and click the plus icon at the bottom of the page. Select the YouTube video from your gallery, add a filter, write a caption, and then hit Share.

How to Post a YouTube Video on Instagram From Your Computer

You have to jump through just as many hoops when posting a YouTube video to Instagram using your computer. It’s a multi-step process that we’ve outlined below.

Step 1: Install 4K Video Downloader

4K Video Downloader YouTube Videos

4K Video Downloader is a reliable tool that you can use to download videos from YouTube, Facebook, TikTok, Vimeo, and more. Not only does this full-featured video downloader allow you to extract subtitles from YouTube videos, but it even lets you download videos in 4K. This makes it ideal for prepping YouTube videos for Instagram.

To learn more about this handy software, make sure to check out our review of 4K Video Downloader.

Download: 4K Video Downloader for Windows, macOS, or Linux (Free, with premium version available)

Step 2: Download the YouTube Video on Your Desktop

Now that you have 4K Video Downloader, you’ll want to use it to download the YouTube video of your choice. Start by copying the URL of the YouTube video, and then hit Paste Link in the top-left corner of the 4K Video Downloader menu.

4K Video Downloader will automatically detect the link you just copied. After it’s done parsing the video, you can choose from several different resolution options that can even go up to 8K if the video supports it. Instagram only permits video uploads of up to 1080p, so you won’t have to worry about downloading 4K or 8K videos.

Download YouTube Video Quality

4K Video Downloader also presents you with an option to change the video format, but you’ll want to leave that set on MP4. To start the download, hit Download at the bottom of the page.

Step 3: Shorten the Video

You can quickly trim the video using Windows’ built-in Movies & TV app, or you can opt to use iMovie on macOS. There are also plenty of other video editing apps you can use instead.

Here, we’ll give you a quick tutorial on how to trim the video in Movies & TV. After opening the video in Movies & TV, click the pencil icon at the bottom of the menu, and select Trim from the dropdown menu.

Edit YouTube Video in Photos

You can drag the two white markers on either side of the video’s timeline to set a new length. When you’re finished, click Save a copy in the top-right corner of the app.

Step 4: Transfer the YouTube Video to Your Smartphone Using Google Drive

Unfortunately, Instagram doesn’t allow you to post photos or videos from its desktop site. The easiest way to get around this is to send the downloaded video to your smartphone.

There are quite a few options when it comes to transferring the video to your mobile device. You can use a cloud storage provider, attach the video to an email, or even sync your mobile device to your computer. For this article, we’ll show you how to send the video to your smartphone using Google Drive.

First, ensure that you have a Google Drive account, and make sure you’ve already downloaded the Google Drive app on your smartphone.

To upload your video to Drive, follow these simple steps:

  1. Open Google Drive.
  2. Hit the New button in the left corner of the screen.
  3. Select File Upload from the dropdown menu.
  4. Find the YouTube video you downloaded, and hit Open.

When the video finishes uploading, you should be able to open Google Drive on your mobile device and select the video. From here, hit the three vertical dots in the right corner of the video, and hit Download.

Now that the video is on your mobile device, you can upload the video to Instagram using the same steps that we’ve previously outlined.

How to Share YouTube Videos on Instagram the Right Way

Sharing a YouTube video on Instagram may sound complicated, but it’s easy once you get the hang of it. While both methods outlined above require a series of steps, posting on your smartphone is ultimately the easier way to post a YouTube video on Instagram. This way, you don’t have to go through the trouble of dealing with Google Drive.

Having YouTube videos on your Instagram page can help attract more followers to your page. For more ways to make your profile unique, check out these tips to make your Instagram stand out.

Read the full article: How to Post a YouTube Video on Instagram



Source link

قالب وردپرس

Continue Reading

Trending