Discover the real-world uses of Microsoft Excel and its impact upon business, academic, and personal applications. Move from inserting and manipulating data, to working with tables, charts, graphs, and calculations. Content of this course will also be applicable to the Microsoft Office Suite certification exam.
During this course, you will learn career-related skills and earn a badge for this accomplishment. A badge is a digital certification of your career-related learning that you can share on social media and higher education platforms, or with colleges, potential employers, peers, and colleagues. Select this link to learn more about badges.
Students will demonstrate an understanding of Excel basics by summarizing the basic functions and features of Excel, describing the data-formatting process, and explaining common uses of Excel in business.
Students will demonstrate an understanding of Excel customization by describing how to configure display preferences, explaining the organization of information, and summarizing various ways to protect information.
Students will demonstrate an understanding of data display by explaining the operation of data formatting functions and describing the importance of an ePortfolio.
Students will demonstrate an understanding of table management by explaining the features of a pivot table, describing ways to customize tables, and describing the basic principles of using “totals.”
Students will demonstrate an understanding of functions in Excel by explaining the use of functions, explaining various syntax rules, and describing the use of advanced functions.
Students will demonstrate an understanding of how to work with charts by describing ways to manipulate information within charts and describing the functions of various types of charts.
Students will demonstrate an understanding of Excel in the workplace by describing ways to increase efficiency when using Excel, describing common uses of Excel in the workplace, and describing other applications within the Microsoft Office Suite.
Students will demonstrate an understanding of the use of Excel tools by describing special tools in Excel and explaining the procedures for collaborating in an Excel file.
Unit 1: Using Excel
Unit 2: Customizing and Configuring
Unit 3: A Range of Data
Unit 4: Creating and Managing Tables
Unit 5: Fun with Formulas and Functions
Unit 6: Organization Essentials: Charts and Data
Week 7: Excel at Work
Week 8: Pulling It All Together