![]() I highly encourage you to explore Quick Analysis with your own data if you are using “latest” Excel. There is no sample file accompanying this post. So, I am going to show one quick tip of using Quick Analysis (provided that you are using Excel 2013 or later) to add a column ofĪ picture (especially an animated one) tells thousand words, so let’s look at the screencast below: Try it Select File > New, select Take a tour, and then select the Chart Tab. Select Charts, hover over the options, and pick the chart you want. ![]() Select the Quick Analysis button to the bottom-right of the selected cells. Needless to say, many people have never clicked the tiny icon that showed up automatically when a range of data is selected. Select the data you want to show in a chart. The response I got was mostly: “What are these?” and some of them unconsciously showed an attitude of “I don’t care…” (not yet to mention about the new FUNCTIONS). What is even more surprising (or ironic): when I met someone who uses Excel 2013 or later, I looked at them with my “hearty” smiles and told them how lucky they are with all those new features like Flash Fill, Quick Analysis, etc…. Select the Quick Analysis button that appears at the bottom right corner of the selected data. ![]() However I am living in a city where most people I know (across different companies) are still using Excel 2010 or before. You may think that Excel 2013 is a product of 5 years ago… there is no way it can be called “latest”…. Of course, Excel 2016 and of course Excel 365 is getting even better. Well, what I meant “latest Excel” here are those versions since Excel 2013. For example, you can use it to create charts and graphs, or to apply conditional formatting. Latest Excel makes things easier, just that you may not be aware of… There are a few different ways to use the Quick Analysis Tool. Select the D1:D10 range, click the Quick Analysis button that appears next to the selected range, select the Totals menu and then select the Running Totals. Looking to improve your Microsoft Excel skills Check out Webucator’s Microsoft Excel classes. Roll over each option in the Quick Analysis gallery to see a preview. Notice that Excel knows where to put them without additional input from you. Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. To quickly insert sparklines, select the data, open the icon, click the Sparklines tab, and choose an option. With Quick Analysis in Excel 2013 or later. Select the cells of data that you want to analyze. ![]() This post is about showing you how to perform a common task of adding a column of
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |