Microsoft Excel - Formatting - 40 minutes
Regular price
Sale price
$120.00
Unit price
/ per
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