New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 613th installment in their series of digital spreadsheet magic tricks, you'll learn how to
add sales for the year from dates entered as text using the SUMPRODUCT and RIGHT functions and ampersand (&) join symbol. Learn abut TRUE-FALSE arrays and how numbers and text are different. See two different methods to convert numbers to text (lead apostrophe) and text to numbers (&"").
While you're stuck at home, make the most of your time by learning a new language, skill, or even train for a remote-work job with our new premium online courses.
Be the First to Comment
Share Your Thoughts