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 + YCTRL + 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!



QuickBooks: QuickMath Calculator

Have you ever needed to quickly add figures in QuickBooks? Click here to read an easy QuickBooks tutorial to find out how. If you prefer videos, click on the video in my earlier post below.

QuickBooks Tutorial - Calculator Tip

I've had many QuickBooks users ask for tips to help them in their day to day financials using QuickBooks. This one will save time and frustration. Did you know that QuickBooks has a built-in Calculator? Watch this video to see where to find it.

Excel 2003 Tutorial - Sum and Percentage Formulas

In this Excel 2003 Tutorial – Sum and Percentage Formulas introductory video, Go Ask Debbie teaches simple ways to use the Excel 2003 to create Sum and Percentage Formulas Sum and Percentage.

Most Popular