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

M Training Logo

Beginner Excel Course

It will give you practical Excel skills and knowledge to take away, from basic to intermediate levels. You will learn simple formatting through to utilising formulas and creating reports. Along the way we will show you plenty of hints, tips and shortcuts, to make using Excel easier, quicker and mo...

by M Training [Claim Listing ]
Acudemy Logo

Microsoft Office Essentials

Microsoft Office has a lot of tools, but they can be hard to find. The goal of this course is to teach you how to be efficient in the office’s different programs and to give you a few tips that will help you save time while using Outlook, MS Excel and Word.

by Acudemy
ITrain Scotland Logo

Microsoft Access Level 1

Whether you are a new user or have been using Access for years, this course will vastly increase your understanding of Access.

by ITrain Scotland [Claim Listing ]
Elliott Training UK Logo

Microsoft Visio 2016 – Intermediate

In this course, you’ll learn intermediate skills using Microsoft Office Visio Professional, including creating organisational charts, network diagrams, customised charts and graphs, and cross-functional flowcharts.

by Elliott Training UK [Claim Listing ]
Training 26 Logo

Microsoft Excel

Microsoft Excel training can be delivered for which ever version is required from 2007, 2010, 2013, or 2016, at three basic levels, Introduction, Intermediate, and Advanced.

by Training 26 [Claim Listing ]

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