Curated Video
Learning Microsoft Power BI - Creating Visualizations-Card Visualizations and Title Section
In this video, we will explore the top title section of the report and see what types of information should be displayed there. • Add a title and image to the report • Understand what types of information should be displayed on card...
Curated Video
Learning Microsoft Power BI - Connecting to (Almost) Any Data Source with Power Query
In this video, we will learn how to connect to any data source with the help of Power Query. • Look at the various types of data connections we can make with the help of Power Query • Understand how to connect to data present on premises...
Curated Video
Naming Cells In Microsoft Excel
In this video tutorial I show you how simple and easy it is to name a cell in a Microsoft Excel spreadsheet, and then refer to that cell by its name elsewhere in the spreadsheet. Referring to cells using descriptions and names makes much...
Curated Video
How to Hide and Unhide Columns in a Spreadsheet
This video tutorial demonstrates how to hide and unhide columns in a spreadsheet efficiently. It explains the process of hiding columns to declutter the view without deleting important data, and then provides clear steps on how to easily...
Curated Video
Excel Tutorial: How to Rotate Table Data 90 Degrees Quickly and Easily
Learn how to quickly rotate tables in Excel by transposing the data through 90 degrees. Instead of manually rearranging information, discover the hidden "transpose" feature in Excel's paste special option. This efficient technique allows...
Curated Video
Organizing Large Spreadsheets with Checkboxes
In this tutorial, Justin demonstrates how to tidy up a large spreadsheet in Microsoft Excel using checkboxes. By hiding or compressing sections with checkboxes, users can easily navigate through the spreadsheet and focus on specific...
Professor Dave Explains
Practice Problem: Cell Potential, Equilibrium Constants, and Free Energy Change
Mercy me, how are cell potential, equilibrium constants, and free energy change all related? By a few different equations, that's how. See if you can solve for these values given some data!
Curated Video
Excel: How to Separate First Names and Surnames Using Text to Columns
Learn how to efficiently separate first names and surnames from a list of names in Excel using the Text to Columns feature. By following simple steps, you can split the data into separate columns, eliminating numbers and organizing the...
Curated Video
Rounding Numbers to a Set Decimal Place in Excel
In this video tutorial, learn how to round numbers in a spreadsheet to a set number of decimal places using the ROUND function. The instructor demonstrates how to easily round numbers to two decimal places and ensure consistency across...
APMonitor
Solve Nonlinear Equations with MATLAB
MATLAB solves nonlinear equations either symbolically or numerically with solvers such as "fsolve". This example demonstrates how to obtain a solution to sets of nonlinear equations.
Curated Video
Robotic Process Automation - UiPath RPA Developer Masterclass - Data Table Variables
In this video, you will take a closer look at Data Table variables and all the things we can do with them. This clip is from the chapter "Tech Primer – Variables and Data Types" of the series "Robotic Process Automation - UiPath RPA...
Brainwaves Video Anthology
Nilanjana Dasgupta - Implicit Bias
As the director of faculty equity and inclusion, Nilanjana (Buju) Dasgupta works with faculty and develops policies and programs that can be implemented college-wide to increase diversity in the hiring, retention, success, and...
Curated Video
Alteryx for Beginners - Date and Time Tool
This video explains how to use the Date and Time 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 ComboBox Control II
In this lesson, we wire up the UserForm to iterate over all of the workbook's worksheets and normalize the font name and size based upon the user's ComboBox selections. This clip is from the chapter "User Forms" of the series "Excel VBA...
Curated Video
Excel VBA Programming The Complete Guide - The ComboBox Control I
The ComboBox is a dropdown of predefined options that can optionally accept a new user input. In this lesson, we create two ComboBoxes to accept a font name and a font size. This clip is from the chapter "User Forms" of the series "Excel...
Curated Video
Excel VBA Programming The Complete Guide - Procedures with Boolean Arguments + The Workbook_BeforePrint Event
Some event procedures feature a Cancel Boolean argument that can cancel a specific operation by being set to True in the body of the procedure. In this lesson, we try this out with the BeforePrint event procedure. This clip is from the...
Curated Video
Excel VBA Programming The Complete Guide - The Workbook_Open Event
The Workbook_Open event is triggered when a workbook is opened -- it can be an effective way to welcome a user or run a procedure. In this lesson, we utilize this feature in a new event procedure. This clip is from the chapter "Events"...
Curated Video
Excel VBA Programming The Complete Guide - Date and Time Functions
In this lesson, we explore the Date, Time and Now functions for retrieving the current date and/or time as well as the DateSerial function for generating a specific date in time. This clip is from the chapter "Functions" of the series...
Curated Video
Excel VBA Programming The Complete Guide - The Is Family of Functions
VBA package several functions to determine if a value is of a certain data type. In this lesson, we explore the IsNumeric, IsDate, IsEmpty, and IsError functions and use them to populate a table on our spreadsheet. This clip is from the...
Curated Video
Excel VBA Programming The Complete Guide - The MsgBox Method In Depth, Part II
Continuing where we left off in the previous lesson, we wire up the buttons in a sample MsgBox to follow different branches of logic in our VBA code using the If conditional. This clip is from the chapter "Miscellaneous Features" of the...
Curated Video
Excel VBA Programming The Complete Guide - The Step Keyword
The Step keyword can iterate with a different increment or decrement after each cycle of the loop. In this lesson, we experiment with a syntax and write a procedure that colors every second row yellow. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - The If Then Statement
The conditional If statement is the heart of programming. It allows our macro to have multiple branches --- different pathways to take depending on a given condition. In this lesson, we explore the technical syntax for implementing an If...
Curated Video
Excel VBA Programming The Complete Guide - The Range.Resize Property
The Range.Resize changes the size of a range based on the location of a single cell. It can be used to dynamically increase the size of a cell range in the vertical direction, horizontal direction, or both. This clip is from the chapter...
Curated Video
Excel VBA Programming The Complete Guide - Default Values for Declared Variables
In this lesson, we take a look at the default values for the String, Long, Double and Boolean data types. This clip is from the chapter "Variables and Data Types" of the series "Excel VBA Programming–The Complete Guide".In this...