00:00 Fitting more numbers onto a dashboard page
00:19 Reporting in thousands/ millions/ billions in Excel
00:28 Custom formatting Excel numbers into millions
01:12 Custom format millions- spaces versus commas on different machines
01:34 Display number in thousands
01:48 Display number in millions
01:55 NB- The number is displayed in millions BUT Excel still sees full number
02:33 Add decimals to the millions format
03:07 Spaced saved on a dashboard report using numbers in millions
How to save space on an Excel dashboard by formatting the full numbers into thousands, millions or billions. Also how to include some decimals to these million formats.
Display numbers in millions in Excel
AuditExcel Advanced Excel and Financial Model Training and Consulting
3:36
2021-12-29 16:00
1 576
7
3
Теги
show numbers in millionsshow numbers in millions in exceldisplay numbers in millions in exceldisplay numbers in thousands excelshow numbers in millions in excel chartcustom formatnumber format in thousandscustom formattingcustom format code excelshow numbers in millions pivot tableexcel tips and tricksnumber format in thousands excelcompact dashboard in excelcustom format spaces versus commasExcel custom number formatDisplay large numbers