So first, I'm going to show you two ways in which we can eliminate duplicates. The first thing we're going to do is we're going to tally the number of sales for each of the unique sellers. That's just the product of quantity and price, and we're going to do a couple things. I'll be working on this cookies file over here.

In this Screencast, I'm going to cover some more advanced logical functions in Excel. 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.

To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. The course is organized into 5 Weeks (modules).

No prior knowledge in programming nor advanced math skills are necessary. New to Excel? That is entirely fine! This course is meant to be fun, thought-provoking, and appeal to a wide audience. 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. 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. While this course is meant for beginners of Excel, advanced users will undoubtedly pick up new skills and tools. 'Everyday Excel, Part 1' is aimed at learners who are seeking to learn Excel from the ground up.

Advanced excel 2019