"Everyday Excel, Part 1" is designed for anyone looking to learn Excel from scratch. No prior experience with Excel is required. While this course is designed for beginner Excel users, experienced users will undoubtedly gain new skills and tools. This course is the first in a three-part series and specialization that focuses on teaching beginner to very advanced Excel techniques and tools. In this course (Part 1), you will: 1) learn to navigate the Excel environment effectively; 2) edit and format Excel worksheets; 3) apply basic and advanced Excel functions (including financial, logical, and text functions); 4) learn to manage data sets (filter, remove duplicates, combine data, sort data, and validate data); and 5) learn to effectively visualize data using scatter plots, bar charts, and pie charts. New to Excel? That's totally okay! This course is designed to be fun, thought-provoking, and intended for a general audience. No prior programming knowledge or deep mathematical skills are required. The course consists of 5 weeks (modules).
To complete each module, you will need to pass a test of your understanding of the material and complete a problem-solving assignment. What makes this course unique is that the weekly assignments are completed in application mode (i.e. on your own computer in Excel), which provides you with valuable practical training.