Excel Functions and Formulas

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

5 hours 34 minutes
Sessions

On-Demand
Subtitles

English

Found in

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

Grab it

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. Unlock the full potential of Excel with this comprehensive course on Excel functions and formulas. Whether you're a beginner or intermediate user, you'll gain the skills to efficiently manage data, perform complex calculations, and automate tasks to enhance your productivity. Through step-by-step guidance, you'll learn everything from basic formulas to advanced array functions, giving you a deep understanding of Excel's power and versatility. This course also covers key Excel features like cell references, logical functions, text manipulation, and data analysis techniques, ensuring that you can confidently use Excel in any professional setting. The course begins with foundational concepts like cell references and copying formulas, leading into practical topics such as managing large datasets with count, sum, and date-time functions. You'll then explore logical functions for decision-making, followed by powerful lookup and reference tools like VLOOKUP. The latter part of the course delves into rounding, statistical functions, and text manipulation to handle more complex data operations. You’ll also learn how to master array formulas to simplify large-scale data calculations. Designed for anyone looking to enhance their Excel skills, this course is perfect for professionals working with data, students, or anyone aiming to use Excel more efficiently. No prior Excel knowledge is required, but a basic understanding of spreadsheets will be helpful. This course is suitable for beginners, but it will also provide valuable insights for intermediate users looking to take their skills to the next level. By the end of the course, you will be able to confidently use Excel to manage complex data, perform advanced calculations, create dynamic reports, and automate repetitive tasks, enhancing both your efficiency and productivity.

Syllabus

Functions & Formulas - Cell References

In this module, we will dive into the foundational aspects of Excel’s cell references. You will learn how to set cell references correctly, master the art of copying formulas, and use absolute references to ensure formulas work across different cells. By the end of this section, you'll be able to work with large datasets efficiently, saving time and reducing errors.

Functions & Formulas - Count and Sum

In this module, we will explore powerful counting and summing functions in Excel. You’ll learn to quickly calculate sums and counts based on various criteria and handle more complex analysis with functions like SUMPRODUCT. By the end, you will be proficient in handling large datasets and deriving meaningful insights from them.

Functions & Formulas - Date & Time

In this module, we will focus on how to manage date and time data in Excel. You’ll learn to enter and manipulate dates, use date-related functions, and format them appropriately for your needs. This section will also teach you how to find critical time-based information like the last day of the month.

Functions & Formulas - Logical

In this module, we will explore how to use Excel’s logical functions to automate decision-making and data evaluation. You’ll learn to build complex formulas using IF, OR, and SWITCH to analyze data based on multiple conditions. By the end of this section, you'll be able to craft logical expressions that streamline data analysis and problem-solving in Excel.

Functions & Formulas - Lookup & Reference

In this module, we will delve into Excel’s lookup and reference functions to help you efficiently search and retrieve data. You will gain a thorough understanding of VLOOKUP and other lookup techniques, enabling you to extract critical information from large datasets with ease.

Functions & Formulas - Round

In this module, we will explore the essential rounding functions in Excel. You will learn to round numbers to the desired decimal places and remove unnecessary decimals, helping you present data more clearly and professionally. By the end of this section, you will be able to work with numbers in a way that best suits your analytical needs.

Functions & Formulas - Statistical

In this module, we will explore the statistical functions available in Excel. You will learn to apply functions like AVERAGE, RANK, and STDEV to analyze and interpret your data. By mastering these functions, you’ll be equipped to make data-driven decisions and draw meaningful conclusions from your datasets.

Functions & Formulas - Text

In this module, we will cover essential text manipulation techniques in Excel. You will learn how to extract, combine, and clean text data using functions like TEXT, CONCATENATE, and SEARCH. By the end of this section, you’ll be able to handle large text-based datasets with ease.

Functions & Formulas - Array Formulas

In this module, we will dive into the world of array formulas, a powerful tool for handling complex calculations in Excel. You will learn how to apply these formulas to calculate data in large datasets, identify unique values, and solve intricate problems like summing every nth row. By mastering array formulas, you'll be able to tackle more advanced Excel tasks with ease.