Reach Michael on 0700ANALYTICS, 08089382423, 08063125227 and mike@urbizedge.com or Hannah on 08021180874 and hannah@urbizedge.com or Emmanuel on 09084825064 and emmanuel@urbizedge.com to register for any of our training: Excel Training or Power BI training or Financial Modelling training. You can 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 

Video 49: Getting Comfortable With Microsoft Excel VBA 

Video 50: Useful Add-ins You Should Be Aware Of In Excel 

Video 51: Carrying Out Predictive Analysis Using Microsoft Excel 

Video 52: The New Features In Microsoft Excel