Microsoft Excel 365 Training Course Beginners Peterborough

Peterborough Beginners Microsoft Excel 365 Course Overview

Stuart House - East Wing
St John's Street
Peterborough PE1 5DD
United Kingdom

This business centre is a strategically located headquarters office building in central Peterborough, in the heart of the business district. It is within walking distance of the bus and railway stations and close to all shopping facilities, including Marks & Spencer and the Queensgate Shopping Centre where tenants include John Lewis, Waitrose and Boots. It is within a quarter mile of junction 5 of the Peterborough Ring Road. Convenient for your Beginners Microsoft Excel 365 Training Course.

Alternatively if you live in and around Peterborough and wish to have your training on-site the we can provide all the equipment, included laptops & projector, required. All we ask is that you provide a little space for the trainer to set up.

Looking for another training courses? Have a look at the other training courses in Peterborough.

Peterborough features a stunning cathedral and a mix of urban and rural landscapes.

Course Duration: 1 Day

Course Prerequisites for your training in Peterborough

This is a beginners training course, so no advanced skills are required, just a willingness to learn! To make the most of your training experience, we recommend:

• Familiarity with using a PC or Mac, including navigating with a mouse or equivalent device.
• Confidence in accessing the internet and downloading files as needed.

Complete Course Outline

Introduction to Excel 365 and the Excel Interface

• Understanding rows, columns, and cells
• Navigating and selecting data in a worksheet
• Entering and editing data in cells
• Basic formatting techniques (e.g. changing font size, colour, and alignment)

Basic Formulas and Functions within Excel 365

• Using basic arithmetic operators (e.g. +, -, *, /)
• Understanding the difference between relative and absolute cell references
• Using functions such as SUM, AVERAGE, MIN, and MAX

Working with Multiple Worksheets and Workbooks

• Creating, renaming, and deleting worksheets
• Moving and copying data between worksheets and workbooks
• Linking data between worksheets and workbooks

Sorting and Filtering Data

• Sorting data alphabetically or numerically
• Filtering data using criteria
• Advanced filtering techniques (e.g. using AND/OR logic)

Working with Basic Charts and Graphs

• Creating and formatting charts and graphs
• Adding data labels and data tables to charts
• Changing the chart type and style

Importing and exporting data

• Importing data from other sources (e.g. CSV files, databases)
• Exporting data to other formats (e.g. PDF, CSV, HTML)

Collaborating with Others, Including Printing

• Sharing workbooks and worksheets with others
• Tracking and resolving conflicts in shared workbooks
• Protecting worksheets and workbooks with passwords
• Printing worksheets

Other Related Courses

Microsoft Excel 365 Training Course Intermediate

Microsoft Excel Power BI Training Course Beginners

Microsoft Word 365 Training Course Beginners

Microsoft PowerPoint 365 Training Course Beginners

Microsoft Office 365 Training Course Beginners

Microsoft Outlook 365 Training Course Beginners

Microsoft Excel and Forms 365 Training Course Beginners

Microsoft SharePoint 365 Training Course Beginners

Browse all of ourExcel Training Courses

Post-Course Resources

• Training notes & exercise files
• Online materials: video tutorials & shortcuts
• 3 months post training support

All you need to know about our Live Online Training.

Live Online Training