LibreOffice Calc Data Menu Tutorial in Hindi | Calc Data Menu | LibreOffice Calc Data Menu |
Microsoft Bing: https://www.bing.com
Google Ai: https://www.ai.google
Chat GPT: https://chat.openai.com/chat
Laptop: https://amzn.to/3JxCGqm
Mic: https://amzn.to/3Lb1mpX
Charger Cable: https://amzn.to/3JtNBRY
Charger: https://amzn.to/3mDdLsl
Keyboard: https://amzn.to/3my6Oc3
Mouse: https://amzn.to/3ZEEUdc
libre office: https://www.libreoffice.org
|| Playlist ||
Create Ai: • voice command 👌 AI (artificial intell...
Mobile App: • microsoft 👌mobile launcher🤣 for daily...
Calc: • Libre office 👌😘 calc first video for ...
Microsoft Access: • Microsoft 👌❤️Access for beginners par...
Shoping: • कौन सा लैपटॉप लें या न लें
Libre Writer: • Open office Libre office for beginner...
Excel : • how to use excel file menu in one video.
word: https:// • how to use Microsoft word clipboard t...
Windows: • how to change wallpaper in windows 11
HTML: • html basic
Python: • Python Installation in हिन्दी पायथन क...
Use the Data menu commands to edit the data in the current sheet. You can define ranges, sort and filter the data, calculate results, outline data, and create a pivot table.
Sort
Sorts the selected rows according to the conditions that you specify. LibreOffice automatically recognises and selects database ranges.
Sort Ascending
Text fields are sorted alphabetically, numeric fields are sorted by number.
Sort Descending
Text fields are sorted alphabetically, number fields are sorted by number.
AutoFilter
Automatically filters the selected cell range, and creates one-row list boxes with which you can choose the items that you want to display.
More Filters
Shows commands to filter your data.
Define Range
Defines a database range based on the selected cells in your sheet.
Select Range
Selects a database range that you defined under Data - Define Range.
Refresh Range
Updates a data range that was inserted from an external database. The data in the sheet is updated to match the data in the external database.
Pivot Table
A pivot table provides a summary of large amounts of data. You can then rearrange the pivot table to view different summaries of the data.
Calculate
Commands to calculate formula cells.
Validity
Defines what data is valid for a selected cell or cell range.
Subtotals
Calculates subtotals for the columns that you select. LibreOffice uses the SUM function to automatically calculate the subtotal and grand total values in a labelled range. You can also use other functions to perform the calculation. LibreOffice automatically recognises a defined database area when you place the cursor in it.
Form
Data Entry Form is a tool to make table data entry easy in spreadsheets. With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide.
Streams
Create live data streams for spreadsheets.
XML Source
Import XML data in a spreadsheet.
Multiple Operations
Applies the same formula to different cells, but with different parameter values.
Text to Columns
Opens the Text to Columns dialogue box, where you enter settings to expand the contents of selected cells to multiple cells.
Consolidate
Combines data from one or more independent cell ranges and calculates a new range using the function that you specify.
Group and Outline
You can create an outline of your data and group rows and columns together so that you can collapse and expand the groups with a single click.
Statistics
Use the data statistics in Calc to perform complex data analysis
#now #vworld143 @vworld143 @pradumnmaurya170 #Ai #microsoft #chatpgt #chat #MsChat #google #googleAI #AIgoogle #laptop #voice #video #pivot #qrcode #media #video #insert #fontwork #wordart #rrr #award #education #max #min #spreadsheet #googlesheets #excel #sheet #LibeOffice #function #recurction #max #min #if #vlookup #hlookup #row #col #range #date #datedif #count #iferror #india #abs
#cell #formating #character #number #rowfomating #italic #emphasis #bold #strong #solid #ancher #markup #shortcut Thank you.