MS Excel (Level 2)

by IT Training Solutions Ltd Claim Listing

In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways.

£195

Contact the Institutes

Fill this form

Advertisement

IT Training Solutions Ltd Logo

img Duration

1 Day

Course Details

In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways.

The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.

 

Objectives:

  • Use the IF function to automate tasks using tests.
  • Create a summary sheet that will calculate the total for a range of sheets, without duplicating the data, eg. an expenses sheet that takes the monthly totals and displays them on a summary sheet.
  • Filter a spreadsheet to show only the records that meet a specific criteria, eg. all surnames beginning with A.
  • Display data in various graphical formats that can be easily understood by anyone not using Microsoft Excel.
  • Leeds Branch

    The Studio, Riverside West, Whitehall Rd, Leeds
  • Durham Branch

    Oakville 14 Durham Road West, Durham
  • Newcastle Branch

    Clavering House Business Centre Clavering House, Newcastle

Check out more MS Excel courses in UK

Chamber of Commerce Training Logo

Microsoft Excel (Basic To Intermediate)

Excel is a comprehensive tool to help businesses create, analyse and share information using spreadsheets. This course is designed for those who have a basic knowledge of Excel but wish to learn some of the more intermediate functions in order to make better use of spreadsheets.

by Chamber of Commerce Training [Claim Listing ]
Elliott Training UK Logo

Microsoft Access – Introduction

On successful completion of the course, delegates will be able to design tables, setup relationships, produce complex queries and create forms and reports using the Wizards.

by Elliott Training UK [Claim Listing ]
Computer Tutoring Logo

Microsoft Access 2019 Training Course (Intermediate)

This Microsoft Access 2019 Intermediate course will expand your knowledge and skills regarding relational database design, promote quality input from users, improve database efficiency, promote data integrity and implement advanced features in tables, queries, forms, and reports.

by Computer Tutoring [Claim Listing ]
Skillsgen Logo

Using Microsoft PowerPoint

This course is for those who wish to create a sophisticated PowerPoint presentation incorporating advanced features, enhanced graphics, embedded objects; and present the slide show in a professional manner.

by Skillsgen [Claim Listing ]
MSP Training Logo

Microsoft Word Masterclass

The Microsoft Word Masterclass training course is a beginner to an advanced level course designed to create complex and professional quality documents.

by MSP Training [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy