Excel 365 Intermediate – Data Analysis & Advanced Functions

Packt via Coursera

Go to class Write review

Details

Go to class

Provider

Coursera
Pricing

Paid Course
Languages

English
Certificate

Paid Certificate Available
Duration & workload

15 hours 11 minutes
Sessions

On-Demand
Level

Intermediate
Subtitles

English

Found in

Overview

Coursera Spring Sale

40% Off Coursera Plus Annual!

Grab it

A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. In this intermediate-level course on Microsoft Excel 365, you will master data analysis techniques and advanced functions that will enhance your efficiency and precision. You’ll learn key skills like logical functions, lookup formulas, data validation, and how to apply advanced statistical and mathematical operations. By the end of the course, you will be confident in using Excel’s more complex tools to organize and analyze large datasets with ease. The course is designed to take you on a structured journey, starting with essential spreadsheet design principles, then progressing to advanced functions like logical operations, sorting, filtering, and analyzing data. You will also dive into Excel’s powerful features such as PivotTables and PivotCharts, learning how to visualize and interact with your data dynamically. From conditional formatting to data manipulation, you will gain practical skills applicable in both professional and personal settings. This course is suitable for those who already have basic Excel knowledge and are eager to enhance their skills. Whether you're a professional looking to improve your data analysis capabilities or a student aiming to master advanced Excel functions, this course will provide valuable knowledge for various scenarios. The course is designed for intermediate learners, but no specific prerequisites are required beyond basic Excel knowledge. By the end of the course, you will be able to create advanced Excel functions, analyze data with PivotTables and charts, manipulate datasets with arrays, and apply logical functions to make better data-driven decisions.

Syllabus

Microsoft Excel 365 Intermediate – Course Introduction

In this module, we will introduce the key components of the Microsoft Excel 365 intermediate course, outlining the topics and tools that will be explored. You'll begin by understanding the course layout and the foundational skills you'll build through the lessons.

Spreadsheet Fundamentals for Good Design

In this module, we will focus on the fundamentals of spreadsheet design, including strategies for creating clean and readable spreadsheets. You'll learn how to improve data entry and presentation with effective design techniques and practical exercises.

Make Better Decisions with Logical Functions

In this module, we will dive into logical functions that enable you to make smarter decisions with your data. You'll explore various conditional functions and practice using them for error handling and formatting in Excel.

Work with Lookup Formulas

In this module, we will explore lookup formulas to help you retrieve data efficiently. You'll practice applying both basic and advanced lookup techniques to manipulate large datasets and simplify data retrieval.

Sort and Filter Like a Pro!

In this module, we will enhance your ability to sort and filter data effectively. Learn advanced sorting techniques and dynamic filtering functions to extract and organize valuable insights from complex datasets.

Compare Data

In this module, we will focus on comparing data sets, utilizing both visual and formula-based approaches. You'll practice identifying duplicates and refining your data for more accurate analysis.

Statistical Functions

In this module, we will explore essential statistical functions that help summarize and analyze data. You'll learn to calculate averages, ranks, and advanced statistical summaries to draw meaningful conclusions from your datasets.

Math Functions

In this module, we will cover the key math functions in Excel, including various rounding techniques. You'll practice applying these functions to control the precision of your calculations and manage numeric data effectively.

Formatting

In this module, we will explore Excel's formatting capabilities, focusing on custom and conditional formatting. Learn how to format data dynamically for better presentation and understanding.

Work with Date and Time

In this module, we will work with date and time functions in Excel. You'll learn how to manage date formats, perform date calculations, and handle specialized tasks like calculating workdays and projecting future dates.

Text and Array Manipulation

In this module, we will focus on advanced text and array manipulation. You'll learn how to clean, split, and join data to streamline your datasets for better analysis and decision-making.

Analyze Data with PivotTables

In this module, we will explore the power of PivotTables. You'll learn how to create and manipulate PivotTables to summarize data, organize it, and present it in meaningful reports.

Pivot Charts

In this module, we will learn how to create and format PivotCharts, enabling you to visualize your PivotTable data more dynamically. Explore advanced formatting and map charts to enhance your reports.

Add Interaction to PivotTables and Charts

In this module, we will focus on adding interactive elements to PivotTables and charts. You'll learn how to insert and format slicers and timelines for dynamic data filtering and enhanced user interactivity.

Formula Auditing

In this module, we will cover formula auditing techniques. You'll learn how to trace errors, evaluate formula relationships, and troubleshoot common issues to ensure accurate Excel formulas.

Data Validation

In this module, we will explore data validation techniques in Excel. Learn to implement drop-down lists, input messages, and error alerts to manage data entry and ensure accuracy.

What-If Analysis Tools

In this module, we will dive into Excel's what-if analysis tools. You'll learn to use Goal Seek, data tables, and Scenario Manager to evaluate different scenarios and calculate potential outcomes.

Microsoft Excel 365 Intermediate – Conclusion

In this module, we will wrap up the course by reviewing the key concepts and skills you've learned. You'll also get a preview of the advanced Excel topics that follow, helping you apply your knowledge in practical scenarios.