Basics Of Ms Excel - A Beginner Course

Simple and comprehensive course to learn MS Excel for real world application

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