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
Good afternoon
ReplyDeleteThe link to the practice file do not open. Please help
Hi Ogerruv,
DeleteYou 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.
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
ReplyDeleteHi Othello,
DeleteSorry about layoff. And congrats on joining the consultants club!
You can access all the tutorials and links at https://www.urbizedge.com/Tutorials