Wednesday, December 6, 2023

How to Get the Word Count in Microsoft Word

Microsoft Word
Have you ever found yourself in the middle of a writing project, wondering how many words you’ve written so far? 

Or perhaps you’re working on a document with a strict word limit, and you need to keep track of your progress. 

Here's a Cool Tip.  Use the Word Count Keyboard Shortcut.

Here's how to do it.

Click the Status Bar Word Count
  • Open your Microsoft Word document.
  • Look at the bottom left corner of the Word window. 
    • You should see a count of the words in your document.
  • If you don’t see the word count, right-click on the status bar at the bottom and click on ‘Word Count’.
  • Click the Word Count on the status bar to display the Word Count screen.
Keyboard Shortcut
  • Press and hold CTRL + SHIFT + G to display the Word Count screen.

Microsoft Word - Word Count

fig. 1 - Word Count Keyboard Shortcut
CTRL + SHIFT + G

The word count feature is a great tool for keeping track of your word count without interrupting your workflow. 

That's it.

Enjoy!


Please LIKE and SHARE OneCoolTip.com!
Visit the OneCoolTip YouTube Channelhttps://www.youtube.com/@onecooltip


READ MORE

OneCoolTip.com
Cool Tech Tips for a Cooler Life


#Microsoft @Microsoft #Word #MicrosoftWord #WordCount #WritingTips #Productivity #TechTips #OneCoolTip @OneCoolTip 

Tuesday, December 5, 2023

Preserve the Quality of Your Memories on WhatsApp for iPhones

WhatsApp Messenger
Have you ever shared a high-resolution photo on the iPhone WhatsApp app, only to find that its quality was significantly reduced? 

Or perhaps you’ve sent a video, but the recipient complained about the poor resolution? 

If so, you’re not alone. 

But what if there was a way to preserve the original quality of your photos and videos when sharing them on WhatsApp?

Here's a Cool Tip.  Use the newest version of What'sApp Messenger app for iPhone.

WhatsApp Messenger, the popular messaging app, has introduced a feature that allows users to send photos and videos at the original quality of the media files. 

Here's how to use it.
  • Ensure you have the most recent version, 23.24.73 or greater, of the WhatsApp Messenger app for iPhone.
  • Save the photo or video.
  • Open WhatsApp and access the chat where you want to send the image or video.
  • Tap the "+" icon and select the “Document” option.

Select Document
fig. 1 - Select Document
  • Tap “Choose Photo or Video”.

Choose Photo or Video
fig. 2 - Choose Photo or Video
  • Select the image or video and tap Send to confirm your choice.
The primary benefit of this feature is that it allows you to maintain the original quality of your photos and videos. 

When you send photos as documents, WhatsApp Messenger does not compress the images. 

This ensures that the recipient receives the photos in their original quality. 

You can also select multiple photos and send them as a single document, making it easier for your recipients to view and download them.

This feature is rolling out to users over the coming weeks.

That's it!

Enjoy!

Please LIKE and SHARE OneCoolTip.com!
Visit the OneCoolTip YouTube Channelhttps://www.youtube.com/@onecooltip

READ MORE

OneCoolTip.com
Cool Tech Tips for a Cooler Life


#iPhone #Apple @Apple #Messenger #WhatsApp #Photo #HiRes #TechTips #OneCoolTip @OneCoolTip

Monday, December 4, 2023

How to Unlock Age Calculation in Excel

Have you ever wondered how to calculate someone’s age in Excel? 

Or have you tried to do it but found it more complicated than you expected? 

Here's a Cool Tip.  Use the DATEDIF in your formula, 

DATEFIF a hidden gem in Excel that makes age calculation a breeze.

www.OneCoolTip.com Back to Work Monday

Here's how to do it.
  • Open your Excel spreadsheet where you have the names and birthdates.
  • Insert a new column for ‘Age’.
  • Click on the first cell under the ‘Age’ column.
  • Type the DATEDIF formula: =DATEDIF(B2,TODAY(),"Y")
    • B2 should be the cell containing the birthdate
    • "Y" calculates the difference in complete years.
  • Press Enter and the age will be calculated.
  • Drag the fill handle (small square at the bottom-right of the cell) down to copy this formula to the rest of the cells in the ‘Age’ column.

Calculate Age in Excel with DATEDIF

fig. 1 - Calculate Age in Excel with DATEDIF


DATEDIF is a simple and easy to use once you understand how it works.

And it automatically updates the age as time progresses.

Enjoy!

Note:  Microsoft provides this functionality to support older versions of Excel.  It's possible that they will stop supporting it.


Please LIKE and SHARE OneCoolTip.com!
Visit the OneCoolTip YouTube Channelhttps://www.youtube.com/@onecooltip


READ MORE


OneCoolTip.com
Cool Tech Tips for a Cooler Life

#Microsoft @Microsoft #ExcelTips #DATEDIFFormula #AgeCalculation #ExcelTutorial #BackToWorkMonday #TechTips #OneCoolTip @OneCoolTip 

Sunday, December 3, 2023

Master Google Keep with These Keyboard Shortcuts

Google Keep
Are you a Google Keep user? 

Do you find yourself spending too much time navigating through your notes? 

Is there a faster, more efficient way to use Google Keep? 

Here's a Cool Tip.  Use Google Keyboard Shortcuts.

Google Keep, Google’s note-taking service, is a powerful tool for organizing your thoughts, lists, and reminders. 

But did you know that you can navigate and edit your notes even faster with keyboard shortcuts? 

Here's how to do it.
  • Go to keep.google.com.
  • At the top right, click the Gear icon.
  • Select Keyboard Shortcuts.
  • You can also use a shortcut, Ctrl + /, to display the Keyboard Shortcuts screen.

Google Keep Keyboard Shortcuts - First Screen
fig. 1 - Google Keep Keyboard Shortcuts - First Screen


Google Keep Keyboard Shortcuts - Second Screen
fig. 2 - Google Keep Keyboard Shortcuts - Second Screen


These shortcuts are clear: they can significantly speed up your workflow, allowing you to navigate and edit your notes quickly and efficiently. 

This can be particularly useful for heavy users of Google Keep, or for those who use it for work or study.

And best of all, Google Keep is free to use.  

While other note taking apps have reduced their free services and now pester users with ad after ad after ad (I'm looking at you Evernote), Google Keep is a great tool that works well with other Google services.

We've told you about Google Keep and its many features so check out the links below to learn more.

Enjoy!

Please LIKE and SHARE OneCoolTip.com!
Visit the OneCoolTip YouTube Channelhttps://www.youtube.com/@onecooltip


OneCoolTip.com
Cool Tech Tips for a Cooler Life

#Google @Google #Keep #Technology #Notes #Tech #GoogleKeep #Productivity #TechTips #OneCoolTip @OneCoolTip

Saturday, December 2, 2023

Protect Your Privacy. How to Disable NameDrop on iPhones

Have you recently updated your iPhone to iOS 17.

Did you notice a new feature called NameDrop? 

Are you curious about what it does and how it can affect your privacy? 

NameDrop is a new feature introduced in iOS 17 that allows iPhone users to share their contact details simply by holding their iPhones close to each other. 

Here's a Cool Tip.  You can Disable the Feature.

It’s designed to make sharing contact information quick and effortless. 

But like any feature, it has its pros and cons.

For most users, this is an unneeded feature.

Here's how to disable NameDrop
  • Open the Settings app.
  • Tap General.
  • Tap AirDrop.
  • Toggle the switch next to Bringing Devices Together on or off.

NameDrop Settings

The primary benefit of NameDrop is convenience. 

It eliminates the need to manually type in contact details, making the process of sharing information faster and more efficient.

However, many users have privacy concerns. 

Many police departments around the country warned residents to turn this new feature off.

Although NameDrop requires both parties to agree before any information is shared, the feature could potentially be triggered accidentally. 

If you’re worried about this, you can choose to disable NameDrop.

And if it's not a concern to you, leave it on!

That's it.

Enjoy!


Please LIKE and SHARE OneCoolTip.com!
Visit the OneCoolTip YouTube Channelhttps://www.youtube.com/@onecooltip


READ MORE

OneCoolTip.com
Cool Tech Tips for a Cooler Life


#Apple @Apple #iPhone #iOS17 #Technology #Tech #TechTips #Privacy #OneCoolTip @OneCoolTip 

Friday, December 1, 2023

How to Make Google Search Do a Funky Spin

Google Search Barrell Roll
Have you ever wondered if you could make Google Search do something a little more exciting than just providing you with search results?

Here's a Friday Funday Cool Tip.  Do a Barrell Roll!

With a simple command, you can make Google Search perform a barrel roll, transforming your ordinary search experience into a fun and entertaining one.

Here's how to do it.
  • Open Google Search.
  • Type in the phrase "do a barrel roll".
  • Press Enter.
Watch as Google Search performs a 360-degree barrel roll animation

Google Search - Do a Barrell Roll

fig. 1 - Do a Barrell Roll


This Cool Tip adds a touch of fun to your search experience.

Enjoy!


Please LIKE and SHARE OneCoolTip.com!
Visit the OneCoolTip YouTube Channelhttps://www.youtube.com/@onecooltip


READ MORE




OneCoolTip.com
Cool Tech Tips for a Cooler Life


#Google #Search #Googlesearch #barrelroll #fun #easteregg #tech #FridayFunday #TechTips #OneCoolTip @OneCoolTip 

Thursday, November 30, 2023

Don't Be a Victim: Update Chrome Immediately to Patch Zero-Day Exploit

In today's interconnected world, our online security is paramount.
With the ever-evolving threat landscape, staying vigilant and keeping our software up to date is crucial.
On November 28. 2023, Google warns that a  recent zero-day exploit requires Chrome to be updated. 
Chrome needs to be updated to updated to Chrome version 119.0.6045.199/.200 for Windows and version 119.0.6045.199 for Mac and Linux.
Google Chrome, one of the most popular web browsers, regularly releases security updates to address vulnerabilities and protect users from potential exploits.
Here's how to do it.
  • Launch Chrome and click on the three-dot menu in the top right corner.
  • Select "Help" from the dropdown menu.
  • Choose "About Google Chrome."
  • Chrome will automatically check for updates.
    • If an update is available, it will start downloading.
  • Once the download is complete, Chrome will prompt you to restart the browser to apply the update.
  • Click "Relaunch" to complete the process.

Update Google Chrome - Zero Day Exploit
fig. 1 - Update Google Chrome - Zero Day Exploit

That's it!

Enjoy!

Please LIKE and SHARE OneCoolTip.com!
Visit the OneCoolTip YouTube Channelhttps://www.youtube.com/@onecooltip


READ MORE



OneCoolTip.com
Cool Tech Tips for a Cooler Life


#Google @Google #Chrome #ChromeUpdate #ZeroDayExploit #SecurityPatch #OnlineSafety #TechTips #OneCoolTip @OneCoolTip

Wednesday, November 29, 2023

How to Unlock the Secrets of YouTube Videos with Google Bard

Google Bard
Have you ever watched a YouTube video and wanted to ask a question about it, but didn't know where to turn? 

Here's a Cool Tip.  Use Google Bard.

This powerful AI tool can now watch and answer questions about YouTube videos, making it easier than ever to get the information you need.

Here's how to do it.
  • Copy and paste the URL of the YouTube video into the Bard chatbox and ask Bard to review it.
  • Ask your follow-up question about the video.
  • Bard will process the video content and provide you with a answer.

In this example, I asked Bard to review a popular OneCoolTip video.

Google Bard YouTube

This is a great new capability of Google Bard.

Check it out!

Enjoy!


Please LIKE and SHARE OneCoolTip.com!
Visit the OneCoolTip YouTube Channelhttps://www.youtube.com/@onecooltip



READ MORE



OneCoolTip.com
Cool Tech Tips for a Cooler Life


#Google @Google #Bard #googlebard #youtube #ai #technology #video #questions #answers #watchandlearn #gettheinfoyouneed #youtubecompanion #makethesmostofyoutube #techTips #OneCoolTip @OneCoolTip 

Tuesday, November 28, 2023

How to Use the Secret ChatGPT Keyboard Shortcuts

ChatGPT Logo
Have you ever felt like you're not using ChatGPT to its fullest potential? 

Do you find yourself wishing for a quicker way to interact with this AI powerhouse? 

Here's a Cool Tip.  Use the ChatGPT Keyboard Shortcuts.

There is a treasure trove of shortcuts is just a keystroke away, waiting to transform your ChatGPT experience.

ChatGPT is an artificial intelligence language model developed by OpenAI. 

It's based on the GPT (Generative Pretrained Transformer) architecture, which is designed to generate human-like text based on the input it receives. 

The "Chat" in ChatGPT emphasizes its capability to engage in conversational dialogue, making it well-suited for a variety of applications that involve natural language processing.

Let's dive into the world of keyboard shortcuts.

  • Go to ChatGPThttps://chat.openai.com/
  • Login or sign-up.
  • Press Ctrl + / (Cmd + / on Mac) while in the ChatGPT interface.
  • A list of available keyboard shortcuts appears on your screen.

ChatGPT Keyboard Shortcuts

fig. 1 - ChatGPT Keyboard Shortcuts


Here's how to use each keyboard shortcut available in ChatGPT:

Open New Chat: Ctrl + Shift + O

Opens a new chat window or tab in ChatGPT.

To start a fresh conversation without navigating through the interface, simply press Ctrl + Shift + O.

Set Custom Instructions: Ctrl + Shift + I

Allows you to set custom instructions for the ChatGPT session.

To provide specific guidelines or context for your chat session, use Ctrl + Shift + I to open the instructions dialogue.

Focus Chat Input: Shift + Esc

Directly focuses on the chat input box, readying it for new input.

If your cursor is elsewhere on the page and you want to start typing a new message, press Shift + Esc to jump to the chat input box.

Toggle Sidebar: Ctrl + Shift + S

Opens or hides the sidebar in the ChatGPT interface.

To view additional options or hide them for a wider chat view, use Ctrl + Shift + S.

Copy Last Code Block: Ctrl + Shift + ;

Copies the last code block sent by ChatGPT.

If ChatGPT sends a block of code and you wish to copy it, press Ctrl + Shift + ; to quickly copy it to your clipboard.

Delete Chat: Ctrl + Shift + X

Deletes the current chat or chat thread.

To clear your current conversation, perhaps for privacy or to start anew, use Ctrl + Shift + X.

Copy Last Response: Ctrl + Shift + C

Quickly copies the last response from ChatGPT.

If you want to copy the most recent answer or statement from ChatGPT, simply press Ctrl + Shift + C.


Show Shortcuts: Ctrl + /

Displays a list of all keyboard shortcuts available in ChatGPT.

To remind yourself of the available shortcuts or to learn new ones, press Ctrl + /.


These shortcuts are designed to enhance productivity and ease of use when interacting with ChatGPT, providing a more streamlined and efficient user experience. ​

Enjoy!


Please LIKE and SHARE OneCoolTip.com!
Visit the OneCoolTip YouTube Channelhttps://www.youtube.com/@onecooltip


READ MORE



OneCoolTip.com
Cool Tech Tips for a Cooler Life


#ChatGPT #OpenAI #AI #ChatGPTTips #AIProductivity #TechHacks #KeyboardShortcuts #TechTips #OneCoolTip @OneCoolTip

Monday, November 27, 2023

How to Master Microsoft Outlook Search

Have you ever found yourself sifting through hundreds of emails in your Microsoft Outlook inbox, trying to find that one important message? 

Ever wished there was a quicker way to locate specific emails?

Here's a Cool Back-to-Work-Monday Tip.  Use Microsoft Outlook Search Operators.

Here's how to do it.
  • Open Microsoft Outlook.
  • Navigate to the Search Box, located at the top of the Outlook window.
  • Type in the specific search operator you wish to use. 
    • For example, from:(sender) will show all emails from a specific sender.
  • Press Enter to display all emails that match your search operator.

But wait...  

There's a even Cooler Cool Tip.  Use the Outlook Search Filter screen.
  • Press and Hold the Filter icon to display search screen.

Outlook Search Screen
fig. 1 - Outlook Search Screen

  • Use the screen to enter your search criteria in one or more fields.
  • Then press Search to see the results.
But if you want to enter your own search operators, there are a number of operators that you can manually enter in the main search box.

Enter your search criteria in the Search box at the top of screen.



fig. 2 - Outlook Search

Using search operators can drastically reduce the time spent looking for specific emails, making your work more efficient.

Here are a few examples of search operators you can use:

from:(sender): 
Shows all emails from a specific sender.

subject:(keyword): 
Shows all emails with a specific keyword in the subject line.

NOT operator: 
This operator is used to exclude emails that contain a certain word.

OR operator: 
This operator is used to include emails that contain any of the specified words.

[ ] operator: 
This operator is used to search for empty fields.

to:
This operator searches the To line for emails addressed to a specified recipient.

cc:
This operator searches the Cc line for specified email recipients.

before:
This operator searches for emails sent or received before the given date.

after:: 
This operator searches for mail sent or received after the given date.

date:: 
This operator searches for mail sent or received on the given date.

folder:
This operator searches for mail in the specified folder.

has:attachment:
This operator searches mail messages that have at least one file attachment.

Remember, by default, you will be searching with the AND operator which you do not have to specify in your search. 

You can use the OR operator if you want your search results to also include items for which only a single condition is met. 

You can combine this field with the NOT operator to find items for which any value is selected.

For a full list of search operators, check out this Microsoft Support page.

That's it.

Enjoy!

Please LIKE and SHARE OneCoolTip.com!
Visit the OneCoolTip YouTube Channelhttps://www.youtube.com/@onecooltip


READ MORE



OneCoolTip.com
Cool Tech Tips for a Cooler Life

#Microsoft  @Microsoft #Outlook #Search #OutlookTips #EmailManagement #ProductivityHacks #TechTips #BacktoWorkMonday #OneCoolTip @OneCoolTip