Basics Of Ms Excel - A Beginner Course

What you'll learn
MS Excel Practical Applications
Requirements
No prerequirements
Description
Welcome to your course "Basics of MS Excel - A Beginner Course". Microsoft Excel is used in all types of industries and professions & relevant for every Finance & Non-finance Executives to prepare reports, critical documents, analysis, etc. You can learn Excel with this engaging online course at ease & it will give you a more in-depth look without ignoring key factors. Why learn Excel?Developing your Excel skills using online resources could improve your employment prospects without the need to spend a lot of money on college courses. Seeing as how Excel is so prominent in the workforce, it pays to learn all about it and put that experience on your resume. Who should take this course?Now a days every person uses Microsoft Excel for various purposes. Mainly Students, Teachers, Professors, Finance Executives, Non-finance Executives, Accountants, Entrepreneur, Analysts, Consultants, Marketing professionals and Bankers all of them use Excel on a consistent basis. Hence, this course is relevant for all above.How this course will benefit you?At the end of the course,you automatically make yourself more valuable in the modern day workforce. Excel is one of the most useful tools in the Microsoft Office suite, and learning how it works can improve your job prospects and help you to be more confident in your use of analytics and mass data. Excel is one of the most useful tools in the Microsoft Office suite and used by every single individual in the world and if you are lacking the in-depth knowledge about Excel, then you are at your right time - Our course is in front youWhat you will learn by taking this course?- Excel Basics- Financial Statements, understanding of references and Ratios- Some Basic Text Functions- SUM IF Function- Logical Functions – IF, AND, OR and Nested If - VLOOKUP made simpleSee you inside the course!!!
Overview
Section 1: Excel Basics
Lecture 1 Arithmetical Operations
Lecture 2 Formulas Basics
Lecture 3 Relational Operators
Lecture 4 Tips to be Fast in Excel
Lecture 5 Functions Basics
Lecture 6 Editing A Formula
Section 2: Financial Statements, understanding of references and Ratios
Lecture 7 Financial Statements
Lecture 8 Ratios
Lecture 9 Relative Reference and Absolute Reference Advanced
Lecture 10 Relative Reference and Absolute Reference Basic
Section 3: Some Basic Text Functions
Lecture 11 Text Functions
Section 4: SUM IF Function
Lecture 12 Sum If Function
Section 5: Logical Functions – IF, AND, OR and Nested If
Lecture 13 If Function
Lecture 14 Nested If Function
Lecture 15 If And or Functions
Section 6: VLOOKUP made simple
Lecture 16 V Lookup Function 1
Lecture 17 V Lookup Function 2
Lecture 18 V Lookup Range Lookup Function
Lecture 19 V Lookup & Match Function
Section 7: Last Section
Lecture 20 Bonus Lecture
Students,Teachers,Professors,Finance Executives,Non Finance Executives,Data Entry Operators


Homepage

https://www.udemy.com/course/basics-of-ms-excel-a-beginner-course/

Basics Of Ms Excel - A Beginner Course Fast Download
Basics Of Ms Excel - A Beginner Course Full Download