Practice Files for the Class

Practice Files for the Class - student project

 Following are the files which I have used in my video lectures, please download ALL of the following and use when you watch the lecture. This way you will learn and remember. Thanks to Victoria for reminding me to upload the links.

 

Practice Basic Formulas

https://docs.google.com/spreadsheets/d/1maj9_dLgiU1L5TmlOauRr5sZMdYIamugFfq22ZDVnKU/edit?usp=sharing

Date and Time

https://docs.google.com/spreadsheets/d/1EY15sDJWZ7IdQQVatvfMZhUn7MwAtPRDBQ_8QxWEibE/edit?usp=sharing

Affiliate Earnings Record

https://docs.google.com/spreadsheets/d/1vWx0zziHpHH8wFzEPEJ6eCX7bA-Q9i-hxih7Q1L3gxA/edit?usp=sharing

Adding & Counting

https://docs.google.com/spreadsheets/d/1W94qTRGoXPwhE2kgSOB0hAPbOGPt-IIkwjbb3Yo3e3Y/edit?usp=sharing

Sales Person Record

https://docs.google.com/spreadsheets/d/1bGB_F7xwTdqIZAh593W-HFB9n2kpmE4ZGVe4GfUc1lY/edit?usp=sharing

Named Ranges

https://docs.google.com/spreadsheets/d/1RJRJoW-Sl3IPRo9_5mHsUePJ-FpewbCTuJegavObAA4/edit?usp=sharing

Ranking a Data Range

https://docs.google.com/spreadsheets/d/1oSH1_QfAIGSMvYU5s34PCppwEJSKnTf2hUzBpk5qDjk/edit?usp=sharing

Data Validation

https://docs.google.com/spreadsheets/d/13lK3I4PtDLYm7EFPbC43mubCtnRF7WmIUN3JWEA--DA/edit?usp=sharing

Filter & Filter Views

https://docs.google.com/spreadsheets/d/1qFYOFNc51t7OUcFJyWM6aGxRIfOkP3Hq2lHyWYd7JIU/edit?usp=sharing

Index and Match

https://docs.google.com/spreadsheets/d/11DWlDjPY6yAJzilbR2sbxzO9PkGrJWToUNrwOGzq1mE/edit?usp=sharing

Charts

https://docs.google.com/spreadsheets/d/1yrojQP0NbV01kgg4vJGuiLNVGNWlQpo_78O395rm2U4/edit?usp=sharing

 

Tahir Yaqub
I Teach Online
Teacher