Data Analysis in Excel
About Course
- Data Camp is the most trusted interactive and data skills online learning platform. Data Camp provides a number of courses, which include Non-coding to coding courses like start from excel to data science and Machine Learning. This best online learning platform specially designed for data skills learners. Data Camp gives the flexibility to pick up courses with career tracks or skill tracks.
What I will learn?
- The wonderful world of excel
- What can excel do?
- Data Analysis Steps
- Setting up the environment
- Navigating worksheet
- Exploring Data
- Looking for exact matches
- Trimming your data
- Table Sorting
- Nesting functions
- Understanding data types
- Classifying data types
- Changing the text
- Rounding values
- Preparing data
- Cleaning text data
- Joining text strings
- Capitalizing words
- Using upper & lower case
- Extracting text from cells
- Characters counting
- Extracting text
- Replacing characters
- Preparing Date Data
- Using the system Date
- Working with dates
- Finding the week-day
- Figuring out the month
- Most important functions
- Finding Matching columns
- Working with a range lookup
- Using VLookUP
- Analysing Data
- Counting
- Choosing right count function
- Learning count
- Counting blank cells
- Excel great calculator
- Math functions
- Finding Minimum
- Aggregating Data
- Logic functions
- Arguments of IF() function
- Performing logical test
- Taking IF() to the next level
- Conditional aggregation
- Finding unique values
- Counting Projects
- Determining the average
- Wrap up