![]() ![]() Only 36 minutes! How is this possible? I work through two business case studies on sales reporting and analysis, showing you how to use Excel to analyze data and answer questions, highlighting each step, and clearly explaining what I’m doing and why. How to filter and sort large tables of data and calculate totals. You’ll learn how to enter and edit data and formulas. You’ll learn many of the important Excel functions: IF, VLOOKUP, pivot tables and charts, including line charts, column charts and 3D column charts. The course is just 36 minutes - you can finish it over a lunch break! That’s how long it takes to complete the videos in this course, and come away with a strong understanding of the use of Excel in business. Will be making some accounting pivot charts right away." - Kyrie ![]() This course gave a good overview of major functions I have never used and didn't know existed. "I have been using Excel for years but only in very specific ways. "Needed this to get ready for a new job, feeling more confident already!" - Daniel H. "Great introduction to pivot tables and good examples too." - John P. "Very clear and easy to understand" - Fiona M It was like having a friend show you what to do." - Patrick M. "Really concise quick summary and foundation in Excel" - Clare B. The course is organized into 5 Weeks (modules).Here's what some students are saying about the course in the Reviews! 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. This course is meant to be fun and thought-provoking. 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 the second part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques 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 aimed at intermediate users, but even advanced users will pick up new skills and tools in Excel. Building on concepts learned in the first course, you will continue to expand your knowledge of applications in Excel. "Everyday Excel, Part 2" is a continuation of the popular "Everyday Excel, Part 1". 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |