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

Exciting News! Systematix is rebranding to Future Savvy. Same great services, with a fresh new look. Learn More

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

Very good at tailoring the course to my needs. Very individual and attentive.

Andrew Griffin - Blackfin

Really enjoyed this course. It delivered exactly what I wanted out it.

Malkit Singh - Regatta Ltd

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

Debbie Seymour - FatFace

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

Ben Cooper - TSS

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

The trainer was an amazing lecturer and the vba course was very usefull and well structured. Thank you.

Veronika Panton - Haven Power

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