EXCEL Training Course

ittrainingimg

Excel training

At our company we offer excel training that is designed to help you to use excel to analyse data on any level. Whether you just want to learn how to create spreadsheets or you need to perform advanced data analysis with functions, formulas and charts our excel training can help.

What it can cover

This training course can cover a wide range of different topics like cell formatting, creating pivot tables, writing what-if equations and how to visually represent data with charts and graphs. We are also able to tailor the course around your current knowledge of excel and what you want to learn about during our training.

Learning options

You can choose to do this course online, at our workplace or we can arrange to come out to your workplace if there is more than one person who wants to learn about excel.We are regularly out at workplaces all over the UK so if you are in the UK then this option is available to you.

Who it is suitable for

This training course is suitable for anyone who wants to learn more about excel and how it works, so there isn’t a criteria that needs to be met. All that we would ask is that you are keen to learn about excel.

Course Outline

The Screen / The Ribbon / Office Button/
Quick Access Toolbar
Excel Options Menu
Screen Tips / Using Help
Excel Shortcuts
Overview of the Spreadsheet / Cell Addresses
Cursor Movement / GoTo / Excel Navigator
Selecting Methods
Working with Ranges & Named Ranges
Name Manager
Data Entry /Editing
Text / Numbers / Custom Lists / Fill Ranges
Quick Copy etc.
Cut / Copy / Paste / Paste Special Functions
Relative /Absolute Cell Addresses
Copying between Sheets / Files
Creating / Importing / Using Custom Lists

Formula / Formatting the Worksheet
Formatting cells
Numeric / Alignment Options / Fonts / Borders / Patterns
Conditional Formatting
File Handling
Using Save / Save As – Directories / Drives / File Type
Adding Password Protection
Protecting the Sheet / Workbook
Using Format Painter
Working with comments

=Functions

SUM / AVERAGE / MIN / MAX / COUNT / COUNTIF / SUMIF/ DATE & TIME FUNCTIONS / NOW() IF STATEMENTS/ AND and OR
Named Ranges in Formula
Headers and Footers / Print Area / Page Break Preview / Orientation / Print Preview /Changing the Set Up / Freezing Panes / New Window
Working with Charts
Creating a Chart
Change Design / Layout / Colours / Format
Change the Chart Type

Course Schedule
Course Date City Duration Price Book Now
EXCEL Training Course 17 – 18 Sep Glasgow 1 day £100 Book Now
EXCEL Training Course 24 – 25 Sep Glasgow 1 day £100 Book Now
EXCEL Training Course 17-18 Oct Glasgow 1 day £100 Book Now

Contact Us

To get in touch, call us on 0141 280 9900 or fill in the form below.

Please select the course(s) which you want.*
WordpressDigital MarketingITSocial Media

captcha