![pndtechzone](/img/default-banner.jpg)
- 648
- 68 674
pndtechzone
India
Registrace 23. 12. 2022
This channel gives you tutorial videos on how to use excel, google sheets,outlook,word, PowerPoint and other google and Microsoft services. our aim is to help you improve and enhance your skills. All these tutorials will help you to accomplish daily task in the easiest way possible.
How To Move Pivot Table In Excel Sheet
Select PivotTable Actions Move PivotTable. The Move PivotTable dialog box is displayed. Under Choose where you want the PivotTable to be placed, do one of the following: To place the PivotTable in a new worksheet starting at cell A1, click New worksheet
zhlédnutí: 2
Video
How to Hide Data in pivot table
zhlédnutí 1Před 3 hodinami
Right-click the table or column you'd like to hide and select Hide from Client Tools. In Power Pivot, hiding a column does not remove it from the model. A hidden column can still be used as a sort column in a table. It can also be referenced in formulas that define calculated columns or calculated fields.
How To Shift Word Space In Excel Sheet
zhlédnutí 142Před 7 hodinami
How To Shift Word Space In Excel Sheet
How To Group And Ungroup Data In A Pivot Table
zhlédnutí 20Před 9 hodinami
Right-click the grouped field and select Ungroup... from the context menu. Select any cell in the grouped field and on the Pivot Table Tools | Analyze tab, in the Group group, click the Ungroup button.
How To Remove Gridlines In Excel Sheet
zhlédnutí 164Před 9 hodinami
You can either show or hide gridlines on a worksheet in Excel for the web. On the View tab, in the Show group, select the Gridlines check box to show gridlines, or clear the check box to hide them.
How To Create Exploded Pie Chart In Excel Sheet
zhlédnutí 34Před 12 hodinami
Right-click the pie chart, then click Format Data Series. Drag the Pie Explosion slider to increase the separation, or enter a number in the percentage box.
How To Use Dot After Letter In Excel Sheet
zhlédnutí 114Před 14 hodinami
You can select the entire column and then press Ctrl 1 and dialog box format cells in excel will open. 2. Then go to custom and in place of general type @*. As soon as you will press ok you will see the trailing dots are added and it is self-adjusted.
How To Insert Timeline In Pivot Table
zhlédnutí 139Před dnem
Click anywhere in a PivotTable to show the PivotTable Tools ribbon group, then click Analyze Insert Timeline. In the Insert Timeline dialog box, check the date fields you want, and click OK.
How To Insert Blank Line In Pivot Table
zhlédnutí 47Před dnem
Here is how to insert a row in Pivot Table STEP 1: Click any cell in the Pivot Table. STEP 2: Go to Design Blank Rows. METHOD 1: Simply press CTRL Z if you have recently inserted a blank row. METHOD 2: Go to Design Blank Row dropdown Select Remove Blank Line After Each Item.
How To Summarize Value In Pivot Table
zhlédnutí 131Před dnem
In the PivotTable, right-click the value field you want to change, and then click Summarize Values By. Click the summary function you want.
How To Find And Replace In Excel Sheet ( 3 Unique Trick)
zhlédnutí 48Před dnem
Replace text or numbers with the Find & Replace #exceltech #exceltricks #exceltips Press Ctrl H or go to Home Find & Select Replace. In Find what, type the text or numbers you want to find. You can further define your search: ... In the Replace with box, enter the text or numbers you want to use to replace the search text. Select Replace or Replace All.
Excel Tab Menu Finding Trick For Beginners
zhlédnutí 38Před 14 dny
Excel Tab Menu Finding Trick For Beginners #exceltech #spreadsheet
How To Multiply Two Different Units In Excel
zhlédnutí 189Před 14 dny
In this tutorial I show how to multiply two different units and in this case it's to get a price.
How To Use Text To Column In Excel Sheet Part 2
zhlédnutí 187Před 14 dny
Select the cell or column that contains the text you want to split. Select Data Text to Columns. In the Convert Text to Columns Wizard, select Delimited Next. Select the Delimiters for your data. ... Select Next. Select the Destination in your worksheet which is where you want the split data to appear.
How To Insert Multiple Pivot Table In Excel Sheet
zhlédnutí 41Před 14 dny
How To Insert Multiple Pivot Table In Excel Sheet
How To Use Text To Column In Excel Sheet Part 1
zhlédnutí 13Před 14 dny
How To Use Text To Column In Excel Sheet Part 1
How To Delete Blank Cell In Excel Sheet
zhlédnutí 7Před 14 dny
How To Delete Blank Cell In Excel Sheet
How To Use Countblank Function In Excel Sheet
zhlédnutí 52Před 14 dny
How To Use Countblank Function In Excel Sheet
How To Use Edate Function In Excel Sheet
zhlédnutí 99Před 14 dny
How To Use Edate Function In Excel Sheet
How To Use Find Function In Excel Sheet
zhlédnutí 67Před 14 dny
How To Use Find Function In Excel Sheet
How To Use Formulatext Function In Excel Sheet
zhlédnutí 51Před 14 dny
How To Use Formulatext Function In Excel Sheet
How To Use Report Layout In Pivot Table
zhlédnutí 41Před 14 dny
How To Use Report Layout In Pivot Table
How To Covert Roman Number In Excel Sheet
zhlédnutí 47Před 14 dny
How To Covert Roman Number In Excel Sheet
How To Add Serial Number In Excel Sheet ( Unique Trick )
zhlédnutí 92Před 21 dnem
How To Add Serial Number In Excel Sheet ( Unique Trick )
Not sure what you were hoping to demonstrate, but I think you confirmed my fear that there is not a work-around for a standard format including DATE + TIME for modified column. GDrive does dumb formatting based on their team's whim. This problem makes it unuseable for any business scenario where multiple documents with same or similar name arrive in a folder and you want to see quickly if it's a dupe or a change, and WHEN. Another factor is that google drive allows you to have multiple files with the same name within a single folder (not possible in Windows) so if you knew the precise time, you could easily see if it was a dupe. This is google being lazy LOL.
I get piles daily. When I say block sender they just keep sending aother way the same companies. This might work. Thanks.
Thank you...
This is great information, however you are talking so softly it is hard to understand and hear you fully.
Thanks......Noted
How to grouping in a row for correct sum of remaining rows perfect ly please guide me ASAP
Hi, Please check this -- How to group of row in excel sheet czcams.com/video/PTrtHZ3WKF8/video.html
but you can't go lower then 50%????
Your performance is genuinely outstanding! Would you like to share your thoughts on my work?🙂🙏
Your dedication is truly admirable! Can you share your good views on my assignment?🙂🙏
Your work is genuinely exceptional! Would you be willing to offer feedback?🙂🙏
Your contributions are truly noteworthy! Could you provide feedback on my endeavor?🙂🙏
Do you know how to share one Google Keep account to our other Gmail account? so that we don't share/collaborate on one note or several notes. Because if one Chrome profile will access Google Keep on the Gmail account that is logged in, even though I want to access Google Keep whose Gmail I use most actively. This also aims to ensure that I only use one Google Keep, I don't need many Google Keeps.
Your work is truly impressive! Could you share your thoughts on my work?🙂🙏
Very Informative Video. It does helped me.
Glad it helped
I'm eager to hear your thoughts on my work, could you provide some uplifting comments?🙂🙏
Your results are genuinely impressive! Can you spare a moment to evaluate my work?🙂🙏
Your work is truly impressive! Could you share your thoughts on my project?🙏🙂
This doesn't really do much. I want the background of the sheet dark, not just the header.
Thanks ma'am. It was easy to understand n execute. Will subscribe. Wanted to learn simple ways like the above video to make things easier.
Thanks and welcome
*promosm*
Great, thanks!
Welcome!
Thanks.
Welcome!
😊
FYI: The video explains how to freeze the top row, left column, or both. However, you are not limited to just the 1st row, the 1st column, or both. For example, if you highlight row 8 and click on "Freeze Panes" it will freeze ALL of the rows ABOVE row 8. If you highlight Column D and click on "Freeze Panes" it will freeze ALL of the columns to the left of Column D. Lastly, if you select Cell D8 click on "Freeze Panes" it will freeze ALL of the columns to the left of Column D AND ALL of the rows ABOVE row 8, ALL at the same time.
I'm truly grateful for the information you've shared. Thanks.
Thanks
Welcome
Mam how i get a print after doing delivery challan.... And where i find drft delivery challan
Hi Pavan, When you click on save draft option, preview in Pdf will be opened, on header of delivery challan you get option Pdf/Print Just click on print option to print delivery challan.
Thanks 🎉😊
Welcome 😊
"PromoSM" 😬
Good idea! But you have to learn the correct English words to use. It is not "semi-colon", it is "Quotation Mark"
Thank you...Noted
Mam.. Gst not added in Quote...what i do...Can you explain it
Hi... You have to add the tax amount in the line items itself. It automatically calculates the total tax amount and add it to the total amount.
Pls explain clearly and avoid being fast
Noted