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

Add 3 Hours to Your Week: Keyboard Shortcuts

“Ugh, it’s taking too long to edit Notes in PowerPoint.  Too much clicking. There must be a better way.”  Time for SHORTCUTS –   Proceed to Notes Viewà Ctrl +Enter, ñ, Ctrl +V, Esc, Esc, ò. Keyboard shortcuts increase productivity by 3 hours per week.  There are shortcuts we use everyday, like cut and paste (Ctrl+C & Ctrl+V).  However, even for quick tasks, referencing a few shortcuts can speed up the work. Here are a few favorite, yet obscure, shortcuts: Ctrl+K: Inserts

Continue Reading

Sliding Sidebar

Archives