What you'll learn

Learn the most common Excel functions used in the Office

Create dynamic reports by mastering one of the most popular tools, PivotTables

Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

Curriculum

Overview of Excel Course(4:44)

Introduction to Excel

Excel Functions(21:11)

Tables and Conditional Formatting(9:43)

Lookups(17.01)

Index & Match(7:11)

Pivots, Charts and Median Function(6.47)

Dynamic Charts with Power of sumifs(2:34)

Introduction to VBA(14:22)

Challenge Logistic Orders Data

Challenge Towers

Challenge Course Order

Challenge Donation

Challenge Shift

Problem Statement(4.17)

Using Excel Solver

Detailed Solution(7.29)

Excel Slides

Why you should take this course?

Excel Course is the perfect way to improve your Excel skills! This comprehensive course covers everything from the basics of Excel to more advanced features, and is designed to help you get the most out of this essential tool.



Whether you're new to Excel or looking to brush up on your skills, Excel Course has something for everyone. With over 50 lessons and exercises, you'll learn how to use Excel like a pro in no time.



Some of the things you'll learn include:



- How to create and format spreadsheets



- How to enter and manipulate data



- How use formulas and functions



- How to create charts and graphs



- How to use pivot tables



- And much more!



With Excel Course, you'll be able to take your Excel skills to the next level and become more confident and efficient in your work. Whether you're using Excel for personal or professional purposes, this course will give you the foundation you need to be successful. enroll today and start learning Excel the right way!

Bonus