Category Archives: Excel Tips

Working with Data in Excel Part 2: Fine Techniques for Excel Lists, Drop Downs and Data Validation

In Part 2 of this series we’ll look at Excel lists, drop downs and data validation. These are very important areas of Excel that you should master if you want to take your Excel skills to the next level. If you missed Part 1 you can read it here: Working with Data in Excel Part…

Working with Data in Excel Part 1: 10 Excel Data Entry Tips Everyone Should Know

In this article we’ll look at data entry and I’ll show you some important tips and shortcuts that everyone using Excel should learn. You’ll find these data entry tips handy whether you work with short to-do lists, stacks of survey results or a prolific pile of personnel data. I will focus on four specific areas:…

Learn how to become an Excel Power User with our Top 20 Mouse Tricks for Excel

Tricks in Excel – everyone should learn some. I’ve used Excel for over 10 years and some of the coolest tricks I know are the simplest to learn. Little tricks can help you become a more powerful Excel user as they simplify and speed up your work. And there’s a delicious range of mouse tricks…

The Ultimate Guide to Bullet Points in Excel

Would you like to know how to insert a bullet point in Excel? For a long time I thought there was only one way to do this – type a lower-case letter “l” in the font Wingdings to insert a round bullet point character. But now I know that Excel is such a versatile bit…

The Little Known Secrets of Adding Watermarks in Excel 2010

Many people ask the question “How can I add a watermark to Excel?” You know the kind of thing I mean if you’ve ever seen printouts marked “Secret” or “Confidential” or “Draft” in big bold letters splashed on every page at a 45 degree angle. Microsoft’s online help explains that “Watermark functionality is not available…

Give your Spreadsheets the Festive Makeover with a custom Background in Excel

Have you ever been secretly bored with the standard Excel grid? With its hundreds and thousands of empty cells staring right back at you? Did you know there is a way to change your Excel background and brighten up your day! I’ll show you two ways that you can use right now to change the…

Excel Keyboard and Mouse Combos Part 3 (Accelerator Keys)

In part 2 of this series we looked at how you can use the keyboard and mouse together to move, copy and insert the cells you selected. In this third article I am going to show you how to use the right mouse button together with keyboard accelerator keys to speed up your workflow.

Excel Keyboard and Mouse Combos Part 2 (Move, Copy, Insert)

In part 1 of this series I showed how you can use the keyboard and mouse together to select ranges and bring up the research pane. In this second article I am going to explain ways to use the keyboard and mouse together to move, copy and shift cells around a workbook by dragging the…

Pivot Table Tutorial: How to flatten a cross tab table

When you have a cross tab table you might want to flatten it to make it easier to analyze. Here is a 3 minute video to show you how to do this using Excel’s pivot table wizard to import multiple consolidation ranges. I also show you how to add the pivot table wizard to your…

Excel Keyboard and Mouse Combos Part 1 (Ctrl, Shift, Alt)

In a previous article I showed how it was possible to use the keyboard and mouse together as this can lead to increased productivity. And who in today’s world of work doesn’t want to be more productive? In this article series I am going to expand on ways to use the keyboard and mouse together…