Formatting Cells In Excel | 10 Formatting Cells Tips | CTRL + 1 [Hindi]
Excel Tutorial
Learn More:- https://exceltutorial.net
============================================================
Previously In this Channel; ✔Format Painter in Excel With Conditional Formatting - https://www.youtube.com/watch?v=HNOnpxpM46k ✔Advanced Filter In Excel:- https://www.youtube.com/watch?v=QuH7YnQ20NA ✔ Sort & Filter in Excel:- https://www.youtube.com/watch?v=xiulgk_CtfU ✔ VLookup Function in Excel Introduction:- https://www.youtube.com/watch?v=OKEb8A6RYNs ✔ Synchronous Scrolling In Excel:- https://www.youtube.com/watch?v=6LdLd9tJS6Y ✔ Import TXT Data to CSV/XLSX - https://www.youtube.com/watch?v=OUYUKv1HP9Y ✔ Extract Unique Values With Advance Filter:- https://www.youtube.com/watch?v=ZW-0gIDLtGY 👉 Create Drop Down List In Excel:- https://www.youtube.com/watch?v=xhE4XZjbaAA 👉 Remove Blanks In Excel:- https://www.youtube.com/watch?v=gwSVVbgfKUo 👉 Alt Key Shortcuts in Excel:- https://www.youtube.com/watch?v=6OkKe-eIQ14 👉 CTRL G In Excel - https://www.youtube.com/watch?v=KU7ZNFWaqNc 👉customize Quick Access Toolbar:- https://www.youtube.com/watch?v=ONC_dmV9XbI 👉Create a Custom Tab:- https://www.youtube.com/watch?v=kN0gnlwEelM 👉 Excel Navigation Shortcuts:- https://www.youtube.com/watch?v=9Ugh-oLv2DA 👉Customize Excel Footer Stats:- https://www.youtube.com/watch?v=c68VKmFx_6w 👉Flash Fill in Excel: https://www.youtube.com/watch?v=dtfXkmalQyM 👉Fix 6 Common Excel Errors You're Sick Of Seeing:- https://youtu.be/JjCC-4FKQCo 👉Get Email name from Email Address:- https://www.youtube.com/watch?v=5HUH7SeBDLY 👉Add Row Index In Power Query:- https://youtu.be/jbZTdpg7ZZc 👉Month Name and Number :- https://www.youtube.com/watch?v=WJexkRPo-SY 👉COUNTIF:- https://www.youtube.com/watch?v=gpYCgLqciuA 👉Rounddown:- https://www.youtube.com/watch?v=U13Ounbk4Jg 👉COUNT FUNCTIONS:- https://www.youtube.com/watch?v=NBPgxlFqg1E
Formatting Cells in excel is easy with CTRL + 1 shortcut which let excel open format cells dialog box where we can format any cell in many different criteria. Some of them are stated in below video;
Table of Content 00:00 Introduction to Formatting Cells In Excel 00:45 Currency Formatting 02:55 Decimal Formatting 03:51 Without Decimal Formatting 04:13 Time Formatting 05:52 Date Formatting 07:37 Percentage Formatting 08:34 Fraction Formatting 09:37 Scientific Formatting 11:07 Number to text Formatting 12:39 Hide your Numerical Value (Bonus)
If you have any questions please do ask in comment below or contact from our website. ... https://www.youtube.com/watch?v=Ro07XuUMsBY
124064071 Bytes