About this Course
This course is designed to give you fundamental working data for utilizing Excel spreadsheets for Knowledge Evaluation. It covers among the first steps for working with spreadsheets and their utilization within the means of analyzing knowledge. It consists of loads of movies, demos, and examples so that you can be taught, adopted by step-by-step directions so that you can apply and apply on a reside spreadsheet.
- IBM Knowledge Analyst Skilled Certificates
- Knowledge Evaluation and Visualization Foundations Specialization
WHAT YOU WILL LEARN
Describe the basics of spreadsheet functions
Carry out fundamental spreadsheet duties together with navigation, knowledge entry, and utilizing formulation.
Make use of knowledge high quality strategies to import and clear knowledge in Excel.
Analyze knowledge in spreadsheets through the use of filtering, sorting, look-up features, and pivot tables.
SKILLS YOU WILL GAIN
- Knowledge Science
- Spreadsheet
- Microsoft Excel
- Knowledge Evaluation
- Pivot Desk
Syllabus – What you’ll be taught from this course
2 hours to finish
Introduction to Knowledge Evaluation Utilizing Spreadsheets
On this module, you’ll be taught in regards to the fundamentals of spreadsheet functions, and you’ll be launched to the Excel interface and learn to navigate your method round a worksheet and workbook.
2 hours to finish
Getting Began with Utilizing Excel Speadsheets
On this module you’ll learn to carry out fundamental spreadsheet duties, corresponding to viewing, getting into and enhancing knowledge, and shifting, copying and filling knowledge. As well as, you’ll be taught in regards to the fundamentals of formulation, and study the commonest features utilized by an information analyst. Lastly, you’ll learn to reference knowledge in formulation.
3 hours to finish
Cleansing & Wrangling Knowledge Utilizing Spreadsheets
On this module, you’ll be taught in regards to the significance of information high quality, and you’ll learn to import file knowledge in to Excel. Additionally, you will be taught in regards to the fundamentals of information privateness. As well as, you’ll learn to take away duplicate and inaccurate knowledge, and tips on how to take away empty rows in your knowledge. Lastly, you’ll learn to take care of inconsistencies in your knowledge and tips on how to use the Flash Fill and Textual content to Columns options that will help you manipulate and standardize your knowledge.
3 hours to finish
Analyzing Knowledge Utilizing Spreadsheets
On this module, you’ll be taught in regards to the fundamentals of analyzing knowledge utilizing a spreadsheet, and learn to filter and type knowledge. Additionally, you will learn to use among the most helpful features for an information analyst, and tips on how to use the VLOOKUP and HLOOKUP reference features. As well as, you’ll learn to create pivot tables in Excel, and use a number of pivot desk options.
0 Comments