Excel Power User Advanced Tutorial
Advanced Excel techniques for power users: dynamic ranges, pivot table enhancements, web data import, and VBA macros. Develop skills to solve complex problems efficiently and push Excel's capabilities to new limits.
Excel Power User Beginner Tutorial
Master advanced Excel functions like VLOOKUP, INDEX-MATCH, and OFFSET. Learn data mining, dynamic ranges, and conditional formatting to solve complex problems efficiently and become a true Excel power user.
Excel 2016 Advanced Tutorial
Master advanced Excel techniques including named ranges, complex functions, data consolidation, solver tools, and macros to enhance your data analysis and productivity skills.
Excel 2016 Intermediate Tutorial
Comprehensive intermediate Excel tutorial covering advanced data manipulation, visualization, and analysis techniques. Learn to create pivot tables, charts, and use powerful features for efficient data management.
MongoDB + Python - Full-Text Search with Atlas Search
Learn advanced MongoDB and Python techniques for full-text search, including fuzzy matching, synonyms, autocomplete, compound queries, and relevancy scoring. Enhance your database querying skills.
Mini Python Projects for Intermediates
Learn to build three intermediate Python projects: a shortest path finder, NBA stats tracker, and currency converter. Enhance your skills with practical coding examples and step-by-step guidance.
Learn Data Science from Scratch - With GitHub CoPilot
Explore data science fundamentals with expert guidance, hands-on demos, and GitHub CoPilot assistance in this engaging livestream session.
Playing with Data in Jupyter Notebooks with VS Code
Explore data science workflows using Jupyter Notebooks in VS Code. Learn tips and tricks for efficient coding, and discover how to make your notebooks faster and more visually appealing.
Excel Add-in Development
Learn to develop Excel Add-ins, connect to live services, create custom functions, and utilize new APIs. Hands-on demo includes building a meme generator and exploring preview features.
Setting Up VS Code for Python Beginners
Learn to set up VS Code for Python development, covering installation, extensions, settings, virtual environments, IntelliSense, and Jupyter notebooks in this beginner-friendly tutorial.
XLOOKUP Excel Tutorial
Master Excel's powerful XLOOKUP function for faster, more efficient data lookup. Learn its advantages over VLOOKUP and Index/Match, and explore advanced features like approximate matching and two-way searches.
Excel 2019 Expert Tutorial
Comprehensive tutorial covering advanced Excel features including named ranges, complex functions, data analysis tools, and macros. Ideal for users seeking to enhance productivity and data manipulation skills.
Excel 2019 Advanced Tutorial
Master advanced Excel 2019 features: data management, charts, pivot tables, and automation. Enhance efficiency in organizing, analyzing, and presenting complex data for professional spreadsheet mastery.
Excel 2019 Beginner Tutorial
Comprehensive tutorial covering Excel 2019 basics, from interface navigation to formulas, functions, data organization, and time-saving features for beginners and everyday users seeking efficiency.
Word Expert Tutorial
Comprehensive tutorial covering advanced Microsoft Word features, including forms, tracking changes, citations, macros, and PDF editing. Suitable for beginners and experienced users seeking to enhance productivity.
Power BI Master Tutorial
Comprehensive tutorial on Power BI, covering data querying, analysis, and visualization. Learn to build relationships, create dashboards, and master advanced functions for effective business analytics.
Power BI Advanced Tutorial
Master advanced Power BI techniques for data analysis and visualization. Learn to build queries, create relationships, use DAX functions, design interactive dashboards, and publish reports online.
Power BI Beginner Tutorial
Learn to process and visualize data using Microsoft's Power BI. Master querying, data prep, relationship building, and creating interactive dashboards and reports for effective business analytics.
Visio Tutorial
Learn to create professional diagrams, flowcharts, and visual representations using Visio's powerful tools. Master essential features for project management, organizational planning, and process visualization.
How Twitter Bots Are Made - The Ultimate Guide for Beginners
Learn to create a simple Twitter bot using Python and Selenium. Explore web automation techniques, HTML basics, and ethical considerations while building a retweet bot with customizable features.
Introduction to jq - Lightweight and Flexible Command-Line JSON Processor
Explore jq, a powerful JSON processor. Learn command-line options, filters, data manipulation techniques, and practical applications for efficient JSON handling and transformation.