Udemy - Expert In Ms Excel

What you'll learn
MS Excel is a commonly used Microsoft Office application. It is a spreadsheet program which is used to save and analyse numerical data.
MS Excel is a spreadsheet program where one can record data in the form of tables. It is easy to analyse data in an Excel spreadsheet.
Benefits of Microsoft Excel Best way to store data You can perform calculations, Easy to data visualizations with charts You can print reports easily
With data and case study you can excel your knowledge of MS Excel.
So Learn and earn your pride...
Requirements
No programming experience needed. you will learn everything you need to know.
Go forward Gracefully..
Description
Hello Learners, Sikhne ki koi umar nahi hoti toe Sikhte rahiye.. MS Excel is a spreadsheet program where one can record data in the form of tables. It is easy to analyse data in an Excel spreadsheet. To open MS Excel on your computer, follow the steps given below:Click on StartThen All ProgramsNext step is to click on MS OfficeThen finally, choose the MS-Excel optionAlternatively, you can also click on the Start button and type MS Excel in the search option available.A spreadsheet is in the form of a table comprising rows and columns. The rectangular box at the intersection point between rows and columns forms a cell. The cell address is the name by which is cell can be addressed. For example, if row 7 is interested in column G, then the cell address is G7.Given below are a few important benefits of using MS Excel:Easy To Store dаta: Since there is no limit to the amount of information that can be saved in a spreadsheet, MS Excel is widely used to save data or to analyse data. Filtering information in Excel is easy and convenient.Easy To Recover dаta: If the information is written on a piece of paper, finding it may take longer, however, this is not the case with excel spreadsheets. Finding and recovering data is easy.Application of Mathematical Formulas: Doing calculations has become easier and less time-taking with the formulas option in MS excelMore Secure: These spreadsheets can be password secured in a laptop or personal computer and the probability of losing them is way lesser in comparison to data written in registers or piece of paper.Data at One Place: Earlier, data was to be kept in different files and registers when the paperwork was done. Now, this has become convenient as more than one worksheet can be added in a single MS Excel file.Neater and Clearer Visibility of Information: When the data is saved in the form of a table, analysing it becomes easier. Thus, information is a spreadsheet that is more readable and understandable.✓Master the course of Microsoft Excel from Beginner to Advanced level. ✓Pump up your basics in Excel. ✓Learn the most common Excel functions used in the day to day work life. ✓Harness the full power of Microsoft Excel by automating your day to day tasks. ✓Maintain large sets of Excel data in a list or table. ✓Elevate your work with advance pilot. ✓Create dynamic reports by mastering one of the most popular tools, Pivot Tables ✓Get street smart by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more.✓Create interactive Dashboards. ✓Why just sail with Excel, start learning Advanced Excel too.
Overview
Section 1: Introduction
Lecture 1 Ms Excel- Introduction
Lecture 2 MS Excel - Formatting, Finding Data and Formulas In Hindi
Lecture 3 Microsoft Excel Text Functions
Section 2: Reference
Lecture 4 How to use Relative Reference
Lecture 5 How to use Absolute Reference
Lecture 6 How to use Mixed Reference
Section 3: Data Validation
Lecture 7 What is Data Validation and how to use it!
Section 4: Sorting & Filter
Lecture 8 Ms Excel - Sorting
Lecture 9 Ms Excel Filtering
Section 5: Formatting
Lecture 10 Conditional Formatting
Section 6: Pivot
Lecture 11 Pivot Table and Pivot Graph
Section 7: Charts
Lecture 12 Principle of Charts & creation of Interactive Components
Section 8: Data & File Security and Hyperlink uses
Lecture 13 Data & File Security and uses of Hyperlink
Section 9: ms Excel - LookUp Functions
Lecture 14 MS Excel - V LookUp
Lecture 15 MS Excel - H LookUp Functions
Section 10: projects
Lecture 16 How to create Bar Code
Lecture 17 How to create Data Entry Forms
Lecture 18 School Marks Grading
Beginner , who are curious to learn and earn job with respect.
Homepage

https://www.udemy.com/course/expert-in-ms-excel/