Video Tutorials

$50 | Duration: 9.5 hours | Video: h264, 1280x720 | Audio: AAC, 44100 Hz, 2 Ch | 2.4 GB Genre: eLearning | Language: English | Project Files    What Will I Learn? Automate tasks on their computer by writing simple Python programs. Write programs that can do text pattern recognition with "regular expressions". Programmatically generate and update Excel spreadsheets. Parse PDFs and Word documents. Crawl web sites and pull information from online sources. Write programs that send out email notifications. Use Python's debugging tools to quickly figure out bugs in your code. Programmatically control the mouse and keyboard to click and type for you. Requirements No programming experience is required. Downloading and installing Python is covered at the start of the course. Basic computer skills: surfing websites, running programs, saving and opening documents, etc. Description If you're an office worker, student, administrator, or just want to become m...

$200 | Duration: 10 hours | Video: h264, 1280x720 | Audio: AAC, 44100 Hz, 2 Ch | 1.2 GB Genre: eLearning | Language: English | Project Files BEST SELLER    What Will I Learn? Automate and Customize data entry forms Choose the right Loop for each task Master the CELLS and RANGE objects in multiple scenarios Create multiple Variable styles to match your need Customize your VBA Editor and Understand all the Toolbars and options Debug and Troubleshoot code like a boss! Record, Modify or Write Macros from scratch Make Custom Formulas/Functions on the fly Breeze through IF THEN statements and conquer all the Logical Operators Batch out inter-active MessageBoxes, InputBoxes and give users CHOICES! Generate Basic Reports that can be printed Add filters to report menus to narrow the records Take control of forms, Buttons, Drop-down menus, Checkboxes and option buttons AND so much more. . . Trigger code from a number of different methods - from Clicking on a ce...

$195 | Duration: 6.5 hours | Video: h264, 1280x720 | Audio: AAC, 44100 Hz, 2 Ch | 2.4 GB Genre: eLearning | Language: English | Project Files BEST SELLER What Will I Learn? • Work comfortably with Microsoft Excel and many of its advanced features • Become one of the top Excel users in your team • Be much quicker at carrying out regular tasks • Be able to build a P&L statement from a raw data extraction • Be able to build a Cash Flow statement • Know how to value a company • Be able to build a Valuation model from scratch • Know how to create a model with multiple scenarios • Know how to create professional and good-looking advanced charts Requirements Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Excel 2016 Description **Updated for July 2017! ** Do you want to learn how to use Excel in a real working environment? Are you about to graduate from university and look for your first job? Are you a young professional who is looking to establish himself at ...