Category Archives: Word

Southeastern Accounting Show!

Posted on by

 

Presenting for one of my favorite organizations and industries – my accounting friends. The Southeastern Accounting Show is a great event with over 1,000 accountants and finance folks in one place; how will there organizations cope with them out of the office for a couple of days?! I love my accountant, Lynn; she keeps me out of jail and off of the IRS nasty list. All businesses, small, large, or, like me, self-employed, must have an accountant, even before a lawyer.

Let’s geek out together in Excel and Microsoft Office! For the attendees and fellow accountants, here are my PowerPoint presentations and some of the files that I use in my sessions.

Excelling @ Excel: Tips N Tricks and Shortcuts

Microsoft Office Made Easy

Excelling @ Excel: Deep Dive

Track – Excel Workbook    Budget – Excel Workbook   Database Functionality – Excel Workbook    VLOOKUP – Excel Workbook  Loan – Excel Workbook 

Word Letter – Word Document  Word Manual – Word Document

Enjoy!

Geeky Greg

Propeller Geek Hat

 

Common MS Office Function Keys – Adds Functionality, Saves time

Posted on by

TechTip: In Word, Excel, Outlook (Email, Appointment), and PowerPoint (PC versions) these four Function Keys at the top of your keyboard work the same:

  • F1 is Help (not that I would EVER need help HA!),
  • F7 runs your Spell Checker,
  • F10 is Key Tips (Keyboard shortcuts for using the Ribbon and tabs), and
  • F12 (my personal favorite) key quickly activates Save as for you.

The other Function Keys work differently in the applications, such as F5 is Go To in Excel and Word, but begins your PowerPoint presentation from the beginning and activates Find and Replace in Outlook.

Stay Tuned! Plenty more keyboard shortcuts coming soon.

Text-to-Speech – Talk to me, Baby!

Posted on by

TechTip: Text-to-Speech – Talk to me baby! Word, PowerPoint, OneNote, and Outlook (2010 and 2013) can read any of your selected text. Outlook speaks my selected email text and Word helps me proofread by reading back my document. Add the Speak button to your Quick Access Toolbar by clicking the arrow at the end of your toolbar and clicking More Commands – pictured below. At the next pane (displayed below), in your Choose commands from list choose Commands Not in the Ribbon and scroll to Speak and click the Add button. Click OK. Now, in your application select text (paragraphs, pages, sentences – whatever) and click the button – Michael Microsoft reads to you! I’m not so lonely anymore.Text-to-Speech - Talk to Me!

Text-to-Speech – Talk to Me!

Word – Readability Statics – Make the Grade!

Posted on by

TechTip: Make the Grade with Word. Word has a neat feature called Readability Statistics. After using your Spelling and Grammar check, Word can give a pane showing you the percentage of passive voice (editors/publishers do not like more than 8% – 10% passive voice) and what grade level you are writing. To activate Readability Statistics, go to your Word Options from the File Tab (Office 2010 and 2013) or the Office Button for (Office 2007) and click Options and check Show Readability statics as displayed below. After you run your spell/grammar check (use the F7 key at the top of your keyboard to quickly activate Spelling and Grammar), the pane below displays. Mrs. Wyman, my high school English teacher, is very proud that I’m writing this post at the 11th grade level AND no passive voice; however, my Flesch Reading Ease should be at 70 – 80. This works in Outlook 2010 and 2013 for your email messages, too.

Word's Readability Statistics

Word’s Readability Statistics