request@systematix.co.uk
supermarketBasket
Call Us On:
0118 324 3000

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.

Course Outline

Download PDF 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

Dates & Availability

We currently don’t have any dates scheduled for this training course but offer it as a corporate, private course for your own team.

Please use the enquire button below.

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.

Delivery Options:
On-Site At Your Offices
Virtual Online Virtual Online
Training Centres Training Centres

What Our Clients Think

Really good course. lots of hands on practice and clear explanations.

fiona dawe - Covetrus Global Software Services

The trainer did a fantastic job of delivering the course and providing understanding

Niall Simmons - Haven Power

Really good trainer. He made the training interesting and fun.

Wendy Sipson - Hampshire Constabulary

Very good, trainer was excellent.

Mike Hartley-Bingle - XPS Pensions Group

Got a really good and rounded training session. It met more than my original needs, and has given me great confidence.

Debbie Seymour - FatFace

The pace he delivered the course was perfect and he explained everything so clearly and in a way I could understand.

Jessica Homer - All About Food

Related Courses

Getting Started with Microsoft 365

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...

Excel Online

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...

Outlook Online

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, ...

PowerPoint Online

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...

Word Online

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...

OneNote Online

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...