In this video the author shows how to perform custom number format for turnover ratio in a Microsoft excel document. He shows how to perform custom number formatting in which he shows how to display a decimal value in words. He opens the Format Cells option and there he shows how to set the Custom option. He shows how to configure different options so that we can format the decimal value and display it as text with some meaning attached to it. In this video the author shows how to use custom ...
The step by step methods to isolate colors in Photoshop have been shown in the video. In a layer we have to place an image and first select the particular part to be isolated with the pen tool which has free form pen tool, add subtract, intersect and exclude overlapping path options. After that make a right click and select make selection option. Keep the feather be in 3 and click ok. Paste this in a new layer by pressing control+d keys. Create a copy layer of 2 and open Hue and saturation pa...
In this video tutorial, Chris Pels will show how to use the aspnet_merge.exe utility to combine assemblies that have been compiled using the aspnet_compiler.exe utility. First, view the output of the ASP.NET compilation process to learn what assemblies are created. Next, learn the mechanics of using the aspnet_merge.exe utility to merge assemblies from the compilation of a web site, first seeing how to control the compiled assembly names with the –prefix option. Then see how to merge all the ...
This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to “Display options for this workbook”, where you will see some check boxes. Uncheck the boxes for horizontal scroll bar, vertical scroll bar and sheet tabs. This will remove them from the current workbook. This feature only works with the current workbook.
Trying to pick out a great watch takes time, and if you don't know what you're looking for it can take even longer. With this great video you'll learn what options are available and what specific options you can pick to fit what you need it for.
The personal computer is a strange and powerful entity, capable of bringing great joy. Just as often, you probably want to chuck the damn thing at the wall because it doesn't work right. If you want to pull a prank on a friend that will really upset them, messing with their computer is one of the best ways to do it. This hilarious video will show you how to do three great PC pranks quickly and easily, including changing the contrast on the monitor and pretending to edit websites using Javascr...
Chris Davis with the Educational Technology Center shows us a few easy steps to putting YouTube videos in our Microsoft PowerPoint 2007 presentations. To start you'll need to have an active internet connection and you should have the developer tab in PowerPoint active. To do this go to the Office menu, PowerPoint options, popular and click show developer tab. Locate the hammer looking more control option button and scroll down to Shockwave Flash Object and click it. This allows you to draw a ...
This video tutorial from TruTricks presents how to setup Google customized alerts.Open your internet browser and search for Google Alerts using Google search engine.Click first result that says Google Alerts.You will need to sign in to use this Google feature.Google or Google mail account will work. If you don't have it you should create one.After you signed in Google Alerts welcome screen will open.Here you can create new Google alerts using Create a Google Alert window.Enter Search Term you...
Is your Outlook inbox starting to seem overwhelming? No problem! In just a few minutes you can corral that growing pile of e-mail by using the 'archive' feature. Have a look at this video and learn how to use this handy option and clean up the mess in your inbox.
This video tutorial from TutVid shows how to create a simple movie poster text effect in Adobe Photoshop CS4.
Want to learn nose drawing? Watch this tutorial to learn how to draw the male nose (step-by-step). Make sure to pause the video after each step and look at the screen every few seconds while you are drawing.
Developer Options is your first step to becoming a power user. If the Pixel 4a feels a bit slow, Developer Options can fix that. You want to root your device for unprecedented controls and powerful apps? You need to enable OEM unlocking in this hidden menu. ADB, secret features — Developer Options is where it all originates.
Before you go out to protest, understand what you are facing. Sometimes these demonstrations become infected with looters and rioters, which could mean interaction with law enforcement and potentially arrest. And if your phone is on you, it can be used as a tool against you.
The first thing any Android power user does with their phone is unlocked the Developer options. The hidden menu has many low-level tweaks, such as forcing Dark mode on all apps, speeding up animations, or enabling hidden Quick Setting tiles. And most modifications require nothing more than hitting a toggle.
If you're using or need to use Zoom, the popular video teleconferencing service, you've almost certainly heard about "Zoombombing" by now. While Zoom has been adding security measures to address the problem, there are other things you can do to prevent or stop Zoombombers in their tracks so that your video meetings and chats go undisturbed and uninterrupted.
One of the more competitive aspects to chat apps these days is customizability. It seems every messenger wants to offer the largest number of options for users to make the app feel like a truly personal experience. Telegram is no stranger to this customizability, offering tools where you can select backgrounds and chat bubble colors.
You don't have to be a frequent flyer to know how indispensable navigation apps have become. Many of us rely on these apps for traveling from state to state and getting around in foreign cities, but even more of us count on these apps to beat rush hour traffic and find the quickest routes to school or work. So naturally, we all have our favorite mapping apps, but which one is truly the best?
I noticed the neon yellow sign at the new location of Pho Bar in Chinatown right away. The sweeping cursive yellow letters spell out "Crazy Rich Broth"; the same phrase printed on the back of servers' shirts. It's the kind of minimalist but colorful design feature that is especially popular on Instagram at the moment — shots of patrons in front of a glowing sign.
In the latest example of non-tech companies taking on augmented reality marketing, online travel site Travelocity has added an AR version of its Roaming Gnome mascot to its mobile app.
Even though your iPhone's Camera app is fast and easy to use, its default settings prevent you from immediately accessing any other shooting mode aside from "Photo" with "Live Photo" on and no filter applied. But there is a way to make the Camera app remember what you prefer the next time you open it up.
After months passed since Google first announced the feature, YouTube's dark mode has finally reached the Android masses. Sure, it just changes some colors, but it has been a highly sought-after feature since iPhone users got it months ago.
If touring the scenic vistas behind the Lord of the Rings film franchise doesn't persuade tourists to visit New Zealand, perhaps immersive content viewed through Magic Leap One will do the trick.
If you've ever connected your iPhone to a computer before, you know iOS prompts you to "Trust" the computer and enter your passcode to confirm. According to Apple, trusted computers can "sync with your iOS device, create backups, and access your device's photos, videos, contacts, and other content." That's a lot of permissions to hand off, especially if the computer's not your main laptop or desktop.
We recently ran down several hidden features on the Galaxy S9 — items that are buried deep within the settings menu that can be tricky to find. One thing that many users cannot find is the option for a black navigation bar. Unfortunately, this option does not exist in Samsung's stock settings. But this is Android, so with a bit of developer magic, we can easily regain the black navigation bar in no time.
One click on the iPhone X's Side button locks or wakes the device. Two clicks opens Apple Pay. Holding down activates Siri. So how do you shut down the iPhone X then? On every other iPhone, you hold the Side button down until the "slide to power off" option appears, but that doesn't exist on the iPhone X.
Hulu used to be simple — just a site with all the latest clips and episodes from your favorite shows. Watch some ads, watch some free TV. Easy, right? Not so much anymore. Hulu is no longer free, and on top of that, offers different pricing plans and add-ons.
As my fellow cheapskates know, Groupon is an oasis. From discounted vacations to reduced-price massages, it has — nearly — anything and everything. It's great for discounts on dining and travel, but I've never thought of it as a place to shop for smartphones ... until now.
Parents rejoice, Apple Pay is making it much simpler for your kid to use Greenlight, the MasterCard for kids app.
Today, Facebook Messenger is rolling out Discover, a feature that helps you chat with companies and locate nearby businesses of interest to you. First discussed in April at Facebook's developer conference F8, Discover is finally available for public use.
The number of Legionnaires' cases in New York over the last couple weeks has led to concern and recommendations of caution for those at risk.
With iOS 11, Apple is working hard towards breaking down language barriers to bring people closer together than ever before, as evidenced by Siri's newfound ability to directly translate words and phrases in different languages. In the near future, it's easy to imagine Siri as our very own real-life BabelFish.
The Galaxy S8 continues to be a treasure trove of hidden features that, with a little digging and experimenting, can be easily unlocked to further enhance your overall experience with the device. DPI scaling, or the ability to adjust the size of on-screen content, is among these hidden options that come standard with Samsung's newest flagship.
Here's another workday distraction for all you social media lovers out there: Pasted, launching out of beta today on iOS, is a simple collage and photo editing app mixing iconic '90s imagery with a love of the The Shins.
Samsung's latest flagship devices—the Galaxy S7 and S7 edge—both sport an interesting new feature called Always On Display, or simply AOD. When enabled, this feature keeps the clock, date, and other bits of information visible at all times—even when the screen is off.
If you get a ton of emails each day, your mailbox probably has thousands of unread messages, and that annoying badge icon will keep reminding you of it. Fortunately, iOS comes with some tools to help you bring some sense of order to that chaotic mailbox of yours.
Many users across the web have reported issues with receiving notifications from the Gmail and Hangouts apps on Android. The problem is most prevalent with users running Marshmallow, and the gist is that notifications from these apps are extremely delayed or don't come through at all.
Basically, this article is a true life experience writing from the introspective mind of the writer and do share more knowledge on how to deal with introvert lifestyle.
As familiar as it may look at first glance, there are still tons of subtle changes in Windows 10. Many options that existed in past versions have been moved, and virtually every system menu received at least a small visual makeover.
There are a number of ways to give your productivity a kicktstart, from taking a break from your distracting smartphone to just taking a break, plain and simple. Yet finding the motivation to start working doesn't require any effort at all—just a little bit of green.
Edit: Some of the methods I show you may be difficult, or not work at famous or high quality hotels.
