This tutorial works with Excel 2013 (works with previous versions) and shows how to create a simple macro (this one will make a sheet landscape, create custom footers) and a demonstration of creating a button to put in the quick access toolbar.
This 11 minutes video covers a lot of territory…make sure you hit the pause button. This also works with earlier versions of Excel.
By default, Office 2013 goes to the cloud…that’s great if you want to share with others. However, if you want files to go to your hard drive such as My Documents, this quick tutorial shows you how….this works with Excel, Word, PowerPoint 2013
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!