Excel Basics - Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data
Learn essential Excel data analysis techniques: sorting, filtering, and Flash Fill. Master organizing and cleaning data efficiently for improved productivity and insights.
Excel Basics - PivotTable Power - Amazing PivotTable Reporting Tricks - Slicers to Show Values As
Master advanced PivotTable techniques in Excel, including slicers, custom calculations, and data analysis. Learn to create powerful reports and gain insights from complex datasets.
Excel Basics - SUMIFS, COUNTIFS, AVERAGEIFS Functions Calculations With One or More Criteria
Master advanced Excel functions like SUMIFS, COUNTIFS, and AVERAGEIFS for data analysis. Learn to apply multiple criteria, use logical tests, and leverage Excel tables for efficient calculations.
Excel Basics - Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & More
Learn to leverage Excel's Table feature for dynamic ranges in VLOOKUP, PivotTables, charts, and more. Master efficient data management and analysis techniques for improved productivity.
Excel Basics - Excel VLOOKUP Function Made Easy
Master Excel's VLOOKUP function with 9 practical examples, from exact matches for product pricing to approximate matches for commission calculations, enhancing your data analysis skills.
Excel Basics - IF Function Made Easy and IS Functions Too - Epic Examples
Master Excel's IF and IS functions with 14 practical examples, enhancing your data analysis and decision-making skills for various business scenarios.
Excel Basics - Complete Formula Lesson of Formula Types & Formula Elements With Examples
Comprehensive guide to Excel formulas covering number, text, and logical operations with practical examples for data analysis and business calculations.
Excel Basics - PivotTables & SUMIFS Function to Create Summary Reports
Learn to create summary reports using PivotTables and SUMIFS function in Excel. Master data analysis techniques, proper data set creation, and efficient report formatting for regional, daily, and sales rep summaries.
Dynamical Systems
Explore advanced techniques in dynamical systems analysis, including SINDy, Koopman theory, and deep learning applications for modeling complex nonlinear systems.
Sparsity and Compression
Explore sparsity and compression techniques, from compressed sensing to robust regression, with practical applications in image processing, signal analysis, and machine learning.
Python Projects for Beginners - Great Learning
Comprehensive tutorial covering 13 Python projects for beginners, from basic concepts to advanced applications like face recognition and machine learning, with hands-on demonstrations and examples.
Using Data Science to Fight Covid-19 and How to Start Learning ADSB
Explore data science applications in fighting COVID-19, learn about pandemics, and discover pathways to start a data science career with insights from MIT faculty and industry experts.
Hypothesis Testing Statistics - Examples and T-Test Hypothesis Testing
Comprehensive overview of hypothesis testing in statistics, covering key concepts, types of tests, and practical examples. Ideal for learners seeking to understand and apply statistical hypothesis testing methods.
Analytics in Medical Malpractices - An Analytical Perspective
Explore medical malpractices analytically through case studies and hands-on learning. Gain insights into exploratory analysis, key concepts, and descriptive techniques for healthcare data.
Resource Planning - Importance of Resource Planning
Learn to optimize organizational efficiency through effective resource allocation, forecasting, and management. Explore key concepts, steps, and tools for successful resource planning across various business contexts.
Python Career Options in 2021 - Python for Different Job Roles
Explore Python's versatility in web scraping, development, game creation, and machine learning. Learn about career options, salary trends, and future prospects for Python professionals.
How to Crack Analytics Interview in 2021
Comprehensive guide to acing analytics interviews, covering SQL, Python, Data Science, and NLP questions with detailed explanations and practical tips for success.
Azure SQL Database: Grouping Sets and Windowing Functions for Developers
Explore Grouping Sets and Windowing Functions in Azure SQL Database to enhance code efficiency and solution performance. Learn practical tips for developers to leverage these powerful features.
Analytics and Operational Data
Explore Azure Synapse Link for SQL, enhancing analytics for operational data stores. Learn its functionality with Azure SQL DB and SQL Server 2022 through demonstrations and practical insights.
Manage Tables in Dataverse
Explore Dataverse tables: types, creation, attachments, and licensing. Hands-on exercise for custom table creation. Ideal for those seeking practical Dataverse management skills.
Explore and Analyze Data with R
Explore, analyze, and visualize data using R programming language. Learn to use packages like ggplot2, dplyr, and tidyr to transform raw data into insights and knowledge.