Curated Video
Core Java Programming Course- Writing MS Excel Data using POI
This video explains how to write MS Excel data using POI. This clip is from the chapter "Working with MS Excel Files (Apache POI)" of the series "Learn How to Code: The Complete Core Java Programming Course".null
Let's Tute
Microsoft Excel Function: Structure, Operators, and Examples
In this Microsoft Excel tutorial, we learn about the structure of Excel functions, including the use of equal sign, function names, opening and closing brackets, and arguments separated by commas. We also explore operators such as...
APMonitor
Install Python 3.7 on Windows or Linux
Follow these steps to install Python 3.7 on Windows: 1. Remove old Python distributions 2. Browse to python.org and download installer 3. Install to C:\Python37 4. Add to PATH Environment Variable a. C:\Python37 b. C:\Python37\Scripts 5....
friEdTech
Back up your Microsoft Files to Google Drive Two Ways
You probably have YEARS worth of Microsoft files. Once in a while, you might want to actually be able to find one of them wherever you are. If you live in a Google world like us, the best way to do this is to back them up to your Google...
Curated Video
Learning Microsoft Power BI - Creating Table Relationships in Power BI
In this video, we will learn more about relationships and how to create them in the data model. • Further understand why key columns are important for relationships • Create relationships between the data and lookup tables • Learn how to...
Curated Video
Finding Percentages Using Technology
In this video, the teacher explains how to use technology, such as spreadsheets and calculators, to find the percentage of a population that falls within a certain range. They demonstrate how to use statistics tables, Z scores, and the...
APMonitor
Install Julia on Windows and Linux with Jupyter Notebook
Julia is a language that combines the ease of programming of MATLAB or Python with the speed of C or Java. This tutorial shows how to install Julia 0.5.0 on Windows or Linux (Ubuntu) and manage add-on packages.
R Programming 101
How to import data from excel into R studio - R programming for beginners
Importing data from excel into R is easy. Learn how to import data from excel by using both R code and by using the tools within R studio. This video is part of the R programming for beginners series.
Curated Video
How to Format Numbers in Excel with Color-Coding and Arrows
This tutorial demonstrates how to format numbers in Microsoft Excel without using conditional formatting. It shows how to display positive numbers in black with an up arrow and negative numbers in red with a down arrow. By utilizing the...
Professor Dave Explains
Italian Vocabulary: In the Living Room, Bedroom, and Bathroom
The names of things in the house in Italian.
APMonitor
Record and Plot Real time Data in Python
This sample exercise records, analyzes, and plots real-time data in Python. It is an introductory exercise for the project listed at http://apmonitor.com/che263/index.php/Main/CourseProjects
APMonitor
Interactive Python with Widgets
An IPython widget allows a user to input a value or perform a function. Widgets enhance user interaction with the IPython notebook. See http://apmonitor.com/che263/index.php/Main/PythonWidgets to download the example IPython notebook and...
Curated Video
Alteryx for Beginners - Getting Data from Excel
This video demonstrates how to get data from Excel. 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.
IDG TECHtalk
How to export to Excel with R
See how to save a data frame from R to Excel – with styling or multiple tabs. If you have a request for a future episode of Do More With R, leave a comment below.
Let's Tute
IFERROR Function & Dynamic Amortization Tables in Excel
In this video tutorial, the teacher explains the use of the "if error" function and dynamic amortization tables in Microsoft Excel. The "if error" function is used to handle errors in Excel functions, while the dynamic amortization table...
Curated Video
Excel VBA Programming The Complete Guide - Objects as Properties
It's easy to see object properties as simple, static data values -- integers, floating point numbers, or strings. However, object properties can also store other objects, complete with their own distinct properties and methods. In this...
Curated Video
Excel VBA Programming The Complete Guide - The AND & OR Logical Operators
Multiple conditions can be checked with the And and Or logical operators. In this lesson, we apply these principles to conditional logic across two columns. This clip is from the chapter "Conditionals" of the series "Excel VBA...
Curated Video
Excel VBA Programming The Complete Guide - Collection Objects in Real Life
Some objects in VBA are collection objects. Their purpose is to serve as a box or container for related objects. For example, the Worksheets collection object stores a Worksheet object for each worksheet in a Workbook. In this lesson, we...
Curated Video
Excel VBA Programming The Complete Guide - Introduction
We discuss the benefits offered by the technology, the tools and features available in VBA, a brief history of the language including its precursors Basic and Visual Basic and the prerequisites for the course. This clip is from the...
Curated Video
The Beginners 2022 Cyber Security Awareness Training Course - Macro Malware
You will learn all about Macro malware, why they are so popular, having become a go-to means of infiltrating a computer in devastating fashion. You will also learn how to easily spot malicious macros, as well as protect yourself against...
Curated Video
Excel VBA Programming The Complete Guide - The Application Object
In this section, we'll explore the objects in the Excel object hierarchy in greater depth. We begin with the Application object at the top of the hierarchy. Its properties and methods deal with top-level, global Excel settings. They...
Let's Tute
Introduction to Excel Interface and Basic Shortcuts
In this Excel tutorial, we will learn about the Excel interface and basic shortcuts. We will cover the options and ribbons, where to insert various formulas, and how to find row and column numbers. By the end of this tutorial, you will...
Curated Video
Alteryx for Beginners - Running Total Tool
This video explains how to use the Running Total tool in Alteryx. This clip is from the chapter "Transform Tab" of the series "Alteryx for Beginners".This section explores the Transform tab.
APMonitor
Install Python Modules
Python packages such as numpy, scipy, matplotlib, xlwings, pygame, openCV, and others extend the capabilities of this capable programming language. Installing packages is accomplished with downloadable installer packages or through the...