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
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
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