Curated Video
Servant Leadership: Leading Your Team in the Tuckman Performing Stage
In the Tuckman Performing Stage, teams don’t need guidance (they know their roles) nor supportive team leadership (they can manage their own care, collaboration, and conflict management). What they most need is to be allowed to succeed...
Curated Video
AWS, JavaScript, React - Deploy Web Apps on the Cloud - IAM Credentials Report (Guide)
This lecture will demonstrate how to create a credentials report for IAM users in the AWS account.
Curated Video
Make Apps with ChatGPT and Generative AI - Optimizing Prompts
In this video, we will understand the other key concepts of ChatGPT before we begin creating models. You will learn about prompts, tokens, and temperature and understand them in detail. This clip is from the chapter "What Are OpenAI and...
Curated Video
A Practical Approach to Timeseries Forecasting Using Python - Types of Time Series Data
This video explains different types of time series data. First, you will see univariate and then multivariate time series data. This clip is from the chapter "Motivation and Overview of Time Series Analysis" of the series "A Practical...
Curated Video
Top Digital Skills for 2024
"How will you become a success in 2024? With digital skills! Discover the most in-demand digital skills for 2024. Mark delves into the essential skills that are key to navigating the fast-paced digital career landscape. From the...
Curated Video
EXCEL DATA: Using JSON Data
Mark will guide you in writing and executing SQL queries, pulling data right where you need it.
Curated Video
EXCEL DATA: Connecting to databases
Learn to connect to databases, opening doors to a world of live data interaction.
Curated Video
EXCEL DATA: TODAY, NOW, DATEVALUE
Join Mark in discovering date functions, making time work for you.
Curated Video
EXCEL DATA: CONCATENATE, LEFT, RIGHT, MID
You'll learn text functions to shape your strings, playing with text like a poet.
Curated Video
EXCEL DATA: INDEX and MATCH as alternatives
Mark will demonstrate INDEX and MATCH, powerful alternatives for smart lookups.
Curated Video
EXCEL DATA: VLOOKUP and HLOOKUP
Learn the art of VLOOKUP and HLOOKUP, the essential tools for data navigation.
Curated Video
EXCEL DATA: Exercise: Create conditional summaries
You'll get hands-on with an exercise to create conditional summaries, putting theory into practice.
Curated Video
EXCEL DATA: SUMIF and COUNTIF
Join Mark to dive into SUMIF and COUNTIF, calculating with conditions like a wizard.
Curated Video
EXCEL DATA: IF, AND, OR functions
Explore logical functions like IF, AND, OR, paving your path to logical thinking in Excel.
Curated Video
EXCEL DATA: Exercise: Clean and consolidate a contact list
Practice cleaning and consolidating a contact list in a real-world exercise.
Curated Video
EXCEL DATA: Using Pivot Tables for summarizing data
You'll master Pivot Tables, a powerful tool for interactive data summarization.
Curated Video
EXCEL DATA: Methods to identify and remove duplicates
Learn methods to identify and remove duplicates, keeping your data pristine.
Curated Video
EXCEL DATA: Using subtotals to summarize grouped data
Mark will guide you through using subtotals to create compelling summaries.
Curated Video
EXCEL DATA: Grouping data by categories
Explore how to group data by categories, turning clutter into meaningful segments.
Curated Video
EXCEL DATA: Exercise: Sort and filter a sample dataset
Get hands-on! You'll master sorting and filtering through a sample dataset.
Curated Video
EXCEL DATA: Filtering data with basic and advanced techniques
Join Mark as he demonstrates how to filter data, uncovering the secrets you seek.
Curated Video
EXCEL DATA: Sorting data by various criteria
You will learn to sort data by various criteria, turning chaos into elegant order.
Curated Video
EXCEL DATA: Welcome and Course Overview
Welcome aboard! You'll embark on a data-driven journey through Excel, learning the ropes and discovering what's ahead.
Curated Video
EXCEL DATA: Consolidating data from multiple sources
Discover how to consolidate data from various sources with Mark's expert guidance.