Tools for Information Literacy | Week ⑪ 
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 20+ 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

• What is Excel?
• Excel Formulas Step by Step Tutorial
• Using Excel Functions in Spreadsheets

And these from Microsoft

• Enter a formula for Mac
• Overview of formulas in Excel for Windows
• you won't be asked to do it, but it might be useful to know that you can Create Custom Functions

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