How to Use Sparklines in Excel 2013 to Create Miniature Charts
There’s no doubting the usefulness of charts to spot trends and patterns, but they are impractically large for illustrating individual records. …
Continue ReadingThere’s no doubting the usefulness of charts to spot trends and patterns, but they are impractically large for illustrating individual records. …
Continue ReadingExcel 2013 relies on functions to change capitalization. The LOWER, UPPER and PROPER functions change text in referenced cells to lowercase, uppercase …
Continue ReadingOne of the best forecasting tools in Excel 2013 is the Goal Seek feature. Learn where to access and ways that you can use this What-If Analysis …
Continue ReadingPerhaps you have used some of the Paste options available in Microsoft Excel, but you may not have realized you can copy and paste just the formatting …
Continue ReadingExcel 2013 alleviates the tedium of retyping text to combine it within a cell thanks to its concatenation abilities. These functions not only combine …
Continue ReadingSome data is necessary for functions and tools, but is distracting on an otherwise clean worksheet. To keep your sheet neat, hide the data using the …
Continue ReadingA quick way to find and delete blank rows in a worksheet is to use Excel’s filter feature. Learn how to locate and remove entirely blank rows …
Continue ReadingSeveral Excel functions and tools require knowing the unique values contained in a dataset. The simplest solution is Excel 2013’s Advanced Sort & …
Continue ReadingExcel 2013 offers numerous text and cell formatting options, including options to change text orientation. This option conserves horizontal cell space …
Continue ReadingExcel 2013’s Conditional Formatting tool offers, among other things, graphical elements that are directly linked to data within cells. One such visual …
Continue ReadingExcel’s Icon Sets add dynamic, visual elements to aid in data identification within cells. Available graphics include traffic lights, checkmarks, …
Continue ReadingExcel 2013 supports multi-tiered sorting rules to arrange data as you prefer, but the default sorting rules only provide alphabetical or …
Continue Reading