Microsoft Excel for Beginners

A to Z of Excel in one course. Learn everything from start.

4.35 (33 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Microsoft Excel for Beginners
884
students
2 hours
content
Jun 2023
last update
FREE
regular price

What you will learn

Master Microsoft Excel for your daily work

Make use of functions such as SumIfs, CountIfs and AverageIfs for your analysis

Work with logical and conditional operators along with functions to analyze data based on certain criterias

Create beautiful and easy to understand Charts in Excel for Data Visualization

Why take this course?

Are you looking to learn Excel, but finding it very difficult with all the technical jargons and concepts been thrown around?

Are you looking to make your life easier and make Excel work for you and save time?

Then you are at the right place. Excel is one of the most widely tool use for various kinds of tasks and makes your life easy at work. If you do not know how to use excel, you are missing on a superpower that Excel provides in your work. So buckle up and learn with us and become a superhero at work.

This course does not require you to have any pre-requisite knowledge or skills. This course will teach everything from beginning. This course has got you covered for everything.


In this course, you will learn the following:

Excel Introduction: Here you will learn how excel is structured. You will learn about Excel Worksheets, cells, and tabs. You will learn about Cell Referencing and its importance.

Excel Operators: In this section, how to write a function in Excel and make use of different functions and operators, such as logical operators and conditional operators, which are available in Excel.

Excel Data Analysis: Excel is widely used to analyse data and build models. Here you will learn how you can analyse data using Pivot, VlookUp and create various charts and dashboards for Data Visualization.


Learn from the best:

The Trainer of this course is an Ex-fund manager, Equity research analyst and CFA charter holder

· Extensive experience with fund management in alternative investments

· Lead Trainer at – Mentor Me Careers

· Vast 11 Years of Experience in Fund Management, Product Management & Entrepreneurship.

· Trained 3000+ students in premier institutions

· Renowned Visiting Faculty in top tier 1 MBA colleges

· Ex-Partner- Ennovate Research Investment and Capital, Hedge Fund


What do you get:

· Well-designed focussed content on explaining concepts and building skills

· Extensive question bank and case studies for practice

· Downloadable course materials

· Regular course updates

· Forum doubt-solving answers quickly


About this Course

· This course has 30-day Money Back guarantee. We believe in providing value to the student. So, you get to explore the course and make an informed choice.

· You will get 24x7 doubt solving access.

· All concepts covered with practical application


We always strive to put student’s learning experience over everything else. So, we do look-out for your feedback on how we can improve our course and give our students a better learning experience. So, any suggestions for improving the learning experience is always welcomed.

Content

Excel Introduction - Layout

Excel Layout
Home Ribbon
Other Ribbons
Excel Layout Quiz

Excel - Cell Referencing

Relative Referencing
One Dimentional Data Table
Relative Referencing Quiz

Excel Daily Functions

Excel Functions
Daily Excel Function - Quiz
Daily Excel Functions Quiz
Solution File - Daily Excel Functions

Excel Logical Operators

The need for logical operators
IF Function
Nested IF Function
Logical Operator Quiz

Excel Conditional Operators

Conditional Operators
Conditional Operator Quiz
Conditional Operator Quiz

Pivot Table and VlookUp

Pivot Table
Pivot Table Quiz
VlookUp
VlookUp - Index & Match
VlookUp - Index & Match Quiz

Excel Data Visualization

Excel Charts
Data Visualization - Best Practices

Insurance Analysis Case Study

Case Study File
Analysis Questions
Solution File

Market Crash Indicator

Case Study File
Market Crash Indicator - Quiz
Solution File

Screenshots

Microsoft Excel for Beginners - Screenshot_01Microsoft Excel for Beginners - Screenshot_02Microsoft Excel for Beginners - Screenshot_03Microsoft Excel for Beginners - Screenshot_04

Charts

Price

Microsoft Excel for Beginners - Price chart

Rating

Microsoft Excel for Beginners - Ratings chart

Enrollment distribution

Microsoft Excel for Beginners - Distribution chart
4848444
udemy ID
8/24/2022
course created date
9/12/2022
course indexed date
Bot
course submited by