Excel 2021 Power User Tutorial
Master advanced Excel techniques for efficient data analysis, including XLOOKUP, pivot tables, array functions, and macros. Enhance problem-solving skills and streamline complex tasks for power users.
Excel 2021 - Intro to Data Analysis Tutorial
Learn essential Excel data analysis techniques: tables, conditional formatting, functions, charts, and pivot tables for effective data insights and visualization.
Excel 2021 Advanced Tutorial - Part 3 of 3
Master advanced Excel 2021 features: nested functions, database operations, XLOOKUP, UNIQUE, SORT, FILTER, LET, data consolidation, and an introduction to macros for enhanced productivity.
Excel 2021 Intermediate Tutorial - Part 2 of 3
Enhance data analysis skills with advanced Excel features: tables, pivot tables, data validation, conditional formatting, and more. Learn to visualize and protect your data effectively.
Azure SQL Updates - November 2022 PASS Summit
Comprehensive overview of Azure SQL updates, featuring expert insights on performance, managed instances, migrations, hybrid solutions, Power BI integration, security, and tools for SQL professionals.
Exploring BTP Service Metadata - Deep Dive into Resource Files and JQ Filters
Dive deep into BTP Service Metadata project, exploring resource files and advanced jq filtering techniques. Learn about OData frontend, metadata structure, and JSON manipulation for SAP BTP services.
Exploring the BTP Service Metadata Project - Part 1
Dive into SAP BTP Service Metadata project, exploring JSON files, metadata structure, and practical examples using jq and ijq tools. Learn to extract and manipulate data for various use cases.
Tableau Desktop Tutorial - Beginner to Advanced Tableau Training
Comprehensive Tableau training covering basics to advanced topics, including data connections, visualizations, parameters, LOD expressions, geospatial charts, and table calculations for effective data analysis and interpretation.
Numerical Differentiation - Second Derivatives and Differentiating Data
Explore numerical computation of second derivatives and data differentiation with Python and Matlab examples, covering finite difference schemes and practical applications.
Intermediate Microsoft Excel Tutorial - How to Use Power Pivot in Excel
Learn to use Power Pivot in Excel for advanced data analysis, creating relationships between tables, performing calculations, and building insightful reports with Pivot Tables, KPIs, and Pivot Charts.
Intermediate Microsoft Excel Tutorial - How to Use Power Query
Learn Power Query in Excel: Import, transform, and consolidate data efficiently. Master data cleaning, column manipulation, merging tables, and formula creation for streamlined data management.
Open Trivia Database for PyQt5 GUI App
Learn to build a functional Trivia game using PyQt5, connecting to a JSON database, processing data, populating widgets, tracking scores, and debugging in Python.
Web Scraping Facebook with Selenium - Automated Bot
Learn to create an automated bot using Python, Selenium, and Chrome Driver to scrape and download entire Facebook image galleries, with step-by-step guidance on setup, coding, and execution.
Track Ethereum Transactions and Balance Using Python
Learn to track Ethereum transactions and balances using Python and the Etherscan API. Create graphs to visualize wallet data over time. Ideal for intermediate Python programmers interested in blockchain technology.
Make a Personal GitHub Dashboard - Progress Tracker
Learn to create a personal GitHub dashboard to track coding progress and view statistics, using Retool for quick development of internal tools.
How to Web Scrape and Download Images With Python
Learn to web scrape and download images using Python, covering project setup, Selenium configuration, image downloading, and URL scraping techniques for efficient data collection and analysis.
Beautiful Soup 4 Tutorial - Finding the Best GPU Prices
Learn to find the cheapest GPU prices on Newegg using Beautiful Soup 4. Covers HTML parsing, multi-page querying, product extraction, and price sorting for efficient online shopping.
Learn NumPy in 30 Minutes
Master essential NumPy functions for efficient array operations, data manipulation, and numerical computing in Python. Covers basics to advanced topics like multidimensional arrays, broadcasting, and linear algebra.
PyTorch Time Sequence Prediction With LSTM - Forecasting Tutorial
Learn to predict time sequences using PyTorch and LSTMs. Create sine waves, build an LSTM model, implement a training loop, and perform final testing for accurate forecasting.
Excel VBA Expert Tutorial
Master Excel VBA: Automate tasks, create custom functions, and build advanced tools. Learn foundational concepts and practical applications for enhanced productivity.
Excel VBA Advanced Tutorial
Comprehensive guide to advanced Excel VBA concepts, covering loops, variables, and complex functions. Ideal for business analysts and data scientists seeking to automate processes and expand Excel capabilities.