Become A Skilled Excel User Among Your CoWorkers

Become A Skilled Excel User Among Your Co-Workers
Published 5/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

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

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