Computer E-Learning

Welcome to the Excel 2007-Advanced workshop. Knowing how to use the advanced features of Microsoft Excel 2007 opens a completely new experience in using this spreadsheet program. The novice user tends to use Excel 2007 as holding place for report data. They may know how to insert data and move columns around, but rarely go into the deeper functions that Excel 2007 offers. This workshop will teach you the most common advanced features of Microsoft Excel 2007. The goal of this course is to get you familiar with these functions in a safe learning environment. Once you complete the course, your familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for you at work or at home. Before we begin, let’s learn more about each other. Breaking the ice early in the training session will help to foster a team environment where sharing and learning will occur.

SmartArt is a feature in Excel 2007 that gives you the ability to add your information graphically. The SmartArt feature offers a variety of graphical models. From lists to hierarchical charts, SmartArt makes adding graphics to your document an easy process. In this module, you will learn the following: • How to insert SmartArt • Understand the SmartArt tab • How to add text to the diagram • Resizing and moving the diagram • Resetting the diagram

At times, you may need to add objects like pictures, text, and shapes to your spreadsheet. These additions to your document can help to enhance the meaning and appeal of your data. In this module, you will learn the following: • About contextual tabs • How to add pictures • How to add ClipArt • How to add text boxes • How to draw shapes

Creating charts is an essential task when presenting data. Charts help to communicate your information clearly and concisely. It also adds a visual appeal to the document. In this module, you will learn the following: • How to insert a chart • Understand the Chart Tools Tab • Understand the parts of a chart • How to change the chart style • How to resize and move the chart

Pivot tables are useful in presenting data in summary format. Pivot tables are helpful in analyzing data for trends and manipulating data to view different summaries of information. In this module, you will learn the following: • How to insert a pivot table • Understand the pivot table tools tab • How to choose fields

In Excel 2007, working with pivot tables is an easy process. Change data and apply styles with a few simple clicks of the mouse. In this module, you will learn the following about working with pivot tables: • How to change the data displayed • How to apply a style to your pivot table • Apply some real-life examples

Converting pivot tables into charts is an easy process in Excel 2007. Charts help to illustrate your information in a visual format that is easy to read by your audience. This module will help you learn the following: • How to create a pivot chart from a pivot table • How to pivot chart from data

Excel 2007 can contain many formulas. They range from simple addition to logical formulas. Understanding how to solve formula errors will make working with Excel 2007 less intimidating. In this module, we will learn how to solve formulas by accomplishing the following objectives: • How to use the named ranges • Understand formula errors • How to trace dependents and precedents • How to use the trace errors command • How to evaluate formulas

The What-if feature in Excel 2007 will help you study various situations by using several data sets. This is useful when there are variables at play and it is difficult to determine one outcome. The What-if analysis feature will help you make informed decision. In order to use the What-if tool we will need to learn the following: • How to use Goal Seek • How to use the Scenario Manager • How to use a one input data table • How to use a two input data table

Once your information is in an Excel 2007 spreadsheet, you can move data and apply other useful tools that make managing your data easy. Understanding these additional features will increase your proficiency in Excel 2007. In this module, you will learn the following: • How to transpose data from rows to columns • How to use the text to columns feature • How to check for duplicates • How to create data validation rules • How to consolidate data

When there is a lot of information contained in your spreadsheet, you can group and outline your data, making it more visually appealing to your viewer. Grouping is a way to consolidate information by a category. Outlining is another way to consolidate information into groups that close and expand. Both of these tools help you to create neat and orderly spreadsheets. In order to accomplish this you must learn the following: • How to group data • How to outline data • How to view grouped and outlined data • How to add subtotals

Although this workshop is coming to a close, we hope that your journey to improve your Excel 2007 Advanced skills is just beginning. Please take a moment to review and update your action plan. This will be a key tool to guide your progress in the days, weeks, months, and years to come. We wish you the best of luck on the rest of your travels!