Create complex Excel user interfaces with VBA. Learn form validation, complex controls usage, and secure email sending via VBA.

Leverage Excel's VBA tool for operations, macros, and debugging. Learn to format cells, manage sheets, and utilize FormatConditions object.

Master VBA in Excel for pivot tables, charts, and financial data. Learn to automate tasks in MS Access, run SQL queries, and set up event handlers.

Explore large language models (LLMs) and vector databases, including ANN search, similarity methods, and practical skills using BERT and ChromaDB embeddings.

Master integration, correlation identification, and anomaly detection for informed decision-making.

Learn how to create and customize pie charts, bar graphs, and other data visualizations with Microsoft Excel.

Learn to make effective data visualizations in Python with Matplotlib and Seaborn.

By combining the stream processing capabilities of Azure Stream Analytics and the data visualization capabilities of Microsoft Power BI, you can create real-time data dashboards.

Data visualization is an important step for professionals who want to make sense of data for machine learning purposes or even presenting meaningful data to an audience. In this course you will see how to do data visualization using AWS QuickSight.

This course will teach you how to connect Snowflake to BI tools such as Tableau and Power BI. You'll also learn how to visualize and create dashboards within each of the tools.

Data is often available on web pages, requiring extra effort and caution to retrieve it. This course is about the Rcrawler package which is a web crawler and scraper that you can use in your R projects.

Learn to retrieve and parse information from the internet using the Python library scrapy.