Ms Excel-Home Tab Options Part-2|| Conditional Formatting||How To Create Date Format||Protect Sheet.
#advancedformula, #advancedExcel,
#pastespecial,#vlookupformula
Hi
I Am Soniya Gupta Welcome To Our Youtube Channel Ca World.
--------------------------------------------------------------------
About This Video-
#hyperlink,
Dosto Is Video Maine Apko Excel Se Related Information Di Hai.Home tab ka function
The Excel Home Tab is used to perform common commands such as bold, underline, copy, and paste. It is also used to apply formats to cells in a worksheet. The table below describes the commands in each of the groups in the Home Tab.
*************************************************************
ConditionalFormatting:-
This button is used to select different formatting for cells based on
particular criteria. It is possible to highlight interesting cells,
emphasize unusual values, and visualize data using Data Bars,
Color Scales, and Icon sets.
**********************************************************
Format :-
As Table Click this button to quickly format a selected range of cells as a
table using a gallery of table styles.
---------------------------------********************---------------
Cell Styles :-
This button is used to apply predefined formatting to a single cell.
A gallery of styles will appear. Move the mouse pointer over the
style to see a Live Preview of the style.
------------------------***************------------------
Cells Group:-
Insert To insert cells, sheet rows, or sheet columns, click this button. A list
of possible options will appear. Click the option that is to be
applied to the worksheet.
Delete:-
This button is used to delete cells, sheet rows, or sheet columns
from a worksheet. If the arrow is clicked, a list of available options
will appear.
--------**********---------**********-----------********-----------
*Ummeed Hai Ki Apko Ye Video Pasand Aayegi And Apki Video Se Related Koi Bhi Quary Ho. App Comment Section Mei Aake Puch Skte Hai
Thank You So Much…
Best & Regards
********************************************
Our Some Other Video Link:-
HOME TAB PART-1
• HOME TAB PART-1 || Advanced paste special ...
------------------------------------------------------------------------------
1.How to create JSON file and enter B2B invoice GSTR 1 offline
• How to create JSON file and enter B2B invo...
2. How to transfer electronic cash ledger balance in GST PORTAL
• How to transfer electronic cash ledger bal...
3. How to create JSON file and enter the invoice in offline utility
• How to create JSON file and enter the invo...
4. HOW TO REMOVE DUPLICATE INVOICES IN GSTR_2A
• HOW TO REMOVE DUPLICATE INVOICES IN GSTR_2A
5. How to download GSTR-1 offline utility
• How to download GSTR-1 offline utility
6. How To Create Marks Sheet Ms Excel, With Conditional Formatting . [PART-1]
• How To Create Marks Sheet Ms Excel, With C...
7. How to download GSTR -2A & remove duplicate invoices a few minutes
• How to download GSTR -2A & remove duplicat...
8. HOW TO VIEW GST RETURN ACKNOWLEDGEMENT NUMBER
• HOW TO VIEW GST RETURN ACKNOWLEDGEMENT NUMBER
9. GSTR-1 Offline Utility Download
• GSTR-1 Offline Utility Download
10. how to export sales and purchase details form tally ERP spreadsheet
• how to export sales and purchase details f...
11. how to select QRMP (opt) mode & monthly mode in GST portal
• how to select QRMP (opt) mode & monthly mo...
12. how to customise CSV GSTR1 report
• how to customise CSV GSTR1 report
********************************************
ABOUT THIS CHANNEL
Hi Friends, I Am SONIYA GUPTA. I Am A Multi-Tasking Person And Created This Channel To Share Updates About GST, INCOME TAX, TDS , ROC, MCA, ADV EXCEL. Motive Behind Creating This Channel Is To Make Easy To Understand Videos And To Connect Globally. Aims At Sharing Information Who Wants To Learn And Grow. Disclaimer Any Topic Or Issue Discussed In The Videos On This Channel Are For Educational Purposes Only. Subscribe Our Channel For Latest Updates And Information..
Thanks Team CAWORLD
BEST & REGARDS
*******************************************
OUR SOCIAL LINKS-
YOUTUBE- / @caworld8583
Twitter- / soniyag68621625
Instagram- / caworld7
EMAIL- [email protected]