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 

4 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

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!