• About
• Our IT Courses
  • Personal Communication Courses
  • Computer & IT Courses
    • Essential IT Courses
    • Business IT Courses
    • Bootcamp
    • Silver surfer
• IT Training for Individuals
• IT Training for Companies
• Our Offices
• Links
• Contacts

Excel Course for Business

Category

Business Class

Description

This course will build on the skills you have learnt on our Essential Excel course or already posess and teach you the more advanced features of the application.  You will become familiar with lists, and sorting and filtering data.  You will learn how to create hyperlinks, create and modify charts, and look at the more advanced functions and formula.

 

Working with Graphs & Charts

·            Create Column, Line and Pie Charts

·            Edit & Format charts

·            Change the chart type

·            Update charts

·            Link charts to other worksheets

 

Advanced Formulae & Functions

·            Working with %

·            Absolute & Mixed Cell Referencing

·            Named Ranges

·            Conditional Formulae

·            IF statements

·            Sum IF, Count IF

 

Working with Lists

·            Sort Data Lists

·            Filtering Data

·            Create and Apply Advanced Filters

·            Creating custom lists

·            Introducing V Look Up

 

Linking Worksheets and Workbooks

·            Working with Hyperlinks

·            Link data from worksheets

·            Link data from workbooks

·            Export to Microsoft Word

 

Summarising Data

·            Pivot Tables

·            Pivot Charts

·            Data Consolidation

 

 

Data Worksheet Protection

·            Protect Cell Contents

·            Protect Workbook

·            Share workbooks

·            Inserting Comments

·            Revision Tracking

Price: £150

 

Book Now