This 2-day course provides a solid foundation for using Microsoft Excel 365. Participants will learn how to create, format, and manage spreadsheets, use basic formulas, and generate visual data representations. By the end of the training, attendees will be able to confidently work with Excel to handle daily tasks efficiently.

Training Objectives

• Understand the basic functionality and interface of Microsoft Excel 365.
• Learn essential spreadsheet techniques for data entry and formatting.
• Perform basic calculations and use essential formulas.
• Create and customize charts for data visualization.
• Build confidence in using Excel for everyday tasks.

Course Schedule

Day 1: Understanding Excel Basics and Building Spreadsheets

• Introduction to Excel
  • Overview of Excel 365 and its applications.
  • Navigating the interface: Ribbon, menus, and workbooks.
  • Opening, saving, and managing Excel files.
• Working with Cells, Rows, and Columns
  • Entering and editing data.
  • Adjusting column width and row height.
  • Using AutoFill and Flash Fill for efficiency.
• Basic Formatting Techniques
  • Formatting cells: Numbers, dates, and text.
  • Applying borders, colors, and styles.
  • Using conditional formatting to highlight data.
• Introduction to Formulas
  • Understanding formula syntax.
  • Performing basic calculations: SUM, AVERAGE, MIN, MAX.
  • Introduction to relative and absolute cell references.
• Organizing Data in Tables
  • Sorting and filtering data.
  • Formatting data as a table.
  • Exploring basic table tools.

Day 2: Essential Functions, Charts, and Practical Application

• Working with Functions
  • Exploring key functions: COUNT, COUNTA, IF.
  • Using the AutoSum feature for quick calculations.
  • Troubleshooting common formula errors.
• Creating and Customizing Charts
  • Introduction to charts: Column, Line, and Pie charts.
  • Customizing chart elements (titles, legends, axes).
  • Formatting and updating chart data.
• Managing Worksheets
  • Adding, deleting, and renaming sheets.
  • Moving and copying data between sheets.
  • Freezing panes and splitting windows for easier navigation.
• Printing and Sharing Spreadsheets
  • Setting up print options: Margins, scaling, and orientation.
  • Using Print Preview to check formatting.
  • Sharing and collaborating on Excel 365 online.
• Final Project
  • Creating a simple, formatted spreadsheet with basic formulas.
  • Generating a chart from data.
  • Presenting the completed project to the class for feedback.

Pedagogical Methodology

• Hands-On Learning: Real-time practice with provided datasets.
• Guided Exercises: Step-by-step instructions for new skills.
• Q&A Sessions: Time for participants to ask questions and clarify concepts.
• Practical Application: A final project to apply learned skills.

Instructor Expertise

The instructor is a Microsoft-certified expert in Excel and Office 365, with years of experience teaching Excel to beginners and helping professionals use it efficiently in their work.

Materials Provided

• Training workbook with exercises and instructions.
• Sample datasets for hands-on practice.
• Access to recorded sessions for post-training review.

Certification

Participants will receive a Certificate of Completion, demonstrating their foundational skills in Microsoft Excel 365.

Centre de formation PIXYSTREE

Rue Beeckmans, 53
1180 Bruxelles

02/412.04.10
0477/789.445
http://www.pixystree.com