Excel Headings in Detail
THE BAR
This is the bar you will see immediately above all the little icons of your spreadsheet and the following detailed explanation of each will help you to further understanding the great capabilities present in an Excel Spreadsheet.
Under the Heading File
The most used items are – New; Open; Save; Save As; Print Preview; Print.
These items are self-explanatory as they are used in almost every other program.
Under the Heading Edit
The most used items here are – Undo; Cut; Copy; Paste. These also are self-explanatory. However, there is also Paste Special under that heading, wherein amounts copied can be pasted exactly as seen without their formulas factored in. Another item under Edit is Office Clipboard which could be useful. See the
following screenshot.
Posted in Spreadsheets
Tagged 3 important headings, excel headings, headings broken down
Explanation Of The Spreadsheet – 7 tips
The above screenshot is the first one you see when you begin a new spreadsheet. Here are 7 points about this program.
- Excel spreadsheets are comprised of cells. Each square you see is a cell.
- The cells are contained within rows and columns.
- The columns can be expanded to any width you need. For example; after typing in a heading under A1 bring your cursor up to the right of A until you see this symbol † then double click and the column will automatically expand to the exact width needed.
- The size of a row of cells can be determined by the font size. If you use a large font all the cells in that row will expand to accommodate the size needed.
- You can change the color of your font by clicking on the large A with the colored underline that you will see at the far right heading.
When you click on the large A a color chart will appear from which you
choose your desired font color.
Posted in Budgeting, Spreadsheets
Tagged excel spreadsheets, spreadsheet lessons, tips for using excel
Does Time Equal Money?
Time really does equal money. When you are an internet entrepreneur you need to ask yourself what the best use of your time really is because it is your time that equals money. The health of your bottom line is directly affected by the way that you choose to allot your working hours.
First let’s discuss what your job really is as an internet entrepreneur. Your job is to grow your business. Your job is to make those contacts that will make you money. Your job is to conceive ideas and bring them to fruition. Your job is to close that deal! You do agree with that description of your job duties as an internet entrepreneur, don’t you?
Okay! Now let’s discuss what your job as an internet entrepreneur is NOT. Being an internet entrepreneur does not qualify you as an accountant, an advertising guru or a writer. You aren’t qualified to be an event planner or a travel agent. When you decided to become an internet entrepreneur that did not automatically make you a ‘jack-of-all-trades’. I have a background in accounting and I can tell you that many hours can be spent “working on the books”. Of course there are programs that can help with this and save you a lot of time such as QuickBooks, which I highly recommend.
However, you can waste a lot of your valuable time on tasks that you just plain aren’t very good at. You are the idea man/woman. It IS your job to make your business grow and you’ll be good at that provided that is where you use your time and direct your energies.
If you insist upon doing everything yourself, whether you are good at it or not, you will use up all of your thought and energy and have nothing left to do the things that only YOU can do to make your business grow. There is a learning curve in all of this, so if you are just starting out you need to study the best ways in which to grow your business.
There are only just so many hours in a day and you can only spend just so many of those hours working at making your online business successful. There IS still life outside of business.
You have friends and family that do require some measure of your time. That makes it even more vital that you use your time to make your business grow and not waste your time by doing the everyday tasks that can take so much of your valuable time.
Think outsourcing!
Visit KDB business Services for all your outsourcing.
Posted in Time & Money
Tagged allot your working hours, internet entrepreneur, time & money
Bookkeeping Tips
Linking between journal entries and the general ledger
When examining the financial books of a company, the direct mapping between the journal entries and the ledger postings will be quite noticeable.
While the posting of journalized transactions in the general ledger at first may appear to be redundant because the transactions already are recorded in the general journal, the general ledger does serve an important function: It allows one to view the activity and balance of each account at a glance.
Because the posting to the ledger is simply a rearrangement of information requiring no additional decisions, it easily is performed by accounting software, such as Quick Books, either when the journal entry is made or as a batch process, for example, at the end of the week or month. Continue reading
Clever Coupon Cutting Strategies
Coupons are there for you to reap the benefits of a generous
manufacturer who wants you to try their product. Those who
don’t use them may be missing out on hundreds of dollars or
more a year in savings. Here are some strategies to get the
most from those newspaper cut-outs.
The Sunday paper is usually chock-full of advertisements for
new foods or household products. At the bottom of those ads
is a coupon to help you save money the first time you buy.
Sounds good, right? So why do so many people avoid using
coupons?
It could be embarrassment. But, using coupons is not a sign
of poverty or too much frugality. It saves money and we can
all use that. Manufacturers get tax breaks on their business
when they perform promotions like this. You might as well
take advantage of it.
Never used a coupon? Here are some ways to help you use
them to their full potential. Continue reading
Posted in Budgeting
Free Guide – Take This Product & Website Creation Survey
I really enjoy creating products, such as ebooks and I also am interested in building websites for others.
Please take a short six question survey to help me understand the desires of my website visitors so that they can be implemented for you.
After you complete the survey you will receive a complimentary copy of either my QuickBooks Guide or my Excel Spreadsheets Tutorial.
The last question in the survey will point out your desire.
I sincerely hope you enjoy taking this short survey and you will make good use of your free gift.
Eleanor McCallum
PS Another cool benefit from taking this survey is a chance to create your very own survey for your website or blog.
Posted in Bookkeeping & Accounting, Websites
Tagged choose a free guide, taking surveys
How to Create a Family Budget
For singles, creating a budget is relatively easy. They tend to have a good handle on how much money they have coming in, and when tracking expenses, they only have their own to think about. But creating a family budget is a whole new ball game.
Most families have multiple sources of income. And when there are multiple spenders, that makes things much more confusing. This is one of the main reasons that families lack a formal budget. But having a budget and sticking to it can greatly improve a family’s financial outlook.
Making a family budget may be tricky, but it can be done. Here’s how.
1. Take inventory of all income. If a certain source of income fluctuates from month to month, use the lowest amount or average it out.
2. Keep track of all expenses for a month or so. Keep all of your receipts, and ask all family members to turn theirs in to you each day.
3. Add up your monthly expenses. Be sure to include bills, debt payments, groceries, and everyday expenses such as lunch money and transportation costs.
4. Get the family together and discuss ways you can trim the budget. Getting input from other family members will help you determine which expenses are necessary and which ones could be cut down or eliminated. Maybe you or your spouse could start taking lunch to work instead of eating out, or maybe the kids can drop an extracurricular activity.
5. In addition to individual expenses, discuss how you can cut down on the electric bill, groceries and other necessary family expenses. Consider such things as carpooling or taking public transportation, buying more generic foods and adjusting the thermostat.
6. Estimate how much you can save on regular expenses, and cut the completely unnecessary items out of the budget. Then refigure it and see where you stand.
7. If you end up with a surplus, allocate a portion of it to savings. If you’re in the red, go back and rework the budget until you have more income than expenses.
Continue reading
Posted in Budgeting
