|
|
 |
Microsoft Excel Shortcut Keys
Darrel Hawes
Here is a comprehensive list of Microsoft Excel keyboard shortcuts. These can save you a lot of time. There are a few that I use every time I open Excel. My advice: find the functions you use the most, then find the shortcuts for those functions. . . . keep reading
|
Open Excel Files Without Excel
Darrel Hawes
There are many times when you may need to open Microsoft Excel files when you don't have Excel loaded on your computer. Here are three options that I use. . . . keep reading
|
Excel Nested If-Then Formulas
Darrel Hawes
On a recent Excel online users group, one user expressed frustration that on a time card spreadsheet application, he wasn't able to create a formula that would distinguish between straight time, time and a half, and double time, and do the calculation properly. The answer is easier than he probably realized, and this video shows how to do it. . . . keep reading
|
Excel Functions Made Easy
Stephen Nelson
Excel provides several hundred prebuilt formulas, called functions, that provide a shortcut to constructing complicated or lengthy formulas. In general, a function accepts input values, or arguments, then makes some calculation and returns a result. . . . keep reading
|
Cash Flow Budgeting Spreadsheet
Darrel Hawes
I created this spreadsheet to make it easy to do simple cash flow projections for your business and personal affairs. I also include four short instruction videos to explain how to use it. . . . keep reading
|
Basic Excel Tricks
Darrel Hawes
Sometimes we spreadsheet geeks forget that not everyone knows the basics of how to use Excel. Check out these five tips that I use almost everyday. . . . keep reading
|
Excel Header and Footer "Data Codes"
Darrel Hawes
Using these data codes in the header or footer of your Excel spreadsheet can make for a professional looking document. Give them a try and see if they spruce up your work, especially if you distribute the spreadsheets to banks or other parties (partners, investors, etc). . . . keep reading
|
Dating Tricks With Excel
by Darrel Hawes
The subject of this article is "dates", as in calendar dates. Formatting Dates You can format your dates in many different pre-set formats by choosing Format-Cells-Dates. Many people . . . keep reading
|
|
|
|
|
 |
|
|
|
 |
What form of business are you using?
|
|
|
|
|
|
| | |
|
 |
|
|
|
Accounting Explained
