MS Excel for Personal and Small Business Financial Record Keeping (MS Office 2003), CMP796
Lost in keeping track of your monthly expenses? Learn basics of managing your budgets, keeping financial records and reconciling your checkbook by using MS Excel 2003. Topics on managing credit cards and credit card comparison shopping on the website will be discussed. You will learn the MS Excel basics and how to create and maintain simple spreasheets for your financial needs.
Prerequisites: Computer Basics and Working with Windows or equivalent experience with PC File Management.
Textbook: Please bring your textbook to the first class session. See MC Bookstores for more information on your textbook, bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).
Classroom Hours: 15-
Course Objectives:
- Explore the Microsoft Office Excel 2007 environment and create a basic worksheet
- Perform calculations
- Modify a worksheet
- Format a worksheet
- Print workbook contents
- Manage large workbooks
Course Content
Lesson 1: Creating a Basic Worksheet
- Explore the User Interface and the Ribbon
- Navigate and Select in Excel
- Obtain Help
- Enter Data and Save a Workbook
- Customize the Quick Access Toolbar
Lesson 2: Performing Calculations
- Create Basic Formulas
- Calculate with Functions
- Copy Formulas and Functions
Lesson 3: Modifying a Worksheet
- Manipulate Data
- Insert and Delete Cells, Columns, and Rows
- Search for Data in a Worksheet
- Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
- Modify Fonts
- Add Borders and Color to Cells
- Change Column Width and Row Height
- Apply Number Formats
- Position Cell Contents
- Apply Cell Styles
Lesson 5: Printing Workbook Contents
- Print Workbook Contents Using Default Print Options
- Set Print Options
- Set Page Breaks
Lesson 6: Managing Large Workbooks
- Format Worksheet Tabs
- Manage Worksheets in a Workbook
- Manage the View of Large Worksheets