I’m teaching a remedial Excel class this week, and so I’ve developed a tutorial to get people going using OneNote to capture crib sheets in Excel. I store my GTD crib sheets in Evernote (Example, Click here to subscribe). But OneNote is a great program too and if you have Microsoft’s Office, you have OneNote for free.
- If you have a Mac Office, you probably don’t have OneNote but you can get OneNote for free.
- If you have an older version of Office for windows you can get OneNote for free here.
To create your OneNote Excel crib sheet do this:
When OneNote opens, then create a top Tab titled “Crib Sheets:
Then add an Excel page:
Then copy the first entry from the image at the top of this blog post.
To enter A1 + B1 = C1 do this
With the pinky finger on your right hand, push the = sign on the keyboard
Now, start Excel so we can get some practice using our Excel crib sheet!
Next question: How do I snip from Excel?
You have created an Excel crib sheet, and made your first entry!!!