Microsoft Excel Hints, Tips & Support: Troubleshooting, Tricks & Tutorials For Microsoft Excel
Microsoft Excel is a proprietary spreadsheet application that has grown to become a very powerful and highly configurable feature rich application. Delivering advanced calculations, graphics, pivot tables, macro's, reporting tools and low level programming language manipulation. Now the MS Excel application is more comprehensive and resilient than ever. Here we provide you with a wealth of Microsoft Excel troubleshooting tips, user guides and support, to cover all levels of ability.
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. However, Excel 2013’s sparklines supports charting within cells themselves, so you can have hundreds of tiny charts on a single spreadsheet.
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 applied to another cell or range. Learn how to use this time-saving feature in Excel 2013.
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 option.
How to Change Text to Upper, Lower or Proper Case in Excel 2013
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.
How 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 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.
How 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 existing text, but it also allows mixing in your own text.
Using 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 & 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.
Quick 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 with this handy tool.
How 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 by rotating lengthy text vertically.
Using AutoCorrect for Faster Data Entry in Excel 2013
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.
