Best Keyboard Shortcut Alternative. No Memory Required.

If you want to switch it up a bit in 2014 by using less mouse clicks and more keyboard shortcuts, I have a great trick for you. Keyboard shortcuts are fast but speed is not everyone’s main objective, so for many of us memorizing keyboard shortcuts is not a priority. On the other end of the spectrum, there are keyboard shortcut wizards, with their fingers flying across the keyboard performing tasks at the speed of light.  [Alt]-ernative to memorizing shortcuts

Continue Reading

Excel Custom Time Formatting

excel formatting how to

How-To In order to create a custom number format, you’ll need to access the Format Cells window. Once there, choose the “Custom” option from the left hand side. Under the word “Type” you’ll be typing in your custom number format. How to Type the Format Customizing time works a lot like customizing dates. However Excel rolls over the clock after 23 hours, so we’ll need to circumvent that. Let’s start with the basic characters. Formatting Characters Hours, Minutes, Seconds Put

Continue Reading

Excel Custom Date Formatting

Most of us at some point have tried to find a particular number format, but we weren’t able to find one that satisfies our needs. There will be another blog to follow this one that specifically deals with time, this one is just about dates. How-To In order to create a custom number format, you’ll need to access the Format Cells window. Once there, choose the “Custom” option from the left hand side. Under the word “Type” you’ll be typing in

Continue Reading

Excel’s Advanced Error Codes – “Why isn’t this working?!”

We’ve all seen Microsoft Excel error codes, and you’ve probably already figured what some of them mean. But when we get into more advanced Excel usage, the error codes we encounter can still be vexing. Understanding the following error codes will promote you to Excel’s Power User status! Excel TIP: Use the Formula tab’s Formula auditing tools to track error issues. We’re going to be using some of them here. #N/A Excel is saying “That lookup value isn’t valid” This usually happens

Continue Reading

Excel Custom Number Formatting Basics

Most of us at some point have tried to find a particular number format in Microsoft Excel , but we weren’t able to find one that satisfies our needs. We will have  other blogs to follow, which will cover date and time, and positive and negative numbers, but for now we’re just going to cover the easiest, fastest ways to customize a number format. How-To In order to create a custom number format, you’ll need to access the Format Cells window. Once

Continue Reading

Sliding Sidebar

Archives