What you will learn

  • This course offers an awareness of the fundamentals of Microsoft Excel.
  • give attendees the confidence to efficiently create, edit and manage spreadsheets.
  • It introduces calculation writing and gives an understanding of basic mathematical structure.
  • Build effective graphs and charts to gain a visual representation of table data.
  • Group table data using sort and extract data with filters.
  • Because of the useful shortcuts this course offers, it is also suitable for those who are self-taught.

Skills you will gain

  • Shareable Certificate Earn a Cerfiticate upon completion
  • Face to Face or Live Online Start instantly and learn at your own schedule
  • Flexible Schedule Set and maintain flexible deadlines
  • Foundation For those starting from the beginning or with a little experience  

This course consists of 11 lessons

How to create a spreadsheet table including formatting and calculations from scratch.

Wrapping text within cells.

Sorting a table’s columns in ascending or descending order.

Use AutoFill to speed up the input of a series of numbers or dates.

Use the AutoSum function to sum columns and rows of numbers.

Outputting statistical results with the AVERAGE and MAX agratate functions.

Inserting and deleting rows in tables. Quickly adjust multiple column widths.

Visually display your table data by inserting pie charts and column charts

Entering simple mathematical calculations using mathematical symbols

Use Freeze Panes to lock parts of a table on screen while scrolling down a page.

Apply Filters to extract row data based on text and number criteria.

Enquire today

Frequently asked questions

Shareable on LinkedIn

You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.

Are you ready to begin learning exceptional new skills?

Call:
01225 308979

Email:
info@go.courses

Registered Office:
Go Courses Ltd.
10 Laura Place
Bath
United Kingdom
BA2 4BL

View on a map

Delighted satisfaction rating