Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Become a skilled Excel user among your co-workers

Become a skilled Excel user among your co-workers

Logical functions, advanced cell referencing, and text functions that make you work faster
Last updated 5/2025
English

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

Course content

5 sections • 10 lectures • 52m total length
  • Introduction1:19
  • The Microsoft excel Interface1:47

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 Data

This 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

Who this course is for:

  • 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