How to Use the Goal Seek Feature in Excel 2013
One 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 ReadingShowing items from windows platform
Using the Paste Options Button to Copy and Paste Formatting in Excel 2013
Perhaps 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 ReadingHow to Combine Data in Excel 2013 Using the CONCATENATE Function
Excel 2013 alleviates the tedium of retyping text to combine it within a cell thanks to its concatenation abilities. These functions not only combine …
Continue ReadingHow to Hide Data in a 2013 Excel Worksheet Quickly and Easily
Some 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 ReadingIs Windows 10 Better than Windows 8 for Convertible Laptops?
Windows 8 was built for touch devices. Mice and keyboards worked, but the implementation was so poor that for Microsoft’s next Windows release they …
Continue ReadingQuick and Easy Way to Remove Blank Rows in Excel 2013
A 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 ReadingText Case Options in Word 2013
In changing capitalization, Word gives you the options of Lowercase, Uppercase, Sentence Case, Capitalize Each Word and Toggle Case. Learn how to use …
Continue ReadingUsing Advanced Sort & Filter in Excel to Copy Unique Values
Several Excel functions and tools require knowing the unique values contained in a dataset. The simplest solution is Excel 2013’s Advanced Sort & …
Continue ReadingOffice 2016 – What’s New and Improved?
Did you know Office 2016 was released in September 2015? Nearly six months after release, there seems to be little fanfare. Is anything new in one of …
Continue ReadingOffice 2016 Versions Explained
With the recent release of Office 2016, you may be wondering which version would be appropriate for you to use. Well – you’ve come to the right place. …
Continue ReadingHow to Make Text Vertical Using Excel 2013
Excel 2013 offers numerous text and cell formatting options, including options to change text orientation. This option conserves horizontal cell space …
Continue ReadingData Bars: Excel 2013 Conditional Formatting Tutorial
Excel 2013’s Conditional Formatting tool offers, among other things, graphical elements that are directly linked to data within cells. One such visual …
Continue Reading