Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Gain a strong foundation in Microsoft Excel by mastering essential spreadsheet skills, calculations, and formatting. Learn to organize, calculate, and present data effectively for personal and professional use. This course introduces the core concepts of Microsoft Excel, guiding learners through spreadsheet creation, data entry, basic calculations, and essential formatting techniques. You'll discover how to manage workbooks, collaborate with others, and apply formatting to make your data clear and visually appealing. By the end of the course, you'll be able to confidently navigate Excel, perform calculations, and prepare well-structured spreadsheets for a variety of tasks. Through clear explanations, practical examples, and step-by-step guidance, this course ensures you build a solid understanding of Excel's foundational features. You'll progress from basic navigation to effective data management and formatting, empowering you to use Excel efficiently in everyday scenarios. This course is part one of a three-course Specialization designed to build a complete and cohesive understanding of the subject. While it offers valuable skills on its own, you'll gain the most benefit by progressing through all three courses as a structured learning journey. This course is based on Microsoft 365 Excel For Dummies, by David Ringstrom. From Microsoft 365 Excel For Dummies Copyright © 2025 by John Wiley & Sons, Inc. All rights reserved, including rights for text and data mining and training of artificial technologies or similar technologies. Used by arrangement with John Wiley & Sons, Inc.

Syllabus

Getting Started with Spreadsheets
- This module introduces learners to the fundamentals of working with spreadsheets, including navigating Excel's interface, entering and editing data, managing workbooks, and collaborating with others. It provides hands-on practice with basic data entry, formatting, and workbook operations, helping learners build confidence in using spreadsheet tools effectively.
Carrying Out Basic Calculations
- This module teaches learners how to perform accurate calculations in Excel using operators, cell references, and functions. It covers linking data across sheets, understanding the order of operations, and applying formulas for sums, dates, and weighted averages. By the end, learners will be able to efficiently manage and analyze spreadsheet data.
Formatting Cells and Worksheets
- This module covers essential spreadsheet formatting techniques to improve readability, consistency, and data presentation. Learners will gain skills in applying styles, adjusting layouts, and managing visibility of data elements. The content also explores practical tools for enhancing worksheets visually and functionally.
Sifting Through Data
- This module equips learners with essential Excel techniques for efficiently managing and analyzing data. It covers tools like freezing panes, custom lists, and the AGGREGATE function to streamline data handling. Learners will also gain skills in removing duplicates and reapplying filters to maintain clean datasets.
Tackling Tables
- This module teaches learners how to effectively use Excel tables to organize, format, and automate data. It covers naming conventions, formatting options, formula automation, and advanced filtering techniques like slicers. Learners will gain practical skills to enhance data analysis and workflow efficiency.

Taught by

Wiley Skills Network

Reviews

Start your review of Excel Foundations: Building Skills for Everyday Productivity

Taught by

Never Stop Learning.