Learn Excel From Basics To Advanced

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.


Homepage

https://www.udemy.com/course/learn-excel-from-basics-to-advanced/