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

    10+ tips for combating Computer Vision Syndrome

    Recent studies indicate that those who spend even a few hours a day working on a computer could suffer significant vision problems. Susan Harkins offers an overview of symptoms and causes and then shares some practical suggestions for reducing eyestrain.This download is also available as an entry...

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

    10 ways to get more mileage from your Office hyperlinks

    Hyperlinks are now a standard fixture in Office documents, but many users don't know much beyond how to click on them. Susan Harkins has rounded up an assortment of tweaks for fine-tuning the behavior of hyperlinks and using them for specialized tasks.This download is also available as an entry...

    Provided By Susan Harkins

  • Downloads // Oct 2008

    How to list the primary key columns in an Access table

    You can get a list of the columns in a primary key manually, but depending on the task, you may want to handle it programmatically instead. Susan Harkins shares a VBA function that uses ADOX objects to obtain the column information.This download is also available as an entry in...

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

  • Downloads // Aug 2009

    10+ ways to avoid drawing layer headaches in Word

    Word offers some decent drawing tools, but they don't always give you the results you expect. Susan Harkins unravels some of Word's drawing layer mysteries.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // Oct 2008

    10+ ways to help your users transition to Outlook 2007

    Unlike the other Office 2007 apps, the Outlook 2007 interface isn't likely to throw users into a panic. But you'll still need to help them get up to speed with new features and show them how to take advantage of various improvements.This download is also available as an entry...

    Provided By Susan Harkins

  • Downloads // Oct 2008

    Log errors in Microsoft Access with a simple function

    If you Google "error logging in Microsoft Access," you'll find a number of complex solutions. The process doesn't have to that difficult. Most of us need only a simple function to log specific information about the current error. This download includes a demonstration database and a several .bas module files...

    Provided By Susan Harkins

  • Downloads // Apr 2009

    10+ ways to keep your Access database in tiptop shape

    A sluggish database can cost your money and waste users' time. Here are some maintenance tasks and general best practices to ensure your database is healthy and operating at peak efficiency.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins

  • Downloads // May 2009

    How to publish a PowerPoint presentation to the Web

    Putting a presentation on your Web site isn't terribly complicated -- but browser differences can pose a big gotcha. Here's a look at the publication process and the hurdles you may encounter.This download is also available as an entry in our Microsoft Office blog.

    Provided By Susan Harkins

  • Downloads // Aug 2009

    37 keyboard shortcuts for moving faster in the Visual Basic Editor

    The Visual Basic Editor (VBE) is the development environment in the Microsoft Office applications. These keyboard shortcuts will help you work more efficiently while entering, viewing, and editing code.This download is also available as an entry in our Microsoft Office blog.

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

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

    Keep supporting details handy for your PowerPoint presentations

    When someone raises a question during your presentation, you can try to wing it -- or you can smoothly bring up an ancillary slide that clarifies the issue. Having a few extra slides up your sleeve can make all the difference in the success of your delivery.This download is also...

    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 // 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 // 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 // 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 // Feb 2009

    10+ IT pros share the utilities and tools they can't live without

    One way to make your job a little easier is to find out which tools other IT pros rely on -- and then try them out for yourself. Susan Harkins extracted a list of favorite tools from 13 IT pros, whose roles range from consultant to developer to net admin...

    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 // 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 // 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 // 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 // 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 // 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 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 // 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 // Mar 2009

    10+ Microsoft Office add-ins to simplify your work

    The right add-in can provide helpful features and make existing Office capabilities easier to use. Susan Harkins has rounded up a selection of handy add-ins for various Office applications.This download is also available as an entry in our 10 Things blog.

    Provided By Susan Harkins