Explore Contact us

What you will learn

  • This course offers an awareness of the fundamentals of Microsoft Excel and aims to 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
  • On Demand or Face to Face 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  
  • English Subtitles: English

This course consists of 11 lessons

Create a Table: Creating an Excel table from scratch - Wrapping text in cells - Formatting table content - Speed up data entry with AutoFill - Sorting columns.

Inserting Functions: Inserting and managing function calculations - Using AutoSum to sum numbers - Inserting statistical calculations AVERAGE, MAX and MIN.

Managing Rows and Columns: Inserting and deleting table rows and columns - Quickly adjusting multiple column widths and row heights - Hiding and unhiding rows and columns.

Writing Formulas: The basics of writing formulas - Understanding the use of mathematical symbols - Using more than one mathematical symbol in a calculation - When to use brackets - Troubleshooting calculation errors.

Managing sheets: Inserting, renaming, moving and deleting sheets - Coping a sheet to another file - Copying a table to another location.

Managing Content Formatting: Appling content formatting - Managing number formatting - Control formatting with the Format Painter.

Sorting and Filtering Tables: Using Freeze Panes to lock table headings when scrolling - Sorting multiple columns - Using Filters to extract table information.

Table Reports: Using the Table tool to run reports - Including totals in reports.

Creating and Modifying Charts: Creating Pie and Column charts - Inserting chart titles and labels - Controlling chart formats - Changing chart type.

Printing: Previewing and printing tables and charts - Modifying page orientation - Adjust margins for printing - Printing selected tables.

Absolute Referenced Formula: Understand the difference between a Relative and Absolute formula - Using a $ sign to lock formulas to cells when copying.

Show more

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