Published 7/2020
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 717.61 MB | Duration: 1h 37m
Learn all functions and features of MS Excel 2019+ to clean the data and make meaningful interpretations
What you’ll learn
Fundamentals of MS Excel
Learn Shortcuts commonly used in MS Excel
20 plus data cleaning techniques to make a meaningful interpretation of the work
Converting Messy data into Ready Data for Analysis
Learn WHY HOW and WHEN you need to clean the data
Requirements
You will need a Laptop/PC with any version of Excel installed in it
Basic understanding of Excel operations like opening, closing and saving a file
Description
Excel is one of the most in-demand skills at all levels and having complete knowledge of this tool will help you to grow and earn.Data is the new oil. Data that is downloaded from software, and survey forms have errors in terms of formatting, duplications, numbers saved as text, numbers saved as negative, etc., There is a need to clean all these data errors to prepare the data for a meaningful and insightful interpretationOnce the data is cleaned and prepared, further analytics can be done easilyData handling is the most sought-after skill in today’s digital world. Whether you are a student, young professional, businessman, or freelancer, everyone needs to understand the data and make the most of the same. This basic course will help you to understand the basic functions to clean the data and prepare for the further analysisThe course covers basic functions to understand the working of MS Excel and then 15+ functions to prepare the dataLearn all functions, and features of MS Excel 2019+ to clean the data and make meaningful interpretationsText FunctionsText to Column FunctionLine BreakConvert Numbers saved as textRemove DuplicatesRemove Extra spacesDelete Blank Rows and ColumnsWe wish the best of luck to all our dear learners
Overview
Section 1: Welcome to the Course
Lecture 1 About the Course Instructor
Lecture 2 Time is Money
Lecture 3 Life Long Learning
Section 2: Fundamentals of MS Excel
Lecture 4 Workbook and Worksheet
Lecture 5 Navigation 1
Lecture 6 Navigation 2
Lecture 7 Selecting the Cells 1
Lecture 8 Selecting the Cells 2
Lecture 9 Selecting the Cells 3
Lecture 10 Selecting the Cells 4
Lecture 11 Paste Special 1
Lecture 12 Paste Special 2
Lecture 13 Paste Special 3
Lecture 14 Paste Special 4
Lecture 15 Formatting 1
Lecture 16 Formatting 2
Lecture 17 Filter the Data
Section 3: Mastering Data Cleaning in MS Excel
Lecture 18 Delete Blank Rows and Column in Data
Lecture 19 Remove the Duplicate Entries in Data
Lecture 20 Magical Function of MS Excel – Flash Fill
Lecture 21 Join the Text
Lecture 22 Convert Negative Numbers to Positive Numbers 1
Lecture 23 Convert Negative Numbers to Positive Numbers 2
Lecture 24 Convert Numbers Saved as Text to Numbers
Lecture 25 Add Line Break in the Text String 1
Lecture 26 Add Line Break in the Text String 2
Lecture 27 Fill the Range
Lecture 28 Create Custom List
Lecture 29 Find and Replace
Lecture 30 Converting Text into Lower Case
Lecture 31 Converting Text into Upper Case
Lecture 32 Converting Text into Proper or Sentence Case
Lecture 33 Remove Extra Space in the String
Lecture 34 Count the Characters in the String
Lecture 35 Convert Text to Column 1
Lecture 36 Convert Text to Column 2
Lecture 37 Convert Text to Column 3
Lecture 38 Clear Formatting
Students who are undergoing Summer Internship Projects and have to clean the survey data to make their reports stand out.,Researchers who want to clean the survey data,Anyone looking to pursue a career in data analysis or business intelligence
Homepage
https://www.udemy.com/course/complete-course-on-data-cleaning-in-ms-excel/
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM UPLOADGIG.COM