Monday, October 21st, 2019 / by Angie
Spreadsheets might seem boring, but they’re incredibly versatile and there are a lot of useful functions that can save you time and make you look like a genius at work.
Here’s a quick list of Microsoft Excel functions everyone should know.
Do you ever find yourself struggling with copying and pasting data in Excel because you either ended up copying and pasting a formula instead of a value, or because when you copied that cell it copied over the colors and formatting as well? If so, the Paste Special menu feature is something that you should learn. Ctrl+Alt+V will bring up the Paste Special menu, or you can access it from Edit > Paste Special on the Home Ribbon. There are lots of options depending on whether you want to paste just the value, or also the formatting and/or formulas.
If you have a huge list of data to parse in Excel then this feature could be super-handy. It gets rid of any duplicates in a range of data in seconds. To avoid messing up your main spreadsheet, copy the data that you want to sanitize to a separate sheet, and then select the data. The “Remove Duplicates” feature is found in the Data Tools section of the Data Tab on the Excel Ribbon.
Most people know that Ctrl+Z is “Undo”, but did you know that you can “Redo” as well, so if you hammered undo a few too many times in frustration then you can, well, “undo your Undo”. Just press Ctrl+Y. This works in other Microsoft applications too.
Using the IF / AND / OR statements will make you look like a programming wizard! These are simple logical tests which you can apply to a formula.
Let’s imagine that you’re testing processor temperatures, and you want to flag them as being “Too High” if the temperature is at or above 85 degrees, otherwise the temperature is “OK”. The temperature is located in cell C2. The statement is easy to write:
=IF(C2>=85, “Too High”, “OK”)
It’s as simple as that. You can use AND statements as well as OR statements, and nest statements inside each other, just like you can with other simple Excel formulas.
The NOW statement (written as =NOW()) and the TODAY statement (written as =TODAY()) are two great MicrosoftExcel functions everyone should know. These return the date/time of the computer at that moment. They’re easy to use, but they aren’t infallible. If the computer’s date or time is incorrect then the information shown in that cell will also be incorrect.
The above are just a few handy features that many people don’t know exist. Spend some time reading the Excel knowledge base, and our previous blogs, and you will quickly come to appreciate just how powerful and flexible it can be. It’s far more than just a tool for adding and subtracting large lists of data, and it really can make your working day easier.
I can not recommend ExcelHelp more highly. We had been struggling to complete a critical project and finding them was a lifesaver. Tom was knowledgable, professional, personable, patient and responsive. Look no further for your database programming needs. Thanks Tom and ExcelHelp.com!Randy Hartnell
We anticipate a long business partnership with ExcelHelp and look forward to working with them. I have been nothing but impressed with your firm’s services, your team members tenacity and the overall results. Sometimes you have to travel a bumpy road trying different firms until you find the one that fits.Posted By: Charlene Faber
Chief Operation Officer, Current Builders
I’d like to express my gratitude for the help and cooperation we’ve received from your entire organization during the development of our Modeling Utility. Over the past several weeks we’ve engaged key customers worldwide...We have confidence that this effort will add significant capability and value to the overall success of the program.Business Development Manager
Network Architecture and Strategy
Posted By: Marty M.