Posts

Rather than manually inserting times and dates into a Google Sheets spreadsheet, you can use the NOW and TODAY functions. These functions show the current time or date, updating as your spreadsheet changes or on a regular basis. While the NOW and TODAY functions regularly update, you can quickly insert a non-updating time or date stamp using keyboard shortcuts. Adding the Current Time and Date Using NOW Adding the current time and date in a Google Sheets spreadsheet using the NOW function is almost too simple....

Microsoft Teams features native integration with an increasing number of third-party services, including cloud-based file storage like Box, Dropbox Citrix ShareFile, and Google Drive. Connect your existing storage to Teams to start sharing and collaborating with just a few clicks. By default, Teams gives you access to cloud storage through Microsoft’s OneDrive service. To import all of your folders and files from Box, Dropbox, Citrix ShareFile, or Google Drive, start by opening the Teams desktop application and navigating to the “Files” tab on the left....

Office 2013 allows you to add useful apps directly to Word, Excel, etc.. By apps, generally we mean research resources such as dictionaries for defining terms or accessing sites such as Wikipedia directly within Office programs to confirm facts. As an example, we will add WordCalc, which is a mathematical expression solver, to Word. To add an app to Word, click the Insert tab. In the Apps section of the Insert tab, click the Apps for Office button and select See All from the drop-down menu....

There are a few ways to add an overlay to a video. One way is to use a video editor, such as Adobe Premiere or Windows Media Player. Another way is to use a software plugin such as VLC or Kodi. To put a picture over a video on Windows Movie Maker, you can use the File > Place Image command. Yes, you can add audio to Windows Movie Maker by right-clicking on the video file and selecting “Add Audio....

Add Your Business to Google Maps Visit http://www.google.com/places/ and click Get Started Now. On the next page, you’ll be asked to sign in to your Google Account. If you are already signed in, it will skip this page. Note: Please be sure you are signed in to the correct Google Account. Whichever account is currently signed into will become the listing manager for the business you add. Google will first ask you for your business’s public phone number....

When you create a new instance in EC2, you’ll be given a PEM file that acts as your access key. You’ll have to use this to SSH into the server, so you’ll want to add it to your keychain for easy access. How To Use Your PEM File You can use PEM files manually by adding the -i flag to ssh: This is unwieldy to type every time, so there are a few ways to fix this....

What Are The Benefits of Increasing Server RAM? Allocating more RAM isn’t necessarily a silver bullet—oftentimes optimizing the server itself is a better solution than throwing more RAM at the problem—but there are certain situations where it is called for. Minecraft is a very resource-intensive game, and increasing the amount of RAM allocated to your server can solve a variety of issues from phantom blocks to players rubber-banding and stuttering as they move across the map....

There are a few reasons why your PS4 may not be automatically updating games. One possibility is that you may not have enough storage space on your PS4 system. If you’re only having a few games installed, they may not be taking up enough space to trigger the auto update process. Additionally, if you’ve deleted any games from your PS4 system, that may also prevent the auto update process from happening....

Windows 7 has a ton of great features, most of which are really obvious—but there’s also some great features hidden away that you might not know even exist. One of these is that Windows 7 can automatically change your default printer based on which network you’re connected to. The normal use case, of course, is to switch printers depending on whether you are at home or at work, but this feature is especially useful if you use one of the many print-to-PDF solutions—you can continue to print things even while you aren’t connected to any network....

If your forgetfulness applies to locking your front door, you can have the Schlage Connect smart lock automatically lock behind you. So if you forget to lock it, you won’t have to worry about it in the first place. RELATED: How to Disable the Beeper on the Schlage Connect Smart Lock Auto-lock works by automatically extending the deadbolt 30 seconds after its unlocked, which gives you plenty of time to open the door, leave, then close the door behind you before it locks....

Do you want your computer to automatically run a program, remind you about something, or even automatically send emails? Use the Task Scheduler included with Windows – its interface can be a bit intimidating, but it’s easy to use. The Task Scheduler has a wide variety of uses – anything you want your computer to do automatically, you can configure here. For example, you could use the task scheduler to automatically wake your computer at a specific time....

You’ve spent a lot of time configuring your Synology NAS to be just perfect. So take the time to periodically backup your configuration file to keep all your settings safe and sound. Much like you can back up the configuration settings of other devices in your home (like the configuration of many routers, including those running the popular open source DD-WRT), you can also back up the configuration of your Synology NAS, so in the event of a restoration or upgrade, you can easily import most of the old settings....

If you need to reinstall Ubuntu or if you just want to install a new version from scratch, wouldn’t it be useful to have an easy way to reinstall all your apps and settings? You can easily accomplish this using a free tool called Aptik. Aptik (Automated Package Backup and Restore), an application available in Ubuntu, Linux Mint, and other Debian- and Ubuntu-based Linux distributions, allows you to backup a list of installed PPAs (Personal Package Archives), which are software repositories, downloaded packages, installed applications and themes, and application settings to an external USB drive, network drive, or a cloud service like Dropbox....

Yes, Facebook allows you to back up your messages through the Facebook Messages app. To do this, open the Facebook Messages app and select the three lines in the top left corner of the main screen. From here, select Settings and then Backup. You can also backup your messages through the Facebook website by going to facebook.com/settings and selecting Backup Messages. There are a few ways to save Facebook messages....

To manually backup your iPhone 6, connect it to your computer and open iTunes. Click on the device icon in the upper left corner of the iTunes window, and then click on “Back Up Now” in the Summary panel. You can backup your iPhone on iTunes, but you may need to change your settings to do so. By default, iTunes will not back up your iPhone because it assumes that you will use iCloud to back up your device....

One of our most popular articles is how to install iTunes on Windows 10. Now, you likely install iTunes not just for its jukebox features, but also for managing that Apple device you own. We know, we hate it too. iTunes has evolved over the years into an albatross that does so many things but not one or a few particularly well. It manages your music library, synced media such as photos, movies and even data such as contacts....

You meant well, you intended to be a good file custodian, but somewhere along the way things got out of hand and you’ve got duplicate photos galore. Don’t be afraid to delete them and lose important photos, read on as we show you how to clean safely. Deleting duplicate files, especially important ones like personal photos, makes a lot of people quite anxious (and rightfully so). Nobody wants to be the one to realize that they deleted all the photos of their child’s first birthday party during a hard drive purge gone wrong....

After taking several dozen large, multi-megapixel photos, the last thing I want to do before uploading is manually shrink them. Rather than deal with long upload times, freeware application XnView comes to the rescue, batching resizes in a few easy steps. Install XnView and navigate to your folder with your group of images. Select each one you intend to resize. Once you have them selected, right-click and choose “Batch Processing” from the contextual menu....

If that wasn’t enough, you’ll also be Cursed – meaning that only your Captain can auto attack and use their Chain Combo. Luckily, we can clear the Curse by triggering Aurora Time – meaning we have to connect 15 tiles of the same color all at once. Things to keep in mind: You’ll need a lot of tiles, so bring a lot of Converters Schummer’s health is locked, meaning you have to wait another turn to deal more damage after getting her to 49% Clearing this requires a lot of RNG – don’t get demoralized if it takes you a while to clear....