Excel & Business Math - Excel Built-in Functions, Data Types and Keyboards are Fast
Learn essential Excel skills: data types, built-in functions, and keyboard shortcuts. Master efficient techniques for data analysis and calculations to enhance your productivity and accuracy in spreadsheet tasks.
Excel & Business Math - Excel's Golden Rule: Formula Inputs, What If Analysis and Excel Models
Learn Excel's Golden Rule for efficient formula solutions and models, with practical examples in building tables for student scores, monthly expenses, and payroll calculations.
Array Formula - Add Daily Rainfall 5 AM to 5 AM Next Day - Most Automatic
Learn advanced Excel array formulas to automate rainfall reporting with custom time periods. Master FREQUENCY, AGGREGATE, and SUMIFS functions for efficient data analysis and unique date extraction.
Introduction to Databases & Access
Comprehensive introduction to databases and Microsoft Access, covering key concepts, objects, data management, and comparison with Excel for effective data analysis and organization.
Excel Basics - Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set
Learn to use Power Query in Excel for data cleaning, transformation, and analysis. Master importing, combining, and refreshing data from various sources to create proper datasets and pivot tables.
Excel Basics - Excel Charts & Graphs to Visualize Quantitative Data
Learn to create effective Excel charts and graphs for data visualization, focusing on best practices and avoiding chart junk. Explore various chart types and their applications in data analysis.
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.
Python Machine Learning Tutorial - Data Science
Learn to predict music preferences using Python and machine learning. Covers data preparation, model training, accuracy calculation, and decision tree visualization in a hands-on tutorial.
MySQL Tutorial for Beginners
Comprehensive introduction to MySQL, covering essential concepts and operations for beginners. Learn to write queries, manage databases, and extract valuable information efficiently.
Linux Networking Tutorials for System Admins
Comprehensive Linux networking tutorials covering internet basics, LAN, commands, network statistics, hosts file, traceroute, Nmap, SSH, and SFTP for system administrators.
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.
Data-Driven Control with Machine Learning
Explore machine learning techniques for data-driven control, covering system identification, model reduction, and advanced control strategies like MPC and reinforcement learning.
Inverse Trigonometric Functions - Evaluating the Composition of Inverse Trigonometric Functions
Explore inverse trigonometric functions, their graphs, and domain restrictions. Learn to evaluate compositions and solve problems involving arcsin, arccos, arctan, and other inverse trig functions.