New PowerPoint Design Themes in Microsoft 365: What’s Changed?
Discover what’s new in PowerPoint Design Themes in Microsoft 365, including unique layouts, modern designs, updated typography, color palettes, and more.
Read MoreDiscover the basics of Number formatting options available in Excel. Watch the tutorial video below to learn more:
This tutorial covers the following aspects of number formatting:
1) Issue with displaying large numbers
If the number digits are greater than 15, Excel doesn't automatically display it correctly.
2) Number Format: Display with or without Decimal places
3) Currency Format - You can change to any currency of your choice as the default currency is Dollars.
4) Accounting Format: is similar to Currency formatting. The difference is that the Alignment of the currency symbol is different and zeroes are displayed as dashes.
5) Date Format: Working with addition/subtraction for dates. How to change the format to display as per your requirement.
6) Time format: Understanding how to format time correctly to represent AM or PM.
7) Converting numbers to percentages correctly.
8) Fraction, Scientific and Text formats are also covered.
9) Learn why numbers in some cells are not taken into consideration when using a formula.
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365.
If you found this video useful, please leave your comment below.
Related Posts
PowerPoint Gets New SmartArt Graphics: What’s New and How to Use Them
PowerPoint has introduced new SmartArt graphics, including Text Cards, Timelines, and Meet the Team layouts. Here’s what’s new and how to make the most of them.
Read MoreHow to Use AI for Presentations: The HITL Framework to Create Clear & Authentic Slides
AI can either save you hours or silently destroy your presentation credibility.The difference isn’t the tool.It’s how you use it.Every week we see headlines claiming that AI can create a “perfect presentation in seconds.” While AI can generate slides quickly, there’s a critical distinction most people miss:Creating slides is easy. Creating impactful, persuasive, and memorable
Read More