Susan Harkins

Displaying 1-40 of 107 results

  • Downloads // Apr 2013

    10 steps to linking PowerPoint slides: Demo files

    These sample PowerPoint presentations (ppt and pptx versions) demonstrate the techniques described in this 10 Things blog post.

    Provided By Susan Harkins

  • Downloads // Mar 2013

    10 steps to animating clipart in PowerPoint: Demo files

    These sample PowerPoint presentations (ppt and pptx versions) demonstrate the animation technique described in this 10 Things blog post.

    Provided By Susan Harkins

  • Downloads // Feb 2013

    10 steps to creating a custom list for sorting in Excel: Demo files

    These sample Excel workbooks (xls and xlsx versions) illustrate the custom sorting technique described in this 10 Things blog post.

    Provided By Susan Harkins

  • Downloads // Dec 2012

    10 steps to creating a Word userform for addressing letters: Demo files

    These sample Word templates (dot and dotm versions) illustrate the addressing technique described in this 10 Things blog post.

    Provided By Susan Harkins

  • Downloads // Oct 2012

    10 steps to creating a scrolling Excel chart: Demo files

    These sample Excel workbooks (xls and xlsx versions) illustrate the scroll bar technique described in this 10 Things blog post.

    Provided By Susan Harkins

  • Downloads // Sep 2012

    10 tips for summarizing Excel data: Demo files

    These sample Excel workbooks (xls and xlsx versions) illustrate the summarizing techniques described in this 10 Things blog post.

    Provided By Susan Harkins

  • Downloads // Apr 2012

    10 cool conditional formatting techniques: Excel demo files

    These sample Excel workbooks (xls and xlsx versions) illustrate the creative conditional formatting techniques described in this 10 Things blog post.

    Provided By Susan Harkins

  • Downloads // Jun 2011

    10 steps to a PowerPoint countdown

    Here's a cool attention-grabber: a countdown to kick off your presentation or lead into a big announcement. This download includes a walk-through that explains how to create your own, along with ready-to-use slides you can drop into your presentations.

    Provided By Susan Harkins

  • Downloads // Apr 2011

    10 cool add-ins for Office 2007 and 2010

    Add-ins let you enhance your Office apps so they can do more things -- and do things better. Susan Harkins combed through the vast sea of Office add-ins to produce this list of winners.This download is also available as an entry in our 10 Things blog and as a...

    Provided By Susan Harkins

  • Downloads // Apr 2011

    10 power tricks for using Word field switches

    With the right combination of fields and switches, you can build expressions that perform calculations, insert text, apply complex formatting, and take the dog for a walk (almost).This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Mar 2011

    10 tips for choosing between a surrogate and natural primary key

    The superiority of surrogate versus natural keys is a hotly debated topic among database developers. Susan Harkins offers some insights into when -- and why -- you might choose one over the other.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Mar 2011

    10 ways to keep your messages out of spam filters

    Legitimate messages that get snagged by spam filters can lead to big problems -- such as derailed job searches, hard feelings, and lost business. These tips will help ensure that your messages reach their intended targets.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Mar 2011

    Five tips for enhancing Excel charts

    With a few simple tweaks, you can make your Excel charts easier to interpret and convey data in a more compelling and meaningful way.This download is also available as an entry in our Five Tips blog.

    Provided By Susan Harkins

  • Downloads // Mar 2011

    Five tips for efficient file management in Windows 7

    Share these tips with Windows 7 newbies to reduce initial confusion and help them get up to speed quickly.This download is also available as an entry in our Five Tips blog.

    Provided By Susan Harkins

  • Downloads // Feb 2011

    10 terms and concepts related to open source

    Despite the proliferation of open source projects, some people are still fuzzy on the terminology and basic open source concepts. Susan Harkins put together this list to help clear up some of the confusion.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Feb 2011

    10 easy ways to speed up an Access database

    Even your least technical Access users can improve the performance of their databases. Susan Harkins shares some basic tips those users can put to work right away.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Jan 2011

    10 tips for making a presentation more accessible to those with disabilities

    By making a few preparations, you can help ensure that your presentations are effective for audience members who have disabilities. Susan Harkins outlines several ways to keep their needs in mind.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Jan 2011

    10 Office tips I learned from readers in 2010

    Some of the best information on TechRepublic is sparked by discussions that spring up around a particular tip or technique. Susan Harkins shares a selection of the insights, refinements, and creative alternatives she learned from members over the past year.This download is also available as an entry in our...

    Provided By Susan Harkins

  • Downloads // Dec 2010

    My 10 favorite Office tips of the year

    During 2010, Susan Harkins wrote more than 200 tips to help Office users and the techs who support them. To wrap up the year, she's selected 10 of the ones she (and TR members) liked the most.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Dec 2010

    10+ of my favorite Windows API functions to use in Office applications

    When a VBA solution falls short of your needs, there's probably a Windows API function that can handle the job. Susan Harkins lists 10 handy APIs and explains how you can put them to work.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Tools & Templates // Dec 2010

    Billable Hours Tracker

    Keeping track of those billable hours is tedious but essential. So IT consultant Susan Harkins built a little automated tool to make the task a bit easier.

    Provided By Susan Harkins

  • Downloads // Nov 2010

    10 ways to screw up your VBA code

    It's easy to get enticed into cutting corners when you write VBA code -- but that's likely to create problems down the road. Susan Harkins looks at some misconceptions that lead to bad practices, flawed code, and buggy apps.This download is also available as an entry in our 10...

    Provided By Susan Harkins

  • Downloads // Nov 2010

    10 mistakes to avoid when working with multiple worksheets

    One of the best ways to boost your Excel efficiency is also one of the best ways to shoot yourself in the foot. Here are some pitfalls to watch out for when you're dealing with more than one sheet.This download is also available as an entry in our 10...

    Provided By Susan Harkins

  • Tools & Templates // Nov 2010

    Business Asset Tracker

    Effectively managing your IT equipment will help you control costs, assess future needs, and make informed purchase decisions. This simple tool lets you input your business assets, along with the data you need to track and properly depreciate them.

    Provided By Susan Harkins

  • Downloads // Oct 2010

    10 steps to creating an Outlook appointment (without using your mouse)

    If you're a diehard keyboard fan, you'll appreciate this mouse-free technique for setting up your Outlook appointments.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Oct 2010

    10 things I can never find in PowerPoint 2007/2010

    If you're having trouble tracking down features you knew by heart in PowerPoint 2003, this list will help you zero in on the options that the newest versions have scattered among various tabs.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Oct 2010

    10+ ways to screw up your database design

    Database developers often fall into certain design traps -- and it's generally the users who pay the price. See how you can improve your design process and build a more flexible, reliable, and efficient database. This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Sep 2010

    10 steps to setting up page numbering in Word sections

    If you've ever been outfoxed by Word's page numbering options in a multiple-section document, here's good news: Controlling how the pages in each section are numbered is actually pretty easy. Susan Harkins demystifies this Word feature.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Tools & Templates // Sep 2010

    Multi-scenario savings calculator

    Regardless of what you're saving up for, a worksheet with relevant calculations will help you stay on top of your plan. Walk through this technique to create your own calculator -- or just use this ready-made tool.The article portion of this download is also available as an entry in...

    Provided By Susan Harkins

  • Downloads // Aug 2010

    10 things your users need to know about Office 2010

    Even if your users are familiar with the Office 2007 interface, they're going to have questions about Office 2010 features and functionality. This list will help them find some of the answers on their own.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Aug 2010

    10+ things I can never find in Access 2007 and 2010

    Even after working a while with Access 2007 or 2010, you may be disoriented if you're used to earlier versions. Susan Harkins offers some help in locating the tools you need.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Jun 2010

    10 steps to adding a gradient background to your Excel data points

    It's easy to turn an Excel chart into a visually compelling object. Susan Harkins walks through the steps for jazzing up data points with a simple formatting trick.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Jun 2010

    10 steps to shading alternate rows in a filtered worksheet

    Excel makes it easy to set up patterned shading -- unless you filter your data. This slick workaround prevents the filter from disrupting your shading scheme.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // May 2010

    10 steps to adding a drop-down menu to a PowerPoint presentation

    With a little animation sleight of hand, you can create a menu that allows viewers to navigate a self-running slide show.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // May 2010

    10 steps to building a custom toolbar in Word

    This quick tutorial steps through the process of creating a Word toolbar to consolidate particular commands or execute specialized tasks.This download is also available as an entry in our Microsoft Office blog.

    Provided By Susan Harkins

  • Downloads // Mar 2010

    10 steps to creating a numbered heading style in Word

    If you want to incorporate automatic numbering in your document headings, the quickest and most foolproof route is to create a custom style.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Mar 2010

    10 steps to beating Excel's character limit for headers and footers

    Excel restricts the amount of text you can place into its headers and footers. Here's a quick way to outfox it.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Jan 2010

    Build a simple timesheet in Excel

    Excel makes it easy to set up a system for tracking time. This download includes a PDF explaining the steps (also available as an entry in our Microsoft Office blog) and a sample timesheet you can customize to fit your needs.

    Provided By Susan Harkins

  • Downloads // Oct 2009

    10+ reasons to split an Access database

    Splitting your Access database offers numerous advantages, including increased flexibility, security, efficiency, and scalability.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Oct 2009

    10+ tips for working In Outlook's Calendar view

    Outlook offers numerous calendaring features -- more than a lot of users know about. These pointers will help you tap into the most useful Outlook functionality.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Aug 2009

    10 ways to reference Excel workbooks and sheets using VBA

    Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Jan 2010

    Build a simple timesheet in Excel

    Excel makes it easy to set up a system for tracking time. This download includes a PDF explaining the steps (also available as an entry in our Microsoft Office blog) and a sample timesheet you can customize to fit your needs.

    Provided By Susan Harkins

  • Downloads // Sep 2009

    10 ways to recover a corrupted Excel workbook

    When an Excel file goes haywire, don't give up hope. Using one of these recovery tricks, you may still be able to salvage the data.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Sep 2010

    10 steps to setting up page numbering in Word sections

    If you've ever been outfoxed by Word's page numbering options in a multiple-section document, here's good news: Controlling how the pages in each section are numbered is actually pretty easy. Susan Harkins demystifies this Word feature.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Mar 2010

    10 steps to creating a numbered heading style in Word

    If you want to incorporate automatic numbering in your document headings, the quickest and most foolproof route is to create a custom style.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Oct 2008

    Quickly export Outlook e-mail items to Excel

    Exporting e-mail messages from Outlook to Excel is easier than you might think. This technique uses sample VBA code to automate the process, allowing you to specify exactly which fields to copy.This download is also available as an entry in our Microsoft Office blog.

    Provided By Susan Harkins

  • Downloads // Jan 2007

    10 tips for using wildcard characters in Microsoft Access criteria expressions

    Wildcards come in handy when you need to locate records with similar data or you're trying to track down a specific record based on limited information. But if you don't use the right wildcard characters the right way, you could wind up with the wrong data--a potentially app-corrupting nightmare. Access...

    Provided By Susan Harkins

  • Downloads // Feb 2009

    10 tips for securing a Microsoft Access database

    A few best practices can go a long way toward protecting your Access data from careless or overly curious users. Here are some simple ways to add a few layers of security to a database.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Jan 2008

    How do I... Calculate a conditional running total in Excel?

    Running totals are used to update totals within a series in Microsoft Excel. For instance, you might use a running total to track an account balance, enrolling students, or even inventory. Usually, a simple expression that adds the previous total to the latest value does the trick. Susan Harkins shows...

    Provided By Susan Harkins

  • Downloads // Jul 2008

    How do I... Reseed a SQL Server identity column?

    Microsoft SQL Server's identity column generates sequential values for new records using a seed value. You can control the column's first and subsequent values, by specifying those values when you create the column. The good news is that seeding and reseeding an identity column is easy and relatively safe, if...

    Provided By Susan Harkins

  • Downloads // Feb 2011

    10 easy ways to speed up an Access database

    Even your least technical Access users can improve the performance of their databases. Susan Harkins shares some basic tips those users can put to work right away.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Apr 2011

    10 cool add-ins for Office 2007 and 2010

    Add-ins let you enhance your Office apps so they can do more things -- and do things better. Susan Harkins combed through the vast sea of Office add-ins to produce this list of winners.This download is also available as an entry in our 10 Things blog and as a...

    Provided By Susan Harkins

  • Downloads // Feb 2008

    How do I... Add items to an Access combo box on the fly?

    On occasion, an application developer working with Microsoft Access may need a list control that's a bit more flexible by allowing users to update the control's list. Handing over a bit of control, in the right circumstances, can be helpful for everyone, including you. Susan Sales Harkins shows you how...

    Provided By Susan Harkins

  • Downloads // Nov 2008

    10+ ways to find out someone's e-mail address

    It would be nice if you could just pull out a directory and look up the e-mail address of anyone you wanted to contact. Unfortunately, a bit more resourcefulness is required. Here's an assortment of strategies to try when you can't seem to run down an e-mail address you need.This...

    Provided By Susan Harkins

  • Downloads // Feb 2007

    How do I... Print a single Microsoft Access record in Form View?

    Microsoft Access lets users print data while browsing records in Form View, but it prints all of the records in the underlying recordset, not just the current one. By adding a command button, you can give users an easy, one-click tool for printing only the current record. Access expert Susan...

    Provided By Susan Harkins

  • Downloads // Feb 2009

    Use Excel's built-in features to simplify data entry

    Entering data into a worksheet can be time-consuming, and mistakes often find their way in -- but with the right tools, both speed and accuracy can be improved. Here's a look at several Excel features that facilitate data entry.This download is also available as an entry in our Microsoft...

    Provided By Susan Harkins

  • Downloads // Jul 2008

    Create a custom letterhead template in Word

    Printing your own stationery can save you significant bucks -- you can print on an as-needed basis and make changes whenever you want without incurring any charges. Susan Harkins explains what you need to know to create your own letterhead and includes a sample template to illustrate the process.This download...

    Provided By Susan Harkins

  • Downloads // Mar 2010

    10 steps to beating Excel's character limit for headers and footers

    Excel restricts the amount of text you can place into its headers and footers. Here's a quick way to outfox it.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // May 2010

    10 steps to adding a drop-down menu to a PowerPoint presentation

    With a little animation sleight of hand, you can create a menu that allows viewers to navigate a self-running slide show.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Nov 2008

    Add a looping introduction to a PowerPoint presentation

    You can set up your slideshows to include a little preview presentation that will help prime your audience for the main event. Susan Harkins demonstrates this simple but highly effective technique.This download is also available as an entry in our Microsoft Office blog.

    Provided By Susan Harkins

  • Downloads // Apr 2011

    10 power tricks for using Word field switches

    With the right combination of fields and switches, you can build expressions that perform calculations, insert text, apply complex formatting, and take the dog for a walk (almost).This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Sep 2009

    Avoid import glitches when bringing Excel data into Access

    Importing data from Excel to Access can be somewhat dicey. These pointers will help you prepare your data and sidestep common import problems.This download is also available as an entry in our Microsoft Office blog.

    Provided By Susan Harkins

  • Downloads // Aug 2007

    How do I... Dynamically fill Microsoft Word fields using Access data?

    Each Microsoft Office application specializes in a specific job. Word lets you create and edit documents and Excel analyzes your data. Storing data is Access' claim to fame. Fortunately, Office applications share data easily. Perhaps you want to filter Access data based on the contents of a Word field. That...

    Provided By Susan Harkins

  • Downloads // Jun 2008

    10+ mistakes to avoid when using VBA Recordset objects

    As an Access developer or power user, you won't get far if you can't work with the Recordset object. But it's easy to go astray, and even the most seasoned experts make mistakes. Susan Harkins explains 12 common Recordset pitfalls you can anticipate and avoid.This download is also available as...

    Provided By Susan Harkins

  • Downloads // Dec 2008

    10+ basic Microsoft Outlook support issues

    Outlook offers a number of benefits, but it tends to throw the occasional obstacle in your path. Armed with the right information and a few tricks, you can smooth the way for your Outlook users -- and for yourself. This download is also available as an entry in...

    Provided By Susan Harkins

  • Downloads // Dec 2008

    Use PowerPoint's advanced animation to imply growth or movement

    You can make your PowerPoint presentations far more engaging with a little animation sleight of hand. Susan Harkins walks through the process and shares a sample presentation to demonstrate the results.The instructions in this download are also available as an entry in our Microsoft Office blog.

    Provided By Susan Harkins

  • Downloads // Mar 2008

    10 reasons to explicitly convert SQL Server data types

    SQL Server converts data types in two ways -- the way it wants to and the way you tell it to. Most implicit conversions work the way you expect. It's those surprise conversions that cause trouble. Unless you know exactly how SQL Server converts a data type, it's a good...

    Provided By Susan Harkins

  • Downloads // May 2008

    10+ common questions about SQL Server data types

    SQL Server has a variety of data types, and as with most things, the more options you have, the more confusing a choice can be. Susan Harkins offers answers to the questions she hears most often about using SQL Server data types.This download is also available as an entry...

    Provided By Susan Harkins

  • Downloads // Jul 2009

    Automatically close all the open forms and reports in an Access database

    Before closing a database, it's a good idea to close all the open objects - but you can't be sure your users will always do it. Luckily, you can have Access execute a simple cleanup routine to handle the task.This download is also available as an entry in our...

    Provided By Susan Harkins

  • Downloads // Mar 2011

    10 ways to keep your messages out of spam filters

    Legitimate messages that get snagged by spam filters can lead to big problems -- such as derailed job searches, hard feelings, and lost business. These tips will help ensure that your messages reach their intended targets.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Mar 2011

    10 tips for choosing between a surrogate and natural primary key

    The superiority of surrogate versus natural keys is a hotly debated topic among database developers. Susan Harkins offers some insights into when -- and why -- you might choose one over the other.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Mar 2011

    Five tips for efficient file management in Windows 7

    Share these tips with Windows 7 newbies to reduce initial confusion and help them get up to speed quickly.This download is also available as an entry in our Five Tips blog.

    Provided By Susan Harkins

  • Downloads // Sep 2008

    Generate a descending-order numbered list in Word

    Word can't automatically produce a numbered list that counts down instead of up. But with the help of a bookmark and some fields, you can work around that limitation.This download is also available as an entry in our Microsoft Office blog.

    Provided By Susan Harkins

  • Downloads // Mar 2008

    How do I... Add music and narration to a PowerPoint presentation?

    Sound effects, such as music and voice recordings, can mean the difference between a good presentation and an outstanding presentation. Luckily, PowerPoint supports media clips, which include sound and video files. Susan Sales Harkins explains how to use sound to enhance your presentations. This download is also available as an...

    Provided By Susan Harkins

  • Downloads // Apr 2008

    10 ways to prevent Access database corruption

    Nothing frustrates Access users like a corrupted database. With a little know-how, you might get lucky enough to repair the database or at least recover the data. Sometimes, a third-party product that specializes in recovering data can help. But you might just end up rebuilding and re-entering data. (Or rather,...

    Provided By Susan Harkins

  • Downloads // Oct 2008

    10 ways to convince your boss to let you work from home

    There may be dozens of reasons why telecommuting makes sense for you. But to make your case with management, you need a list of reasons that make sense for the business. Here are some well-supported arguments that demonstrate the benefits your company will gain when you work at home.This download...

    Provided By Susan Harkins

  • Downloads // Jun 2010

    10 steps to shading alternate rows in a filtered worksheet

    Excel makes it easy to set up patterned shading -- unless you filter your data. This slick workaround prevents the filter from disrupting your shading scheme.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Feb 2009

    Working more efficiently with Word 2007's new building blocks

    With Word 2007's building blocks, you can assemble consistently formatted documents in a snap. Susan Harkins explains how to use built-in elements, such as headers, footers, and cover pages, and how to create, reuse, and share your own building blocks.This download is also available as an entry in our...

    Provided By Susan Harkins

  • Downloads // Mar 2011

    Five tips for enhancing Excel charts

    With a few simple tweaks, you can make your Excel charts easier to interpret and convey data in a more compelling and meaningful way.This download is also available as an entry in our Five Tips blog.

    Provided By Susan Harkins

  • Downloads // Feb 2009

    How to print multiple labels for a single record in Access

    Label printing is often more complex than generating a single label for each record. Users might need one label for multiple records or multiple labels for one record -- or something in between. Susan Harkins offers a VBA alternative that's more flexible than the Access wizard.This article portion of this...

    Provided By Susan Harkins