Microsoft Excel - Formatting - 40 minutes

$120.00

Available number formats

Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel Starter 2010
In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers.

Conditional formatting

Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010
Conditional formatting provides visual cues to help you quickly make sense of your data. For example, it’ll clearly show highs and lows, or other data trends based on criteria you provide..

Align or rotate text in a cell

Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 More...
If you want to change the way data appears in a cell, you can rotate the font angle, or change the data alignment.

Change the format of a cell

Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016
You can apply formatting to an entire cell and to the data inside a cell—or a group of cells. One way to think of this is the cells are the frame of a picture and the picture inside the frame is the data. Formatting the cell might include adding a border, adding color or shading, and changing the size or style of the cell.

Copy cell formatting with the Format Painter

Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010
Copy cell formatting in your worksheet using copy and paste options, Format Painter, and dragging techniques.

Add a watermark in Excel

Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010
Microsoft Excel doesn’t come with a built-in watermark button. But you can use an image, like a logo, to create a watermark.

Display or hide zero values

Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007
You may have a personal preference to display zero values in a cell, or you may be using a spreadsheet that adheres to a set of format standards that requires you to hide zero values

Create or delete a custom number format

Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007

Create and build a custom numeric format to show your numbers as percentages, currency, dates, and more. To learn more about how to change number format codes