If you run your own business, you know how hard it is to keep track of payroll, inventory, customers, and vendors. Guess what? There is an easy way to manage these and other accounting tasks without breaking a sweat! In this first lesson of a beginner QuickBooks course, get an overview of this powerful accounting software and learn just how easy it is to master! Learn to set up a company file, enter critical information, and get ready to use QuickBooks!
Assignment:
A picture’s worth a thousand words, so why not add some to your PowerPoint presentations? Motion Training continues its series on how to use Microsoft Office PowerPoint 2010 by introducing you to inserting photos and Clip Art. Learn how to import your own photo or find Microsoft Clip Art. See how to resize, move, and rotate images without distorting them. Make a picture into your slide’s background, or apply a photo effect such as changing the transparency of a picture in your slideshow.
Assignment:
Want to know how investment analysts crunch the numbers for real, publicly traded companies? Take a look at Subject Money’s tutorial on market values and learn the logic used by Wall Street movers and shakers. From earnings per share to market capitalization and enterprise value, you’ll wade through the jargon with ease.
Assignment:
Did you know that there is a way to pay for medical expenses that actually increases your paychecks? If you make monthly medical loan payments or take expensive prescription drugs, you may benefit from opening a flexible spending account. An FSA increases your take-home pay by allowing you to pay for medical expenses with your own pre-tax money. It can even be used to cover dependent care expenses (like daycare for your child)! Learn how an FSA can help you start saving money today.
Assignment:
Tired of calculating things by hand? This lesson for all versions of Microsoft Excel will show you how to use built in functions to calculate AVERAGE (MEAN), MEDIAN and MODE. In addition you will see how to use a combination of functions to calculate the range from a list of numbers. The worksheet featured in the lesson can be downloaded - just click the paperclip icon at the top right of the lesson player
Assignment:
A budget gives you the “big picture” of your finances—how much income you have coming in, and the total expenses you are paying out. But if you are trying to reduce your debt and become financially responsible, a cash flow projection can help you stay within your budget, and also plan day-to-day spending. In this lesson from Focused Spender, learn the difference between a budget and a cash flow projection, and how they can both help you become financially secure.
Assignment:
Holidays and birthdays often mean expensive travel plans and gifts. If you are working to pay down your debt and are on a strict budget, you may be tempted to call the occasional birthday meal out or housewarming gift an “emergency,” justifying the use of a credit card to make the purchase. Instead of digging yourself deeper in debt, create a “sinking fund”! Learn how to plan all year for expected expenses, so that you don’t find yourself in a financial crisis come the holidays.
Assignment:
Learn to navigate Microsoft Word 2010 with grace and ease! In this third lesson from a series of Microsoft Word tutorials, Motion Training teaches you how to open existing documents and how to scroll through the document with a mouse or keyboard. Learn how use spell check to catch spelling and grammar errors, select and delete sections of text, use the undo and redo features, and search a Microsoft Word document for a specific word or phrase.
Assignment:
Debt is more than just a number. This tutorial by Subject Money runs through some commonly used equations that analysts use to gain a deeper understanding of companies’ debts and how they are leveraged. You will learn a number of ratios—total debt, debt-to-equity and TIE, to name a few—that make it easier to break down any company’s capital structure.
Assignment:
You've learned the basics of navigating Microsoft Office, but how do you create really effective PowerPoint presentations? Motion Training continues his series on PowerPoint 2010 by offering advice on what to take into account when making a good slideshow. See PowerPoint presentation examples, and get a sense of how to tailor your project to your audience and objectives, making your content easy to digest and learning how best to deploy images and graphs.
Assignment:
Why just say something in a powerpoint presentation when you could say it in style? This lesson from Motion Training’s Microsoft Office PowerPoint series explains how to deal with text boxes and WordArt. Learn how to make use of PowerPoint templates, edit font size and type, create fancy text, add bullet points, and generally add a little pizzaz to the words in your slideshow. This lesson includes handy keyboard shortcuts and clear examples of making a PowerPoint presentation.
Assignment:
In your desire to become financially secure, you’ve implemented a budget—and that is an excellent thing. But a budget will not give you a complete snapshot of your finances, so learn how to track your money on a daily basis! Not only will you be reminded when bills are due, but tracking your money also helps you stick to your budget and achieve your financial goals. In this lesson, Focused Spender reviews three tracking options (Mac vs. PC, free vs. paid) to help you find which is right for you.
Assignment:
Need to store, organize, or manipulate data? In this lesson, Amicron explains precisely what is a Microsoft Access Database, and gives you a tour of its parts and their functions. Find out about early databases and spreadsheets, and then learn about the six main parts of a database: the tables, queries, forms, reports, macros, and modules.
Assignment:
Patawaran tells us that “A blank page is no empty space. It is brimming with potential.” Learn how to harness all that potential with this second lesson from Motion Training’s series on Microsoft Word 2010 for beginners. Learn how to create a new document, use Microsoft Word keyboard shortcuts, modify spacing, and cut, copy, and paste text. Then preserve your work by saving and printing! The skills in this Microsoft Word tutorial also can be used for earlier or later versions of Word.
Assignment:
Build a WordPress site! in seconds! Once you have purchased a domain and installed WordPress in cPanel, all you need to do is pick a theme to have a gorgeous, customized website for personal or business enterprises. This tutorial by Websites Made Easy walks you through the process. As a bonus, you will learn how WordPress helps websites reach the first page of Google, Bing, and Yahoo with search engine optimization (SEO).
Assignment:
Are you tired of living in debt? Are you ready to take control of your finances? Focused Spender is here to help you achieve financial security, beginning with the first step outlined in Dave Ramsey’s “The Total Money Makeover”: building an emergency fund of $1,000. Whether $1,000 seems too insignificant to be a cushion or too monumental a figure to save, learn why it is essential that this sum of money be set aside, and get creative tips to help you raise it.
Assignment:
You've found yourself unexpectedly heading up a project at work. How do become an effective and capable project manager? Project Manager shows you how to get started by following seven steps. Learn how to: begin; identify your team, stakeholders, and customers; get the support you need; and set clear expectations for yourself and others that will keep the project on track. With these steps, confidence, and preparation, you'll be ready to go.
Assignment:
Making the transition to Google Drive? Whether you need to word-process, create a presentation, or compile a spreadsheet, Google Drive’s document types (adapted from Google Docs) have you covered—for free. In this tutorial by Chad McGowan, you will learn how to use Google Presentations, Google Drive’s adaptation of Microsoft PowerPoint.
Assignment:
Are you hungering for new Microsoft Excel skills? Learn how to make a pie chart! This lesson from Motion Training teaches you to make and modify a pie chart, which tracks the distribution or percentage of data across multiple categories. Learn how to select your numbers, create your chart, and format it by moving individual pie slices (for an 'exploded pie chart'). Give the chart a 3D effect, and see how to label your pie slices with numbers or percentage values and format your legend box.
Assignment: