Learn Excel From Scratch to Expert. Starting from zero knowledge of Excel, you'll learn basic spreadsheet skills and apply them in to several exciting projects in the capstone "Projects" course.

4.7

별점

571개의 평가

Charlie Nuttelman
최고의 강사

19,478명이 이미 등록했습니다.

제공자:

Everyday Excel 특화 과정콜로라도 대학교 볼더 캠퍼스

배울 내용

In this specialization, you'll learn a variety of Excel tools, techniques, and functions, which you'll apply to real-world, "open-ended" projects.

Navigating Excel, editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting.

Expression entry and common Excel formulas (including logical functions, text functions, and financial functions).

Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups).

귀하가 습득할 기술

Spreadsheet
Microsoft Excel
Problem Solving
Project
computing
Data Management
Real World
Real-world projects

이 전문 분야 정보

최근 조회 42,261회

This Specialization is for learners wishing to learn Microsoft Excel from beginner level to expert level. The first two courses will teach learners the basics of Excel through the use of dozens of educational screencasts and a series of quizzes and in-application assignments. Finally, in Part 3 (Projects), learners will complete several "real world", somewhat open ended yet guided projects. In the Projects course, special emphasis is placed on dynamic array functions, which are new in Office 365 and have revolutionized the way that worksheet calculations are performed.

응용 학습 프로젝트

In Part 3 (Projects), learners choose three "warm-up" projects (chosen from five potential projects), three intermediate projects (chosen from six potential projects), and three main projects (chosen from five potential projects). Thus, learners have liberty to tailor their experience through choice of projects. Screencasts are provided that show hints and previews for each project.

공유 가능한 수료증

완료 시 수료증 획득

100% 온라인 강좌

지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.

유연한 일정

유연한 마감을 설정하고 유지 관리합니다.

초급 단계

While helpful, no previous background nor experience with Excel is an absolute necessity to undertake this specialization.

완료하는 데 약 4개월이 걸립니다

권장 학습 속도: 주 4시간

영어

자막: 영어, 아랍어, 프랑스어, 포르투갈어 (유럽), 이탈리아어, 베트남어, 독일어, 러시아어, 스페인어

공유 가능한 수료증

완료 시 수료증 획득

100% 온라인 강좌

지금 바로 시작해 나만의 일정에 따라 학습을 진행하세요.

유연한 일정

유연한 마감을 설정하고 유지 관리합니다.

초급 단계

While helpful, no previous background nor experience with Excel is an absolute necessity to undertake this specialization.

완료하는 데 약 4개월이 걸립니다

권장 학습 속도: 주 4시간

영어

자막: 영어, 아랍어, 프랑스어, 포르투갈어 (유럽), 이탈리아어, 베트남어, 독일어, 러시아어, 스페인어

특화 과정 이용 방법

강좌 수강

Coursera 특화 과정은 한 가지 기술을 완벽하게 습득하는 데 도움이 되는 일련의 강좌입니다. 시작하려면 특화 과정에 직접 등록하거나 강좌를 둘러보고 원하는 강좌를 선택하세요. 특화 과정에 속하는 강좌에 등록하면 해당 특화 과정 전체에 자동으로 등록됩니다. 단 하나의 강좌만 수료할 수도 있으며, 학습을 일시 중지하거나 언제든 구독을 종료할 수 있습니다. 학습자 대시보드를 방문하여 강좌 등록 상태와 진도를 추적해 보세요.

실습 프로젝트

모든 특화 과정에는 실습 프로젝트가 포함되어 있습니다. 특화 과정을 완료하고 수료증을 받으려면 프로젝트를 성공적으로 마쳐야 합니다. 특화 과정에 별도의 실습 프로젝트 강좌가 포함되어 있는 경우, 다른 모든 강좌를 완료해야 프로젝트 강좌를 시작할 수 있습니다.

수료증 취득

모든 강좌를 마치고 실습 프로젝트를 완료하면 취업할 때나 전문가 네트워크에 진입할 때 제시할 수 있는 수료증을 취득할 수 있습니다.

이 전문 분야에는 3개의 강좌가 있습니다.

강좌1

강좌 1

Everyday Excel, Part 1

4.7

별점

2,088개의 평가

•

723개의 리뷰

"Everyday Excel, Part 1" is aimed at learners who are seeking to learn Excel from the ground up. No experience with Excel is necessary. While this course is meant for beginners of Excel, advanced users will undoubtedly pick up new skills and tools.

This course is the first part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 1), you will: 1) learn how to effectively navigate around the Excel environment; 2) edit and format Excel worksheets; 3) implement basic to advanced Excel functions (including financial, logical, and text functions); 4) learn how to manage data sets (filter, remove duplicates, consolidate data, sort data, and validate data); and 5) learn how to effectively visualize data through scatterplots, column charts, and pie charts. New to Excel? That is entirely fine! This course is meant to be fun, thought-provoking, and appeal to a wide audience. No prior knowledge in programming nor advanced math skills are necessary. The course is organized into 5 Weeks (modules). To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.

강좌2

강좌 2

Everyday Excel, Part 2

4.8

별점

247개의 평가

•

85개의 리뷰

"Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, Part 1". Building on concepts learned in the first course, you will continue to expand your knowledge of applications in Excel. This course is aimed at intermediate users, but even advanced users will pick up new skills and tools in Excel. By the end of this course, you will have the skills and tools to take on the project-based "Everyday Excel, Part 3 (Projects)".

This course is the second part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 2), you will: 1) learn advanced data management techniques; 2) learn how to implement financial calculations in Excel; 3) use advanced tools in Excel (Data Tables, Goal Seek, and Solver) to perform and solve "what-if" analyses; 4) learn how to create mathematical predictive regression models using the Regression tool in Excel. This course is meant to be fun and thought-provoking. I hope for you to at least several times in the course say to yourself, "Wow, I hadn't thought of that before!" Given the wide range in experience and abilities of learners, the goal of the course is to appeal to a wide audience. The course is organized into 5 Weeks (modules). To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.

강좌3

강좌 3

Everyday Excel, Part 3 (Projects)

4.9

별점

39개의 평가

•

20개의 리뷰

"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and 2". It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways).

Each learner must complete 3"warm-up" projects (chosen from 3), 3 intermediate projects (chosen from 6), and 3 main (more difficult) projects (chosen from 5). The projects have been created to span a wide range of interests and topic areas and are anticipated to appeal to diverse learner backgrounds. It is hoped that this project-based courses will dramatically reinforce the application of Excel tools, techniques, and functions to real-world projects.

강사

Charlie Nuttelman
최고의 강사

Senior Instructor

Chemical and Biological Engineering

266,931명의 학습자

6개의 강좌

제공자:

콜로라도 대학교 볼더 캠퍼스

CU-Boulder is a dynamic community of scholars and learners on one of the most spectacular college campuses in the country. As one of 34 U.S. public institutions in the prestigious Association of American Universities (AAU), we have a proud tradition of academic excellence, with five Nobel laureates and more than 50 members of prestigious academic academies.

자주 묻는 질문

환불 규정은 어떻게 되나요?
구독하는 경우, 취소해도 요금이 청구되지 않는 7일간의 무료 평가판을 이용할 수 있습니다. 해당 기간이 지난 후에는 환불이 되지 않지만, 언제든 구독을 취소할 수 있습니다. 전체 환불 정책 보기.
하나의 강좌에만 등록할 수 있나요?
네! 시작하려면 관심 있는 강좌 카드를 클릭하여 등록합니다. 강좌를 등록하고 완료하면 공유할 수 있는 인증서를 얻거나 강좌를 청강하여 강좌 자료를 무료로 볼 수 있습니다. 전문 분야 과정에 있는 강좌에 등록하면, 전체 전문 분야에 등록하게 됩니다. 학습자 대시보드에서 진행 사항을 추적할 수 있습니다.
재정 지원을 받을 수 있나요?
예, Coursera에서는 수업료를 낼 수 없는 학습자를 위해 재정 지원을 제공합니다. 왼쪽에 있는 등록 버튼 아래 재정 지원 링크를 클릭하면 지원할 수 있습니다. 신청서를 작성하라는 메시지가 표시되며 승인되면 알림을 받습니다. 성취 프로젝트를 포함하여 전문 분야의 각 강좌에서 이 단계를 완료해야 합니다. 자세히 알아보기.
해당 강좌를 무료로 수강할 수 있나요?
강좌를 등록하면 전문 분야의 모든 강좌에 접근할 수 있으며 강좌를 완료하면 인증서가 발급됩니다. 강좌 내용을 읽고 보기만 원한다면 강좌를 무료로 청강할 수 있습니다. 수업료를 지급하기 어려운 경우, 재정 지원을 신청할 수 있습니다.
이 강좌는 100% 온라인으로 진행되나요? 직접 참석해야 하는 수업이 있나요?
이 강좌는 100% 온라인으로 진행되므로 강의실에 직접 참석할 필요가 없습니다. 웹 또는 모바일 장치를 통해 언제 어디서든 강의, 읽기 자료, 과제에 접근할 수 있습니다.
전문 분야를 완료하는 데 얼마나 걸리나요?
The time required for this specialization will vary dramatically depending upon the amount of time that learners can devote to it each week. If you can spend 3-5 hours per week on the courses, you should be able to complete the specialization in about 10-12 weeks. The time required to complete the specialization is much less if you're able to spend a significant amount of time each week on the courses.
What background knowledge is necessary?
It is beneficial to have a basic understanding of computers and navigating around computers, but other than that you will learn Excel from "scratch to expert". A basic knowledge of math is helpful, but not a lot of time is spent on mathematical formulas.
Do I need to take the courses in a specific order?
Yes, it is recommended that you take the courses in order: Part 1, Part 2, followed by Part 3.
전문 분야를 완료하면 대학 학점을 받을 수 있나요?
It depends upon university, but most likely not (at least until things change with course credit, etc., which is in the near future!).
What will I be able to do upon completing the Specialization?
Upon completing this specialization, you'll be able to perform a wide variety of techniques in Excel and utilize many functions and tools that are built into Excel. You'll be able to manage large data sets and sort, filter, and search through the data for items of interest. Many learners have received job promotions and/or new careers as a result of completing courses in the specialization.

궁금한 점이 더 있으신가요? 학습자 도움말 센터를 방문해 보세요.