—•—
Course Description: Introduction to Microsoft
Excel- JC Sullivan®
$25.00
- 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.
