Executive Program in MS Excel
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
- 20 plus data preparation techniques to 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
Executive Program in MS Excel is a kind of complete basic course to help you excel in life
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 interpretation
Once the data is cleaned and prepared, further analytics can be done easily
Data 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 analysis
The course covers basic functions to understand the working of MS Excel and then 15+ functions to prepare the data
Learn all functions, and features of MS Excel 2019+ to make meaningful interpretations
Text Functions
Date & Time Function
Text to Column Function
Data Validation
Reference Function
Group Sheet Functions
We wish the best of luck to all our dear learners
Who this course is for:
- 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
Instructor
![Nitin Kr Saxena PhD](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 283 Reviews
- 31,544 Students
- 4 Courses
‘Teacher by instinct, Researcher by training and Institutional Builder by experience’
Dr. Nitin Kr Saxena has 13 years of Industry and 5 years of Academia experience, He has worked for companies like Vodafone, Reliance Communications, Idea Cellular, and HCL. Presently working as Professor of Marketing and Analytics in one of the most reputed business school of India. He is also a visiting Professor at Uniglobe College, Nepal
He has recently been awarded as ''Best Professor in Marketing Analytics" and he has done "Multivariate Data Analysis" and "Data Science Using R and Python" courses from Indian Institute of Technology Roorkee, India
The practical insights and knowledge that he has gained in Industry helps him in delivering the subjects with live and practical cases to Management Students. Dr. Saxena has done my PhD in Marketing.