For example, it looks like Carlos, our number one sales rep started the year with excellent sales-lots of green - but is trending downwards in Q2 as signified by the red color here.Ĭhill Charts Charts: They provide a colorful, informative representation of data contained within spreadsheets. There are a ton of options! Click on your format type and presto – now you can see patterns and highlights in the data.
From the Home Tab, click on Conditional Formatting > Hover your mouse over the preferred conditional formatting type. Select the cells where you want to apply conditional formatting. It is one of the best excel tips ever! If you had sales info and wanted your top sales month to be in Green and your worst sales month to be red, you can do it with Conditional Formatting. For example, by clicking on the salesperson filter, I can isolate Jim’s sales of the Falcon2000.Ĭonditional Formatting: Conditional formatting automatically applies icons, data bars, or colors to data cells based on the value of that cell. I simply uncheck Select All and check Falcon2000 and there you go! I could even filter two columns. I want to isolate sales of the Falcon 2000 Drone. Now you are looking at a subset of your information which is incredibly useful when working on larger spreadsheets. Then selectively check the boxes of the items you want to see in that column and click OK. Uncheck the box next to Select All to deselect all items. Click on the Filter Arrow for any column and the Filter Menu will appear. Select Data > Filter and Filter Arrows will appear next to your headers. The Filter feature is much easier to use when a worksheet contains headers or titles.Ĭlick into any cell in the source data that you want to filter. Isolating a specific kind of data in a column provides useful information. And now I can clearly see that Pam had the biggest sale of the year because I was smart about sorting.įriendly Filters: The Filter feature allows you to select what information you do and don’t see. Under Order, I will leave Largest to Smallest as my selection and click OK. Now, next to Sort by, select the column that you would like to sort on. Make sure that the box next to My data has headers is checked because our data does include headers. That will select all the data in the area really fast. Click anywhere in the data area and select Control + A.
Smart Sort: Let’s say we want to sort this data set to see which sales rep had the biggest Total Sales number for the year. To unfreeze a row or column click on View > Freeze Panes Command > Unfreeze Panes. You can also use this process to freeze a column. The rows now freeze at the gray horizontal line. Click the View Tab on the ribbon and select the Freeze Panes command > Click Freeze Panes. The titles are visible! To freeze a row select the entire row below the row or rows that you want to freeze. However, if you freeze the top header row, you can always see what is in each column as you scroll down. Click on the drop-down menu below Allow: and select List.Ĭlick on the Source area >Select the cells that contain the info that you want to appear in your dropdown list > Click OK.įreeze Panes: If you scroll down in a spreadsheet and can’t see the headers, it can be hard to know what is actually in each column. From the Data Tab click on Data Validation in the Data Tools Area and select Data Validation again. Then, click on the cell in which you want your dropdown list to appear. Create your list items in another part of your spreadsheet. At this point, you can select from a variety of table designs by clicking on the table and looking under Design for options.ĭynamic Dropdowns: Dropdown lists help users select from a consistent group of options. Click Insert > Table > Select the table area > and Click OK. Place your mouse at the top right corner of your data. They come formatted with colored rows and filters. Looking for a best excel tips video? You found it!Īmazing Tables: Tables make data easier to read. And now we are going to help make your spreadsheets more informative via the smart use of stunning visuals. Hi! I’m Mike Song, author of The Hamster Revolution and the Get Control! of Excel class. Create creating stunning visuals and turning boring spreadsheets into valuable knowledge. Best Excel Tips Video: Create Excel Charts, Graphs, and Tables These insights are considered to be the best excel tips ever.
0 kommentar(er)
