Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

Introduction to Microsoft Excel

Learn MS Excel Basics - Calculations, Formatting, Mathematical Funcations
Rating: 3.5 out of 53.5 (3 ratings)
17 students
Created by Binny Mathews
Last updated 4/2013
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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

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 this course is for:

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

Course content

5 sections • 12 lectures • 1h 31m total length

  • Introduction to Microsoft Excel
    04:56

  • How to format cells to make them look more professional
    08:53
  • How to manipulate rows and columns
    08:32
  • How to format numbers
    08:42
  • How to format currency and date
    09:06

  • Preview10:58
  • How to use the Max, Min and IF functions
    08:26

  • How to use Filter and Sort to work with large data sets
    06:18
  • How to combine multiple cells using Concatenate
    02:35
  • How to locate values in a table using VLOOKUP
    05:53
  • How to generate graphs to make data more presentable
    14:12

  • Conclusion
    02:35

Instructor

Binny Mathews
Binny Mathews
  • 3.7 Instructor Rating
  • 283 Reviews
  • 5,586 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. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.