Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera

Microsoft Excel 365 Fundamentals

Packt via Coursera

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Enhance your Excel skills with this hands-on course. From navigating workbooks to mastering formulas, build your foundational Excel 365 knowledge step-by-step. Perfect for both beginners and those looking to refresh their skills. This course introduces you to Microsoft Excel 365, guiding you through the essential tools and techniques needed for effective spreadsheet management. Starting with the basics, learners will navigate the Excel interface, create and organize workbooks, and understand the anatomy of spreadsheets. By focusing on key features like the ribbon, menus, and customizing the Quick Access Toolbar (QAT), you’ll develop a strong foundation in Excel navigation, preparing you for more advanced tasks. Throughout the course, you’ll build your expertise in performing calculations, applying formulas, and formatting cells to present your data in an organized and readable manner. With hands-on exercises after each module, you’ll practice essential skills, such as making selections, managing worksheets, and applying text and number formats. Whether you're new to Excel or need a refresher, the course ensures that you become proficient with key features to streamline your work. The course also covers the fundamentals of printing and sharing workbooks, allowing you to collaborate with colleagues or present your findings efficiently. By the end of this course, you’ll be able to use Excel 365 to complete tasks like organizing data, automating calculations, and sharing workbooks for collaboration. This course is designed for beginners or those looking to refresh their skills with Microsoft Excel 365. It is ideal for professionals who work with data on a regular basis, whether in finance, marketing, sales, or any other sector requiring spreadsheet management. No prerequisites are required, but basic familiarity with computer functions will be helpful. The course uses a hands-on, step-by-step approach, ensuring that learners actively engage with each feature in Excel 365. Exercises and practical demonstrations reinforce learning, enabling you to apply concepts immediately. The goal is to equip you with real-world skills that can be used in professional settings. This course is based on Microsoft Excel 365 Fundamentals, by Assemble You Limited. This video is licensed and distributed by Packt. All rights reserved. Packt is one of the world's most prolific publishers of cutting-edge technical content. For over two decades we've made it our mission to curate and publish the knowledge of only the very best technical experts. We focus on real-world courses that help our customers get the job done, with coverage that extends across a wide range of established and cutting-edge technical topics. If you're an individual or an organisation that embraces learning by doing, Packt is the perfect fit for you.

Syllabus

  • Introduction to Excel
    • This module introduces learners to the fundamentals of Excel, including launching the application, navigating the interface, and utilizing key features such as the ribbon, QAT, and cloud storage. It also covers essential productivity tools like shortcuts and Keytips. By the end, learners will be able to effectively use Excel for basic tasks and customize their workspace for efficiency.
  • Navigating and Organizing Your Data
    • This module focuses on mastering essential Excel navigation and organization techniques. Learners will gain skills in moving around worksheets, selecting data, managing multiple sheets, and cleaning up their work. By the end, students will be able to efficiently structure and maintain Excel workbooks.
  • Formatting and Working with Data
    • This module focuses on mastering data formatting techniques in Excel, including inputting text and numerical data, applying number and cell formats, and practicing formatting skills through exercises. Learners will develop the ability to present and manage data effectively in spreadsheets.
  • Mastering Formulas and Calculations
    • This module teaches learners how to construct and apply formulas in Excel, focusing on basic calculations, AutoSum, and AutoFill. It covers essential functions like SUM and AVERAGE, and provides practical exercises to enhance efficiency in data processing.
  • Printing, Sharing, and Collaboration
    • This module teaches learners how to effectively print, share, and collaborate on Excel workbooks using both desktop and online tools. It covers the practical applications of printing features, cloud-based sharing, and the use of Excel's online portal for seamless access. Learners will gain hands-on experience with real-world scenarios involving workbook management.
  • Wrapping Up the Course
    • This module helps learners consolidate their understanding of Excel by reviewing key concepts and planning for future learning. It emphasizes the importance of reflection and continuous skill development in data management and analysis.

Taught by

Packt - Course Instructors

Reviews

Start your review of Microsoft Excel 365 Fundamentals

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.