Using Microsoft Excel

Students, here is the link to the group of tutorial videos that we watched today. Please use these short tutorial video's to support you as we master these skills that will help you throughout your scholastic and professional career.

Freeze Panes - These three tutorials show how to "lock"columns or rows (or both!) so that they are always visible on the screen. Freezing a row of column headings is especially useful when working with large data files since it's easy to get lost in the data and forget which column of data or student you're examining.

Sort - These three tutorials show how to sort your data by as many as three different columns. This is an especially useful skill for organizing and creating subsets from original data files.

Filter - These seven tutorials show how to use the Filter feature in Excel, which allows you to quickly see or create subsets of your original data file. Filtering is one of the most powerful tools in Excel.

Conditional Formatting - Imagine being able to quickly color code all of the data in one or more columns to highlight patterns and trends in your data file.

Pivot Tables and Charts - These ten tutorials show how to use what is perhaps the most powerful data analysis tool within Excel .

I hope you all find these tools helpful throughout the school year. Please tell me what you think. I thank dr. Richardson from UNCW, he introduced this site to me.