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
IT & Software Operating Systems Excel

Microsoft Excel - Beginner to Advanced

Learn by doing in small, easy to understand I Excel with this A-Z MS Excel Course. Microsoft Excel 2010, 2013, 2019
Rating: 4.7 out of 54.7 (5 ratings)
21 students
Created by Urs Ravi I Vedanta Educational Academy
Last updated 9/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Microsoft Excel Basics, Advanced & Pro
  • An Introduction to Microsoft Excel
  • How to Open MS Excel, What is Menus, Tools, Sheets, Columns, Rows & Cells
  • MS Excel - Copy Cells, Move Cells
  • Learn How to Create Tabs, Groups and add Toll to it in MS Excel
  • MS Excel - Home Tab - Group Clipboard Features Functions Explained
  • MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold
  • Home Tab - Alignment Group Explained - Merge, Wrap Text, Alignments & more
  • MS Excel - Characteristics of Cell
  • Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsoft
  • MS Excel - Fill Series - with formatting, without formatting & more
  • Fill Series - Advance Fill - Numbers, Months, Days, Custom List Edit & Add
  • Fill Series - Flash Fill
  • Excel - Editing Data I over writing I Go to I find & replace I undo & redo
  • MS Excel - Text to Columns
  • MS Excel - Comments - add, edit, delete & Show all
  • MS Excel - How to Hide and Unhide Rows, Columns, Sheets
  • Freeze Panes - Top Row, Columns & Multiple Rows & Columns
  • MS Excel - Filters - Learn How to Use Filter to analyse Big Data
  • MS Excel - Split Sheet Window
  • MS Excel - How to Insert & Delete Cells, Rows, Columns
  • MS Excel - Working with Sheets
  • MS Excel - Format Multiple Sheets at a time I Sheet Formatting
  • MS Excel - View Sheets Side by Side from One Excel File
  • MS Excel - Workbook Protection - Learn how to setup a Password to open Excel
  • MS Excel - Sheet & Cells Protection
  • MS Excel - Conditional Formatting - Highlight Cells Via Number, Text & more
  • Concatenate - Join Multiple Text Strings into ONE
  • MS Excel - Trim Functions - Remove unnecessary Elements from strings
  • MS Excel - Print Formulas Left, Right, Middle
  • MS Excel - Date Related Formulas
  • MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New
  • MS Excel - Page Header & Footer I Add Page Numbers, Logo, Report Name, Date
  • MS Excel - Print, Page Setup, Margins, Size, Excel to PDF
  • MS Excel - Create & Remove Drop Down List
  • Introduction to Data Validation - Time limitation
  • Data Validation - Restrict Cells, Input & Error Message, Drop Down List...
  • Data Validation - Part2 - Circle Invalid data, Error, Stop, Warning, Inform-
  • Data Validation - Dependent - Multiple Drop Down Lists
  • MS Excel - Bar Code I Install Bar code font I Generate Bar Codes
  • MS Excel - Import Data from Websites - Live Data
  • MS Excel - Import Data from Text Document - with Auto Refresh
  • MS Excel - Import - Text, Word, PPT, JPEG, Video, PDF & More Objects
  • MS Excel - Charts - Pie Charts - Create & Customize I Chart Elements
  • MS Excel - Charts - Columnar, Bar, Line Charts
  • Logical Functions - Logical Test I Boolean Expression I TRUE or FALSE I
  • Logical Test - IF Function
  • Logical Functions - Nested IF - Learn How to work with Nested if Formula
  • Logical Functions - AND function
  • Logical Function - Not & IFERROR
  • MS - Excel Commonly Used Formulas I Sum I Subtraction I Avg I Percentage I Mu
  • Statistical Formulas - Sum, Sumif, Sumifs, Count, Countif, Countifs, Avg, Av
  • MS Excel - 3D Sum I Calculate Multiple Sheet Data at a time
  • MS Excel - Consolidate ( 3d Sum extension)
  • Show Formula, Trace Dependents, Trace Precedents, Evaluate Formula, Formula
  • Formulas - sumproduct, mround, floor, ceiling
  • Index Formula - Find a Position of the Value, and Call cells references
  • Match Formula - Find Position of the Value
  • MS Excel - Age Calculator in Multiple Ways - Exclusive formula
  • Student Mark Sheet Calculation - Sum, Average, Rank, Grade, Pass-Fail, Status
  • V Lookup - Introduction
  • V Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
  • H Lookup - Formula, Functionality, Rules, Approximate & Exact Match & more
  • X Lookup - Introduction
  • Download, Add & use X Lookup New Formula in MS Excel
  • X Lookup New Formula in MS Excel
  • Pivot Table Introduction & Basics of Pivot Table
  • Create a Pivot Chart from Table & Pivot Table
  • Pivot Table - Use slicers to filter data
  • Pivot Table, Charts, Progress Dashboard
  • MS Excel Calculate EMI I Prepare Loan Statement I Principal I Interest
  • Working with Tables
  • Create & Maintain Registers - Using GroupSheets, Drop Down Lists, Date Valid
  • Share a workbook with Co Authors, Employees or with Anyone
  • Commission Calculation in MS Excel
  • Attendance Sheet Preparation in MS Excel
  • Salary Calculation with CA, DA, Commission, Advance, PF, ESI
  • Open-Create-Save-Close of Microsoft Excel

Requirements

  • A Desire to learn a valuable skill!

Description

Do you want to learn how to work with Excel ?

Even if you don’t have any prior experience?

If so, then this is the right course for you!


A Verifiable Certificate of Completion is presented to all students who complete this course.

Microsoft Excel 2019 is here, and it promises to be one of the greatest versions that we’ve seen so far.

However, it’s essential that you learn how to work with it effectively.

If you want to become any of the following…

  • Executive Assistant

  • Office Clerk

  • Auditor

  • Accountant

  • Business Analyst

  • Financial Analyst

  • Credit Counselor

  • Sales Representative

  • Sales Manager

  • Financial Manager

  • Investment Banker

  • Real Estate Agent

  • Market Research Analyst

  • Financial Advisor

  • Business Operations Manager

  • Entrepreneur

  • Someone who is involved with a business and would like to be successful

Then you simply have to learn Microsoft Excel 2019. There is no way around it.

But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?

Microsoft Excel 2019 Beginners & Intermediate Excel Training is here for you. One of the best Excel courses available on Udemy, it includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will serve you well throughout your career.

What makes this course different from the rest of the Excel courses out there?

  • High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!)

  • Knowledgeable instructor (experience in Big 4 Accounting + Commercial Finance)

  • Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.)

  • Extensive Case Studies that will help you reinforce everything that you’ve learned

  • Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 24 hours

  • Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course

How come Microsoft Excel is so important?

Every large company uses it, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.

Here are 5 more reasons why you should take this course and learn Excel:

  • Jobs. A solid understanding of Excel opens the door for a number of career paths

  • Promotions. Top Excel users are promoted very easily inside large corporations

  • Bill Gates knows how to work with Excel

  • Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment

  • Girls dig guys who are proficient in Excel! Guys who can use VLOOKUP are proven to be the most popular with women J

This course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used for the purposes of Financial Modeling.

Additionally, the course includes practical case studies that will reinforce everything that you learn. One of the exercises that we will see in the course consists of building a complete Profit & Loss statement from scratch.

This course is perfect for University students, Entry-level Finance, Business and Marketing professionals who would like to grow faster than their peers.

Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?

Enroll today and let's start this journey together!

Who this course is for:

  • Anybody wants to Learn Excel
  • Executive Assistant
  • CA & CS Students
  • Office Clerk
  • Auditor Accountant Business Analyst Financial Analyst Credit Counselor Sales Representative Sales Manage
  • Financial Manager Investment Banker Real Estate Agent Market Research Analyst Financial Advisor
  • Business Operations Manager Entrepreneur
  • Someone who is involved with a business and would like to be successful

Course content

18 sections • 90 lectures • 8h 47m total length

  • Preview02:39
  • 2. Open-Create-Save-Close of Microsoft Excel
    01:28
  • Preview06:26
  • Preview01:19
  • Preview05:16
  • 7. MS Excel - Home Tab - Group Clipboard Features Functions Explained
    09:33
  • 8. MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold
    08:46
  • 9. Home Tab - Alignment Group Explained - Merge, Wrap Text, Alignments & more
    05:34
  • 10. MS Excel - Characteristics of Cell
    01:11
  • 11. Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsoft
    03:41
  • Basic tasks in Excel
    01:56
  • Section-1 Practice Test
    10 questions
  • Create New Tab's and Create New Groups, add tool in that.
    3 questions

  • 14. MS Excel - Fill Series - with formatting, without formatting & more
    02:46
  • 15. Fill Series - Advance Fill - Numbers, Months, Days, Custom List Edit & Add,
    07:11
  • 16. Fill Series - Flash Fill
    03:48

  • 6. Excel - Editing Data I over writing I Go to I find & replace I undo & redo
    05:45
  • 12. MS Excel - Text to Columns
    05:34
  • 13. MS Excel - Comments - add, edit, delete & Show all
    03:20

  • 17. MS Excel - How to Hind and Unhide Rows, Columns, Sheets
    06:06
  • 18. Freeze Panes - Top Row, Columns & Multiple Rows & Columns
    07:00
  • 19. MS Excel - Filters - Learn How to Use Filter to analyse Big Data
    07:54
  • 20. MS Excel - Split Sheet Window
    03:12
  • 21. MS Excel - How to Insert & Delete Cells, Rows, Columns
    07:27
  • 22. MS Excel - Working with Sheets
    06:50
  • 41. MS Excel - Format Multiple Sheets at a time I Sheet Formatting
    04:52
  • 23. MS Excel - View Sheets Side by Side from One Excel File
    04:15

  • 24. MS Excel - Workbook Protection - Learn how to setup a Password to open Excel
    03:35
  • 25. MS Excel - Sheet & Cells Protection
    05:12

  • 34. MS Excel - Conditional Formatting - Highlight Cells Via Number, Text & more
    05:16
  • 27. Concatenate - Join Multiple Text Strings into ONE
    01:15
  • 28. MS Excel - Trim Functions - Remove unnecessary Elements from strings
    01:33
  • 29. MS Excel - Print Formulas Left, Right, Middle
    03:26
  • 30. MS Excel - Date Related Formulas
    03:07
  • 31. MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New
    09:54
  • 33. MS Excel - Page Header & Footer I Add Page Numbers, Logo, Report Name, Date
    06:28
  • 32. MS Excel - Print, Page Setup, Margins, Size, Excel to PDF
    08:42

  • 26. MS Excel - Create & Remove Drop Down List
    08:45
  • Introduction to Data Validation - Time limitation
    01:16
  • 35. Data Validation - Restrict Cells, Input & Error Message, Drop Down List...
    13:22
  • 36. Data Validation - Part2 - Circle Invalid data, Error, Stop, Warning, Inform-
    06:06
  • 37. Data Validation - Dependent - Multiple Drop Down Lists
    06:10

  • Preview05:33

  • 38. MS Excel - Import Data from Websites - Live Data
    05:24
  • 39. MS Excel - Import Data from Text Document - with Auto Refresh
    03:14
  • 40. MS Excel - Import - Text, Word, PPT, JPEG, Video, PDF & More Objects
    09:18

  • 46. MS Excel - Charts - Pie Charts - Create & Customize I Chart Elements
    08:24
  • 47. MS Excel - Charts - Columnar, Bar, Line Charts
    09:02

Instructor

Urs Ravi I Vedanta Educational Academy
Tally&GST Guru I Tally Authorized Faculty I MS Office Expert
Urs Ravi I Vedanta Educational Academy
  • 4.1 Instructor Rating
  • 1,026 Reviews
  • 4,578 Students
  • 9 Courses

UrsRaviTelugu Chief Faculty at Tally Institute of Learning
Ravi Telugu is a Corporate Trainer with 6 Years of Training Experience on various technologies. He specializes in MS Office Tools, Tally, Focus, Wings, SAP, IBM Rational Tools, HP Testing Tools, and Software Testing.

Ravi Telugu, Cheif Executive officer at @ Vedanta Educational Academy.

Authorized partner @ Tally Solutions and also Tally Education

Instructor at Tally Institute of Learning for last 3yrs.

Signed up Top 11 Colleges for Tally & GST(more than 10,000 students)

Speaker at OU Tally & GST awareness program.

Having 4yrs experience in Tally Training center/worked as faculty in Top Institutes.

Working as accounts admin for Valam Foods Pvt LTD. Sri Varun Scales, Digitam Intellect Pvt LTD etc.

  • 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.