Posts

Showing posts from July, 2023

How to group rows in excel

Image
Hello, My Dear Friends, !! In this video, I will show you How to group rows in Excel. Watch the video till the end Thanks. Guys, Here you will know about the guideline on How to group rows in Excel: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Step 1: On the Data tab, in the Outline group, click Group, Group Rows, or Group Columns. Step 2: Optionally, if you want to outline an inner, nested group — select the rows or columns within the outlined data range, and repeat. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #group #rows #in #Excel  

How to search in Excel

Image
Hello, My Dear Friends, !! In this video, I will show you How to search in Excel. Watch the video till the end Thanks. Guys, Here you will know about the guideline on How to search in Excel: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Step 1: To search for text within a cell, the ISNUMBER and the SEARCH function can be used together. Step 2: The SEARCH function will search for the given text in a specific cell. Step 3: If found, it will return the text's position in that cell. If not found, it will return a #VALUE error. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #search #in #excel  

How to find circular reference in Excel

Image
  Hello, My Dear Friends, !! In this video, I will show you How to find circular references in Excel. Watch the video till the end Thanks. Guys, Here you will know about the guideline on how to find circular references in Excel: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Step 1: Go to the "Formulas" tab. To find circular references in Excel, open the spreadsheet you want to review.  Step 2: Select "Error Checking"  Step 3: Click the cell under "Circular References" ... Step 4: Fix your circular references. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #find #circular #reference #in #excel

How to calculate variance in Excel

Image
Hello, My Dear Friends, !! In this video, I will show you How to calculate variance in Excel. Watch the video till the end Thanks. Step 1: Select a population sample. Using the VAR. Step 2: Arrange the data in your spreadsheet. Sort the sample data into the spreadsheet using appropriate columns, cells, and labels.  Step 3: Select a separate cell for the formula.  Step 4: Enter the VAR.  Step 5: Evaluate the sample variance. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #calculate #variance #in #excel  

How to create a spreadsheet in Excel

Image
  Hello, My Dear Friends, !! In this video, I will show you How to create a spreadsheet in Excel. Watch the video till the end Thanks. Step 1: Click the File tab. Step 2: Click New. Step 3: Under Available Templates, double-click Blank Workbook. Step 4: Keyboard shortcut To quickly create a new, blank workbook, you can also press CTRL+N. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #create #a #spreadsheet #in #excel

How to calculate mean in Excel

Image
Hello, My Dear Friends, !! In this video, I will show you How to calculate the mean in Excel. Watch the video till the end Thanks. Step 1: To calculate the Mean in Excel, you can use the AVERAGE function. Step 2: To do this, you will need to enter the cell range containing the data you wish to include in the mean calculation. Step 3: For example, if your data is in cells A1 to A10, you would enter “=AVERAGE(A1:A10)” into the cell where you want the mean to appear. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #calculate #mean #in #excel 

How to freeze columns in Excel

Image
Hello, My Dear Friends, !! In this video, I will show you How to freeze columns in Excel. Watch the video till the end Thanks. Step 1: Select the row or column below or to the right of the pane you want to freeze. Step 2: Click on the View tab in the ribbon. Step 3: Click on Freeze Panes. Step 4: Select Freeze Panes from the dropdown menu. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #freeze #columns #in #excel  

How to use IF function in Excel

Image
  Hello, My Dear Friends, !! In this video, I will show you How to use IF function in Excel. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #use #IF #function #in #excel

How to count unique values in Excel

Image
Hello, My Dear Friends, !! In this video, I will show you How to count unique values in Excel. Watch the video till the end Thanks. Step 1: Select the range of cells, or make sure the active cell is in a table.  Step 2: On the Data tab, in the Sort & Filter group, click Advanced.  Step 3: Click Copy to another location. Step 4: In the Copy to box, enter a cell reference. Step 5: Select the Unique records only check box, and click OK. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #count #unique #values #in #excel  

How to name a range in Excel

Image
Hello, My Dear Friends, !! In this video, I will show you How to name a range in Excel. Watch the video till the end Thanks. Step 1: Select the range you want to name, including the row or column labels. Step 2: Click Formulas, Create from Selection. Step 3: In the Create Names from the Selection dialog box, select the checkbox (es) depending on the location of your row/column header.  Step 4: Click OK. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #name #a #range #in #excel  

How to make a pie chart in Excel

Image
  Hello, My Dear Friends, !! In this video, I will show you How to make a pie chart in Excel. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #make #a #pie #chart #in #excel

How to add columns in excel

Image
Hello, My Dear Friends, !! In this video, I will show you How to add columns in excel. Watch the video till the end Thanks. Step 1: To insert a single column: Right-click the whole column to the right of where you want to add the new column, and then select Insert Columns. Step 2: To insert multiple columns: Select the same number of columns to the right of where you want to add new ones. Step 3: Right-click the selection, and then select Insert Columns. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #add #columns #in #excel  

How to highlight duplicates in excel

Image
Hello, My Dear Friends, !! In this video, I will show you How to highlight duplicates in Excel. Watch the video till the end Thanks. Step 1: Select the data you want to highlight as duplicates. Step 2: Click on the Home tab, then on the Conditional Formatting dropdown list. Step 3: Select Highlight Cells Rules. Step 4: Select the Duplicate Values option. Step 5: Select your preferred formatting from the options provided, then click OK. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #highlight #duplicates #in #excel  

How to insert multiple rows in excel

Image
Hello, My Dear Friends, !! In this video, I will show you How to insert multiple rows in excel.  Watch the video till the end Thanks. Step 1: To insert multiple rows using a shortcut, select the number of rows you want to add and press Ctrl + Shift + Plus sign (+). Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #insert #multiple #rows #in #excel  

How to make a zoom meeting

Image
Hello, My Dear friends, !! In this video I will Show you How to make a zoom meeting. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #make #a #zoom #meeting  

How to mute on zoom

Image
  Hello, My Dear friends, !! In this video I will Show you How to mute on zoom. Watch the video till the end Thanks. Step 1: Join or start a Zoom meeting. Step 2: Find the microphone icon.  Step 3: Click the microphone icon to mute.  Step 4: Click your profile icon in the upper right corner.  Step 5: Click Audio in the menu on the left side of the window. Step 6: Check the box next to Mute my mic when joining. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #mute #on #zoom

How to share music on zoom

Image
  Hello, My Dear friends, !! In this video I will Show you How to share music on zoom. Watch the video till the end Thanks. Step 1: If your Zoom meeting window is open, choose “Share Screen” which you can find in the control bar of Zoom. Step 2:  It will open a modal window wherein you need to choose the tab “Advanced” and click on “Computer Audio” followed by “Share”. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #share #music #on #zoom

How to change name on zoom

Image
Hello, My Dear friends, !! In this video I will Show you How to share screen on zoom. Watch the video till the end Thanks. Step 1: Join a Zoom meeting on the Zoom mobile app. Step 2: On the Zoom in-meeting controls, tap Participants . Step 3: Tap your name, then tap Rename. A pop-up box will appear. Step 4: In the pop-up box, enter your display name. Step 5: Tap Done. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial   #solution   #change   #name   #on   #zoom

How to do breakout rooms in zoom

Image
  Hello, My Dear friends, !! In this video I will Show you How to do breakout rooms in zoom. Watch the video till the end Thanks. Step 1: Click Breakout Rooms . Step 2: Select the number of rooms you would like to create, and how you would like to assign your participants to those rooms: Automatically: Let Zoom split your participants up evenly into each of the rooms. Step 3: Manually: Choose which participants you would like in each room Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #breakout #rooms #in #zoom

How to find recordings of zoom

Image
  Hello, My Dear friends, !! In this video I will Show you How to find recordings of zoom . Watch the video till the end Thanks. Step 1: Sign in to the Zoom web portal. Step 2: In the navigation menu, click Account Management then Recording Management. Step 3: You will see a list of cloud recordings on your account. Search recordings by entering the meeting ID or topic. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #find #recordings #of #zoom

How to make own stickers on telegram

Image
Hello, My Dear friends, !! In this video I will Show you How to make own stickers on telegram. Watch the video till the end Thanks. Step 1: What you need. Images for Telegram stickers should ideally be in the PNG format, have a transparent background, and have 512x512 resolution.  Step 2: Getting started.  Step 3: Launch Sticker bot.  Step 4: Select sticker type.  Step 5: Sticker set name.  Step 6: Upload sticker image.  Step 7: Link an emoji. Step 8: Publish. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #make #own #stickers #on #telegram  

How to not get scammed on telegram

Image
  Hello, My Dear friends, !! In this video I will Show you How to not get scammed on telegram. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #not #get #scammed #on #telegram

How to make a telegram channel

Image
Hello, My Dear friends, !! In this video I will Show you How to make a telegram channel. Watch the video till the end Thanks. Step 1: Open the Telegram app on your Android device. Step 2: Click on the pen icon on the screen's bottom and select “New Channel” from the menu. Step 3: Choose a name for your channel, and if you want, you can also add a description. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #make #a #telegram #channel  

How to find someone on telegram

Image
  Hello, My Dear friends, !! In this video I will Show you How to find someone on telegram . Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #find #someone #on #telegram

How to enable sensitive filtering on telegram

Image
Hello, My Dear friends, !! In this video I will Show you How to enable sensitive filtering on telegram. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #enable #sensitive #filtering #on #telegram  

How to download a video from telegram

Image
Hello, My Dear friends, !! In this video I will Show you How to download a video from telegram. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #download #a #video #from #telegram  

How to clear cache on telegram

Image
Hello, My Dear friends, !! In this video I will Show you How to clear cache on telegram. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #clear #cache #on #telegram  

How to cancel telegram subscription

Image
  Hello, My Dear friends, !! In this video I will Show you How to cancel telegram subscription. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #cancel #telegram #subscription

How to appear offline in telegram

Image
  Hello, My Dear friends, !! In this video I will Show you How to appear offline in telegram. Watch the video till the end Thanks. Step 1: Open the Telegram app. Step 2: Navigate to the settings. On an iPhone, tap the gear icon located in the lower-right corner. Step 3: On an Android device, tap the three lines in the top-left corner. Step 4: Tap on the Privacy and Security. Step 5: Then, go to Last Seen & Online. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #appear #offline #in #telegram

How to do gender swap on capcut

Image
Hello, My Dear friends, !! In this video I will Show you How to do gender swap on capcut. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #gender #swap #on #capcut    

How to draw on capcut

Image
Hello, My Dear friends, !! In this video I will Show you How to draw on capcut. Watch the video till the end Thanks. 0:00   Introduction  0:14   Main Part  1:06   Happy Ending  Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #draw #on #capcut  

How to remove background using capcut

Image
Hello, My Dear friends, !! In this video I will Show you How to remove background using capcut. Watch the video till the end Thanks. Step 1: Launch the app and tap on the “New Project” option.  Step 2: Select a new picture or video.  Step 3: From the bottom of the interface, select “Overlay” and then tap on “Add Overlay.” Step 4: Once the video is uploaded, select “Remove Background” at the bottom of the interface. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #remove #background #using #capcut  

How to slow down video speed on capcut

Image
  Hello, My Dear friends, !! In this video I will Show you How to slow down video speed on capcut. Watch the video till the end Thanks. Step 1: Begin by selecting a “New Project” or an existing project. Step 2: Tap on the video to access the speed icon located at the bottom. Step 3: Click on the speed icon to open the video speed bar. Step 4: Use the speed bar to adjust the playback speed of the video. Step 5: The available speed range is from 0.1x to 100x. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #slow #down #video #speed #on #capcut

How to speed up a video in capcut

Image
Hello, My Dear friends, !! In this video I will Show you How to speed up a video in capcut. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #speed #up #a #video #in #capcut  

How to use chroma key in capcut

Image
  Hello, My Dear friends, !! In this video I will Show you How to use chroma key in capcut. Watch the video till the end Thanks. 0:00    Introduction  0:20    Main Part  2:27    Happy Ending  Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #use #chroma #key #in #capcut

How to do motion blur on capcut

Image
  Hello, My Dear friends, !! In this video I will Show you How to do motion blur on capcut. Watch the video till the end Thanks. Step1:  Open the CapCut app and tap on the “New Project” option. By doing so, upload the video from your phone on its interface. Step 2:  After uploading, select the clip and scroll in the right direction. From there, select the “Motion Blur” option and choose “Blur” strength and “Blend” value. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #motion #blur #on #capcut  

How to do transitions in capcut

Image
Hello, My Dear friends, !! In this video I will Show you How to do transitions in cap cut. Watch the video till the end Thanks. Step 1: On the home screen of your Cap Cut app, tap on “New project.” Step 2: Select the clip you'd like to add a transition to from your album and click on “Next.” Step 3: Drag the white vertical line to the specific part of the video where you'd like to add a transition. Step 4: Press “Edit.” Step 5: Tap “Split.” Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #transitions #in #capcut    

How to get 4k quality on capcut

Image
  Hello, My Dear friends, !! In this video I will Show you How to get 4k quality on capcut. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #get #4k #quality #on #capcut

How to change profile picture on snapchat

Image
  Hello, My Dear friends, !! In this video I will Show you How to change profile picture on snapchat. Watch the video till the end Thanks. Step 1: Open the Snapchat app on your mobile device. Step 2: Tap on your Bitmoji in the top right corner. Step 3: Scroll down and select “My Public Profile.” Step 4: Tap on “Edit Profile.” Step 5: Tap on the empty profile picture. Step 6: Select the photo from your camera roll. Step 7: Tap “Save Changes” at the bottom. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #change #profile #picture #on #snapchat

How to logout your Snapchat app

Image
Hello, My Dear friends, !! In this video I will Show you How to logout your Snapchat app. Watch the video till the end Thanks. Step 1: Open the Snapchat app on your iPhone or Android phone. Step 2: Tap the icon in the top-left corner.  Step 3: Tap the Settings icon in the top-right corner.  Step 4: In the Settings list, scroll all the way down to the bottom and tap "Log Out." Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #logout #your #Snapchat #app  

How to create public profile on snapchat

Image
Hello, My Dear friends, !! In this video I will Show you How to create public profile on snapchat.  Watch the video till the end Thanks. Step 1: Go to your Profile. Step 2: Scroll down to the 'Public Profile' section. Step 3: Tap 'Create Public Profile' Step 4: Follow the on-screen instructions to create your Public Profile. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #create #public #profile #on #snapchat  

How to remove Friend on snapchat

Image
Hello, My Dear friends, !! In this video I will Show you How to remove Friend on snapchat. Watch the video till the end Thanks. Step 1:  Swipe right to go to the Chat screen. Step 2:  Tap and hold on a friend's name. Step 3:  Tap 'Manage Friendship' Step 4:  Tap 'Remove Friend' Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #remove #Friend #on #snapchat

How to share location on snapchat

Image
  Hello, My Dear friends, !! In this video I will Show you How to share location on snapchat. Watch the video till the end Thanks. Step 1:  Go to a Friendship Profile. Step 2:  Tap 'Share My Live Location' under the 'Snap Map' section. Step 3:  Choose how long you want to share your Live Location with a close friend or family member (Always, 8 hours, 1 hour) Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #share #location #on #snapchat

How to enable data saver mode on snapchat

Image
  Hello, My Dear friends, !! In this video I will Show you How to enable data saver mode on snapchat. Watch the video till the end Thanks. Step 1: Tap ⚙️ in the Profile screen to open Settings. Step 2: Tap on 'Manage' under 'Additional Services' Step 3: Toggle Data Saver on or off.  Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #enable #data #saver #mode #on #snapchat

How to pin conversation on snapchat

Image
Hello, My Dear friends, !! In this video I will Show you How to pin conversation on snapchat. Watch the video till the end Thanks. Step 1: Swipe right from the Camera screen to go to the Chat screen. Step 2: Press and hold on a friend or Group. Step 3: Tap 'Chat Settings' Step 4: Tap 'Pin Conversation' Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #pin #conversation #on #snapchat  

How to unblock someone on snapchat

Image
Hello, My Dear friends, !! In this video I will Show you How to unblock someone on snapchat phone. Watch the video till the end Thanks. Step 1: Tap your profile icon in the top of the screen. Step 2: Tap setting option ,to open Settings. Step 3: Scroll down and tap 'Blocked' Step 4: Tap ✖️ next to a name to unblock that Snap chatter. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #unblock #someone #on #snapchat #phone  

How to change snapchat ai gender

Image
Hello, My Dear friends, !! In this video I will Show you How to change snapchat ai gender. Watch the video till the end Thanks. Step 1: Open Snapchat and go to your My AI chat. Step 2:  Tap on the profile icon in the top left corner. Step 3:  Tap on “Customize“. Step 4:  Tap on “Avatar“. Step 5:  Tap on the image of the gender you want to change to. Step 6:  You can now customize the avatar's features, skin tone, hair, and clothing. Chapters: 0:29  Introduction  0:30  Main Part  2:29  Hpappy Ending Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #change #snapchat #ai #gender  

How to block someone on snapchat

Image
Hello, My Dear friends, !! In this video I will Show you How to block someone on snapchat. Watch the video till the end Thanks. Step 1: Swipe right to go to the Chat screen. Step 2: Tap on a Chat with that friend. Step 3: Tap their profile icon at the top. Step 4: Tap the at the top, then tap 'Manage Friendship' Step 5: Tap 'Block' Chapters: 0:15   Introduction  0:16   Main Part  2:19   Happy Ending Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #block #someone #on #snapchat  

How to turn off sensitive content on viber

Image
Hello, My Dear friends, !! In this video I will Show you How to turn off sensitive content on viber. Watch the video till the end Thanks. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #turn #off #sensitive #content #on #viber  

How to know if someone blocked you on viber

Image
Hello, My Dear friends, !! In this video I will Show you How to know if someone blocked you on viber. Watch the video till the end Thanks. Step 1: If it shows as delivered but never appears in their chat history, it's possible that they've blocked you. Step 2: You can also try calling them – if the call goes straight to voicemail or if you hear a message saying that the user is unavailable, they may have blocked your number. Thank you Everyone for watching. If this video can help you, don't forget to like & subscribe to my channel. #initial #solution #know #if #someone #blocked #you #on #viber