This course is a basic course designed to develop data literacy skills using Excel, a software program considered to have the highest recognition and usability among office automation software.
17 learners are taking this course
Level Beginner
Course period Unlimited
You can understand and explain the concepts of data and data literacy.
Can define data-driven problems and explain data analysis techniques for each type of data.
Can use software for data analysis appropriately for its intended purpose.
You can experience and carry out data analysis tasks.
Don’t stop at organizing data,
you can uncover the meaning of data only by defining problems and connecting everything from preprocessing to analysis and visualization. Learn the fundamentals of data literacy and the actual analysis process using Excel.
Understand the concepts of data and data literacy, and define the problems to be solved using data yourself.
Experience the process of preprocessing data in Excel and organizing it into a format suitable for analysis.
Find meaning in data through summary analysis, exploratory analysis, predictive analysis, and visualization.
It is natural to find data challenging.
From basic concepts to hands-on analysis tasks, you can build your data skills at your own pace.
Even beginners who only vaguely worked with tables
grow into analysts who define and explain problems with data.
You can turn vague numbers into questions to analyze.
You will understand the meaning of data and data literacy, and learn how to define problems you encounter at work based on clear criteria. Rather than simply listing numbers such as sales or customer counts, you will develop the habit of organizing for yourself what needs to be checked.
After understanding the meaning of data and data literacy, you will learn how to define problems based on data and select appropriate analysis methods for each type. From preprocessing using Excel to summary, exploratory, and predictive analysis and visualization, you will learn the analytical process as one connected workflow.
After organizing and preprocessing data in Excel, you will create summary tables and exploratory results while carrying out actual analysis tasks. You will compare the purposes of analytical software tools and envision deliverables for use in work or academic settings through examples of data literacy assignments.
The course is structured around Excel to guide you through data preprocessing and analysis procedures, allowing you to examine the workflows needed for summarization, exploration, prediction, and visualization step by step. You will also explore data analysis software tools and assignment examples together, enabling even beginners to establish criteria for applying them to their own data.
Those who need to organize tabular data for class assignments or team projects but are unfamiliar with distinguishing between data types and extracting only the values they need
Those who want to use Excel’s basic features to organize data and complete simple summaries and visualizations themselves
Those who spend a lot of time preparing reports because of duplicate data and missing values while managing sales records or customer lists in Excel
Those who want to learn the data preprocessing process, transform work data into an analyzable format, and explain the results based on evidence
Those preparing for a career in data analysis or digital work who want to learn the differences between summary analysis, exploratory analysis, and predictive analysis using real-world data
Those who want to use Excel as an analysis tool to define problems, visualize results in charts, and carry out data-driven tasks
Practice environment
Excel is used on the Windows operating system.
An internet connection and a basic office computer are required.
Prerequisite Knowledge and Important Notes
Learners who are new to Excel can also participate.
Experience creating simple tables and saving files will be helpful.
You will practice by organizing the data yourself.
Learning materials
We organize the key concepts using the lecture slide materials.
It is helpful to prepare data for Excel practice and analysis examples.
Use them for exercises in summarization, exploration, prediction, and visualization.
Who is this course right for?
Data analysis beginner
Excel beginner
205
Learners
4
Reviews
5.0
Rating
9
Courses
It is a project team composed of professors specializing in AI and software.
We are offering a variety of software-related courses free of charge.
I hope this will be of great help.
All
14 lectures ∙ (7hr 37min)
Check out other courses by the instructor!
Explore other courses in the same field!
Free
![[Data Humanities] Think with DataCourse Thumbnail](https://cdn.inflearn.com/public/files/courses/331134/cover/ai/3/4b845453-c2a8-411f-a7d8-2f082b54ecab.png?w=420)
![[NetMiner 5] Social Network AnalysisCourse Thumbnail](https://cdn.inflearn.com/public/files/courses/343889/cover/01m1azepkpa7fq8zjjc6xzz079?w=420)
![What kind of work do you do as a data analyst? [Monthly Datarian Seminar Replay | January 2023]Course Thumbnail](https://cdn.inflearn.com/public/courses/329969/cover/33071a28-148a-4600-9226-ba177e628b06/329969-eng.png?w=420)