![]() ![]() For example, you could set up a range to make values under or over a certain amount appear in a different color or with a special icon adjacent. Then hover over one of the icons in that category to see the result previewed on your worksheet:įormatting: These shortcuts point to conditional formatting options. This is the Quick Analysis icon, and clicking it opens a panel containing shortcuts to several types of common activities related to data analysis.Ĭlick on of the five headings to see the shortcuts available in that category. ![]() When you select a range of cells, a small icon appears in the lower right corner of the selected area. Here are some points to keep in mind about Quick Analysis: When you need to do a speedy analysis of your data in Excel 2016, consider using the Quick Analysis feature. To remove any conditional formatting, click Clear Format in the Quick Analysis gallery.įor additional formatting options and colors, select your data, and then click Home > Conditional Formatting. On the Formatting tab, move your mouse over the different options to see a Live Preview on your data, and then pick the formatting you like best. You should now be looking at the Scenario Manager window. Click on the What-If Analysis button and choose Scenario Manager from the list of options. The Quick Analysis button appears on the lower-right corner of the selection.Ĭlick the Quick Analysis button, or press Ctrl+Q. To use Excel’s What-If Analysis tool, begin by clicking on the Data tab on the Ribbon and locating the What-If Analysis tool button under the Data Tools section. Here’s how you can quickly apply this type of formatting: For example, you can use a color scale to differentiate high, medium, and low temperature values. But Excel provides a bunch of ways to quickly analyze your data using conditional formatting. It can be hard to get a lot of meaning out of numbers in a worksheet.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |