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 option.
Excel 2013 relies on functions to change capitalization. The LOWER, UPPER and PROPER functions change text in referenced cells to lowercase, uppercase or proper case. This method requires a formula in another cell, but you can copy the results to the original location to avoid with duplicate data.
The FBI wants Apple to break a security feature on a terrorist’s phone. Apple says it will threaten every iPhone user out there. What’s happening and why should you care? Read on to find out!
Excel 2013 alleviates the tedium of retyping text to combine it within a cell thanks to its concatenation abilities. These functions not only combine existing text, but it also allows mixing in your own text.
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 Format Cells feature. While they won’t appear in the cells, you can still verify the values by selecting the cells and looking in the Formula Bar.
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 skipped right to version 10. How does Windows 10 stack up? Read on to find out.
Several Excel functions and tools require knowing the unique values contained in a dataset. The simplest solution is Excel 2013’s Advanced Sort & Filter feature that can copy only unique values from a long list of records, so you can paste them to a location of your choosing.
In changing capitalization, Word gives you the options of Lowercase, Uppercase, Sentence Case, Capitalize Each Word and Toggle Case. Learn how to use these options and what each one denotes.
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 with this handy tool.
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 Microsoft’s oldest product lines? Let’s take a look and see if an upgrade is worthwhile to you.
Excel 2013 offers numerous text and cell formatting options, including options to change text orientation. This option conserves horizontal cell space by rotating lengthy text vertically.
Excel 2013’s Conditional Formatting tool offers, among other things, graphical elements that are directly linked to data within cells. One such visual tool is Data Bars that effectively creates a bar chart within a group of selected cells.
Excel 2013 supports multi-tiered sorting rules to arrange data as you prefer, but the default sorting rules only provide alphabetical or reverse-alphabetical ordering. A convenient workaround is to specify sort order using custom lists that give you exact control over the sort order.
Microsoft Office’s AutoCorrect feature enables you to add custom entries manually. You can capitalize on the option for customization by reducing complicated, frequently entered text to just a few letters, which could dramatically speed up data entry.
Excel’s Icon Sets add dynamic, visual elements to aid in data identification within cells. Available graphics include traffic lights, checkmarks, arrows, flags and a host of others. The dynamic nature of such conditional formats support formulaic rules to determine the icon used.
How secure are your passwords? Learn how every day events can pose risks to your digital security
Windows 10 Cortana may share the name of a character in the popular Halo series of games, but the ‘real’ Cortana in Windows 10 is surprisingly fun and handy to use. This guide will show you how to make the most of using Cortana.