Excel! Learn how to use the Ctrl + Enter keyboard Trick to enter formulas or data into many cells simultaneously. Also, learn how the AVERAGE function ignores Blanks, but not zeroes! And finally, learn about the amazing GoTo feature to select all Blanks in a range!
F5 buton to go to interesting. but if i want to reach the "Go to" window from the ribbon how should i proceed? thanks.
shiryu008 3 years ago
Dear shiryu008,
Home Ribbon, Editing group, Find & Select drop-down icon.
--ExcelIsFun
ExcelIsFun 3 years ago
Hi I love your videos!!! And your voice is awesome btw! I DLed your books from the college website, but its asks for my username & password; when I press cancel it opens the books in Excel style but on my Internet Explorer... I assume thats the point but it sucks... I have no buttons (ribbons?) to follow along with? Am I doning somwthing wrong?
<3
AMLloyd 3 years ago
Dear AMLloyd,
I will check out what the problem is tomorrow. There should be no problem for people to download my Excel Is Fun book, though.
Can you send me an e-mail, with a copy of the link that you clicked on to try and download the book.
One way or another I'll get you the book.
--ExcelIsFun
ExcelIsFun 3 years ago
Dear AMLloyd,
Oh, ya, did you click Open or Save when you tried to download it? If you click Save it should work (BTW, it is 30 MB becasue it 144 pages with mostly pictures); if you click Open it asks for a password if you try to save it.
--ExcelIsFun
ExcelIsFun 3 years ago