Intermediate Excel

by HWGTA Claim Listing

This Intermediate course assumes that you will have a good working knowledge of all of the principles covered in the introductory Excel course.

£195

Contact the Institutes

Fill this form

Advertisement

HWGTA Logo

img Duration

1 Day

Course Details

This Intermediate course assumes that you will have a good working knowledge of all of the principles covered in the introductory Excel course.

It is also expected that you will know how to open and save files to a folder in Windows, have a good working knowledge of the layout and use of a QWERTY keyboard including use of shift, tab and control keys and understand how to select blocks of content by clicking with a mouse.

The course assumes a working knowledge of basic Excel functions such as SUM, COUNT and AVERAGE as well as the ability use absolute cell references with confidence.

By the end of the session delegates will be able to:

  • Inserting and renaming a new Worksheet

  • Importing Data from External Files

  • Data Validation (Drop Down Lists)

  • Conditional Formatting

  • Advanced Formatting

  • Auto Filters

  • Removing an Auto Filter

  • Advanced Auto Filtering

  • Using Named Cells and Ranges  

  • Calculating Across Worksheets 

  • Protecting Worksheets 

  • Creating a Shared Workbook

  • Advanced Functions (IF, AND, OR, VLOOKUP, HLOOKUP, CONCATENATE etc)

  • Mathematical Functions              

  • Using LOOKUPS  to Access Ranges

  • Introduction to Pivot tables

  • Pivot Table Charts

  • Hereford Branch

    Holmer Road,, Hereford

Check out more MS Excel courses in UK

Enliten IT Logo

Visio Course (2019 Introduction)

This Microsoft Visio 2019 Introduction course provides practical guidance on how to create a range of business and technical diagrams and layouts.  You will learn the concepts of creating various floor plans, flow charts, ideas, processes, maps etc.

by Enliten IT [Claim Listing ]
Etopia Training Logo

Microsoft Word (Intermediate)

A hands-on instructor-led Microsoft Word training course allowing people with an existing knowledge of Word fundamentals to improve their skills and create better documents.

by Etopia Training [Claim Listing ]
Teach All About IT Logo

ICDL Advanced Access Databases

This course may be studied as a stand alone Advanced Access course with a CPD certificate of completion, or as part of the larger Advanced ICDL IT User Skills qualification.

by Teach All About IT [Claim Listing ]
NILC Training Logo

Microsoft Outlook Introduction Training Course

This Microsoft Outlook training class introduces the interface and gets students up and running quickly working with messages, calendars, and contacts.

by NILC Training [Claim Listing ]
Kaplan UK Logo

Introduction To Excel Functionality

Microsoft Excel is one of the most important business tools any of us will use. It’s the tool of choice for presenting and analysing data. However, even though Excel is so widely used, much of the workforce don’t know how to apply all of the fantastic tools which are available.

by Kaplan UK [Claim Listing ]

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