Learn to set multi-color shading or patterns in the cell background. In MS Excel multi-color shading background is known as Gradient.
Tag: Mr Coding
How to solve the Date problems while using mail merge. Sometimes Number is appearing instead of the date in the mail merge.
MS-EXCEL-016-Custom Cell Formatting in MS Excel | Full Detailed Video, From Basic to Advance | Hindi
Learn Detailed Custom Cell Formatting in MS Excel. Custom Cell Formatting display only visual representation, it does not change the actual value.
MS-EXCEL-015-Advanced Format Cell Part-2 in MS Excel | Date, Time, Percentage, Fraction, etc.| Hindi
learn all options of the Format Cells window under Number Formatting Group in MS Excel. These all are the advanced option to Format Cell’s content.
MS-EXCEL-014-Advanced Format Cell Part-1 in MS Excel | General, Number, Currency, Accounting | Hindi
Learn all options of the Format Cells window under Number Formatting Group in MS Excel. These all are the advanced option to Format Cell’s content.
MS-EXCEL-013-Number Formatting in MS Excel | Date-Time, Accounting, Currency, Decimal, Comma | Hindi
Number Formatting that are available in In MS Excel are, Accounting Number Formatting, Percent Style, Decimal, Currency, Date, Time, Fraction, Scientific
Advanced Text Orientation, one can rotate text from +90 degrees to -90 degrees. These all are very easy, advanced, and very important topics in MS Excel.
When the number of text or text sizes is more than the cell width at that time Shrink to fit option is used to adjust the text size as per cell width.
MS-EXCEL-010-Advanced Horizontal and Vertical Alignment Setting | Justify Alignment in Excel | Hindi
Learn the advanced Text alignment settings. there are many advanced options for horizontal and vertical alignments
MS-EXCEL-009-Wrap Text | Cell Content in Multiple Lines | Merge Cell | Unmerge Cell | MS Excel-Hindi
Wrap Text options , wrap extra-long text into multiple lines. Merge & Center option, combine more than one selected cell into one large cell.