Excel 365 Advanced – Power Features and Automation

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

11 hours 21 minutes
Sessions

Self-Paced
Level

Advanced
Subtitles

English

Found in

Part of

Master Microsoft Excel & 365 Apps: Beginner to Advanced

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

Get Full Access

This course features Coursera Coach! 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. This advanced Excel 365 course equips you with essential tools to automate tasks and optimize your workflow. You will learn powerful formulas, dynamic arrays, advanced lookups, and automation tools like Macros and VBA. The course will introduce you to both foundational and cutting-edge Excel features, enabling you to manage data more efficiently while boosting productivity. The course is structured in modules, each diving deep into critical Excel features. Starting with six productivity-boosting formulas and Flash Fill, you'll quickly move into advanced topics like Dynamic Array Functions, Power Pivot, and Power Query. You'll discover new ways to analyze data with PivotTables, and then automate your tasks using Macros and VBA. In addition, you'll explore the integration of AI tools like Microsoft Copilot and ChatGPT to further enhance your workflow. This course is ideal for Excel users looking to level up their skills. Whether you're a professional analyst, a manager, or just looking to improve your Excel abilities, you'll find techniques that are directly applicable to real-world scenarios. The course is designed for those familiar with Excel and will take you from intermediate to expert-level proficiency. By the end of the course, you will be able to automate repetitive tasks, use advanced formulas for data analysis, manage large datasets with Power Pivot and Power Query, and leverage AI tools to work more efficiently with Excel.

Syllabus

Six Excel Formulas to Boost Productivity

In this module, we will explore six key Excel formulas designed to boost productivity. Each video introduces a formula that automates tasks, simplifies analysis, and streamlines data management. By mastering these formulas, you will dramatically reduce manual work and enhance your Excel skills.

Microsoft Excel 365 Advanced – Course Introduction

In this module, we will provide an overview of the advanced Excel 365 course. You will get a detailed understanding of the course structure and what to expect as you dive into complex Excel features. We’ll also begin with a short exercise to lay the foundation for more in-depth topics.

Dynamic Array Formulas

In this module, we will dive into dynamic array functions, starting with understanding what they are and how they work. You'll learn how to use these functions to manage large datasets, filter data, and apply dynamic sorting. These techniques will help you handle complex data analysis tasks more efficiently.

Advanced Lookup and Reference Functions

In this module, we will teach you how to perform precise lookups using advanced techniques. You’ll learn how to work with multiple criteria and duplicate values, ensuring that you can handle even the most complex lookup scenarios in Excel.

Create Your Own Functions

In this module, we will focus on creating your own functions in Excel. You’ll learn how to simplify complex formulas using the LET function and design custom, reusable functions with LAMBDA. These tools will help you work more efficiently with advanced calculations.

Power Pivot

In this module, we will explore Power Pivot, a powerful tool for handling large datasets. You’ll learn how to create robust data models, establish relationships between tables, and generate PivotTables from multiple sources to analyze complex data seamlessly.

Working with Power Query

In this module, we will guide you through the process of importing, cleaning, and transforming data using Power Query. You'll also learn how to combine multiple files into a single dataset and how to refresh your data models to ensure they stay up-to-date.

Advanced PivotTables and Pivot Charts

In this module, we will focus on refining your PivotTable and PivotChart skills. You will learn how to create customized styles, apply number formatting, and integrate advanced features to enhance data presentation. These techniques will give you a deeper understanding of complex data analysis.

Form Controls and Checkboxes

In this module, we will introduce you to form controls in Excel, enhancing interactivity in your workbooks. You’ll explore how to use checkboxes, combo boxes, and other controls to create user-friendly, dynamic spreadsheets. Practical exercises will help reinforce these concepts.

Macros and VBA

In this module, we will guide you through automating tasks using macros and VBA. You’ll learn how to record macros, write custom VBA code, and apply them to create more powerful, efficient Excel workflows. With multi-step macros, you’ll save time on complex tasks.

AI Tools (Microsoft Copilot and ChatGPT)

In this module, we will explore the capabilities of Microsoft Copilot and ChatGPT for enhancing your Excel experience. You'll learn how to use AI tools to automate data creation, solve Excel queries, and streamline workflows. Practical exercises will demonstrate their full potential.

Microsoft Excel 365 Advanced – Course Close

In this final module, we will conclude the advanced Excel 365 course by summarizing the key takeaways. You will gain insights into the next steps for advancing your Excel skills and applying your knowledge in practical, real-world scenarios.