This video is very useful when working with large spreadsheets (lots and lots of data!). You can filter it down to any category or date. In addition, learn how to do subtotals….this is great if you need to know how much each sales rep earned.
I wish I wrote this book, but I didn’t. Anyhow, it’s great for the novice, slightly experienced or even someone like me who teaches and is always looking for something new.
You can buy the book in print or as an ebook.
If you live in Sarasota, FL, you may wish to check out the classes that she teaches there.
A few tips to help with Word – works with all versions! Highlighting/selecting text can sometimes be a pain, these shortcuts will make life easier…stuff I thought EVERYONE knew! I’ve taught basic and intermediate classes…very often the intermediate students are thrilled to learn them:
highlight a word: double click on it
highlight a paragraph: triple click in it
highlight a sentence: put your mouse inside the sentence, hold down control key and left click.
highlight entire document to adjust spacing, font size, color, etc: CTRL + A (selects all). (command A on the Mac)
highlight a single line in a paragraph: put mouse to the left of the line, you get a right pointing arrow. click once.
highlight multiple ranges in a document: select first range of text. Hold down CTRL key and highlight second range. Repeat this step.
This link is very helpful for those who know the basics of Excel. There are so many additional features that you need to know that this link will help you.
Some of the many topics include the basics like sum, average. etc. However, it includes some functions that I forgot about which include LEN, TRIM, RIGHT, LEFT, MID, VLOOKUP, IF, SUMIF, COUNTIF, AVERAGEIF, CONCATENATE. If you don’t know what they mean, check this out…instructions are very well written!
The video is demo’d in Excel 2013 yet will work with 2010 and 2007. Conditional formatting allows the user to change the appearance of cells if they meet a specific condition – i.e. top 10 in a range will appear bright green. As a bonus, this video also shows you how to toggle it on/off with a very simple step. This way you can look at the information without being distracted by the color(s) being displayed.