Reach Michael on 0700ANALYTICS, 08089382423, 08063125227 and mike@urbizedge.com or Hannah on 08021180874 and hannah@urbizedge.com to register for any of training: Excel Training or Power BI training. You should also sign up for our tutorial newsletters and webinar via our homepage



Access our free training Videos and Practice-along File
Below are the training video links and the practice-along files to give you a tip of the value to expect.

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

Video 25: Learn Excel Macros: Custom Functions (UDF) 
Download the practice-along file: Custom Functions (UDF)

Video 26: Learn Excel Macros: Birthday Reminder 
Download the practice-along file: Birthday Reminder

Video 27: Data Cleaning with Excel 

Video 28: Learning the magic of PowerPivot for Dashboards 

Video 29: Enable Developer Tab in Excel 2016 for Mac 

Video 30: Intro to Dashboards and Dynamic Charts in Excel 

Video 31: Showing you some useful cool Excel Magic 

Video 32: How to enable PowerPivot, PowerQuery, PowerView and PowerMap in Excel 2013 

Video 33: New charts in Excel 2016 

Video 34: Demystifying Data Analysis, Business Analysis, Business Intelligence and Big Data 

Video 35: Power BI 

Video 36: Analysing Large Data Records With Pivot Table, Power Pivot and Power BI. 

Video 37: New Column and Formatting in Power BI 

Video 38: Getting Familiar with Power BI settings. 

Video 39: Relationships in Power BI. 

Video 40: Unpivot Column in Power BI 

Video 41: Workspaces In Power BI 

Video 42: Building a Dashboard with Power BI 

Video 43: Excel vs Python vs R for Data Analysis: Making the Right Choice 

Video 44: Turbo Charging Your Reports With PowerPivot 

Video 45: Data Cleaning With Excel 

Video 46: Learn Excel Macros: Custom Functions (UDF) 

Video 47: Learn Excel Macro: Birthday Reminder 

Video 48: Enable Developer Tab In Excel 2016 for Mac