This course will be useful for anyone who has a foundational knowledge of Excel and would like to perform more robust and advanced data analysis. You will begin by performing fundamental data-analysis tasks like creating tables and sorting and filtering data. You'll also start visualizing data with Excel through charts.
This is the first course in a multi-course Specialization.
All of the courses in this Specialization require that you have a recent version of Microsoft Excel installed. The course setup instructions provided in the first module of this course go into more detail about the hardware and software requirements.
Embracing data analysis as part of a job role requires that you grasp fundamental concepts about data science, data analysis, and visualization. It also requires an understanding of the core data organization and segmentation capabilities in Excel. In this lesson, you'll perform fundamental data analysis tasks in Microsoft® Excel®.
涵盖的内容
1篇阅读材料6个插件
显示有关单元内容的信息
1篇阅读材料•总计5分钟
Course Introduction•5分钟
6个插件•总计85分钟
Getting Started with This Course•30分钟
Lesson Introduction•5分钟
Introduction to Data Science•15分钟
Create and Modify Tables•15分钟
Sort and Filter Data•15分钟
Lesson Summary•5分钟
Visualizing Data with Excel
第 2 单元•小时 后完成
单元详情
Microsoft® Excel® provides you with powerful features to help organize and analyze data, but once your analysis is complete, you have to communicate your findings. The people you report or present data to might not have the same comfort level or expertise when it comes to viewing worksheets. Further, viewing rows of numbers in tables is not a natural way for people to process information. To communicate effectively, you need to provide a simple, easy-to-digest view of relevant data so your audience can quickly understand what's really important.
涵盖的内容
5个插件
显示有关单元内容的信息
5个插件•总计100分钟
Lesson Introduction•5分钟
Visualize Data with Charts•30分钟
Modify and Format Charts•30分钟
Apply Best Practices in Chart Design•30分钟
Lesson Summary•5分钟
Completing the Course
第 3 单元•15分钟 后完成
单元详情
You'll wrap things up and then validate what you've learned in this course by taking an assessment.
Logical Operations is the world's largest general publisher of instructor-led technology curriculum, and a leader in the technical training community for over 40 years. We employ a rigorous, expert-driven authoring process that, for decades, has produced successful results for learners the world over. Our courseware aligns with real-world business needs and objectives, ensuring learners are able to apply their newly developed skills while on the job.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.