Susan Harkins

Displaying 1-40 of 92 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 // 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 // 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 // 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 // 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 // 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 // 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 // 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 // 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 // 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 // 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

  • 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

  • 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

  • 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 // 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

  • 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 // 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 // Apr 2009

    Avoid costly errors by verifying cross-foot results in Excel

    Cross-footing can help keep your worksheet healthy, but comparing subtotals can only go so far. See how a simple IF function can alert you to problems with your data.This download is also available as an entry in our Microsoft Office blog.

    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 // Jun 2007

    How do I... fill Word form fields with Access data?

    Filling a Word form with Access data can be useful when you need to use Word's formatting features to present that data in just the right way. Fortunately, the process is simple, whether sharing one record or thousands. Access expert Susan Harkins walks through this technique and provides the VBA...

    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 // Jan 2008

    How do I... Transfer data from a Word form to an Access database?

    Although Access forms are powerful interface objects, your users might not be familiar with them. However, your users may be very familiar with Word forms. Susan Sales Harkins shows you how to use a Word form to collect data and then transfer that data to an Access table. The technique...

    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 // 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 // Aug 2007

    How do I... Export Outlook e-mail messages to Access using VBA?

    Exporting Outlook folders and their contents is a simple enough task most of the time. The Import And Export wizard handles the process nicely. But as easy as it is to use, the wizard is a one-time deal. You can't append records to an existing file using the wizard. So...

    Provided By Susan Harkins

  • Downloads // Mar 2008

    10+ things you should do before building a custom Access database

    Whether you take on freelance work or you support your organization's IT needs by developing custom database solutions, you must build an efficient, easy-to-use database if you plan to stay employed. Access expert Susan Harkins explains some measures you can take before you build a custom database to make sure...

    Provided By Susan Harkins

  • Downloads // Apr 2008

    How do I... Avoid e-mail spam using Outlook tools?

    As more and more spam finds your Inbox, it's harder to find legitimate mail. Regrettably, at least from the recipients' point of view, it looks like spam is here to stay. You can't keep spammers from sending you e-mail, but you can make sure you don't ever see it. Susan...

    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 // Apr 2008

    10+ tips for using Word's Track Changes feature for collaborative editing

    Editing is a tough job and not many of us do it well. Most likely, you'll want others to review important letters and reports to suggest changes and catch errors. Thanks to Word's Track Changes feature, keeping up with all those changes and comments is a relatively simple task. Office...

    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 // Aug 2008

    Return to the record you were working on when you reopen an Access form

    If you get interrupted while working on a record in an Access form, finding your way back to it can be time-consuming. Here are two ways to bookmark the current record so that you can hop straight to it when you reopen the form.This download is also available as

    Provided By Susan Harkins

  • Downloads // Jul 2008

    10+ tips for getting the best performance out of your SQL Server data types

    Data integrity and performance are the driving force behind almost every decision you make during the design and development process. Defining appropriate data types is one of the easiest ways to let SQL Server help you help yourself.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Jul 2008

    10+ tips for upsizing an Access database to SQL Server

    When the time comes to migrate your Access database to SQL Server, you could be in for a bumpy ride. These suggestions will help you sidestep problems -- or at least wrestle them into submission.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Aug 2008

    10+ reasons to use Access (and a few reasons not to)

    Microsoft Access may not be the king of databases, but it does offer a number of advantages over solutions like SQL Server and Oracle in certain situations. Access guru Susan Harkins counts the ways.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Aug 2008

    10+ ways to help your users transition to Word 2007

    If you're one Word 2007 support call away from a nervous breakdown, these tips may help. Susan Harkins addresses the most common areas of confusion and offers practical advice for helping users conquer the steep learning curve.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Jul 2008

    10 reasons why IT pros hate Microsoft Access (but really shouldn't)

    Microsoft Access may not be right for all situations, but it does have its place -- at least according to database expert Susan Harkins. Here's her take on some of the more common complaints she's encountered from IT pros who like to kick Access around.This download is also available as...

    Provided By Susan Harkins

  • Downloads // May 2009

    10 ADO best practices

    You can work more efficiently with data when you know how to take advantage of the ActiveX data objects (ADO) library. Susan Harkins offers some pointers that will help you use ADO objects effectively and avoid potential code snafus.This download is also available as an entry in our 10...

    Provided By Susan Harkins

  • Downloads // Aug 2009

    10+ tips for using Word as an XML editor

    XML makes it possible for you to extract, manipulate, store, and reuse data from any number of sources - and Word 2003 and 2007 provide tools for working with XML files. Here are a few pointers that will make the process go more smoothly.This download is also available as

    Provided By Susan Harkins