Guide to Microsoft Excel Help
Microsoft Excel is a wide-ranging spreadsheet application, enabling you to not only create worksheets with detailed formulas, but also charts, macros, filters and more. All of these features may seem a bit overwhelming at first, but this guide is here to help you navigate the many aspects of Excel and go from a novice user to an intermediate or expert Excel guru. Perhaps you are already quite skillful but are experiencing errors or need to recover a lost or corrupted worksheet. This Microsoft Excel help guide can assist you with these issues as well, walking you through troubleshooting steps and offering solutions to common Excel problems.
Image credit: Wikimedia Commons/Brews Ohare
| Microsoft Excel: Round Prices to Next Highest $5
Need to round numerical values in a non-standard manner in Excel? Read on to learn how.... |
Microsoft Excel: Count, Average, Etc. Without Using A Formula
You don't need to construct a formula to determine certain measures, like an average, in Excel. Read on to learn a quicker way.... |
| Microsoft Excel: Rank A List Without Ties
Problem: The RANK function behaves strangely when there are ties. It is possible to have a list where two people are ranked second and no one is ranked third. In Fig. 383, Dora... |
Microsoft Excel: Calculate a Trendline Forecast
Having a little trouble calculating an Excel trendline? Try this approach.... |
| Microsoft Excel: Use Excel As A Word Processor
Problem: You need to type some notes at the bottom of the report, as shown in Fig. 96. How can you make the words fill each line as if you had typed them in Word? ... |
Microsoft Excel: Quickly Filter A List To Certain Records
Problem: You have 10,000 records, as shown in Fig. 641; you need to be able to quickly find records that match a criterion, such as all East ABC records.... |