MICROSOFT EXCEL WORKSHOPS
Microsoft Excel is a spreadsheet program that allows you to enter numerical values or data into the rows or columns of a spreadsheet, and then use these numerical entries for such things as calculations, graphs, and statistical analysis.
- Advanced Excel Techniques
- Charts
- Creating Drop-Down Boxes in Cells
- Part I
- Part II
- Sorting and Filtering
- Troubleshooting
- Using Excel as a Gradebook
- Viewing
Data Using Pivot Tables
Advanced
Excel Techniques
Sure
you know the basics of Excel, but what else can it do? Now is the time
to explore other concepts that make Excel the wonderful tool that it is.
For instance, do you have a spreadsheet that you use over and over by
removing old data and replacing with new data? A macro can remove that
old data automatically with just a touch of a button. Ever need to calculate
a running balance, repeat column headings on a second sheet when printing,
or protect certain cells so you don’t inadvertently lose that valuable
formula? This workshop will show you how you can make your spreadsheets
even more efficient and easier to use.
Charts
This
workshop utilizes Excel's built-in Chart Wizard to create professional
looking charts and graphs based on your workbook data. Create bar charts,
column charts, pie charts and more with a few clicks of the mouse. This
session also covers editing the chart.
Creating
Drop-Down Boxes in Cells 
Wouldn’t
it be great to just click on a drop-down list and select what you want?
Are you putting in data that might be misspelled or is often repeated?
You can learn how easy this is by using a validation drop-down list. These
lists display all of the available choices to the user so you can simply
click your preference. It doesn’t take long to learn the simple
steps.
Part
I
This beginning workshop introduces you to Microsoft Excel. It covers basic
terminology, toolbars and buttons, moving around the spreadsheet, selecting
cells and ranges, and entering, editing, and formatting different types
of data. You will also learn how to insert and delete rows, columns and
worksheets, fill and copy data, and write formulas.
Part
II
This is an "application" session where you will apply what you
learned in Part I. You will complete two different workbooks--a monthly
budget and a salary spreadsheet.
Sorting
and Filtering
Excel can function as a simple database. This workshop shows
you how to sort and filter records when using Excel as a database. Single
and multiple-level sorts, custom sorts, and automatic subtotals will be
covered. You will also learn how to filter data from one column and multiple
columns.
Troubleshooting
This workshop is intended for the expert user of Excel. You will
be asked to solve complex Excel problems. Participants are also encouraged
to bring their own "stumpers" to the workshop.
Using
Excel as a Gradebook
Do you spend hours with a calculator trying to figure out grade
averages? If so, learn how to make Excel do the work. This workshop provides
an example of how to set up a grade book, put in test scores, then put
in formulas to average or weight the scores. Finally, you'll learn how
to set up a grade scale so that Excel converts the number grades to letters.
Some very basic knowledge of Excel is helpful when attending this workshop.
The time spent in an hour workshop will save you hours of frustrating
calculating and recalculating.
Viewing
Data Using Pivot Tables
You've
seen Excel's abilities to filter and sort data. Now go beyond that and
completely rearrange your spreadsheet without disturbing the original
by turning your data into an organized pivot table. Quickly create drop-down
lists and look at only the data you are presently interested in with a
click of a button.
A "Learn
in 30" session
Copyright
© 2006 by Marywood University
Computer Training & User Support
Learning Resources Center - 2300 Adams Avenue - Scranton, PA
18509
(570) 348-6215
Please report all errors to the Pagemaster
This page was last updated on June 11, 2008