Showing posts with label Microsoft Excel. Show all posts
Showing posts with label Microsoft Excel. Show all posts

Sunday, January 28, 2024

Aptos: The New Typeface Elevating Microsoft 365

Aptos
Have you ever considered how a font can shape your experience with digital documents? 

What if a simple typeface change could refresh the entire look and feel of your workspace? 

Here's a Cool Tip.  Aptos is now the default font in Microsoft 365 apps.

We first told you about Aptos HERE where we shared about the history of default fonts in Microsoft office applications.

Microsoft recently rolled out the new font as the default in 365 apps such as Word, Excel and PowerPoint replacing the previous default font Calibri.

Here's how to do it.
  1. Open any Microsoft 365 application (Word, Excel, PowerPoint).
  2. Create a new document (In Word, File --> New --> Blank Document)
  3. Aptos is the new default font used when you start typing.

Aptos Now Default Font in Microsoft 365 Apps
fig. 1 - Aptos Now Default Font in Microsoft 365 Apps

Aptos offers a modern, clean aesthetic that enhances readability and as a cloud font, it ensures document consistency across devices.

By embracing Aptos, users enjoy a refreshed, cohesive digital workspace that’s poised to meet the demands of modern typography.

Have you started using Aptos yet?

Has it impacted your documents or productivity?

What do you think?

Let us know in the comments below.

Enjoy!


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

Do you have a Cool Tip or question? Email us at
onecooltip.com@gmail.com


READ MORE

OneCoolTip.com
Cool Tech Tips for a Cooler Life!


#Microsoft @Microsoft #Microsoft365 #Aptos #Font #Word #Excel #PowerPoint #TypographyTransformation #DigitalWorkspace #CloudFonts #OfficeUpdate #TechTips #OneCoolTip @OneCoolTip 

Monday, January 8, 2024

Unlock the Power of Excel: How to Convert Image Data to Spreadsheets Without Rekeying

Have you ever wondered how to transform data trapped in an image into an editable Excel spreadsheet? 

And you don't want to rekey in all of the data manually?

Here's a Back-to-Work-Monday Cool Tip.  Use Microsoft Excel's Data from Picture feature.

Excel’s ‘Data From Picture’ feature streamlines your data entry so you don't have to re-key.




Here's how to do it.
  • Open Excel.
  • Select a tab where you want the data to go.
  • Select the Data tab. 
  • In the ‘Get and Transform Data’ section, choose 'From Picture’.
  • You can import data from an image file saved on your device or from your clipboard
  • To insert a saved image, choose ‘Picture From File’. 
  • To insert an image from your clipboard, choose 'Picture From Clipboard’.
    • Be sure you have an image copy in your clipboard.
  • Excel’s AI will analyze the image and extract the data
  • Review and edit the data before inserting it into the spreadsheet.

Microsoft Excel Data from Picture

fig. 1 - Microsoft Excel Data from Picture

This feature allows you to quickly convert data from an image into an editable Excel spreadsheet.

This feature is only supported on Windows 11 or Windows 10 version >=1903 (must have Microsoft Edge WebView2 Runtime installed).

Check out this Cool Tip video to see how it's done.




So give this a try the next time you need to rekey data.

What do you think about this feature?

Let us know in the comments below.

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!


#ExcelDataFromPicture #ExcelTutorial #ExcelTips #AI #BackToWorkMonday #TechTips #OneCoolTIp @OneCoolTip #YouTube @YouTube 

Sunday, December 31, 2023

Top 5 Cool Tech Tips that Rocked 2023: AI Work Hacks, Google Bard Secrets, and More!

Have you ever wondered how AI is revolutionizing the way we work? 

Or how to make the most of Google Bard’s new export feature? 

If so, you’re in the right place! 

2023 has been a great year for Cool Tips at OneCoolTip.

We've posted hundreds of Cool Tips on a variety of topics such as AI, Windows, iPhone, Android, and more.

And you've responded by reading and watching hundreds of thousands of Cool Tips!

Thank you!


We’ve compiled the most viewed Cool Tips from www.OneCoolTip.com in 2023, and we’re excited to share them with you.

1. How AI is Changing the Way We Work: An Example for Bing Chat AI, Excel and Data Analysis

AI is transforming our workspaces, and Bing Chat AI is a prime example. It’s helping us analyze data in Excel more efficiently, saving us time and effort. However, like all AI tools, it requires careful handling to avoid potential pitfalls.
Google Bard’s new export feature is a game-changer for content creators. It allows you to export your creations in various formats, expanding your sharing options. But remember, with great power comes great responsibility!


3. How to Master Split Screen in Microsoft Edge

Split Screen in Microsoft Edge is a handy tool for multitaskers. It allows you to view multiple tabs side by side, boosting your productivity. But be warned, it can be a bit tricky to master!


4. How to Play the Google Snake Game

The Google Snake Game is a fun way to pass the time. It’s easy to play and highly addictive. But beware, it’s not as easy as it looks!


5. Your Pet Deserves to be Royalty, Let AI Paint Their Portrait!

AI is not just for work, it can also be fun! With AI, you can turn your pet into royalty with a custom portrait. But remember, AI is only as good as the data it’s trained on!

https://www.onecooltip.com/2023/05/your-pet-deserves-to-be-royalty-let-ai.html


Here are a few honorable mentions that caught OneCoolTip viewers' eyes this year:




And in 2023, we've started a YouTube channel, OneCoolTip.

Here are your favorites:


This video provides a tip on how to insert lines quickly into Microsoft Word and Microsoft Outlook using autocomplete.



This video provides a tip on how to play the Microsoft Edge Surf Game, an Easter egg hidden in the new web browser Edge.



This video introduces a new feature in Chromium browsers like Chrome and Edge that allows you to capture a high-definition still image from a video. You can then use the captured image in image editing software or paste it into documents like Word or PowerPoint.



This video is about how to use the new Gallery feature of File Explorer for Windows 11. It provides instructions on how to open the Gallery view, adjust how to view images, and access the details pane or preview pane.



This video is about how to use Microsoft Excel's Geography Data Type feature.
The video shows how to make Excel spreadsheets more dynamic and informative using Microsoft Excel's Geography Data Type feature. This feature allows users to access and integrate rich geographical data into their spreadsheets.
# # #


What was your favorite Cool Tip in 2023?

Let us know in the comments below.

Enjoy!


READ MORE

 #CoolTips2023, #AIatWork #GoogleBard #MicrosoftEdge #GoogleSnakeGame #AIPetPortrait #Apple @Apple #Microsoft @Microsoft #word #Excel  #Google @Google #TechTips #OneCoolTip @OneCoolTip 

Monday, December 11, 2023

Master the Magic of Excel: Unleash the Power of the Fill Handle

Microsoft Excel
Have you ever found yourself in a sea of data, manually copying formulas down a column in Excel? 

Have you ever wondered if there’s a faster, more efficient way? 

Here's a Cool Tip.  Use Microsoft Excel's most underutilized feature: the Fill Handle.

In Microsoft Excel, double-clicking the fill handle will automatically copy a formula down to the end of the data. 

The fill handle is a small black square in the bottom right corner of the active cell. 

When the pointer changes to a small black plus sign, you can double-click the fill handle to activate the AutoFill feature. 

www.OneCoolTip.com - Back To Work Monday

Here's how to do it.
  • Select the cell you want to copy.
  • Hover over the fill handle in the bottom right corner of the cell.
  • Double-click the fill handle.
  • The cells below will auto-populate based on the prior column and where you left off.
  • Scroll down to the bottom of your data to check if the formula has been copied correctly.

The Fill Handle can save you a significant amount of time, especially when dealing with large datasets. 

However, it’s important to note that it copies the exact formula, including relative cell references. 

If your formula includes absolute cell references, you may need to adjust them accordingly.



Excel Double Click Handle to Autopopulate

fig. 1 - Microsoft Excel - Double Click Selection Handle to Auto-Populate to End of Data


The Fill Handle is enabled by default in Excel. 

If it’s not working, check your settings: File > Options > Advanced > Enable fill handle and cell drag-and-drop.

Microsoft Excel - Enable Fill Handle
fig. 2 - Microsoft Excel - Enable Fill Handle





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 #Excel #ExcelTips #DataAnalysis #ProductivityHacks #TechTips #OneCoolTip @OneCoolTip #YouTube 

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 

Monday, November 13, 2023

How to Use Microsoft Excel's Geography Data Type Feature

Have you ever wondered how to make your Excel spreadsheets more dynamic and informative? 

Here's a Cool Tip.  Use Microsoft Excel's Geography Data Type feature.

Microsoft Excel’s geography data type feature is a powerful tool that allows you to access and integrate rich geographical data into your spreadsheets. 

But how does it work, and what can you do with it? 

Here's how to use it.
  • Start by typing geographic data into your cells. 
    • This could be country names, city names, or even postal codes.
  • Highlight the cells containing your geographic data.
  • Navigate to the Data tab and select 'Geography’. 
    • Excel will automatically convert your data to the geography data type.
Microsoft Excel - Select Country Cells and Geography

fig. 1 - Select Country Cells and Geography

  • Click on the Insert Data button that appears when you select a cell with the geography data type. 
  • From here, you can choose what information you want to display in your spreadsheet.
Select Country Fields

fig. 2 - Select Fields

  • The geography data type feature in Excel offers  allows you to access a wealth of information about geographic locations.
  • After converting them to the geography data type, you can extract information such as capital and  population, and more. 
Excel Geography Fields

fig. 3 - Excel Geography Fields

This can be incredibly useful for a variety of applications, from creating informative tables to performing data analysis.

The information in Excel’s geography data type feature is linked to an online data source, which means it can be refreshed and updated. 

To get current data for your data types, you can right-click a cell with the linked data type and select Data Type > Refresh or Refresh All

This will refresh the cell you selected, plus any other cells that have that same data type. 

This ensures that your data is always up-to-date with the latest information from the online data source.

Excel also has Stocks and Currency data types which we'll cover in a future Cool Tip.

Enjoy!

Watch this Cool Tip video to learn more about using Microsoft Excel's Geography Data Type feature:


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 #Excel #MicrosoftExcel #ExcelTips #DataScience #MicrosoftOffice #TechTips #BackToWorkMonday #YouTube @YouTube #OneCoolTip @OneCoolTip 

Wednesday, November 8, 2023

Master the New Bing Chat Excel Export Feature

Bing Chat
Have you ever wondered how to make your data analysis more efficient? 

Have you been looking for ways to seamlessly integrate your chat data into your spreadsheets? 

Here's a Cool Tip.  Use Microsoft Bing Chat’s new Excel export feature.

Microsoft recently add the ability to export tables from its AI tool, Bing Chat, directly to an Excel worksheet.

Here's how to do it.
  • Go to www.Bing.com
  • Select Chat from the menu.
  • Create a prompt for the information you want to see in a table.
    • For example, "Create a table of consumer inflation in the US from 2000 to 2020."
    • Select Enter
    • Bing Chat provides the answer.
  • Select ‘Edit in Excel’ icon.
Bing Chat Create Table - Select Edit in Excel

fig. 1 - Bing Chat Create Table - Select Edit in Excel

  • Your data will open in Excel 
    • You need to have Microsoft Excel installed.
Bing - Table Export to Excel

fig. 2 - Bing - Table Export to Excel


This feature allows for quick and easy transfer of chat data into a structured format.

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 #Bing #BingChat #ExcelExport #DataAnalysis #MicrosoftOffice #Productivity #TechTips #OneCoolTip @OneCoolTip

Monday, November 6, 2023

Boost Your Productivity with Microsoft Excel's Paste as Picture

Microsoft Excel
Have you ever wondered how to make your Excel reports more visually appealing? 

Or how to keep your data updated across multiple sheets without the hassle of manual updates?

Here's a Back-to-Work-Monday Cool Tip.  Use Microsoft Excel's Paste as Picture.

Microsoft Excel, a powerful tool in the Microsoft Office suite, offers two unique features: Paste as Picture and Paste as Linked Picture

While they may sound similar, they serve different purposes and can be used to achieve different outcomes.

Here's how to do it.

Paste as Picture
This feature allows you to take a snapshot of your selected cells and paste it as an image. 
  • Select the cells you want to copy.
Microsoft Excel - Select Table to Copy

fig. 1 - Select Table to Copy

  • Go to the Home tab, click on the Copy dropdown, and select Copy as Picture.
  • In the dialog box, choose “As shown on screen” and “Picture”, then click OK.
Microsoft Excel Copy as Picture
fig. 2 - Microsoft Excel Copy as Picture
  • Go to the location where you want to paste the picture and press Ctrl+V.

It’s a great way to preserve the look of your data, especially when sharing it with others.

The pasted picture won’t change even if the original data is modified.

Paste as Linked Picture
This feature creates a live snapshot of a range of cells. 
  • Select the cells you want to copy.
  • Copy the cells (Ctrl+C).
  • Go to the Home tab, click on the Paste dropdown, and select Linked Picture.

Microsoft Excel - Paste as Linked Picture

fig. 3 - Microsoft Excel - Paste as Linked Picture

The linked picture updates automatically when the original data changes.

It’s useful for creating dynamic dashboards and reports.

Here’s an example to illustrate the difference. 
  • Let’s say you have a cell A1 with the value 10. 
  • If you use Paste as Picture, you’ll get a picture of the cell displaying 10. 
  • If you change the value in A1 to 20, the picture remains the same. 
  • But if you use Paste as Linked Picture, the picture will update to display 20.
Be sure to check out this video that explains Paste as Picture and Paste as Linked Picture.



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 #Excel @Excel #ExcelTips, #DataVisualization, #ProductivityHacks, #MicrosoftExcel #TechTips #YouTube @YouTube @OneCoolTip @OneCoolTip 

Monday, October 16, 2023

Unleash the Power of Excel's Text-to-Columns Feature

Microsoft Excel
Ever found yourself staring at a jumbled mess of data in an Excel spreadsheet, wishing you could magically separate it into neat, individual columns? 

Have you ever wondered if there’s a simple way to transform a single column of data into multiple ones? 

Here's a Cool Tip.  Use Microsoft Excel’s Text-to-Columns feature.

Text to columns in Excel is a method that is used to separate a text into different columns based on some delimited or a fixed width.

Here's how to do it.
  • Click on the column or select the area that contains the data you want to separate.
  • Navigate to the Data tab on the Ribbon, 
  • Click on Text to Columns
  • A wizard will pop up.
  • Choose Your Data Type: 
    • You’ll be asked if your data is Delimited or Fixed Width
      • Delimited means your data is separated by characters such as commas or tabs. 
      • Fixed Width means the data is separated by a fixed number of spaces
    • Choose the option that fits your data.
  • Set Delimiters or Column Breaks: 
    • If you chose Delimited, you’ll need to specify the delimiters (comma, space, tab, etc.). 
    • If you chose Fixed Width, you’ll set where the column breaks should be.

Microsoft Excel Text to Columns Wizard
fig. 1 - Microsoft Excel Text to Columns Wizard

  • Next and Finish: You’ll get a preview of your data. 
Microsoft Excel Text to Columns - Preview
fig. 2 - Microsoft Excel Text to Columns - Preview
  • If everything looks good, click Finish.
Microsoft Excel Text to Columns - Final

fig. 3 - Microsoft Excel Text to Columns - Final

That's it!

Excel’s Text-to-Columns feature is a powerful tool that can save you time and frustration when dealing with complex data sets. 


Enjoy!

Please LIKE and SHARE OneCoolTip.com!


READ MORE

OneCoolTip.com
Cool Tech Tips for a Cooler Life

#Microsot @Microsoft #ExcelTips #DataAnalysis #TextToColumns #MicrosoftExcel #ProductivityHacks #BackToWorkMonday #TechTips #OneCoolTip @OneCoolTip #YouTube 

Monday, October 2, 2023

How to Transpose Data in Microsoft Excel

Microsoft Excel
Have you ever found yourself in a situation where you needed to switch rows to columns or vice versa in your data? 

Ever wished for a magic wand that could instantly reorient your data to suit your needs? 


Here's a Cool Tip.  Microsoft Excel’s Transpose feature.

The Transpose feature in Excel is a tool that allows you to rotate your data by converting columns into rows, and rows into columns. 

This can be particularly useful when you want to restructure your data to make it easier to read or analyze. 

For example, if you have a dataset where the variables are in rows and observations are in columns, you might want to transpose the data so that each variable has its own column. 

This can make it easier to carry out further analysis, such as calculating descriptive statistics for each variable. 

The Transpose feature in Excel makes this process quick and easy, saving you the time and effort of manually rearranging your data.

Here's how to do it.
  • Select the data you want to transpose. 
  • Click and drag your mouse across the cells to select them.


fig. 1 - Selected Data to Copy in Excel

  • Copy the selected data
  •  You can do this by right-clicking on the selected cells and choosing ‘Copy’, or simply by pressing Ctrl+C  keys (Cmd+C for Mac users).
  • Click on the cell where you want your transposed data to begin. 
    • This will be the top-left cell of your transposed data.
  • Right-click on the chosen cell and select ‘Paste Special’. 
    • A dialog box will appear.
  • In the ‘Paste Special’ dialog box, look for the ‘Transpose’ option and check it. 
  • Click ‘OK’.

Microsoft Excel Transpose Window
fig. 2 - Microsoft Excel Paste Special - Transpose Window

  • Your data has been transposed.

Transposed Data in Excel
fig. 3 - Transposed Data in Excel


Remember, if you have any formulas in your data, they will be adjusted to suit the new orientation. 

So, are you ready to take control of your data?

Enjoy!

Please LIKE and SHARE OneCoolTip.com!


READ MORE

OneCoolTip.com
Cool Tech Tips for a Cooler Life

#Microsoft #Excel @Microsoft #MicrosoftExcel #MicrosoftTranspose #DataManagement #ExcelTips #TechBlog #TechTips #OneCoolTip @OneCoolTip