Microsoft Excel Workshops

More Tools and Tips

Is there more to Excel that you really should know? You bet there is! It’s amazing how most of us only use a small portion of Excel, especially when there are so many other features that could make life easier. This workshop showcases some of those features, such as Pivot Tables (are they really more helpful than sorting or filtering?) How can I hide certain parts of a spreadsheet when I print? The page breaks are appearing at inappropriate places. How can I change them? What about changing the print area, itself? How can I make the data easier to read? These are just a sample of the questions that will be answered. Learn how to take advantage of the power of Excel.

Tools and Tips

Sure you know the basics of Excel, but what else can it do? What problems have stumped you? Now is the time to explore other concepts that make Excel the wonderful tool that it is. For instance, are there times when you need to split a column in order to arrange the information for a mail merge? Ever need to calculate a running balance, repeat column headings on a second sheet when printing, keep those leading zeros in a zip code? This workshop will show you how you can make your spreadsheets even more efficient and easier to use.


Charts are graphic representations of data.  A chart can communicate information more effectively than a table of numbers.  Charts are created based on data contained in a worksheet.  It can be saved as an object embedded within a worksheet or placed on a separate sheet in a workbook.  There is a link between the data from which a chart is created and the chart itself.  Therefore, if any of the source data is changed, the change will be reflected immediately on the chart.

Related Documentation: $content.file.fileName

Formulas and Functions

Formulas perform numeric calculations (addition, subtraction, multiplication, division) on data in a spreadsheet.  Formulas are written by the user.  Functions are predefined formulas that calculate a result based on one or more input values.  They are already written for you.

Related Documentation: $content.file.fileName

Excel Basics

Excel is a spreadsheet application found in the Microsoft Office Suite.  Excel can be used to create and format workbooks in order to organize, manipulate, and analyze data, write formulas, calculations, and charts.

Related Documentation: Excel-Basics.pdf

Excel Grade Book

If you spend countless hours at the end of each semester calculating students' final grades, this workshop will surely help streamline the process and save you valuable time. Faculty will be taken through each step to set up their grade book using Excel. Tips for better organization of your quizzes, exams, papers and other materials will be shared along with the proper procedures for writing your formulas. Lastly, assigning letter grades to numerical grades using the LOOKUP function will also be demonstrated.