Curated Video
Robotic Process Automation - UiPath RPA Developer Masterclass - Excel Automation - Part 1
This is first of the two-part video, where you will learn about the automation of data in a spreadsheet. This clip is from the chapter "Tech Primer – Automation Activities" of the series "Robotic Process Automation - UiPath RPA...
Curated Video
Practical Data Science using Python - Data Science Stages and Technologies
This video explains data science stages and technologies. This clip is from the chapter "Introduction to Data Science" of the series "Practical Data Science Using Python".This section introduces you to data science.
Curated Video
Excel VBA Programming The Complete Guide - The Range.Rows and Range.Columns Properties
In this lesson, we explore the Rows and Columns properties, which are available on both the top-level Application object and a specific Range. The two can be used to target complete rows or columns, within the spreadsheet or within a...
Curated Video
Excel VBA Programming The Complete Guide - The Workbook.Activate Method
In this lesson, we invoke the Workbook.Active method to simulate a user click on a workbook and make it the ActiveWorkbook. We also review the ActiveSheet property, which targets the currently highlighted worksheet. This clip is from the...
Curated Video
Excel VBA Programming The Complete Guide - The Exit Sub Keywords
The Exit Sub keywords terminate a procedure prematurely, before it reaches its last line of code. It's an effective technique to combine with conditional logic --- proceed if all the pieces fall into place, exit otherwise. In this...
Curated Video
Excel VBA Programming The Complete Guide - The CommandButton Control
The CommandButton is a clickable button that trigger an event procedure. In this lesson, we add 3 buttons to our form -- Submit, Cancel and Hide. This clip is from the chapter "User Forms" of the series "Excel VBA Programming–The...
Curated Video
Excel VBA Programming The Complete Guide - The ListBox Control I - Wire up the Form
In the first of a 3-part series, we introduce the ListBox form control for displaying a list of predefined values for the user to choose from. We hardwire our list to show the names of all of the workbook's sheets. This clip is from the...
Curated Video
Excel VBA Programming The Complete Guide - The OnError and GoTo Keywords
The On Error Go To keywords redirect the pathway of a procedure to a specially designated section. In this lesson, we set up an example and discuss why the Exit Sub keywords have to be used to avoid running into the code automatically....
Curated Video
Excel VBA Programming The Complete Guide - VBA Functions, Part I
The VBA object includes many helper methods to assist the developer with common utility operations. In this lesson, we explore the LCase, UCase, Len, Trim, and InStr methods for working with strings. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - The LBound and UBound Methods
The LBound and UBound methods return the smallest and greatest index positions of an array. In this lesson, we utilize these values to write a flexible, dynamic loop procedure. This clip is from the chapter "Arrays" of the series "Excel...
Curated Video
Excel VBA Programming The Complete Guide - Initialize Arrays within a For Loop
Arrays can easily be populated with values from the worksheet using a basic For loop. In this lesson, we perform a popular string cleaning operation --- trimming the leading and trailing whitespace of a string -- on a column of values...
Curated Video
Learning Microsoft Power BI - Creating a Dashboard
In this video, we will learn about dashboards, what they are for, and how they’re different from reports. • Understand the important differences between a report and a dashboard • Create a new dashboard by adding visualizations from the...
Curated Video
Learning Microsoft Power BI - Connecting to a Folder as a Data Source
In this video, we will learn how to connect a folder as a data source. • Understand the power and usefulness of the import option • Combine flat files from a folder using Power Query • Import data from multiple files into a single folder...
Curated Video
The Complete Excel Guide: Beginners to Advanced - Subtotals
The aim of this video is to explore subtotals. This clip is from the chapter "Excel 2019 Beginners: Outlining and Subtotaling" of the series "The Complete Excel Guide: Beginners to Advanced".In this section, we'll explore what is...
Curated Video
REST API Automation Testing from Scratch - REST Assured Java - Practice Exercise- Excel Driven Testing – Part 2
This video is the second part of the three-part video that presents another practice exercise on Excel driven testing. This clip is from the chapter "Excel Integration with REST Assured Test" of the series "REST API Automation Testing...
Curated Video
Using COUNTIF Function and Absolute Cell References in Excel
The video explains how to efficiently count the occurrences of specific numbers in a spreadsheet using Excel's COUNTIF function and absolute cell references. By setting up a simple table and formula, you can easily track the frequency of...
Curated Video
Business Intelligence with Microsoft Power BI - with Material - Extracting Text with Delimiters
This video explains how to extract text with the help of delimiters. This clip is from the chapter "Text Functions in Power Query" of the series "Business Intelligence with Microsoft Power BI - with Material".This section provides an...
Curated Video
Business Intelligence with Microsoft Power BI - with Material - Creating the Map of Australia in Power BI
This video demonstrates how to create the map of Australia in Power BI. This clip is from the chapter "Maps in Power BI" of the series "Business Intelligence with Microsoft Power BI - with Material".This section focuses on the types of...
Global Health with Greg Martin
Writing a grant application for public health projects
In this video, Dr Greg Martin does a screen recording of himself writing a concept note for funding of a research projects. The video focusses on the "activities" (done on a gantt chart) and budget. If you're wanting to send a concept...
Curated Video
Alteryx for Beginners - Directory Tool
This video explains the Directory tool in Alteryx. This clip is from the chapter "In/Out Tab" of the series "Alteryx for Beginners".This section provides an introduction to the In/Out tab in Alteryx.
Curated Video
Alteryx for Beginners - Browse Tool
This video demonstrates how to use the Browse tool in Alteryx. This clip is from the chapter "In/Out Tab" of the series "Alteryx for Beginners".This section provides an introduction to the In/Out tab in Alteryx.
Curated Video
Excel VBA Programming The Complete Guide - The Range.ColumnWidth and Range.RowHeight Properties
The Range.ColumnWidth and Range.RowHeight properties can resize the row and height of one or more columns or rows. In this lesson, we play around with these features in the Immediate Window. This clip is from the chapter "Range Actions"...
Curated Video
Excel VBA Programming The Complete Guide - The Workbook. Method
The Workbook. method accepts a SaveChanges parameter; pass it a Boolean value of True to save the workbook before closing. In this lesson, we practice this concept by writing values to our red and blue workbooks. This clip is from the...
Curated Video
Excel VBA Programming The Complete Guide - The Workbooks.Open Method and Workbook.Path Property
In this lesson, we offer a review of the Workbooks.Open method and introduce the Workbook.Path property. The former is used to open a single workbook while the latter is used to identify the direction that a workbook exists in. It's...