Video Tutorials

Reader Question: Incrementing numbers in headers

by The Guru on November 8, 2011

Post image for Reader Question: Incrementing numbers in headers

A reader wrote me recently with an interesting dilemma: She needed to be able to automatically increment numbers in a Microsoft Word footer. But she’d found that the otherwise trusty AutoNum field doesn’t work in headers or footers. So how was she going to put the correct “Exhibit [X]” at the bottom of her documents? Here’s the solution I came up with for her. Click the “Read More” link to see the demonstration video.

Read More

Four ways to insert tables in Microsoft Word

by The Guru on September 21, 2011

Post image for Four ways to insert tables in Microsoft Word

If you ever want to insert a table in Microsoft Word 2007 or 2010, there are four (count ‘em, FOUR) ways to do it. Click the Read More link for detailed instructions, then pick your favorite!

Read More

Part II of the continuing series on Tables of Authorities shows you – with video and screen shots – how to:

(a) Check over your citations for correct marking
(b) Insert the TOA in your document
(c) What formatting options are available to you (passim, dot leaders, etc.) and how to adjust them
(d) What to do if your TOA headings or entries aren’t formatting just right

Click the “Read More” link below for the full tutorial.

Read More

When just the page number won’t do

Post image for When just the page number won’t do

by The Guru on August 30, 2011

When you have to have a page number formatted with text (like “C-1 of 3″), then you need a working knowledge of how to insert the various page number fields in Microsoft Word. Here’s a tutorial using a real-life situation: an appellate brief with a specially numbered “Certificate of Interested Parties” section.

Read More

Reader question: Page number macro misfire

Post image for Reader question: Page number macro misfire

by The Guru on August 26, 2011

A Legal Office Guru reader has an “insert page number” macro that works just fine … until he logs off. How I solved his dilemma.

Read More

Summarizing Excel data with Pivot Tables

by VideoTutor on June 28, 2011

Post image for Summarizing Excel data with Pivot Tables

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

Customizing the Quick Access Toolbar

by VideoTutor on June 22, 2011

Post image for Customizing the Quick Access Toolbar

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

Don’t keep copying commonly-used blocks of text from old documents – that cut-and-paste routine will inevitably get you into trouble when you forget to edit out client-specific info. Instead, use Quick Parts to store generic text blocks like Certificates of Service, Signature Blocks, etc. Here’s a video to show you how.

Read More

Quick-and-dirty text sorting in Microsoft Word

by VideoTutor on May 30, 2011

If you need to sort text in Word, whether it’s within a table or just typed straight, here’s how.

Read More

Printing those monster Excel sheets

by The Guru on April 25, 2011

Post image for Printing those monster Excel sheets

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 More

If you ever have columns of numbers (particularly currency figures) you need lined up in Word, you need to learn about decimal tabs. Here’s a quick video introduction to inserting and using them.

Read More

Creating a custom timeline in Excel

by VideoTutor on April 4, 2011

Jessica, 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 More

It’s easy to have a different footer for the first page – just use the Page Setup function called “different first page.” But what if you need a different footer for the LAST page? Well, it may not be check-box easy, but it is possible. Here’s a video tutorial showing you exactly how.

Read More