![\"MS_Office_2007_Logo.svg\"](\"http:\/\/southjerseytechies.net\/blog\/wp-content\/uploads\/2013\/04\/MS_Office_2007_Logo.svg_.png\"){kind=logo}
<\/span><\/p>\nWhen considering tips to share, think about ease-of-use and efficiency. A few naturally rise to th<\/span>e top as your favorites. For your commemoration, here are 10 of 2012\u2019s most popular posts from both the Office Blog, which was deactivated in mid-2012, and the current Windows and Office Blog. Thank you for reading, and thank you for sharing your thoughts and enhancements with one another throughout the year.<\/span><\/p>\n The response to this limited technique surprised me. It\u2019s something only a few will use, but if you\u2019re one of those few, it can be a big help! I was pleasantly surprised at the positive response it received and the way readers enhanced the technique.<\/p>\n These two short macros make quick work of bookmarking work areas in a Word document. When the built-in navigation techniques just don\u2019t get the job done for you, consider these macros or one of the alternative methods that readers shared.<\/p>\n This quick Go To comparison solution is great for a one-time task. Comparing Excel data is a common task, and I receive frequent questions for solutions. This solution is a great one to add to your bag of tricks.<\/p>\n Sometimes a great tip doesn\u2019t offer a specific solution, but rather guides you to using a feature more efficiently and effectively. Users tend to ignore Excel\u2019s pivot table feature because they don\u2019t really understand it – hence this blog post offers some quick insight into how to use this feature without mind-bending tricks.<\/p>\n This blog post is one of my favorites. I enjoyed sharing the technique, but more than that, I loved the way the readers jumped in to help one another with a step I accidentally omitted in the instructions. TechRepublic readers rock!<\/p>\n This technique uses Go To ([F5]) in an unusual way – to anchor two cells, creating a range. The ensuing conversation shared a number of great selection tips!<\/p>\n Using the right function can help you round up your rounding woes. Excel offers three rounding functions and knowing them all will round out your skills nicely. (Okay, I promise to stop that.)<\/p>\n I review a lot of workbooks, so this blog was one of my favorites to write. In my experience, performing these three quick tasks when inheriting a workbook can speed up your troubleshooting time. Fortunately, it sparked some insightful conversation into what others do.<\/p>\n Reader response sometimes surprises me, as it did for this easy technique. I hadn\u2019t expected so many great alternatives from the readers.<\/p>\n I\u2019m glad a PowerPoint technique made the top list, but it wasn\u2019t because the readers loved my technique. Mostly, the conversation centered on the typo I missed, and then my lack of proper contrition for said typo. It was fun while it lasted.<\/p>\n","protected":false},"excerpt":{"rendered":" The ten most popular Microsoft Office tips Takeaway: \u00a0Susan Harkins lists ten most popular Office tips published in the Windows and Office Blog, and the now inactive Office Blog. When considering tips to share, think about ease-of-use and efficiency. A …<\/p>\n1:\u00a0A quick Word trick for typing text into a scanned document<\/h3>\n
2:\u00a0Use Word macros to save your place in a document<\/h3>\n
3:\u00a0A quick and dirty way to compare columns of Excel data<\/h3>\n
4:\u00a0Demystify Excel\u2019s PivotTable feature with this simple method<\/h3>\n
5:\u00a0Create a dynamic Excel chart and make your own dashboard<\/h3>\n
6:\u00a0A quick Excel keyboard trick for selecting large ranges<\/h3>\n
7:\u00a0Three tips for rounding Excel time values<\/h3>\n
8:\u00a0Three things you must do when you inherit an Excel workbook<\/h3>\n
9:\u00a0Launch Word with the most recently used document<\/h3>\n
10:\u00a0Run a list of rolling credits at the end of your PowerPoint presentation<\/h3>\n