Business

Learn how to keep the books for your small business or employment. Practice recording daily transactions and experience the entire accounting cycle as this course walks through a hands-on case study of an actual sample company. Up-to-date materials and practical exercises guide you through typical bookkeeping practices--all the way from the concepts of the accounting equation and the balance sheet, through debits/credits and double entry bookkeeping, to profit and loss statements and closing the books at year end.

Use Excel to create useful budgets to manage your department or small business finances. Discover tips and tricks for using Excel effectively to track monthly and annual estimates, actuals, and spending variances. Find out how to create what-if scenarios to prepare for the unknown, and learn to build multi-worksheet spreadsheets with summaries and graphs for easy analysis.

Enhance your career opportunities by learning more about financial analysis with Excel. Learn how to structure your data to get the most out of Excel's analysis capabilities--then sort, filter, and subtotal your data easily with Excel. Discover Excel's built-in data analysis tools and find out how to use PivotTables in a financial capacity in the workplace. Prerequisite: Budgeting with Excel or equivalent skills.