Excel Formulas: Sum and Percentages

I just updated my most popular YouTube Video Course - Excel Formulas: Sum and Percentages.

If it's been a while since you've viewed it, it's worth the few minutes.

If you haven't viewed it and need assistance with the Sum and Percentage Formulas in Excel, please enjoy watching it.

Thanks,

Debbie

Organize Your Communications

Are people often confused by your Emails? Do people not read your Emails? If you write poorly, it can confuse readers and they often won't read them.

Organizing the key points for your communication is helpful in two ways: it helps you put key points in a logical order for your readers and reduces your writing time because you can keep focused on your key points. Two strategies that you can use to organize your key points are ranking and planning worksheets.

This brief tutorial teaches you how to use Ranking and Planning Worksheets to organize your communications.

For more tips like this plus MUCH more, check out my course on Udemy, now only $12 (87% off!) Full course includes 1+ hour of content and downloadable resources, 1-on-1 instructor support and a 100% money-back guarantee. Sign up today!

Go Ask Debbie now available on Udemy

I published my Written Communications course on an online learning site called Udemy. The site makes it really easy and fun to learn new things, and there’s even a mobile app for my course, so you can watch it on the go.

Definitely take a minute and check out my course trailer video here: Written Communications Course and see if you think it’s something you’d want to take in your free time. You can use that same link using the Promo Code "SEPT12" to get an 87% discount on the course if you’re ready to dive in. That's just $12 for the entire course! And of course, feel free to share with your friends who would be excited about a lesson in Written Communications. Hope you like it! Regards, Debbie

Udemy Written Communications course $12 coupon rate

Excel Styles and Themes

In Excel, it is easy to just type numbers for a boring looking spreadsheet. But, did you know you can apply styles and themes similar to PowerPoint?

Here's a brief tutorial how to do just that.

Microsoft Office Quick Access Toolbar

If you've been using Microsoft Office 1007 or 2010, you may have seen the Quick Access Toolbar and not known what it was.  Or you may be missing the old Microsoft Office Standard Toolbar.

Either way, this Microsoft Office Tutorial is for you.

To learn to customize the Microsoft Office Quick Access Toolbar in 2007 or 2010, watch the video below.

Enjoy!

Keyboard Shortcuts

With 2014 just around the corner, I know most people could make 2014 much better by learning some simple Keyboard Shortcuts.

I've given tips for keyboard shortcuts before, but here are some easy to use keyboard functions which help make tasks that much quicker.

We've all heard of CTRL + X to Cut, CTRL + C to Copy, CTRL + V to Paste, but do you know about CTRL + Z and CTRL + Y?  CTRL + Z will Undo the previous action and CTRL + Y will Redo the previous Undo.

When browsing an Internet page, not only can you use the Page Down to move down a page, but sometimes it might be easier to just press the Space Bar. That's right, you can move down an Internet page by simply pressing the Space Bar.

And, here's an old-school keyboard shortcut that came in handy when a friend's mouse died. To open up the File Menu, press ALT + F.

To review:
CTRL + Y will Redo an Undo
Space Bar will move a page down on an Internet page
ALT + F will open the File Menu

I hope these keyboard shortcuts will help you in 2014 and hope that everyone has a Happy New Year!

Excel Tip: Sheet Types

For those of you who use Excel, I'm always trying to show tips that are helpful and fun at the same time.  Did you know Excel has built-in Sheet Types?  This short video will show you this fun Excel Tip.

Enjoy!