Susan Harkins

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

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

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

    How do I... Pass data over a network using disconnected recordsets?

    Retrieving data across a busy network can put a real cramp in your networking performance. Dragging only the data you actually need and only when you need it is the key to working efficiently across a network, but there's more. In Microsoft Access, you can also retrieve data using 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 // 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 // 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 // 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 // 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 // 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 // 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 // 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 // Apr 2007

    10 simple tips for working more efficiently in Microsoft Excel

    Excel is a highly sophisticated application, and users don't always discover the easiest or smartest way to accomplish various tasks. This list of tips will help them shave significant time off some of the most common spreadsheet chores. Susan Harkins shares a number of efficiency-boosters, such as taking advantage of...

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

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

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

    10 commands you may want to add to the Office 2007 Quick Access Toolbar

    If the Office 2007 Ribbon has you pulling your hair out, a little customization may ease the pain. Susan Harkins explains how to put your frequently needed or hard to find items on the Quick Access Toolbar for, well, quick access.This download is also available as an entry in...

    Provided By Susan Harkins

  • Downloads // Jan 2009

    10+ air travel tips for IT pros

    Flying has become trickier than it once was -- especially if you're packing a laptop and other electronic gadgetry. Here's some basic advice, along with a few pointers for traveling techs, to help make the trip go as smoothly as possible.This download is also available as an entry in...

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