Class Syllabus: Excel 2007
|  | |
|
Office Hours: |
Continuous
|
|
Course Meeting Times: |
Continuous
|
|
|
Course Description
Microsoft Excel 2007 is Microsoft Corp.'s latest version of its very popular business productivity application for the management and manipulation of data. Microsoft Excel is often packaged as part of Microsoft Office that includes other applications such as Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook. Other desktop applications such as Microsoft Publisher and Microsoft Tools have also been added in recent releases of Office.
Since its launch in 1985, Microsoft has released 24 Excel application versions for Windows, Macintosh, and OS/2 based computer systems. Each successive release incorporated new functions and features that allowed the user to customize how data was displayed, and to do more and better data management. However, Excel 2007 is by far the most powerful and versatile of them all!
In addition to a whole new look and feel, Excel 2007 has modified its underlying technical foundation that enables businesses to expand the uses, integration and reach of Excel. Microsoft has also has continued to improve security, plug security gaps, and address functional issues. All this has helped to make Excel a very stable and reliable business application.
Many new features await the Excel 2007 user. Below are just a few highlights:
- Horizontal "ribbons" that display commands left-to-right instead of the traditional vertical water-flow look.
- More rows and columns to help manage your really massive spreadsheets!
- Memory management increased from 1GB to 2GB's which allows for faster computations and increased performance.
- New options for applying themes and styles which enhance the look of your spreadsheets and graphics. And, Excel now supports up to 16 million colors!
- Easier creation and use of formulas.
- New Pivot Table User Interface to help the user more effectively use pivot tables.
With the right training and understanding of Excel 2007, businesses and individual users can unlock the world of opportunities that this powerful business application offers. This Excel 2007 Online Training Course does just that and more! It assumes users have no prior experience with Excel or other spreadsheet programs. We start with the basics, and move up from there. So join us today, and lets learn the fundamentals of Excel 2007! Course Requirements
This course will not require you to have previous experience in any particular area but you should have the following:
- Excel version 2007
- a high school reading level.
No books will be required. Course Topics
|
1
|
Introduction: Organization of this Training Guide, Uses of Excel, New Functions and Features in Excel 2007
|
|
2
|
Getting Started with Excel: Opening a Blank or New Workbook, General Organization
|
|
3
|
Highlights and Main Functions: Home, Insert, Page Layout, Formulas
|
|
4
|
Highlights and Main Functions: Data, Review, View, Add-Ins
|
|
5
|
Using the Excel Help Function
|
GENERAL EXCEL LESSONS
|
6
|
Customizing the Quick Access Toolbar
|
|
|
7
|
Creating and Using Templates
|
|
|
8
|
Working with Data: Entering, Editing, Copy, Cut, Paste, Paste Special
|
|
|
9
|
Formatting Data and Using the Right Mouse Click
|
|
|
10
|
Saving, Page Setup, and Printing
|
|
|
11
|
Using Headers and Footers
|
|
|
12
|
Manipulating Data using Data Names and Ranges, Filters and Sort, and Validation Lists
|
|
|
13
|
Data from External Sources
|
|
|
14
|
Using and Formatting Tables
|
|
|
15
|
Basic Formulas and Use of Functions
|
|
|
16
|
Data Analysis Using Charts and Graphs
|
|
|
17
|
Managing, Inserting, and Copying Worksheets
|
|
|
18
|
Securing the Excel Document (Protect Cells and Workbook)
|
|
ADVANCED EXCEL LESSONS
|
19
|
Advanced Formulas and Functions
|
|
|
20
|
Advanced Worksheet Features
|
|
|
21
|
Advanced Data Analysis using PivotTables and PivotCharts
|
|
Course Materials
All course material will be provided in the lessons and netlinks. There are no required materials to purchase before taking the class. In order to fully benefit from this course, though, you do need access to Microsoft Excel 2007.
Grading Policy
Lessons will include a lesson review quiz along with one or two assignments. Students will successfully complete this course with 70% or better.
Learning Outcomes By successfully completing this course, students will be able to:
- Describe the major features and functions of Excel 2007.
- Summarize using the Excel help function.
- Customize the Quick Access Toolbar.
- Use templates.
- Demonstrate working with data.
- Demonstrate formatting data.
- Utilize the save, page setup, and print functions.
- Use headers and footers.
- Manipulate data using data names and ranges, filters and sort, and validation lists.
- Create and format tables.
- Create basic formulas and functions.
- Use charts and graphs.
- Manage, insert, and copy worksheets.
- Secure Excel documents.
- Use advanced formulas and functions.
- Create PivotTables and PivotCharts, and
- Demonstrate mastery of lesson content at levels of 70% or higher.
Other Related Classes in Computer Training - Typing and Keyboarding 101 Today, knowing how to type fast is almost a necessity in the business world. More and more corporate-world employees are being asked to create reports, sales letters, business plans, blogs, web content, forecasts and more. Knowing how to type can sav...
- Basic Math 101 Fear fractions no more. And learn whether to add first or multiply first in a string of operations. Whether you are struggling with basic math functions in a course today, you are taking a new job that demands understanding of math, or you simply need to...
- Adobe Photoshop 101 Adobe Photoshop is a complex graphics and image editing software and paint program. Chances are, you've heard of Photoshop frequently in the past even if this will be the very first time that you use the program. Adobe's Photoshop program has become a ...
- Photoshop Elements Version 7.0 (or earlier) The Photoshop Elements software package is a condensed version of the popular Adobe Photoshop. Lesser priced, it contains all the features of Photoshop, but contains fewer options that are much easier to understand. Elements was designed with the consum...
- Payroll Management 101 There are many aspects that need to be covered when running a successful business. One of the most important aspects in any business is of course, payroll management. The members of the business involved in payroll management have unique responsibilities...
- Dreamweaver 101 Whether this is your first time using Dreamweaver or you've used it in the past, this course will walk you through the program step-by-step and teach you how to use its many features and options to create professional web pages with little more than ...
- Math All-In-One (Arithmetic, Algebra, and Geometry Review) This self-paced All-In-One Math Course reviews the basics of arithmetic, algebra and geometry. This condensed course covers the following material: Arithmetic: reviewing the use of numbers, signs and symbols, how to perform various operations, how t...
- Microsoft Publisher 2007 Microsoft Publisher can be an amazing tool. It can help us complete impressive tasks in a fraction of the time, and help to accomplish things that we could never have done on our own. But you have to know how to use this program. This course will sho...
- Photoshop Elements 101 The Photoshop Elements software package is a condensed version of the popular Adobe Photoshop. As the lesser priced version of Adobe's Photoshop, Elements offers all the same features, but just with less options. However, don't let that scare you away fr...
- Microsoft Project 2007 Microsoft Project 2007 is a project management software that helps project managers better structure, organize, and plan for all their projects. This includes budgets, tasks, resources, assignments, and everything in between. It can create critical pat...
- How to Create Web Pages These days, everyone can benefit from an online presence, and that means developing a website. This course covers a basic introduction of how to create your own website page-by-page using HTML, a common website coding process. From basic HTML defin...
- MS Publisher 2010 Microsoft Publisher 2010 is a desktop publishing software program that comes with the Microsoft Office suite. While Microsoft Word is a word processing program, Microsoft Publisher is used for page layout and design. You can use Publisher to create brochu...
- Adobe Flash 101 Adobe Flash CS4 can be a complex program to use and understand, even if you already have basic knowledge. It's very easy to get lost in the interface and confused by the many features it offers. This course was designed to solve the mysteries of Adob...
| | | |
| |
| |
