All courses
Resource hub
Featured resource
Forrester Wave Report 2025
Pluralsight named a Leader in the Forrester Wave™

Our tech skill development platform earned the highest scores possible across 11 criteria.

Learn more
Hamburger Icon
  • Path icon Learning Path
    • Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.
  • Data
    •

Microsoft Excel for Data Analysts

18 Courses
7 Hours
Skill IQ

Microsoft Excel is an essential tool for Data Analysts, offering powerful features for data manipulation, analysis, and visualization. Mastery of Excel enables analysts to efficiently organize data, perform complex calculations, and generate insightful reports, making it indispensable for data-driven decision-making in any industry. This learning path will walk you through the core knowledge and skills you need to get started in your data analysis journey using Microsoft Excel.

Get started

Content in this path

Microsoft Excel for Data Analysts

Watch the following courses to learn foundational Microsoft Excel concepts and skills for data analysis.

Course

Load Data into Microsoft Excel

  • by Jared Westover
  • 18m
  • Aug 26, 2024
Course

Sort and Filter Data in Microsoft Excel

  • by Matt Allford
  • 18m
  • Aug 19, 2024
Course

Data Preparation in Microsoft Excel

  • by Jason Browning PhD
  • 37m
  • Sep 27, 2024
Course

Data Validation Techniques in Microsoft Excel

  • by Janani Ravi
  • 24m
  • Sep 06, 2024
Course

Detect Errors and Audit Formulas in Microsoft Excel

  • by Dr Ali Feizollah
  • 12m
  • Oct 16, 2024
Course

Summarize Data in Microsoft Excel

  • by Wes Higbee
  • 19m
  • Aug 20, 2024
Course

Conditional Formatting in Microsoft Excel

  • by Vlad Catrinescu
  • 28m
  • Aug 26, 2024
Course

Create and Format Basic Charts in Microsoft Excel

  • by Maaike van Putten
  • 11m
  • Aug 16, 2024
Course

Create and Format Specialized Charts in Microsoft Excel

  • by Avdhesh Gaur
  • 15m
  • Aug 15, 2024
Course

Explore Data with PivotTables in Microsoft Excel

  • by Ben Howard
  • 46m
  • Sep 13, 2024
Course

Visualize Data with PivotCharts in Microsoft Excel

  • by Ben Howard
  • 33m
  • Sep 23, 2024
Course

Generate Data Insights Using the Analyze Data Feature in Microsoft Excel

  • by Matt Stenzel
  • 14m
  • Oct 21, 2024
Course

Data Analysis Functions and Techniques in Microsoft Excel

  • by Janani Ravi
  • 49m
  • Sep 06, 2024
Course

Analyze Data in Microsoft Excel with the Analysis ToolPak

  • by Anand Saravanan
  • 10m
  • Oct 21, 2024
Course

Perform Basic Statistical Analysis in Microsoft Excel

  • by Amruta Mahajan
  • 14m
  • Sep 10, 2024
Course

Time Series Analysis in Microsoft Excel

  • by Baneen Qazi
  • 13m
  • Aug 19, 2024
Course

Data Transformation with Power Query in Microsoft Excel

  • by Russ Thomas
  • 47m
  • Sep 05, 2024
Course

Create a Macro for Data Analysis in Microsoft Excel

  • by Amine Cherrat
  • 19m
  • Sep 05, 2024
Try this learning path for free
Access this learning path and other top-rated tech content with a free trial.
Free individual trial Free team trial
Have questions? Get them answered now.
Start a live chat
What You'll Learn
  • How to load data into Excel
  • How to sort and filter data in Excel
  • How to prepare data in Excel
  • How to validate data in Excel
  • How to summarize data in Excel
  • How to perform conditional formatting in Excel
  • How to create and format basic charts in Excel
  • How to create and format specialized charts in Excel
  • How to explore data with PivotTables in Excel
  • How to visualize data with PivotCharts in Excel
  • How to perform data analysis functions in Excel
  • How to perform basic statistical analysis in Excel
  • How to perform time series analysis in Excel
  • How to transform data with Power Query in Excel
  • How to create a macro for data analysis in Excel
Prerequisites
  • There are no prerequisites for this learning path, though introductory experience with Microsoft Excel and knowledge of core data analysis concepts are both helpful.
Related topics
  • Business Intelligence
  • Data Analysis
  • Microsoft Excel Programming
  • Power BI
Not sure where to start?
With over 500 assessments to choose from, you can see where your skills stand and receive adaptive learning recommendations to fill knowledge gaps in as little as 10 minutes.
Learn more

Learn with the best

Jared Westover
Jared Westover
Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data giv...
Matt Allford
Matt Allford
Matt is a DevOps engineer and solution architect with over 10 years of experience in systems administration, architecture and design, primarily in the on-premises data center. He has a new found passion for Cloud and DevOps processes, tools and techniques and enjoys helping customers and the community realize value from technology. Over the past several years Matt has experienced first-hand the power of the communities within the wider IT industry and enjoys learning from others and, where possi...
Jason Browning PhD
Jason Browning PhD
Jason Browning is a data and analytics professional with extensive experience in both the public and private sector, currently serving as the chief data officer at Montana State University. As a Tableau Desktop Certified Professional, Jason loves to build data visualizations that both inform and inspire. He is capable of wrangling messy data both inside and outside of Tableau, and using SQL to perform complex queries. He holds a Ph.D. in higher education administration from the University of Wy...
Janani Ravi
Janani Ravi
Janani has a Masters degree from Stanford and worked for 7+ years at Google. She was one of the original engineers on Google Docs and holds 4 patents for its real-time collaborative editing framework. After spending years working in tech in the Bay Area, New York, and Singapore at companies such as Microsoft, Google, and Flipkart, Janani finally decided to combine her love for technology with her passion for teaching. She is now the co-founder of Loonycorn, a content studio focused on providing ...
Dr Ali Feizollah
Dr Ali Feizollah
Hello, I'm Ali. I have a PhD in computer science. I am currently conducting research on natural language processing (NLP) using Python and machine learning. I have a YouTube channel, named Flutterware, that shares tutorial on Google's Flutter platform that is used to develop mobile applications for Android and iOS with one base code. I love research and exploring knowledge. I think acquiring knowledge without sharing it is useless. I hope that you find my classes helpful.
Wes Higbee
Wes Higbee
Wes Higbee is passionate about helping companies achieve remarkable results with technology and software. He’s had extensive experience developing software and working with teams to improve how software is developed to meet business objectives. Wes launched Full City Tech to leverage his expertise to help companies delight customers. Although his primary focus is on outcomes, implementation often includes technical competency. Wes frequently speaks about impactful aspects of software developm...
Vlad Catrinescu
Vlad Catrinescu
Vlad is a Microsoft 365 and Power Platform expert specializing in empowering organizations to securely and effectively integrate AI-powered tools, such as Microsoft 365 Copilot and AI Agents, into their digital workplaces. An IT professional at heart, Vlad excels at preparing, securing, and governing modern environments, enabling IT administrators and business users to automate processes, enhance productivity, and drive digital transformation with confidence. As a Microsoft Certified Trainer, a...
Maaike van Putten
Maaike van Putten
Maaike is trainer and software developer. She founded training agency Brightboost in 2014 and spends most of her days and nights working and learning. Training gives her the opportunity to combine her love for software development with her passion to help others boost their careers and be successful. She has trained professionals in the field of Java, Spring, C#, Python, Scrum, React and Angular. A lot of her time is spend staying up-to-date with the latest developments in her field. Next to the...
Avdhesh Gaur
Avdhesh Gaur
Avdhesh Gaur is a Senior Data Scientist, an instructor, an author, a storyteller and consultant as well when it comes to bringing insights out of data and presenting the story behind. His career spans more than 10 years with a focus on taking down various business requirements by building Data-driven BI models using Tableau, SQL, Hive, and numerous Statistical data analysis Techniques. ​ Avdhesh Gaur got one of his submissions to Tableau accepted on 7th January 2019. On average, only 1 out of ev...
Ben Howard
Ben Howard
Ben is a Power BI & Data Specialist with a healthy interest in Microsoft BI and planning tools. He has over 30 years of customer and implementation experience, has been a Microsoft MVP for 14 years, is a frequent speaker at several European conferences, and blogs and creates videos on a semi-regular basis. He is actively engaged in providing consultancy to UK FTSE companies, and co-runs the Manchester Power BI User Group.
Matt Stenzel
Matt Stenzel
Matt Stenzel is a Data and AI Cloud Solution Architect at Microsoft. He has 15+ years of experience in the data and analytics industry working in various roles including a software developer, data engineer, DW developer, DBA and integration architect. He has spent the last 8 years working at Microsoft helping companies across the US successfully implement Azure solutions that provide business value.
Anand Saravanan
Anand Saravanan
Anand is a software engineer and is enthusiastic about AI and its multidisciplinary applications. He has always had a passion for technology and how it can be used to help people and businesses. Excellence in various programming languages such as C++, Java, R, Python, SQL, Hadoop, etc., he is a man who has an itch to constantly learn and share his knowledge. He has worked with Fortune 500 companies in various sectors to help them effectively use the data at hand to help make better business dec...
Amruta Mahajan
Amruta Mahajan
Amruta is an experienced Data Analyst with over 12 years of experience in interpreting and analyzing data to drive successful business outcomes. She loves tackling hard problems using data manipulation as her superpower and has worked with market leaders from various fields including Standard & Poors, McDonalds, Mondelez International, General Electric, AMD and Beam Suntory. Amruta is passionate about both teaching and learning and believes “The purpose of life is to discover your gift. The work...
Baneen Qazi
Baneen Qazi
A highly technical, marketing technology solutions architect with 10+ years of experience. Baneen has worked with industry-leading SMEs and enterprise businesses to create and develop marketing automation solutions and roadmaps in line with business requirements. With a data-driven focus and a passion for customer-centric solutions, Baneen specializes in designing and delivering architecturally robust solutions across Marketing Cloud, Personalization, and CDP. In her spare time, she enjoys cudd...
Russ Thomas
Russ Thomas
Currently an IT leader in Denver Colorado's FinTech sector Russ has focused on database engineering, modelling, administration, and BI since 1997. Russ is a passionate trainer and community volunteer presenting regularly at tech events and local user groups around the US. In 2019 much of Russ' focus turned to cloud based data lakes specifically on Google BigQuery, and the emerging world of large language models.
Amine Cherrat
Amine Cherrat
Amine is a Data expert with 10+ years in analytics, skilled in SQL, Tableau, Qlik Sense, and Power BI. He excels in making data science accessible by blending technical skills with engaging learning experiences.

Join our learners and upskill
in leading technologies