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

Chamber of Commerce Training Logo

Microsoft Word (Selected Intermediate & Advance Features)

This afternoon session is suitable for delegates with existing Word experience and who are required to produce longer Word documents.

by Chamber of Commerce Training [Claim Listing ]
STL Logo

PowerPoint Introduction Training Course

Our Microsoft Powerpoint Introduction course is suitable for complete beginners to Microsoft Powerpoint.

by STL [Claim Listing ]
Escalla Logo

MS Visio Course

During this hands-on session, you will learn how to create flowcharts and cross-functional flowcharts to visualize business processes, and how to create organization charts to display a hierarchy of personnel.

by Escalla [Claim Listing ]
Kalu Logo

Microsoft Office Word (Intermediate/Advanced)

With Microsoft Office Word Intermediate/Advanced 2 day course you will learn advanced features of Word which will assist your current level of Microsoft Office Word. With this course, you will be able to create professional documents, compose correspondence, produce manuscripts and brochures

by Kalu [Claim Listing ]
Storm Training & Solutions Logo

Microsoft Word Training (Intro)

n site Microsoft Word courses tailored to your needs, designed for businesses and professionals. All Microsoft Office Word versions including 2003, 2007, 2010, 2013, 2016 and Office 365 covered.

by Storm Training & Solutions [Claim Listing ]

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