Introduction to Microsoft Excel
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to Microsoft Excel to your Wishlist.

Add to Wishlist

Introduction to Microsoft Excel

Learn MS Excel Basics - Calculations, Formatting, Mathematical Funcations
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7 students enrolled
Created by Binny Mathews
Last updated 4/2013
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Get Job ready, by mastering MS Excel as a business tool
  • At the end of this course, you will learn how to generate professional, presentable work efficiently using MS Excel
  • Learn skills like formatting, functions, filter, sort, VLOOKUP
View Curriculum
Requirements
  • None. This course does not require you to have any prior knowledge of Excel. It starts from the basics and is easy to follow
Description

How will this Certificate benefit you

  • Get Job ready, by mastering MS Excel as a business tool
  • At the end of this course, you will learn how to generate professional, presentable work efficiently using MS Excel

What Jobs does this Certificate prepare you for

If you are a Working Professional or College Student, interested in one of the following careers, then this course will help you:

  • Business Analyst in Management Consulting firms such as McKinsey, Bain etc
  • Financial Analyst positions in Investment Banking or Corporate Banking divisions of companies such as Morgan Stanley, Credit Suisse, ICICI etc
  • Strategy Executive in Corporate Finance departments of large companies
  • Operations role in MNC's and other companies

How will you learn

  • 100% Online self-paced course that you can watch from anywhere, any number of times
  • 11 online videos that can be completed in 1 week

Why do I need to take the course "Introduction to Microsoft Excel"?

Today, MS Excel is a critical tool for any kind of business job profile. Knowledge of MS Excel increases your efficiency at work and you can get more work done in less time.

The best business experts, will teach you MS Excel using real-life industry case studies. At the end of this course you will be able to confidently use MS Excel to analyse data, make graphs, presentations etc.

Management jobs such as the one in Financial Services and Business Consulting are extremely competitive. There are thousands of well qualified applicants for every open position. This course will significantly improve your chances of a successful career since you will learn the exact skills that industry is looking for.

Course Contents

1. Introduction to Microsoft Excel

  • Introduction to Microsoft Excel
  • How to format cells to make them look more professional
  • How to manipulate rows and columns
  • How to format numbers
  • How to format currency and date
  • How to perform calculations in Excel - Add, Subtract, Multiply, divide
  • How to use the Max, Min and IF functions
  • How to use Filter and Sort to work with large data sets
  • How to combine multiple cells using Concatenate
  • How to locate values in a table using VLOOKUP
  • How to generate graphs to make data more presentable

Who is the target audience?
  • Anybody interested in learning Excel Basics
  • High School students
  • College Students
  • Working Professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
01:31:06
+
Introduction to Microsoft Excel
1 Lecture 04:56
This module talks about introduction to Excel and what all will be covered in this course
Introduction to Microsoft Excel
04:56
+
Formatting
4 Lectures 35:13
How to format cells to make them look more professional – Learn how to do basic formatting of MS Excel so your work looks more professional
How to format cells to make them look more professional
08:53

How to manipulate rows and columns – Learn the various ways you can use rows and columns in Excel
How to manipulate rows and columns
08:32

How to format numbers – Learn how to display numbers in various decimals, rounded, %, comma separated etc
How to format numbers
08:42

How to format currency and date – Learn how to represent money and date timelines in excel
How to format currency and date
09:06
+
Calculations
2 Lectures 19:24
How to perform calculations in Excel - Add, Subtract, Multiply, divide – Learn how to use mathematical operators to add, subtract, multiply, divide etc
Preview 10:58

How to use the Max, Min and IF functions – Learn how to pick a value based on a mathematical operator from a huge range of values.
How to use the Max, Min and IF functions
08:26
+
Handling Data
4 Lectures 28:58
How to use Filter and Sort to work with large data sets - Learn how to arrange values based on a mathematical operator from a huge range of values.
How to use Filter and Sort to work with large data sets
06:18

How to combine multiple cells using Concatenate – Learn how to merge cells for formatting purposes
How to combine multiple cells using Concatenate
02:35

How to locate values in a table using VLOOKUP – Learn how to pick a value based on a mathematical operator from a huge range of values.
How to locate values in a table using VLOOKUP
05:53

How to generate graphs to make data more presentable – Learn how to arrange date, and pick the right graphs to represent the data to make your presentations look more professional.
How to generate graphs to make data more presentable
14:12
+
Summary
1 Lecture 02:35
This module goes over all the topics that were covered in this course.
Conclusion
02:35
About the Instructor
Binny Mathews
4.2 Average rating
65 Reviews
4,866 Students
4 Courses

Highlights

  • Investment Banker, Credit Suisse, New York & San Francisco
  • Sales and Business Development Manager – Quinstreet – World leader in online education
  • M.S in Computer Science, Washington University in St.Louis

Detailed Bio

Binny's expertise is in Corporate Finance, Online Education and Entrepreneurship.  

Binny was a Senior Analyst in the Investment Banking Division at Credit Suisse (New York & San Francisco) working with clients in Media and Technology. At Credit Suisse he worked on transactions over US$25 billion including the SBC-AT&T Merger, Dice.com IPO and First Solar IPO apart from advising clients such as Comcast, Tribune, Global Crossing, eBay, Yahoo, Comcast and Level 3.

Binny graduated with a M.S in Computer Science and Engineering from Washington University in St.Louis, where he was a Graduate Student Representative. At WashU, Binny worked on an Image Sensor module that was part of a space mission.