Learn Excel From Basics To Advanced

Learn PROPER, TRIM, INDEX, MATCH, AVERAGEIFS, WORKDAY, NETWORKDAY, CHOOSE, Combined Formulas and more.

What you'll learn

Learn from basics, open, close, save, edit and password for excel sheet.

Learn charts, tables, secret tricks and tips.

Learn advanced formulas like- Index & Match, etc.

Learn how to combine 2 formulas and get maximum benefits.

Requirements

No experience needed. Learn from scratch.

Description

Welcome to Microsoft Excel Course. Here you will learn a lot of things right from scratch. Learn How to open a file, save a file, then slowly move on to the advanced topics like How to create Dynamic Data, Using Choose, Workday, Networkday, Index, Match, Proper and more.As we all know that Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.Following Formulas are covered:- UPPER function changes all text to CAPITALS- LOWER function changes all text to lower case- PROPER function changes the first letter in each word to upper case and all other letters to lower case – Generally this is useful for fixing names.- TRIM function removes all spaces from text except for single spaces between words.- INDEX function returns a value or the reference to a value from within a table or range. There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form. If you want to return a reference to specified cells, see Reference form.- MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.- WORKDAY returns a number that represents a date that is the indicated number of working days before or after a date (the starting date).- More Formulas like- NETWORKDAY, CHOOSE, AVERAGEIFS, COUNTIFS, SUMIFS.INTL and more.Let's learn microsoft excel and start your career in IT. This course is best suitable for beginners, as we start this course from very basics and go all the way to advanced topics. Enroll now and be a part of future tech industry. Thank You.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 What is Excel

Lecture 3 Open-Input-Save

Section 2: Basics of Excel

Lecture 4 Customization

Lecture 5 Interface

Lecture 6 Formula-Status-Bar

Lecture 7 Tabs

Lecture 8 Navigation

Lecture 9 Shortcuts

Lecture 10 Basic Formulas- I

Lecture 11 Basic Formulas- II

Lecture 12 Basic Formulas- III

Lecture 13 Basic Formulas- IV

Lecture 14 Basic Formulas- V

Lecture 15 Basic Formulas- VI

Lecture 16 Find and Replace

Lecture 17 Advanced Find and Replace

Lecture 18 Assignment- I

Lecture 19 Solution- I

Section 3: Intermediate Excel

Lecture 20 Data Formatting

Lecture 21 Copying External Data

Lecture 22 Organize Data

Lecture 23 Arrange Data

Lecture 24 Text Conversion

Lecture 25 Text to Columns

Lecture 26 Relative Reference

Lecture 27 Assignment- 2

Lecture 28 Absolute Reference

Lecture 29 Mixed Referencing

Lecture 30 Data Validation

Lecture 31 Types of Data Validation

Lecture 32 Ask Y or N

Lecture 33 Data Validation Example

Lecture 34 Conditional Formatting

Lecture 35 Conditional Formatting Example

Lecture 36 Practice

Section 4: Advanced Excel

Lecture 37 Upper-Lower

Lecture 38 Proper-Trim

Lecture 39 Proper-Trim Editing

Lecture 40 VLOOKUP

Lecture 41 Index-Match

Lecture 42 Task- I

Lecture 43 SUMIFS

Lecture 44 AVERAGEIFS

Lecture 45 Task- II

Lecture 46 WORKDAY.INTL

Lecture 47 Task- III

Lecture 48 Presenting Data

Lecture 49 Choose

Lecture 50 Congrats

Anyone who want to learn excel.