For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Microsoft Excel 365 Essentials

Course Overview

Master Excel's essential functions and formatting tools to efficiently organize, analyze, and present data.

In our Microsoft Excel 365 Essentials course, you'll learn fundamental skills to use Excel efficiently. Begin with ribbon navigation, cursor options, and data entry basics. Master formatting features, formulas, and data management for improved efficiency.

You'll discover techniques for formatting numbers, styles, and tables for better data visualization. You'll also learn essential formulas, including relative and absolute references, along with AutoFill and custom list creation to enhance productivity.

Explore conditional formatting for highlighting critical data and sorting/filtering for effective dataset organization. Manage large workbooks seamlessly with freeze panes, splitting, and printing tools.

Understand chart creation and formatting, including columns and pies, and integrate charts into PowerPoint presentations for professional delivery.

By the end of the course, you should possess a solid Excel 365 foundation, empowering you to handle various data tasks confidently. Practical exercises reinforce learning, making it perfect for beginners and those refreshing their skills.

Learning Objectives:

In this course you will learn how to:

  • Navigate the Excel ribbon and cursor options.
  • Enter and format data effectively.
  • Apply number and style formatting to tables.
  • Use formulas with relative and absolute references.
  • Utilize AutoFill and create custom lists.
  • Implement conditional formatting based on cell content.
  • Sort and filter data for better analysis.
  • Create and format various types of charts.