Microsoft Excel Training
for Companies and Organisations
Does Your Team Need Microsoft Excel Training ?
Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.
For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!
Please select the version that you’re interested in
Please select the level that you’re interested in
Microsoft Excel 2016 Introduction
This course is designed for new users of Microsoft Excel, or self-taught users. The course covers all aspects of creating and maintaining spreadsheets; including basic formulae and functions.
No Prior experience or knowledge of Spreadsheets is required to attend this course. You must have good basic windows, keyboard and mouse skills.
This is a 1 day Excel Introduction Course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.
Our Microsoft Excel Introduction course can be run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.
Excel 2016 Introduction Course Outline
SCREEN LAYOUT AND EXCEL BASICS
Understanding Workbooks, Worksheets, Rows, Columns, Cells
Various selection techniques
Understanding different Mouse shapes
Dialog Box Launchers
Quick Access Toolbar (QAT)
Formula Bar Customization
File Tab (Backstage View)
Page Layout View
Access Keys (Shortcut keys)
Saving, File types, File Compatibility (with earlier Versions)
Various selection techniques
Pinning Recent Files
ENTERING, SELECTING AND EDITING DATA
Entering, Editing and Deleting information in cells (Text, Date, and numbers)
Entering Auto Lists
Using Fill handle to create simple lists
Creating custom lists
Deleting Rows, Columns, and Cells
Inserting Rows, Columns and Cells
Inserting, Deleting, Moving, Copying and Renaming Sheets
Various Navigation Techniques using Scroll bar, Keyboards and Go To command
Using the Paste Preview
CREATING FORMULAE AND FUNCTIONS
Editing Existing Formulae
BODMAS: Mathematical Order
Understanding Relative Referencing
Understanding Absolute Referencing
Using the Auto Sum Feature
Common Basic Functions: SUM, MIN, MAX, AVERAGE, COUNT, COUNTA
Using the Formulas Tab
FORMATTING CELLS, ROWS, COLUMNS AND SHEETS
Cell Alignment And Orientation
Applying borders and shading
Changing Column Widths
Changing Row Heights
Changing sheet Tab Colours
Using Format Painter
DATA SORT AND FILTER
Creating Simple Charts
Adding Headers and Footers
Printing A Selection
Setting A Print Area
Adjusting page breaks using
Repeating columns and rows
Centre On Page
One to One
(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training
Group for up to 8 learners
What Our Clients Say
This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.