Companion Files for the YouTube Excel Training Videos

A lot of you have requested for the practice along files for the YouTube Excel Training videos (here's the link to the YouTube Excel Training videos). So I have decided to put the practice files all up here in one place.



First, we do a monthly very intensive and business relevant Excel training that wouldn't cost you too much. If that works better for you, you should register for it here or just read participant's feedback: Best Excel Training in Nigeria

Video List and Practice-along File
Below are the YouTube Excel training videos link and the practice-along files.

Video 1: Introduction to the Excel Training and Trainer
Practice File 1: http://tinyurl.com/ExcelVideo1

Video 2: How Excel handles different data types
Download the companion file here: http://tinyurl.com/ExcelVideo2

Video 3: Data consistency, starting with the end in view
Download the companion file here: http://bit.do/ExcelVideo3

Video 4: Building Datasheets that can scale
Download the companion file: http://tinyurl.com/ExcelVideo4

Video 5: Sorting in Excel 
Download the practice-along file: http://tinyurl.com/ExcelVideo5

Video 6: Filtering in Excel
Download the practice-along file: http://tinyurl.com/ExcelVideo6

Video 7: Data Cleaning in Excel 
Download the practice-along file: http://tinyurl.com/ExcelVideo7

Video 8: Data Formatting in Excel
Download the practice-along file: http://tinyurl.com/ExcelVideo8

Video 9: Making Charts in Excel
Download the practice-along file: http://tinyurl.com/ExcelVideo9

Video 10: Pivot Table, Pivot Chart and PowerPivot in Excel
Download the practice-along file: http://tinyurl.com/ExcelVideo10

Video 11: Excel Training -- Business Data Analysis, part 1
Download the practice-along file: http://tinyurl.com/ExcelVideo11 

Video 12: Excel Training -- Business Data Analysis, part 2 
Download the practice-along file: http://tinyurl.com/ExcelVideo12

Video 13: Power Excel Functions
Download the practice-along file: http://tinyurl.com/ExcelVideo13

Video 14: Protecting Workbook; Protecting Worksheet and formatting for Printing in Excel
Download the practice-along file: http://tinyurl.com/ExcelVideo15

Video 15: Named Range, Goal Seek, Scenario and Solver in Excel 
Download the practice-along file: http://tinyurl.com/ExcelVideo14

Video 16: Creative Excel Features/Use
No Practice File

Video 17: Excel Web Query   
No Practice File

Video 18: Mail Merge
Download the practice-along file: http://tinyurl.com/ExcelVideo18 

Video 19: Creative Excel Use
No Practice File

Video 20: Excel Keyboard Shortcuts
Download the well compiled keyboard shortcuts by Exceljet: http://tinyurl.com/ExcelVideo20  

Video 21: Data Visualization in Excel 
Download the practice-along file: http://tinyurl.com/ExcelVideo21

Video 22: Excel Reports And Presentation
Download the practice-along file: http://tinyurl.com/ExcelVideo22

Video 23: Excel Macros (intro and small project)
Download the practice-along file: http://tinyurl.com/ExcelVideo23  

Video 24: Userform and more Macros 
Download the practice-along file: http://tinyurl.com/ExcelVideo24

We do a monthly very intensive and business relevant Excel training that wouldn't cost you too much. If that works better for you, you should register for it here or just read participant's feedback: Best Excel Training in Nigeria 

12 comments:

  1. Good afternoon

    The link to the practice file do not open. Please help

    ReplyDelete
    Replies
    1. Hi Ogerruv,

      You can access all the tutorial practice files at https://www.urbizedge.com/Tutorials

      The issue with these (no longer working ones) is from Dropbox where I originally hosted the practice files.

      Delete
  2. Hi Michael, I just found you on Youtube when looking to master r and excel. I just started my consultant business after company layoff. I have a engineer degree in Electronics who excited to build my business but need assistance. I'm able to access your video, but not the sheets. I get error each time for all sheets. I'm really exited in venturing this data analytics area. Is there another portal to access excel training sheet. Thank You

    ReplyDelete
    Replies
    1. Hi Othello,

      Sorry about layoff. And congrats on joining the consultants club!

      You can access all the tutorials and links at https://www.urbizedge.com/Tutorials

      Delete
  3. I was very happy to find this site. I really enjoyed reading this article today and think it might be one of the best articles I have read so far. I wanted to thank you for this excellent reading !! I really enjoy every part and have bookmarked you to see the new things you post. Well done for this excellent article. Please keep this work of the same quality.
    Data Science Course in Bangalore

    ReplyDelete
  4. Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
    Data Science Course in Bangalore

    ReplyDelete
  5. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
    data analytics course in bangalore

    ReplyDelete
  6. I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, hope you will provide more information on these topics in your next articles.
    data analytics training in bangalore

    ReplyDelete
  7. I am a new user of this site, so here I saw several articles and posts published on this site, I am more interested in some of them, hope you will provide more information on these topics in your next articles.
    data analytics training in bangalore

    ReplyDelete
  8. Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!
    Data Science Training in Bangalore

    ReplyDelete
  9. Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more.
    Data Science Course in Bangalore

    ReplyDelete
  10. Data Science Training in Bangalore Offered by myTectra is the most powerful Data Science Training ever offered with Top Quality Trainers, Best Price, Certification, and 24/7 Customer Care.

    https://www.mytectra.com/data-science-training-in-bangalore.html

    ReplyDelete

You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.

Thanks!