Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

Strong spreadsheet skills are essential in today’s data-driven workplace, and Excel remains one of the most widely used productivity tools. This course introduces the core skills required to build, format, and manage professional worksheets, helping you work more efficiently and present data clearly in business and technical environments. Throughout the course, you will learn how to navigate the Excel interface, customize the workspace, and create structured worksheets for organizing data. You will also explore essential formatting techniques that enhance readability and visual clarity, along with editing and proofing tools that help maintain accuracy and consistency. What sets this course apart is its balanced focus on both practical workflows and foundational Excel concepts. By combining step-by-step demonstrations with real-world examples, the course helps you develop the confidence to manage worksheets and prepare them for professional sharing and printing. This course is ideal for beginners, students, and professionals who want to build a solid foundation in Microsoft Excel. No prior Excel experience is required, although basic computer skills will help you get started quickly. This course is part one of a three-course Specialization designed to provide a comprehensive learning pathway in this subject area. While it delivers standalone value and practical skills, learners seeking a more integrated and in-depth progression may benefit from completing the full Specialization. Copyright © 2022 by John Wiley & Sons, Inc., Hoboken, New Jersey. Published simultaneously in Canada. Used by arrangement with John Wiley & Sons, Inc.

Syllabus

Excel: The 50-Cent Tour

In this section, we explore Excel's interface, focusing on navigating the Ribbon, Start screen, and worksheet area using keyboard shortcuts and touch input. Key concepts include using the Ribbon's tabs and groups, managing the Quick Access Toolbar, and accessing help features like the Tell Me function and Help tab. Learners gain practical skills for efficient navigation and problem-solving in Excel, essential for real-world spreadsheet tasks.

Customizing Excel

In this section, we explore how to customize Excel's interface and settings for improved workflow. The content covers tailoring the Quick Access Toolbar, configuring program options for efficiency, and managing add-ins to extend functionality. Key concepts include personalizing the user interface, adjusting settings for specific tasks, and leveraging add-ins for enhanced capabilities. The educational value lies in empowering users to optimize Excel according to their needs, improving productivity and reducing frustration.

Building Worksheets

In this section, we explore creating and managing Excel worksheets using templates, custom designs, and data validation to ensure accurate data entry. We cover linking worksheets to external documents and web pages, enhancing workflow efficiency and data integration.

Formatting Worksheets

In this section, we explore Excel's formatting tools to enhance worksheet readability and data analysis. Learn to apply number formats, design tables, and use conditional formatting rules for effective data presentation and accurate interpretation.

Editing and Proofing Worksheets

In this section, we explore efficient workbook editing techniques in Excel, including opening, modifying, and proofing worksheets. Key concepts cover using Undo and Redo, copying and moving data, and applying data validation for accuracy. The section emphasizes practical skills like zooming, freezing panes, and finding/replacing data, all essential for maintaining well-organized spreadsheets. It also highlights the importance of proofing and spell checking to ensure data integrity. These techniques are critical for real-world data management and workflow optimization.

Managing Worksheets

In this section, we explore techniques for managing and reorganizing data in worksheets and workbooks, including inserting and deleting columns and rows, splitting worksheets into panes, and consolidating data across multiple sheets. The focus is on practical skills for efficient data handling, comparison, and transfer between workbooks, enhancing workflow and decision-making in spreadsheet tasks.

Printing Worksheets

In this section, we explore Excel's Backstage view and page layout tools to configure print settings, design professional reports with headers and footers, and adjust margins and page orientation for accurate print outputs. Key concepts include using the Page Layout, Print Preview, and Page Break Preview features to ensure reports appear as intended before printing, with a focus on practical applications for data presentation and document formatting.