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.
Other Related Classes in Computer Training - Accounting & Bookkeeping 101 for Everyone Accounting & Bookkeeping 101 for Everyone is a course that covers the fundamentals of accounting with the newcomer in mind. Accounting is more than just memorizing terms and procedures; it's a whole new way of thinking about finances. This course assu...
- 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...
- 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 ...
- Algebra 201: Beginner to Intermediate Level Algebra 101 is intended for students who need to gather a basic understanding of how to perform Algebra operations. This course will benefit current students and adult learners who need to know how to perform basic Algebra operations which involve ...
- 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...
- Business Math 101 This course takes you through an overview of the wonderful world of business mathematics. The course is designed for a person of any age and anywhere in the world. All that is required of the learner are a computer, a connection to the internet, a c...
- Computer Basics 101 Do you find yourself intimidated by computer jargon? Would you like to have a clearer understanding (in non-jargon language) of how your computer works? Computer Basics 101 will both demonstrate and explain how your computer works in an easy-to-follow, ...
- 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 ...
- Electronics 101 Whether performing a minor repair, such as your phone or DVD player, or applying for a new and technology focused career, an understanding of the principles directing basic electronics will prove helpful throughout life. This course in basic electronics ...
- 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...
- Internet Fundamentals 101 Are you in the dark about how the Internet works? Do you wonder how in the world it is possible to communicate with someone on another continent in the blink of an eye? This straightforward course clearly and plainly lays out the basics of the Internet...
- Introduction to MS Excel Whether you've used MS Excel before and just want to learn more about Excel or are completely new to the program, this course is designed to teach you the features of MS Excel to have you using it like a pro. It's a fact that a lot of people just like...
- Managerial Accounting 101 Managerial accounting is not as widely used as other forms of accounting, nor is it as known. While companies concern themselves with financial accounting methods like audits, budgets and financial statements, they often completely ignore the forward-th...
- Math All-In-One (Arithmetic, Algebra, & Geometry Review) This self-paced All-In-One Math Course reviews the basics of arithmetic, algebra and geometry. The condensed course covers the following material: -Arithmetic: ( reviewing the use of numbers, signs and symbols, how to perform various operations, h...
- Math Review 101 This course deals with the nuts and bolts of Math. Students will become equipped with a solid foundation of the mathematical tools required to solve more complex mathematical operations. This course would benefit any student (regardless of age) who req...
- 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...
- MS Word 2003 It doesn't matter if you've never used MS Word before or you just want to familiarize yourself with MS Word 2003. This course teaches you all the basics of MS Word, from doing simply functions like typing in the text area to formatting text, to give the ...
- MS Word 2007 This Microsoft Word 2007 course is not only designed to give the experienced MS Word user a tour of the new version of Word, but to also introduce new MS Word users to a comprehensive look at the features and utilities that this word processing software...
- Outlook 2007 The purpose of this course is to help you understand what Outlook 2007 can do for you, whether you are familiar with Outlook 2003 or new to the application altogether. This course has been developed to be of benefit to new users of Outlook, individuals ...
- 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...
- Photoshop Elements 101 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...
- PowerPoint 2003 MS PowerPoint 2003 is probably one of the most convenient software applications in the Office suite because it allows you to do so much – easily. Whether you want to create professional presentations for the office or just brush up on your skills...
- PowerPoint 2007 The purpose of this course is to help you understand what PowerPoint 2007 can do for you, whether you are familiar with PowerPoint 2003 or new to the application altogether. One of the most noticeable changes is the new user interface called the Microsof...
- 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...
| | | |
| |
| |
