Author Archives: JD Sartain

Microsoft Excel: Why your spreadsheet is so slow

When your Microsoft Excel spreadsheet slows to a crawl, you can’t help but notice. It may take longer to open and save your files, longer for Excel to calculate your formulas, and longer for the screen to refresh after entering data, or sorting an… Continue reading

Comments Off on Microsoft Excel: Why your spreadsheet is so slow

Excel: How to create simple and dependent drop-down lists

Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field. This is especially useful for fields that require specific information; fields that have long or co… Continue reading

Comments Off on Excel: How to create simple and dependent drop-down lists

10 pro tips for creating Excel macros

Excel macros save you time and headaches by automating common, repetitive tasks, and you don’t have to be a programmer or know Visual Basic Applications (VBA) to write one. With Excel, it’s as simple as recording your keystrokes. Use these tips … Continue reading

Comments Off on 10 pro tips for creating Excel macros

Photoshop tips to boost your skills: Scratch Disk, Image Fill, Masks, Brushes, Vignettes

When you’re ready to boost your Adobe Photoshop skills, try one of these features to work some magic with your images. We start with what to do when your Scratch Disk fills up, then dive right into tips for getting started with Content-Aware Fill, C… Continue reading

Comments Off on Photoshop tips to boost your skills: Scratch Disk, Image Fill, Masks, Brushes, Vignettes