Course Description: Introduction to Microsoft Excelฎ
- Learn how to make and keep your Monthly Budget in a spreadsheet;
- Learn how to create a spreadsheet to find out monthly interest calculations;
- Learn how you can view your monthly expenses and income graphically, in a Pie
Chart and more
- Learn to enter and format data and mathematical formulas;
- Learn how to make boring figures more presentable and more
Although the course is aimed at the beginner to intermediate user it does get intense in certain lessons. It has been prepared for those who MUST learn how to use Excel but never got down to it. Some advanced
users may find it useful.
Content Overview
Week 1
- User Interface
- Toolbars
- Customising Excel
- Document Window
- Saving Files
- Customising
- Formula Bar
- Assignment 1
Week 2
- Data Entry
- Moving around XL
- Cell Addresses
- Highlighting Cells
- Naming Cells
- Formatting
- Find and Replace
- Recent Files
- Assignment 2
Week 3
- Fitting Columns
- Math Calculations
- Currency Sign
- More Formatting
- More Customising
- Auto Calculations
- Copying Cells
- Addressing Cells
- Assignment 3
Week 4
- Operators
- Functions
- Filling Cells
- Charts and Graphs
- Assignment 4
Week 5
- Importing Data
- Exporting Data
- Drawings
- Images
- Paste Special
- Sorting
- Assignment 5
Week 6
- Printing
- Headers and Footers
- Assignment 6
Week 7
What you will need:
- access to a computer or workstation with a recent version of MS Excel,
preferably Ver. 2002 or 2003
- access to a printer
- some of the instructions in this courseware may not look or act the same
on an Apple or Mac PC
- you are required to be familiar with the operating system you're using
(i.e. Windows 95, 98, XP) and how to navigate with your mouse, keyboard or
touchpad
- you are required to know how to click, double-click, right-click and
drag with your mouse
- finally, you are required to know how to open Excel
Certificates:
Certificates will be issued according to Visual Arts Academy policies at the
time but none will be issued unless all assignments are completed.
Copyright ฉ 2008 Visual Arts Academy
All rights reserved and protected by U.S. Copyright laws.
