Advanced Excel Functions
- IntermediateSkill Level
- 2 hr
- 16K learners
Boost your Excel skills with advanced referencing, lookup, and database functions using practical exercises.
Bridge the gap between buying technology and using it. DataCamp delivers hands-on training tailored to your tech stack, so your investments actually deliver value. That means mastering the tools you already have—faster—so adoption rises, productivity soars, and ROI follows.
80% of the Fortune 1000 use DataCamp to get ROI from their existing tech stack

Buying the tool is the easy part; getting your teams to adopt it is the real challenge. DataCamp closes the gap with learning that is:
With DataCamp, learners practice directly in-tool, but with no downloads and no IT setup required. Every course, challenge, and project is designed to build real skills in a safe environment so learners move from knowledge to application in their day-to-day work.


From total beginner to casual explorer or seasoned pro, DataCamp meets learners where they are.
Our curriculum is built in partnership with experts from the companies behind the tools themselves. Every course is rigorously curated, so instead of wasting time sifting through endless how-to videos or generic libraries, your teams get relevant, up-to-date learning.

Boost your Excel skills with advanced referencing, lookup, and database functions using practical exercises.
Practice Power BI with our healthcare case study. Analyze data, uncover efficiency insights, and build a dashboard.
Start your Tableau journey with our Introduction to Tableau course. Discover Tableau basics such as its features and dashboards.
Learn to use Google Sheets to clean, analyze, and draw insights from data. Discover how to sort, filter, and use VLOOKUP to combine data.
Acquire the skills necessary to master Alteryx Designer to pass the Alteryx Core Certification exam. No previous experience is required.
Get started with Sigma! Learn how to build and customize simple, interactive dashboards for real-time analytics.
Prepare for Microsoft’s Azure Fundamentals certification (AZ-900) by learning the fundamentals of Azure: computing, storage, and networking.
Master AWS security, governance, and cost optimization to prepare for the Cloud Practitioner certification.
Learn to design, query, and build in Snowflake - mastering Snowflake SQL for transformation and modeling to become a job-ready Data Engineer.
Learn about the power of Databricks Lakehouse and help you scale up your data engineering and machine learning skills.
Get to know the Google Cloud Platform (GCP) with this course on storage, data handling, and business modernization using GCP.
Unlock BigQuery's power: grasp its fundamentals, execute queries, and optimize workflows for efficient data analysis.
Build AI agentic workflows that can plan, search, remember, and collaborate, using LlamaIndex.
Leverage the OpenAI API to get your AI applications ready for production.
Learn the fundamentals of neural networks and how to build deep learning models using TensorFlow.
What makes LLMs tick? Discover how transformers revolutionized text modeling and kickstarted the generative AI boom.
Import and tidy data, wrangle and visualize data, and model and communicate with data in R with the tidyverse.
Learn how to cluster, transform, visualize, and extract insights from unlabeled datasets using scikit-learn and scipy.
Master Git’s advanced features to streamline data science and engineering workflows, from complex merging to large-scale project optimization.
Learn how to transform raw data into clean, reliable models with dbt through hands-on, real-world exercises.
Master multi-stage builds, Docker networking tools, and Docker Compose for optimal containerized applications!
Learn the power of Docker and Kubernetes, this interactive track will allow you to build and deploy applications in modern environments.
In this course, you will learn the fundamentals of Kubernetes and deploy and orchestrate containers using Manifests and kubectl instructions.
Learn how to implement and schedule data engineering workflows.
Docs explain features. Video libraries demo them. Vendor training covers a single product. In addition to role-based learning and unique, hands-on practice, DataCamp delivers:
One place to learn 30+ tools and how they connect in real workflows.
Manage, measure, and scale learning across the entire organization.
Always up-to-date content, keeping pace with evolving tools.
Your path to ROI starts here
With DataCamp, your workforce doesn’t just learn for the sake of learning; they apply new skills directly in the tools you’ve invested in.