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
$20
Take This Course
  • Lectures 12
  • Contents Video: 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2013 English

Course 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

What are the 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

What am I going to get from this course?

  • 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

What is the target audience?

  • Anybody interested in learning Excel Basics
  • High School students
  • College Students
  • Working Professionals

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to Microsoft Excel
04:56
This module talks about introduction to Excel and what all will be covered in this course
Section 2: Formatting
08:53
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
08:32
How to manipulate rows and columns – Learn the various ways you can use rows and columns in Excel
08:42
How to format numbers – Learn how to display numbers in various decimals, rounded, %, comma separated etc
09:06
How to format currency and date – Learn how to represent money and date timelines in excel
Section 3: Calculations
10:58
How to perform calculations in Excel - Add, Subtract, Multiply, divide – Learn how to use mathematical operators to add, subtract, multiply, divide etc
08:26
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.
Section 4: Handling Data
06:18
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.
02:35
How to combine multiple cells using Concatenate – Learn how to merge cells for formatting purposes
05:53
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.
14:12
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.
Section 5: Summary
02:35
This module goes over all the topics that were covered in this course.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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. 

Ready to start learning?
Take This Course