There are very few persons on the earth who can claim to have thoroughly grasped every complex little detail of Microsoft Excel. It’s the world’s most popular spreadsheet program, and it’s been the industry standard for almost 35 years, having supplanted the once-venerable Lotus 1-2-3, the first killer software for PCs in the 1980s.
Microsoft Excel’s spreadsheet supremacy has yet to be fully tested, definitely not by Corel’s Quattro Pro (still marketed today in WordPerfect Office), LibreOffice’s open-source capabilities, or even Google Sheets (the spreadsheet part of Google Drive). There’s a good explanation behind this. Excel is more than just a well-known brand: it is also extremely strong. It pretty much accomplishes everything a person might want.
It’s not only for figures. Many individuals use Excel as a flat-file database, filling its unlimited grids with data. It may function as a competent contact manager or a full-fledged client relationship manager. Even though Microsoft Word is usually right next to it, it’s not surprising to find individuals utilizing it as a word processor. Not to mention the nearly unlimited amount of visually appealing charts it can produce with the appropriate (or even incorrect!) data.
Almost single Excel user has one thing in common: they don’t know enough. There are so many different ways to slice and dice statistics, give data a new appearance, and more that it’s hard to list them all. Entire volumes have been written on the subject. However, some of the more fascinating and sophisticated methods that will make your time using the application a bit simpler and will make you appear like a guru of high-tech spreadsheet very are simple to grasp. So brush up on any or these entire Excel tips if you want to excel at it. One can learn various things from excel training videos.
If you construct a formula in Excel that has an error or a circular reference, Excel will display an Excel Errors notice. When a formula or function in Excel cannot be resolved, a slew of errors might show in a cell. Knowing what they mean can help you solve the problem.
- #DIV/0! Attempting to divide by zero
- #N/A! A formula or a function within a formula is unable to locate the referenced data
- #NAME? Text in the formula is not recognized!
- #NULL! In formulas that reference several ranges, a space was utilized; a comma-separated range refers
- #NUM! A formula contains erroneous numeric data for the operation type
- #REF! #VALUE! A reference is invalid! The incorrect operand or function argument is utilized.
This is a no-brainer, but it is frequently neglected. When you start inputting a succession of dates (1/1/20, 1/2/20, 1/3/20, etc.), you know you’re in for a long day. Instead, start the series by moving the mouse to the lower-right corner of the final cell—the fill handle. When it changes to a plus sign (+), click and drag down to choose all of the cells you want to fill. They’ll fill in the blanks using the pattern you started. It can also go up and down a column, as well as left and right on a row.