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 Training Videos

link to How to get the Day of the Week in Excel using Functions

How to get the Day of the Week in Excel using Functions

In today's Excel Training video, we'll show you how to extract the day of the week from a date using the built-in functions, specifically TEXT and WEEKDAY. Understanding the day of the week can be...

Continue Reading
link to How to enable and use the Excel Developer Tab

How to enable and use the Excel Developer Tab

In this Excel Training video, we'll focus on enabling and using the Excel developer tab, a crucial feature applicable to both Windows and Mac desktop versions. This walkthrough aims to provide a...

Continue Reading
link to How to use the IF and OR functions in Excel

How to use the IF and OR functions in Excel

In this Excel Training video, we'll guide you through the effective utilization of Excel's IF function, demonstrate the integration of logical OR conditions within an IF statement, delve into the...

Continue Reading
link to How to count non-empty cells using COUNTIF

How to count non-empty cells using COUNTIF

In this Excel Training video, we'll show you how to use the COUNTIF function in Excel to tally the number of non-empty (not blank) cells within a specified range. Additionally, we'll demonstrate how...

Continue Reading
link to How to get Substrings in Excel with Functions

How to get Substrings in Excel with Functions

In this Excel Training video, we'll show you how to extract substrings using functions in Excel. The functions mentioned in this video are LEFT, RIGHT, MID, and SEARCH. But we also have a bonus tip...

Continue Reading
link to How to use the Quick Analysis Tool in Excel

How to use the Quick Analysis Tool in Excel

In this Excel Training video, we'll show you how to enable and use the Quick Analysis tool in the desktop version of Excel (Windows). We'll also show you what to do if you're using the web version of...

Continue Reading
« PREV Page 1 Page 2 Page 3 Page 4 Page 5 Page 6 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.