iCals Digital Solutions
iCals Digital Solutions
  • Видео 64
  • Просмотров 24 710
How to Delete Blank Cells in Excel Easily | Microsoft Excel Tips | iCals Digital Solutions | EasyFix
In this tutorial, we'll show you how to easily delete blank cells in Excel to keep your data clean and organized. Follow these steps:
Select the entire data range that contains blank cells.
Press Ctrl + G to open the Go To dialog box.
Click on Special, then choose Blanks to highlight all blank cells in the selection.
Right-click on any highlighted blank cell and select Delete.
Choose the appropriate option: Shift cells left, Shift cells up, or delete the entire row or column.
This quick method helps you clean up your spreadsheets and keep your data tidy. If you found this tutorial helpful, please like, share, and subscribe for more Excel tips and tricks!
Просмотров: 339

Видео

Record First Data Entry Timestamp in Excel | Keep initial timestamp of data entry | Excel Tutorial
Просмотров 10014 дней назад
In this tutorial, you'll learn how to automatically show the date and time when data is first entered into a cell in Excel, even if the data is edited later. This is useful for tracking data entries without losing the original timestamp. Steps: 1. Go to File Options, click on Formulas, and enable Iterative Calculation. 2. Format the cell as your preferred date and time format. 2. Enter the form...
Fix Activation Failed in Excel: Quick Solution | Microsoft Excel Tutorial | Error fixed | iCals
Просмотров 12821 день назад
In this tutorial, we’ll show you how to fix the "Activation Failed" error in Microsoft Excel. If you’re encountering issues activating Excel, follow these simple steps to resolve it quickly. We’ll guide you through the process of locating the OSPPREARM file in your Microsoft Office installation folder, running it as an administrator three times, and how this action will fix the activation issue...
How to Export Telegram Chat History to Desktop on Windows | Tutorial | Tech tips | Data Safety
Просмотров 116Месяц назад
In this tutorial, we'll show you how to export your Telegram chat history directly to your desktop on Windows. Whether you need to back up important conversations or simply want a record of your chats, this guide will walk you through the steps. Steps Overview: Download and install Telegram for Windows. Log in to your Telegram account. Open the chat you wish to export. Click on the three dots i...
Excel date formatting tutorial step by step guide | Microsoft excel | DD/MM/YYYY
Просмотров 1252 месяца назад
Formatting dates correctly in Excel is essential for maintaining data accuracy and readability. This tutorial guides you through setting the correct regional settings in Windows and selecting the appropriate date format in Excel, ensuring your dates are displayed as intended. Steps to Format Dates Correctly: 1. Set Windows Regional Settings: Go to Settings - Time & Language - Region. Select the...
How to fill automatic Repeating Number Series Sequence in Excel | Microsoft Excel | Number Series
Просмотров 412 месяца назад
Creating number sequences in Excel is a fundamental skill that simplifies data organization and analysis. Whether you're managing lists, preparing datasets, or automating calculations, mastering number sequences can significantly improve your workflow. This tutorial guides you through several methods to create number sequences in Excel, including using the fill handle for quick, automatic seque...
Merge Cells Horizontally in Excel Quick Guide Made with Clipchamp
Просмотров 802 месяца назад
Merge Cells Horizontally in Excel Quick Guide Made with Clipchamp
Create Vertical Headings in Excel
Просмотров 662 месяца назад
Create Vertical Headings in Excel
Excel's Maximum Rows and Columns Quick Overview
Просмотров 1182 месяца назад
Excel's Maximum Rows and Columns Quick Overview
Effortlessly Convert PDF to Excel A Step by Step Guide
Просмотров 402 месяца назад
Effortlessly Convert PDF to Excel A Step by Step Guide
Align Text Left and Right on the Same Line in Google Docs
Просмотров 1032 месяца назад
Align Text Left and Right on the Same Line in Google Docs
Print Headers on Every Page in Google Sheets
Просмотров 432 месяца назад
Print Headers on Every Page in Google Sheets
Windows tips Make This PC Your Default File Explorer View
Просмотров 522 месяца назад
Windows tips Make This PC Your Default File Explorer View
Excel Made Easy Fixing Circular References Like a Pro
Просмотров 682 месяца назад
Excel Made Easy Fixing Circular References Like a Pro
Avoid Printing Issues How to Print Over, Then Down in Excel
Просмотров 662 месяца назад
Avoid Printing Issues How to Print Over, Then Down in Excel
How to Print Headers on All Pages in Excel
Просмотров 1 тыс.2 месяца назад
How to Print Headers on All Pages in Excel
Creating Unique Ranks in Excel Using COUNTIF Formula
Просмотров 413 месяца назад
Creating Unique Ranks in Excel Using COUNTIF Formula
Using ChatGPT to Generate Excel Formulas Calculate Total Marks
Просмотров 303 месяца назад
Using ChatGPT to Generate Excel Formulas Calculate Total Marks
Excel Tutorial How to Resize Columns or Rows Equally
Просмотров 1223 месяца назад
Excel Tutorial How to Resize Columns or Rows Equally
Microsoft Word Tutorial How to Insert the Indian Rupee Symbol
Просмотров 343 месяца назад
Microsoft Word Tutorial How to Insert the Indian Rupee Symbol
Google Sheets Tutorial How to Delete Rows or Columns
Просмотров 273 месяца назад
Google Sheets Tutorial How to Delete Rows or Columns
Excel Error Fix How to Resolve #NUM! Errors Quickly!
Просмотров 2373 месяца назад
Excel Error Fix How to Resolve #NUM! Errors Quickly!
Say Goodbye to #DIV 0! Errors in Excel
Просмотров 113 месяца назад
Say Goodbye to #DIV 0! Errors in Excel
School Timetable On Mobile Screen Google Keep Widget Tutorial
Просмотров 1643 месяца назад
School Timetable On Mobile Screen Google Keep Widget Tutorial
Fixing Rank Errors in Excel with Dollar Signs
Просмотров 713 месяца назад
Fixing Rank Errors in Excel with Dollar Signs
How to get rank in ascending orderin Excel
Просмотров 303 месяца назад
How to get rank in ascending orderin Excel
How to hide or show gridlines in Excel
Просмотров 744 месяца назад
How to hide or show gridlines in Excel
How to remove harakaths from Arabic document
Просмотров 1565 месяцев назад
How to remove harakaths from Arabic document
How to hide page number in Word
Просмотров 795 месяцев назад
How to hide page number in Word
VLOOKUP Common errors fixed
Просмотров 306 месяцев назад
VLOOKUP Common errors fixed

Комментарии

  • @yz_writes
    @yz_writes 9 дней назад

    Thank you brother 😊

  • @firen0136
    @firen0136 11 дней назад

    YEAHHHHHHHH EXCEL YEAHHHHHHHHH BEST OFFICE APP even though it takes literal wizards to use it to its full potential

  • @krishnasaxena2811
    @krishnasaxena2811 18 дней назад

    This was very helpful thank you so much ☺️☺️

  • @iCalsDigitalSolutions
    @iCalsDigitalSolutions 19 дней назад

    Enter this formula in the cell: =IF(A2<>"",IF(B2<>"",B2,NOW()),"")

  • @ursulinengozi
    @ursulinengozi 20 дней назад

    This was super helpful

  • @fareshajjar1208
    @fareshajjar1208 26 дней назад

    There is no option to export chat history

    • @iCalsDigitalSolutions
      @iCalsDigitalSolutions 20 дней назад

      Install telegram windows application. Not android or web app. There you can find it.

  • @colinhuntley9729
    @colinhuntley9729 2 месяца назад

    Hi, i have been searching for a solution to this problem! And thanks to you, I have found one...

  • @muhamadmuhamad4209
    @muhamadmuhamad4209 2 месяца назад

    Good information 🎉

  • @iCalsDigitalSolutions
    @iCalsDigitalSolutions 6 месяцев назад

    The formula I used in this file is: =ISODD(COLUMN(A2))

  • @iCalsDigitalSolutions
    @iCalsDigitalSolutions 6 месяцев назад

    The formula I used in this file is: =IFERROR( VLOOKUP(F3,$A$3:$D$22,2,0),"")

  • @iCalsDigitalSolutions
    @iCalsDigitalSolutions 6 месяцев назад

    The formula I used in this file is: =COUNTIFS($C$2:$C$31,">"&$C2,$B$2:$B$31,B2)+1

  • @iCalsDigitalSolutions
    @iCalsDigitalSolutions 6 месяцев назад

    the code i used in this file is: =MOD(ROW(),2)=MOD(COLUMN(),2)

  • @iCalsDigitalSolutions
    @iCalsDigitalSolutions 6 месяцев назад

    The formula used in this file is: =IFERROR( LET(DOB,A2, CHOOSE(VALUE(TEXT(DAY(DOB),"dd")), "First","Second","Third","Fourth","Fifth","Sixth","Seventh","Eighth","Ninth","Ten","Eleven","Twelfth","Thirteenth","Fourteenth","Fifteenth","Sixteenth","Seventeenth","Eighteenth","Nineteenth","Twentieth","Twenty-first","Twenty-second","Twenty-third","Twenty-fourth","Twenty-fifth","Twenty-sixth","Twenty-seventh","Twenty-eighth","Twenty-ninth","Thirtieth","Thirty-first")&" "& TEXT(DATE(YEAR(DOB),MONTH(DOB),DAY(DOB)),"mmmm")&", "& IF(VALUE(MID(YEAR(DOB),1,2))=19,"Ninteen ",IF(VALUE(MID(YEAR(DOB),1,2))=20,"Two Thousand ",""))& IF(VALUE(MID(YEAR(DOB),3,2))=0,"", IF(VALUE(MID(YEAR(DOB),3,2))<20, CHOOSE(VALUE(MID(YEAR(DOB),3,2)),"one","two","three","four","five","six","seven","eight","nine","ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"), IF(VALUE(MID(YEAR(DOB),3,2))>20, CHOOSE(VALUE(MID(YEAR(DOB),3,1)),"","twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety")&" "& IF(VALUE(MID(YEAR(DOB),4,1))=0,"",CHOOSE(VALUE(MID(YEAR(DOB),4,1)),"one","two","three","four","five","six","seven","eight","nine")))))),"")

  • @iCalsDigitalSolutions
    @iCalsDigitalSolutions 6 месяцев назад

    The formula I used in this file is here: =IFERROR( CHOOSE( VALUE(TEXT(DAY(A2),"dd")), "First", "Second", "Third", "Fourth", "Fifth", "Sixth", "Seventh", "Eighth", "Ninth", "Ten", "Eleven", "Twelfth", "Thirteenth", "Fourteenth", "Fifteenth", "Sixteenth", "Seventeenth", "Eighteenth", "Nineteenth", "Twentieth", "Twenty-first", "Twenty-second", "Twenty-third", "Twenty-fourth", "Twenty-fifth", "Twenty-sixth", "Twenty-seventh", "Twenty-eighth", "Twenty-ninth", "Thirtieth", "Thirty-first") & " " & TEXT(DATE(YEAR(A2), MONTH(A2), DAY(A2)), "mmmm") & ", " & IF(VALUE(MID(YEAR(A2),1,2))=19,"Ninteen ",IF(VALUE(MID(YEAR(A2),1,2))=20,"Two Thousand ",""))& IF(VALUE(MID(YEAR(A2),3,2))=0,"", IF(VALUE(MID(YEAR(A2),3,2))<20, CHOOSE(VALUE(MID(YEAR(A2),3,2)),"one","two","three","four","five","six","seven","eight","nine","ten","eleven","twelve","thirteen","fourteen","fifteen","sixteen","seventeen","eighteen","nineteen"), IF(VALUE(MID(YEAR(A2),3,2))>20, CHOOSE(VALUE(MID(YEAR(A2),3,1)),"","twenty","thirty","forty","fifty","sixty","seventy","eighty","ninety")&" "& IF(VALUE(MID(YEAR(A2),4,1))=0,"",CHOOSE(VALUE(MID(YEAR(A2),4,1)),"one","two","three","four","five","six","seven","eight","nine"))))),"")

  • @soma2224
    @soma2224 Год назад

    Hello sir good work I need some information

  • @shamimkamalabdulnazar37
    @shamimkamalabdulnazar37 Год назад

    No sound

    • @austernesan199
      @austernesan199 Год назад

      Automatic Seating Plan for Schools in Excel using Formula | Shines Excel ruclips.net/video/MROXS_pwsRk/видео.html

    • @iCalsDigitalSolutions
      @iCalsDigitalSolutions 6 месяцев назад

      Mam, it was meant as a silent video. Will try to make voice in upcoming videos.

  • @muhammedfayiz593
    @muhammedfayiz593 2 года назад

    Thanks ❤️

  • @sameertuvvur3732
    @sameertuvvur3732 2 года назад

    Very useful

  • @swabeehmusharraf5438
    @swabeehmusharraf5438 3 года назад

    Awesome!

  • @SmartBee24
    @SmartBee24 4 года назад

    sir, please watch this video : ruclips.net/video/FSd8rEUkMck/видео.html and please reply me, how this excell seat plan is created.

    • @iCalsDigitalSolutions
      @iCalsDigitalSolutions 4 года назад

      Can you ask the developer there itself? They may answer you clearly. Thanks

  • @printdhbengal7021
    @printdhbengal7021 4 года назад

    I can't just found Result Generator 0.9 Version in the given link. it redirects to an older post. can you update it soon. Thanks for your unique works

    • @muhamadmuhamad4209
      @muhamadmuhamad4209 4 года назад

      We will be back with a better online Result Generator IA. Thanks for your support.

    • @printdhbengal7021
      @printdhbengal7021 4 года назад

      @@muhamadmuhamad4209 ​ Glad that you considered it. hope it will rolled out soon. waiting of a die-hard fan 🧐

    • @iCalsDigitalSolutions
      @iCalsDigitalSolutions 3 года назад

      Please go through: www.icalsdigital.com/products/result-generator We have made it available on our new website for smooth access. or contact in WhatsApp: wa.me/919048685090