Microsoft Excel 365 Basic In-Company Training | Practical Learning in Data, Formulas, and AI (Copilot)
Microsoft Excel 365 is the essential tool within Microsoft 365 for processing, analyzing, and presenting data. While many employees use Excel daily, most only utilize a fraction of its capabilities. In this hands-on in-company training, your team will learn how to use Excel 365 efficiently — including the latest AI-powered features with Microsoft Copilot.
This training focuses on the essential skills: from working with tables and formulas to visualizing data using charts. Participants will also learn how to use Copilot to automatically generate formulas, extract insights from data, and complete tasks faster. The course is fully tailored to your organization and work context.
Who Is This Training For?
This training is ideal for:
- Administrative staff and project support roles
- HR, finance, and sales professionals who work with numbers
- Beginners needing a solid foundation in Excel
- Anyone looking to work smarter and more efficiently with Excel 365
Course Content – Microsoft Excel 365 Basic In-Company Training
Introduction to Excel 365
- The Excel interface and navigation within Microsoft 365
- Opening, saving, and sharing files via OneDrive or SharePoint
- Working with worksheets, cells, rows, and columns
- Basic formatting: numbers, text, styles, and conditional formatting
Calculations and Functions
- Using basic functions like SUM, AVERAGE, MIN, MAX
- Creating, copying, and editing formulas
- Understanding and applying relative and absolute cell references
- Adding, subtracting, multiplying, and dividing within formulas
Organizing and Structuring Data
- Sorting and filtering data
- Using tables for structured datasets
- Validating data with dropdown lists and input controls
Analyzing and Visualizing Data
- Creating and modifying pivot tables
- Building charts and graphs for visual data representation
- Using quick analysis tools
AI Support with Microsoft Copilot in Excel
- Automatically generating formulas using natural language
- Requesting summaries and insights from Copilot
- Receiving chart and pivot table suggestions based on data
- Asking Copilot for real-time explanations and analysis
Wrap-Up and Practice
- Improving and applying personal Excel files
- Best practices and tips for working more efficiently
- Q&A and in-depth support for specific work processes and questions
Key Benefits and Additional Options of This In-Company Training
- Free GDPR-compliant baseline assessment via Microsoft Forms, reviewed by a MOS-certified trainer to assess skill levels and learning objectives
- Free intake call with a MOS-certified trainer to create a customized course proposal
- Customized training aligned with your team’s work environment and goals
- Training delivered on-site or online, at a time that works for you
- Optional Microsoft Copilot module, license available for €50 per person per day (AI support in Office)
- Training led by a MOS-certified instructor for expert, practical guidance
- Maximum of 12 participants for optimal personal attention and interaction
- Online evaluation and PDF certificate of completion sent immediately after the session
- Optional printed and mailed certificate available at an additional cost
- Laptop rental available at an additional cost
- 3 months of post-training email support for content-related questions
- Optional Gmetrix practice exams for certification preparation
- Optional Certiport MOS exam for official certification
Additional Microsoft 365 Trainings
Combine this training with other popular Microsoft 365 courses:
Request Your Free Tailored Quote
This in-company training is fully tailored to your organization’s needs and objectives. Includes a free intake call, online baseline assessment, and expert advice. We help your team get the most out of Microsoft 365 and Excel — in a way that fits your real work environment.
Over 500 companies and organizations have already chosen our training programs. OEM Office Elearning Menu was also named the #2 Best ICT Training Provider in the Netherlands (Springest).
Want to learn how this training can benefit your organization? Request your free tailored quote today with no obligation.
Request Your Free Quote and Proposal
