30 Days Excel Crash Course

Microsoft Excel Basics to Advance

What you'll learn

Microsoft Excel (Basics to Advance)

Interactive Dashboard

VBA Basics

Advanced Data Validation

Tricks and Tips

Power Pivot

Requirements

No experience of Excel required. I will start from basics.

Description

In this course, you will learn everything you need to master Microsoft Excel, from the basics to advanced techniques. We’ll cover the foundational concepts of Excel, including cell formatting, data entry, and navigation. As you progress, you’ll dive into more complex topics such as advanced Excel formulas, data analysis, and creating interactive dashboards. You’ll also discover powerful Excel tricks and tips to boost your productivity, helping you work more efficiently and effectively.The course also includes an introduction to VBA (Visual Basic for Applications), which will enable you to automate tasks and streamline your workflows. You'll learn how to write simple macros to perform repetitive tasks and customize Excel to suit your needs. Additionally, we’ll explore Power Pivot, a powerful tool for data modeling and analysis, allowing you to work with large datasets and create complex reports easily.Along the way, you'll also become proficient in Excel shortcuts, saving you time and making you more proficient in using the software. By the end of this course, you'll have the skills and confidence to tackle any Excel-related challenge, whether it’s for personal use, work, or professional projects. With clear, step-by-step lessons, you'll be able to learn at your own pace and apply your knowledge immediately.

Overview

Section 1: 30 Days Excel Crash Course

Lecture 1 Day 1

Lecture 2 Day 2

Lecture 3 Day 3

Lecture 4 Day 4

Lecture 5 Day 5

Lecture 6 Day 6

Lecture 7 Day 7

Lecture 8 Day 8

Lecture 9 Day 9

Lecture 10 Day 10

Lecture 11 Day 11 i

Lecture 12 Day 11 ii

Lecture 13 Day 12

Lecture 14 Day 13

Lecture 15 Day 14

Lecture 16 Day 15

Lecture 17 Day 16

Lecture 18 Day 17

Lecture 19 Day 18

Lecture 20 Day 19

Lecture 21 Day 20

Lecture 22 Day 21

Lecture 23 Day 22

Lecture 24 Day 23

Lecture 25 Day 24

Lecture 26 Day 25

Lecture 27 Day 26

Lecture 28 Day 27

Lecture 29 Day 28

Lecture 30 Day 29

Lecture 31 Day 30

Microsoft Excel Beginners,Microsoft Excel Advanced Users,Data Analyst,Dashboards Creators