Now that it’s past the annual holiday season here in the US, it’s back in the saddle again for the Weekly Roundup. This week: Microsoft Office blog does its own list of most popular posts (including a couple of issues that continually plague legal office users), a quick-and-dirty Excel tutorial on printing title rows, and an exciting rumor for iPad users.
Read More
This week’s Roundup of the reading file is an embarrassment of riches from the usual suspects: TechRepublic’s take on the most important Microsoft Word skills, how to put time values into Microsoft Excel, Vivian Manning tackles Microsoft Word’s mail merge feature, making it easier to switch between Word documents, and how to share your Microsoft Outlook calendar. Click the “Read More” link for the details.
Read More![Post image for [Insanely] Popular Post: Printing Those Monster Excel Sheets](http://legalofficeguru.com/wp-content/uploads/2011/04/filestack-e1303672461628.jpg)
The #1 most popular tutorial on this blog now features a video demonstration on how to format a large Microsoft Excel spreadsheet for printing plus a downloadable video transcript. Click the Read More link to view this insanely popular post.
Read More
Here are four quick tips across a range of Microsoft Office applications: modifying the Status Bar, ensuring Excel sheets auto-calculate, improving full justification of text in Word, and starting Outlook in the folder of your choice. Click through for a link to the full article.
Read More
A reader asked me recently how to calculate the difference between two dates. My response? Well, it depends. Fortunately, there are only two scenarios to pick between, and I’ve illustrated them both in this post. Click through for complete tutorial on how to calculate in Microsoft Excel using dates.
Read More
For this week’s Roundup: how to put zeroes in otherwise blank cells in Excel (and not the long way, either), how to pick and choose which formatting marks Word shows you with Show/Hide, and a heads-up on some hefty discounts on several Outlook plug-ins.
Read More
From this week’s reading: when Outlook’s Autocomplete … won’t, when Excel’s autocalc … doesn’t, cleaning up imported data in Excel, and what to do with 250 Vcards. Click through for links to the full articles
Read More
Got a large spreadsheet you need to make sense of? Don’t waste time trying to sort and manually manipulate those kabillion rows and columns. Create a pivot table to group and summarize your data with just a few mouse clicks.
Read More
If you want one-click access to the Microsoft Office commands, you need to use the Quick Access Toolbar. Here’s a video showing you two easy ways to add commands so you have quick and easy access to them as you work.
Read More
Got a humongous Excel spreadsheet that needs printing? Here’s a detailed tutorial (including video) on how to format it to print attractively so the data makes sense.
Read MoreJessica, a reader from Miami, wanted some help with creating a custom timeline in Microsoft Office. Here’s the Excel-based solution I created for her.
Read MoreIf you use Microsoft Excel to organize data (say, a list of documents being produced), you may have run across The Cell That’s Too Small For Its Data. Fortunately, there are ways to get information to fit into a single cell. Here’s how to wrap text, insert manual line breaks, and control vertical alignment in a cell.
Read More