Excel Online

1 Day Instructor-led
course icon

Course Information

Excel Online is Microsoft’s cloud-based, easy-to-use spreadsheet program. This course is intended to help all users get up to speed with Excel Online. By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulas and functions, and making a spreadsheet look professional and presentable. View Outline

Private Courses

We can arrange your own private Online course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

Some of our customers

Course Outline

1. Getting Started
  • Getting Started with Excel Online
  • Getting to Know Excel
  • Managing Workbooks
  • Getting Help in Excel Online
2. Working with Data
  • A Closer Look at Formulas
  • Using Formulas and Functions
  • Working with Data
  • Working with Rows and Columns
  • Sorting and Filtering Data
3. Formatting a Worksheet
  • Formatting Text
  • Formatting Cells
  • Aligning Cell Content
  • Using Find & Select Tools
  • Applying Conditional Formatting
4. Adding Pictures and Shapes
  • Inserting Pictures
  • Inserting Shapes
  • Formatting Shapes
5. Organizing Worksheet Data with Tables and Charts
  • Inserting Tables
  • Inserting Charts
  • Modifying Charts
6. Using Pivot-Tables
  • Inserting PivotTables
  • Working with PivotTable Data
  • Sorting and Filtering PivotTable Data
7. Finalizing Workbooks
  • Using Comments
  • Managing Worksheets (Part One)
  • Managing Worksheets (Part Two)
  • Changing View Options

What Our Clients Think

This has been by far one of the most useful and well planned/executed training courses I have ever attended. For this to have been achieved remotely just adds to how impressive it was managed.

Trevor Stratton - Lincolnshire County Council

Very good, trainer was excellent.

Mike Hartley-Bingle - XPS Pensions Group

Cannot fault the content & delivery of the course at all. A brilliant service from start to finish. Thank you Systematix.

Claire Mitchell - Denbighshire County Council

Excellent course, The trainer was very helpful and taught the group a wide range of new Word skills.

Ben Cooper - TSS

This course was great, the trainer was very knowledgeable and has improved my knowledge considerably. The facilities are fantastic. Thank You!

Kurtis Fleming - HM Revenue & Customs

I found the course very relevant to a lot of the day-to-day work I do.

Sian Stephenson - Aldi Stores Ltd

Related Courses

Format:
Virtual or Classroom
Length:
1 Day
This course is intended to introduce users to Microsoft 365 and get started with basic tasks, such as logging into and out of their accounts, and modifying basic account s...
Format:
Virtual or Classroom
Length:
1 Day
By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulas and functions, and making a spreadsheet look professiona...
Format:
Virtual or Classroom
Length:
1 Day
By the end of this course, students should be comfortable using Outlook Online in their day-to-day workflow. Key learning areas will include creating and sending messages, ...
Format:
Virtual or Classroom
Length:
1 Day
This course is intended to help all users get up to speed quickly with PowerPoint Online. We will cover: getting started with the app; creating and delivering a simple pres...
Format:
Virtual or Classroom
Length:
1 Day
Using Word Online, you can create professional documents of nearly any type. We will cover getting started with the app, formatting text, working with images and objects, a...
Format:
Virtual or Classroom
Length:
1 Day
OneNote Online includes familiar Office features (such as the ability to add different types of content to a notebook), as well as unique note-taking options, such as handw...