Technology Help and Resources

Excel

• Excel workshop with Dr. Mike Hoffman:

  Video Recording

  Excel Files used: 

• Food Sales Sample File
• Academic Data Example File
• Winter Athlete Sample File
•    

  Protection and security in Excel

  Excel gives you the ability to protect your work, whether it’s to prevent someone from opening a workbook without a password, granting Read-Only access to a workbook, or even just protecting a worksheet so you don’t inadvertently delete any formulas. In this topic we’ll discuss the various ways you can utilize the primary options to protect and distribute your Excel files.  Learn all about securing your Excel files here. 

• Getting Started with Excel Handout File

  Topics covered: The Excel Workbook Overview - Getting Started - Entering Data into the Worksheet
  - Adjusting Column Widths and Row Height - Writing a formula - Creating a chart
  - Freezing Rows and Columns

• Getting Started with Excel Workbook File
• Excel Formulas Handout File

  Syntax of a formula - Examples of simple & more complex - Formulas that involve multiple sheets

• Excel Formulas File
• Video - Excel Formulas URL
• Excel Intermediate Workbook File

  Import data: csv files and pasting from the internet - Data manipulation Sorting - Advanced sorting - Filtering
  Find duplicate records - If/Else Examples (Find unique records)

• Excel Intermediate Workshop File
• Excel: Data Management File

  Topics covered: Sorting Data - Custom Sort - Filtering - Text to Columns 
  Formulas to use to manipulate or format Text - Trim, Concatenate, Count If, Proper

• Data Management Workbook File
• Excel: Data Management Tips and Tricks File

  Topics Covered: Importing Data into Excel - Paste Special - Re-order Columns
  Conditional Formatting - Find and Replace - Finding Duplicate Records

• Excel Workbook for Data Management Tips and Tricks File
• Zipcodes for import File