Skip to content
Search
  • Home
  • Free eBook
  • Teams
    • Getting Started with Teams
    • Teams Guides
    • Teams Troubleshooting
  • OneDrive
    • OneDrive Guides
      • OneDrive Troubleshooting
  • SharePoint
    • SharePoint Guides
    • SharePoint Troubleshooting
  • Loop
    • Loop Guides
    • Loop Troubleshooting
  • Outlook
    • Outlook Guides
    • Outlook Troubleshooting
  • More Apps
    • Microsoft Azure
      • Azure Guides
      • Azure Troubleshooting
    • Microsoft Edge
      • Edge Guides
      • Edge Troubleshooting
    • Microsoft Excel
      • Excel Guides
      • Excel Troubleshooting
    • Microsoft Exchange
      • Exchange Guides
      • Exchange Troubleshooting
    • Microsoft Intune
      • Intune Guides
      • Intune Troubleshooting
    • Microsoft OneNote
      • OneNote Guides
      • OneNote Troubleshooting
    • Microsoft Planner
      • Planner Guides
      • Planner Troubleshooting
    • Microsoft PowerPoint
      • PowerPoint Guides
      • PowerPoint Troubleshooting
    • Microsoft Visio
      • Visio Guides
      • Visio Troubleshooting
    • Microsoft Windows
      • Windows Guides
      • Windows Troubleshooting
    • Microsoft Word
      • Word Guides
      • Word Troubleshooting
  • About Us
    • Contact Us
    • Privacy Policy
  • Free Video Training
    • Excel Training Videos
    • Microsoft 365 Training Videos
    • OneDrive Training Videos
    • SharePoint Training Videos
    • Teams Training Videos
    • Word Training Videos

Category: Excel Guides

link to How to separate numbers from text in Excel

How to separate numbers from text in Excel

If you use Excel regularly, you may be familiar with its wide selection of different features to help you. The program's unique ability to work with numbers and text makes it ideal for data...

Continue Reading
link to 3 simple ways to convert the date to month and year in Excel

3 simple ways to convert the date to month and year in Excel

Excel offers a vast array of functions to enhance content management within the program. Among these functions is the capability to create and customize datasets to suit individual needs....

Continue Reading
link to 2 quick ways to freeze more than one row in Excel

2 quick ways to freeze more than one row in Excel

Microsoft Excel gives its users an abundance of different and well-established features to help them manage their data efficiently. You can formulate data, such as adding accounting figures or other...

Continue Reading
link to How to export lists from SharePoint to Excel with filters

How to export lists from SharePoint to Excel with filters

If you have a large amount of information stored in a SharePoint list or an Excel spreadsheet, you may find that filters are a great way to refine this information so you can easily locate specific...

Continue Reading
link to How to make all cells the same size in Excel

How to make all cells the same size in Excel

Spreadsheets allow us to structure, assess, and manipulate large amounts of data. And we can ensure our spreadsheets are clear and readable by using formatting tools. But if you neglect to format...

Continue Reading
link to What does “the data you’re pasting isn’t the same size as your selection” mean?

What does “the data you’re pasting isn’t the same size as your selection” mean?

Copy and paste is an effective way of transferring data from one location to another. But it's not always a straightforward process. For example, you may find that "the data you're pasting isn't the...

Continue Reading
Page 1 Page 2 Page 3 … Page 11 NEXT »

About Us

Here at Business Tech Planet, we're really passionate about making tech make sense. In a world where businesses are embracing technology more than ever, it's essential you understand the tech you're using. We've created this blog to share our knowledge and make tech simple, so you can make use of all the fantastic technology available to your business.

Important Legal Information

Business Tech Planet is owned and operated by M&D Digital Limited, company number 12657448. Business Tech Planet is a participant in affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to affiliated sites. Business Tech Planet is compensated for referring traffic and business to these companies.

  • Privacy Policy
  • About Us
  • Contact Us
© 2026 Business Tech Planet

Contact Us

  • Address: Chartered House, 5 Axis Court, Nepshaw Lane South, Gildersome, Leeds, LS27 7UY
  • Phone: 0333 200 4687
  • Email: btp@mddigitalltd.com

Company Info

Business Tech Planet is owned and operated by M&D Digital Limited, company number 12657448. Business Tech Planet is a participant in affiliate advertising programs designed to provide a means for sites to earn advertising fees by advertising and linking to affiliated sites. Business Tech Planet is compensated for referring traffic and business to these companies.