Cool Tech Tips for a Cooler Life - www.One Cool Tip .com

Monday, July 3, 2023

How to Ensure Accurate Data Entry in Microsoft Excel

Have you ever struggled with inaccurate date entries in your Excel spreadsheets?

Do you want to ensure that the dates entered in your workbook fall within a specific range?

Here's a Cool Tip: Use data validation to restrict date entries in Excel.

Data validation is a powerful feature in Excel that allows you to control the type of data entered into a cell.

With data validation, you can specify that a cell can only accept values that meet certain criteria, such as a date within a specific range.

Here's how to do it:

Select the cells where you want the data validation applied.
In the Ribbon, select Data > Data Validation.
In the Settings tab, set the Validation criteria.
Set the Allow to Date

fig. 1 - Microsoft Excel Data Validation

Set the date range you want to apply.
Now, if a user tries to enter a date outside of the specified range, an error message will appear.
This helps ensure that the dates entered in your workbook are accurate and fall within the desired range.

You can choose many different data validations such as whole number, time, decimal or make your own Custom validation.

You can also set the error message to display.

So use Data Validation the next time you are creating a spreadsheet for data entry.

Enjoy!

Please Like and Share OneCoolTip.com!

READ MORE

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#Microsoft #Excel #software #techtip #BacktoWorkMonday #MicrosoftExcel #DataValidation #Productivity #OneCoolTip @Microsoft

Sunday, July 2, 2023

How to Illuminate Your Way with the Apple Watch

Are you making the most of your Apple Watch?

Beyond tracking your fitness goals and receiving notifications, this sleek wearable has a hidden feature that can be a lifesaver in certain situations.

Here's a Cool Tip: Apple Watch Flashlight feature.

Just like your iPhone, your Apple Watch can double as a handy flashlight.

Whether you're fumbling for your keys in the dark or need a little extra light in a dimly lit environment, the Apple Watch flashlight is here to illuminate your way.

How to Access the Flashlight Feature

Raise your wrist or tap the screen of your Apple Watch to wake it up.
Once it's awake, swipe up from the bottom of the screen to reveal the Control Center.
Find the flashlight icon—a small, illuminated torch symbol.

fig.1 - Apple Watch, Control Panel, Flashlight

Turn On the Flashlight

Tap the flashlight icon.
Your Apple Watch's screen will transform into a radiant light source.
Swipe left to choose a mode:

a steady white light,
a flashing white light, or
a steady red light, perfect for lighting the dark without being annoying.

Adjust the Brightness

Once the flashlight is activated, press on the screen to adjust the brightness level.

Turn Off the Flashlight

Tap the flashlight icon in the Control Center again to switch off the light.
Or, press the Digital Crown on the side of your Apple Watch to return to the watch face, automatically deactivating the flashlight.

That's it.

Enjoy!

Please Like and Share OneCoolTip.com!

READ MORE

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#AppleWatch #FlashlightFeature #TechTips @Apple #TechTips #OneCoolTip

Saturday, July 1, 2023

How to Change Your Windows Desktop Icon Size

Are your Windows desktop icons too small?

Maybe they are too big?

Here's a Cool Tip to make them just right.

Use Your Mouse.

Here's how to do it.

Click your desktop background.
Hold the CTRL key on your keyboard and scroll your mouse wheel up or down,
Keep scrolling the mouse wheel to increase or decrease the size of your icons until the icons are the size you want.

fig. 1 - Increase or Decrease Windows Icon Size
by Using Your Mouse

That's it!

Enjoy!

Please Like and Share OneCoolTip.com!

READ MORE

OneCoolTip.com
http://www.onecooltip.com
Cool Tech Tips for a Cooler Life!

#microsoft #windows #windows10 #windows11 #desktop #icons #techtip #OneCoolTip

Friday, June 30, 2023

Discover the World of the Ultimate Relaxation Tool

Are you looking for a way to enhance your focus, relaxation, and sleep?

Do you want to create your perfect audio environment?

Here's a Cool Tip for Friday Funday: myNoise.com!

This website offers a world of immersive and customizable soundscapes that can help you achieve your desired state of mind.

It offers a vast library of interactive sound generators, including noise generators, nature sounds, and ambient music.

You can choose from a variety of options to create your perfect audio environment. For example, if you want to concentrate better, you can choose from consistent auditory environments that minimize distractions.

Here are some of my favorites:

The Irish Coast generator offers seaside sounds made of ocean waves, rain, and wind - nature’s ultimate noise blockers.
The Cafe Restaurant generator can help you brew up creativity.
The Japanese Garden generator lets you embrace zen tranquility in a Japanese garden.
The Singing Bowls generator produces soothing vibrations.
The Waterfall generator lets nature’s white noise cascade away distractions and lull you into dreamland
The Distant Thunder generator offers a gentle rain and far-off rumbles.

fig. 1 - myNoise Focus and Productivity

Using myNoise is easy.

You can adjust the volume of each sound to create your perfect mix.

And if you’re not sure where to start, myNoise offers a variety of presets to help you get started.

So why not give it a try?

Enjoy!

Please Like and Share OneCoolTip.com!

READ MORE

OneCoolTip.com
http://www.onecooltip.com
Cool Tech Tips for a Cooler Life!

#mynoise #relaxation #focus #sleep #ambientmusic #naturesounds #noisegenerators #OneCoolTip #techtip #FridayFunday

Thursday, June 29, 2023

How to Use Google's New Filter to See Different Perspectives on Any Topic

Are you tired of seeing the same old perspectives on the news?

Do you want to learn more about different viewpoints on a topic?

Here's a Cool Tip: Google's new Perspectives filter.

The Perspectives filter is a new feature that allows you to see a variety of perspectives on any topic.

When you use the filter, Google will show you a mix of long and short-form videos, images, and written posts from a variety of sources, including discussion boards, Q&A sites, and social media.

This means that you can get a more well-rounded view of a topic by seeing what people from different backgrounds and with different experiences have to say.

Google Search Results with Perspectives Filter

fig.1 - Google Search Results for Culver's with Perspectives Filter

Here's how to use the new Perspectives filter:

Go to Google on the web or use the mobile Google app for iPhone or Android.
Search for a topic.
Click on the Perspectives filter.
For the mobile apple, swipe the filters until you see Perspectives.
Scroll through the results and see what different people have to say.

Here are some additional tips for using the Perspectives filter:

This feature is slowly rolling out to users. Try checking if you can see the Perspectives filter on the web or mobile app version.
Pay attention to the sources of the content. This will help you to understand the different perspectives that are being represented.
Don't be afraid to click on the links to the original content. This will give you the opportunity to learn more about the different perspectives.
Use the filter to find new and interesting topics. You might be surprised at what you find.

An interesting note is that many users would add Reddit to the end of their Google search input in order to filter results to include comments from the popular site.

However, this no longer works well since Reddit's recent policy changes on APIs and moderation has resulted in many popular subreddits going dark or unusable.

So try this new Google feature on your next Google search!

That's it.

Enjoy!

Please Like and Share OneCoolTip.com!

READ MORE

OneCoolTip.com
http://www.onecooltip.com
Cool Tech Tips for a Cooler Life!

Source: Google Blog

#GooglePerspectives #PerspectivesFilter #SeeDifferentPerspectives #DiverseVoices #WellRoundedView #GoogleNews #GoogleSearch #GoogleUpdates #GoogleTips #Reddit #techtips #OneCoolTip @Google

Wednesday, June 28, 2023

Discover the Power of What3Words

Are you tired of getting lost in unfamiliar places, struggling to find precise locations, or having difficulty explaining directions to others?

What if there was a revolutionary app that could simplify location sharing by using just three words?

Imagine the possibilities of a world where every corner of the globe has been divided into three-meter squares, each assigned a unique combination of three simple words.

Wonder no more.

Here's a Cool Tip: What3Words!

What3Words divides the world into 3 metre squares and gives each square a unique combination of three words.

It’s the easiest way to find and share exact locations.

For example, the White House in Washington DC is goods.enjoyable.loft.

What 3 Words - The White House - Washington DC

fig. 1 - The White House What 3 Words - goods.enjoyable.loft

Here's how to use it.

Download the app from the Apple iPhone store or Google Android store/

Familiarize yourself with the concept of three-word addresses.

What3Words has assigned a unique combination of three words to every three-meter square on the planet.

To share your current location, tap the "Share" button at the bottom center of the app interface.

A three-word address corresponding to your current location will be displayed.
You can either copy the three-word address or share it directly with others through various communication apps on your device, such as messaging apps or email.

To navigate to a specific three-word address, tap the "Navigate" button at the bottom right of the app interface.

Enter the three-word address you want to navigate to in the search bar.
The app will display the precise location on the map along with the three-word address.

What3Words offers additional features to enhance your location-sharing experience.

You can save favorite locations, view nearby points of interest, and switch between different map views (standard, satellite, or hybrid) to suit your preferences.
Explore the app's settings to customize notifications, language preferences, and coordinate display formats.

You can check out more information at: https://what3words.com/

With these simple steps, you can harness the power of What3Words to easily share precise locations, navigate unfamiliar areas, and communicate locations with utmost accuracy.

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

READ MORE

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#What3Words #PrecisionLocation #NavigationRevolution #SimplifyLocationSharing #3WordsNavigation #TechTips #OneCoolTip

Tuesday, June 27, 2023

The Secret Way to End a Phone Call Without Being Rude

Do you need to hang up on someone but don't want to be rude about it?

Maybe it's a sales call.

Maybe it's your annoying in-law.

Here's a Cool Tip: Airplane Mode.

Here's how to do it.

When on a call you want to end, just say that the connection is breaking up
Then turn on airplane mode
Your call will end and you'll won't be able to receive calls.
When you are ready to make and receive calls again, turn off airplane mode.

Note: If you are on WiFi and have WiFi calling turned on, you'll need to also turn off WiFi.

That's it!

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

READ MORE

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#phonecalls #airplanemode #howto #productivitytips #tech #lifehack #socialmedia #awkward #iPhone #android #mobilephone

Monday, June 26, 2023

How to Set One Simple Setting Change That Will Make Your Microsoft Word Documents Look Better

Do you find the white space between pages in Microsoft Word distracting?

Do you wish you could focus on your document without being interrupted by the gray areas?

Here's a Cool Tip: Change the Setting to hide the white space in Microsoft Word.

When you're working in Print Layout view in Microsoft Word, you may see a gray area between pages.

fig. 1 - Microsoft Word with White Space

This is the white space that's not visible when you print the document.

If you find this white space distracting, you can hide it by changing a setting in Word.

Here's how to do it.

Open the document that you want to hide the white space in.
Click the File tab.
Click Options.
In the Word Options dialog box, click the Display tab.
In the Page display options section, uncheck the Show white space between pages in Print Layout view checkbox.
Click OK.

fig. 2 - Microsoft Word White Space Setting

The white space between pages will now be hidden.

fig. 3 - Microsoft Word with No White Space

Here are more Cool Tips to hide white space in Microsoft Word:

Double-click the gray area between pages. This will toggle the visibility of the white space.
Use the keyboard shortcut Ctrl+Shift+8. This will hide all non-printing characters, including the white space between pages.
Use the View tab in the Ribbon. In the Show/Hide group, uncheck the White space checkbox.
Whichever method you choose, hiding the white space in Microsoft Word can help you to focus on your document and make it easier to read.

Enjoy!

Please Like and Share OneCoolTip.com!

READ MORE

OneCoolTip.com
http://www.onecooltip.com
Cool Tech Tips for a Cooler Life!

#Microsoft #Word #microsoftword #wordprocessing #documentformatting #whitespace #onesimplesettingchange #productivitytips #TechTip #OneCoolTip @Microsoft

Sunday, June 25, 2023

How to Search Google with Right Click

Do you ever find yourself wanting to search Google for a word or phrase that you see on a web page, but you don't want to open a new tab or window?

If so, here's a Cool Tip: Right Click.

You can use the right click menu to search Google using Google Chrome for the selected text.

Here's how to do it:

Open the Google Chrome browser.
Open the web page that contains the word or phrase that you want to search for.
Right click using the mouse on a word or phrase.
Select "Search Google for 'word or phrase'" from the right click menu.

fig. 1 - Search Google with Right Click

Google will open a new tab or window with the search results for the selected text.

That's it.

Enjoy!

Please Like and Share OneCoolTip.com!

READ MORE

OneCoolTip.com
http://www.onecooltip.com
Cool Tech Tips for a Cooler Life!

#rightclicksearch #googlesearch #searchengineoptimization #seo #webdevelopment #techtip #techhacks #Google @Google #OneCoolTip

Saturday, June 24, 2023

Google Bard Goes Dark

Do you find yourself using Google Bard, Google's new AI service, at night or in low-light conditions?

Here's a Cool Tip: Dark Mode.

Dark Mode is a feature that changes the color scheme of Google Bard site to a dark background and light text.

This can make it easier on your eyes and reduce eye strain.

Here's how to do it.

Steps to Enable Dark Mode:

Open Google Bard in your browser.
Click on Dark Mode icon at the bottom-left of the screen

fig. 1 - Google Bard Dark Mode icon

This will put you in Dark Mode.
To undo, just select the Dark Mode icon again.

There are a few reasons why you might want to use Dark Mode in Google Bard.

First, it can help to reduce eye strain.

When you are using a computer or device in low-light conditions, the bright white background of most websites and apps can be harsh on your eyes.

Dark Mode can help to reduce this strain by making the background darker and the text lighter.

Dark Mode also can help to save battery life.

This is because the display of your device has to work less when it is displaying a dark background.

This is a great new feature for Google's AI.

Enjoy!

Please Like and Share OneCoolTip.com!

READ MORE

OneCoolTip.com
http://www.onecooltip.com
Cool Tech Tips for a Cooler Life!

#Google #Bard #googlebard #darkmode #tech #productivity #techtip #OneCoolTip @Google

Friday, June 23, 2023

How to Paint the Universe

Do you need a few minutes of creativity?

A moment to spread color throughout the universe?

Check out this Cool Tip for Friday Funday: 29a.ch

This site lets you create a colorful cosmos.

Pick a color and start spreading your artistic design across the universe.

Then pick another color.

And another.

Until you have a sea of colors across the sky.

fig. 1 - 29a.ch

That's it!

Enjoy.

Please LIKE and SHARE OneCoolTip.com!

READ MORE

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#29a.ch #FridayFunday #Create #TechTip #OneCoolTip

Thursday, June 22, 2023

How to Silence Unknown Callers in WhatsApp

Are you tired of being interrupted by spam calls on WhatsApp?

If so, you're not alone.

Millions of people receive spam calls on WhatsApp every day.

Here's a Cool Tip: Silence unknown callers in WhatsApp.

This will help you to reduce the number of spam calls you receive and it will also protect your privacy.

WhatsApp is a great way to stay in touch with friends and family but it can also be a nuisance if you receive a lot of calls from unknown numbers.

Here's how to do it:

Open WhatsApp on your mobile device.
In the top right corner, click on the three vertical dots.
Select Settings.
Select Privacy.
Select Calls.
Toggle on the option to Silence unknown callers.

fig. 1 - WhatsApp Silence Unknown Callers

Once you've done this, WhatsApp will no longer ring when you receive a call from an unknown number.

The call will still show up in your call log, so you can still see who called you if you need to.

Here are some additional things to keep in mind:

If you call or message an unknown number, you won't be able to silence their calls in the future.
You can still block unknown callers if you want to prevent them from calling you altogether.
If you have a lot of contacts saved in your phone, you may want to create a group for unknown callers so that you can easily see who has called you.
Silencing unknown callers is a great way to reduce the number of spam calls you receive. It's also a good way to protect your privacy, as you won't be interrupted by calls from people you don't know.

Please LIKE and SHARE OneCoolTip.com!

READ MORE

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#WhatsApp #spamcalls #privacy #howto #tutorial #tech #silenceunknowncallers #reducespamcalls #protectyourprivacy #whatsapptips #Meta #techtips #OneCoolTip

Wednesday, June 21, 2023

How to Find These Lost Dishes in St. Louis

Do you like to cook?

Do you remember popular dishes from restaurants that are no longer around?

If you are a St. Louis, MO native, you're in luck.

Here's a Cool Tip: Lost Dishes

Lost Dishes is a website that shares secret recipes from popular St. Louis restaurants that are no longer around.

It is a companion site to Lost Tables.

Lost Dishes hosts recipes from many popular restaurants, including Casa Gallardo, Busch's Grove, Miss Hullings, and Balabans.

The recipes are organized by categories such as Beverages, Appetizers, Main Entres and Desserts.

Here are a few popular recipes:

fig.1 - Strawberry Crepes Supreme - The Magic Pan

That's it!

Enjoy!

Please LIKE and SHARE OneCoolTip.com!

READ MORE

OneCoolTip.com

http://www.onecooltip.com

Cool Tech Tips for a Cooler Life!

#losttable #lostdishes #restaurant #recipe #techtips #OneCoolTip