Become A Skilled Excel User Among Your Co-Workers

Logical functions, advanced cell referencing, and text functions that make you work faster

What you'll learn

Know the best Microsoft Excel shortcuts to make you stand out at work

Understand how to approach different datasets

Understand the building blocks data and how to manipulate it

Work on a real-life dataset to boost your experience

Requirements

No prior experience needed but basics of Microsoft Excel will be beneficial

Description

Understand how to use various formulas and functions to become a better and faster user of Microsoft Excel in whatever field you are in. Course Description: Microsoft Excel Essentials – Unlocking the Power of DataThis comprehensive Microsoft Excel course is designed to equip learners with practical skills to analyze, manage, and present data efficiently. The course focuses on essential Excel functions and tools that enhance productivity and support data-driven decision-making.Participants will master logical functions such as `IF` to create dynamic formulas that respond to various conditions. The course also explores Pivot Tables, a powerful feature for summarizing large data sets and generating insightful reports with just a few clicks.Learners will understand cell referencing—absolute and relative—and how it affects formulas when copied or moved, enabling better control over data manipulation. Additionally, the course covers text functions like TEXT TO COLUMNS, `CONCATENATE`, and `TEXTJOIN`, which are essential for cleaning and restructuring text data.The course also delves into **date functions** such as `TODAY`, `WEEKDAY`, `, and `DAYS`, teaching students how to perform date calculations and automate time-sensitive tasks.Ideal for beginners and intermediate users, this hands-on course uses real-world examples to build confidence and proficiency in Excel, laying a strong foundation for roles in administration, finance, analysis, and beyond. in. We will utilize Logical functions, Pivot Table, Cell referencing, Text functions, and Date Functions. We will attempt to have various problems using different methods and discover which is faster and more efficient

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 The Microsoft excel Interface

Section 2: Cell Referencing

Lecture 3 Cell Referencing Intro

Lecture 4 Understanding Data and Absolute Cell Referencing

Lecture 5 Absolute Cell Referencing: Putting it all together

Section 3: Pivot Table

Lecture 6 Pivot Table

Section 4: Logical, Text, and Date Functions

Lecture 7 If Logical Function

Lecture 8 Text Functions

Lecture 9 Date Functions

Section 5: Conclusion

Lecture 10 Conclusion

Either you are just starting your career or you are a professional, you will learn how to best use Excel for your day to day tasks