Home Schedule
27 Oct 2025 - Data formatting 03 Nov 2025 - Data manipulation 10 Nov 2025 - Data visualization 17 Nov 2025 - Relational databases
Monday Lecture Wednesday Recitation Friday Recitation
worksheets preps spreadsheets formulas functions
Canvas Syllabus Contact Options Last Updated on

Tools for Information Literacy ⑪ Data control

Preps for the workbook, formulas, and functions session

If you want to know why we will do this module and what you might want to learn about this tool,

spend a productive 25 minutes watching this video.

Did you celebrate on 17 October?

To prepare yourselves for the initial spreadsheets, formulas, and functions session, glance over ...

  1. some basic terminology and shortcuts you will be using
  2. Excel Video Training and see if any are ones you need to view.

 You might want to bookmark all or parts of all of them

.

From Lifewire and W3Schools

And these from Microsoft

On pioneers

Watch this TED talk and ask yourself who the speaker is.

OK, he started it, but how did Excel grow?

  1. Excel for Office 365 cheat sheet
  2. Excel: Top 10 tips for beginners
  3. What We Know About Spreadsheet Errors
  4. Useful Excel for Office 365 (in Windows) keyboard shortcuts
  5. Useful Excel for Office 365 (for Mac) keyboard shortcuts
  6. 15 Excel Formulas That Will Help You Solve Real Life Problems
  7. How to lock cells in Microsoft Excel, so people you send spreadsheets to can't change certain cells or data
  8. How to Do a VLOOKUP in Excel Spreadsheets
back to top