"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.
Example: Sales invoice as PDF file
Compétences que vous apprendrez
Data Management, Spreadsheet, Microsoft Excel, Problem Solving, Real World
Avis
This is one of the BEST course I have done in Coursera. I must say special "Thank You" to Charlie Nuttelman Sir, the way he taught us was excellent. In future I must do other two courses.
Great Course!!! The only thing when I found trouble was with dates. I use DD/MM/YYYY but in some examples he uses MM/DD/YY and that gave me some troubles, but without that was Excellent!
Week 5 is all about data visualization. You will learn the differences between and how to use scatter plots, column charts, and pie charts. You will be introduced to Pivot Tables, Slicers, and Sparklines, which all represent different and exciting ways to visualize your data. I will show you how to share data (embed vs. linking) with Word and PowerPoint as well as how to print your worksheets and how to convert them to .pdf documents. Like the other modules, Week 5 concludes with a quiz and an on-computer, in-application assignment. When you've completed those assessments, you will earn the Course Certificate! Good luck!
Enseigné par
Charlie Nuttelman
Senior Instructor
Explorer notre catalogue
Rejoignez-nous gratuitement et obtenez des recommendations, des mises à jour et des offres personnalisées.
Coursera Footer
