Master Excel with Practical real world scenarios

Master Excel with Practical real world scenarios, available at $19.99, has an average rating of 4.45, with 18 lectures, 5 quizzes, based on 10 reviews, and has 1011 subscribers.

You will learn about Introduction to Excel How to manage spreadsheets, Formulas & Functions Charts & Graphs Practical scenarios to explain pivot table, power query, forms and many other concepts This course is ideal for individuals who are Beginners in Excel It is particularly useful for Beginners in Excel.

Enroll now: Master Excel with Practical real world scenarios

Summary

Title: Master Excel with Practical real world scenarios

Price: $19.99

Average Rating: 4.45

Number of Lectures: 18

Number of Quizzes: 5

Number of Published Lectures: 18

Number of Published Quizzes: 5

Number of Curriculum Items: 23

Number of Published Curriculum Objects: 23

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Introduction to Excel
How to manage spreadsheets, Formulas & Functions
Charts & Graphs
Practical scenarios to explain pivot table, power query, forms and many other concepts

Who Should Attend

Beginners in Excel

Target Audiences

Beginners in Excel

This Course will teach you Microsoft Excel using practical real world situations and scenarios. The skill set acquired here will be directly applicable in your job or projects. This is a beginner level course but has plenty of material for experienced people to learn including pivot tables, power query, Gantt charts, expense trackers, data entry forms, VLOOKUP, time value of money, NPV and many more concepts.

The first five sections are for learning Excel Foundations. You will learn about working in Excel and following every lesson will prove extremely beneficial for you, if you are new to MS Excel.

The 6th and the largest sections is filled with many case studies, where you will see MS Excel’s power used in actual situations. This section also includes some much needed and less known tips as well. Some of the Topics are given below:

Data Validation

Flashfill

Gantt Chart in Excel from scratch

How to make Monthly expense tracker for Family

Making data entry forms without coding

Power Query Intro and use on actual data

Using the NPV function to understand the time value of money

Using Vlookup in serial fashion to compare two lists

These lectures and real world cases are intended to bring you at par with an intermediate user of Excel. However, polishing any skill requires practice. You can call it “sharpening the saw” as Stephen covey puts it. The best way to learn Excel is to get your hands dirty and apply all these concepts by hand. Only then you will learn something that will stay with you for life.

Course Curriculum

Chapter 1: Introduction + Lesson 1

Lecture 1: Introduction

Lecture 2: Interface, Data Entry, Basic Formulae, Profit Loss

Chapter 2: Lesson 2

Lecture 1: Data Duplication methods, Fill Handle, cell types, formatting

Chapter 3: Lesson 3

Lecture 1: Structure of Formula, Cell Reference, Relative & absolute reference

Chapter 4: Lesson 4

Lecture 1: Structure of complex formula and Introduction to Functions

Chapter 5: Lesson 5

Lecture 1: Formula Tab, Review of SUM, Average, Min, Max, Count, Number formatting

Chapter 6: Practical examples/Case Studies with advanced concepts

Lecture 1: Using the Flashfill feature

Lecture 2: Using Vlookup in serial fashion to compare two lists

Lecture 3: Power Query Intro and use on actual data

Lecture 4: Gantt Chart in Excel from scratch

Lecture 5: How to make Monthly expense tracker for Family

Lecture 6: Data Validation

Lecture 7: Using the NPV function to understand the time value of money

Lecture 8: Making data entry forms without coding

Lecture 9: Applying pivot table on sales data

Lecture 10: Fixing a cell reference in a formula

Lecture 11: How to add Pictures as Comments in Microsoft Excel

Lecture 12: How to use Solver in MS Excel

Instructors

Athar Shah
Entrepreneur, Business and Project Management Professional

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 0 votes
4 stars: 4 votes
5 stars: 5 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu