INTRODUCTION TO MICROSOFT EXCEL

Microsoft Excel is probably one of the most important pieces of software in business. It is a spreadsheet tool which allows users to analyse and evaluate data extremely quickly and to test it for various scenarios without altering the underlying data. It also allows users to present the data visually in the form of graphs so that the data can quickly be understood by a bigger audience.
 
The introduction to Microsoft Excel course is suitable for those with little or no prior knowledge of  Excel and focuses on the basics of creating spreadsheets including entering and editing data,formatting spreadsheets, basic formulae, functions and charts.
 
EDITING FEATURES - Working with sheets
  • Insert and delete columns and rows
  • Cut/Copy/Paste
  • Printing
  • Autofill 
FORMATTING - Formatting text and numbers
  • Font formatting
  • Borders and shading
  • Number formatting
CALCULATIONS - Formulae and functions
  • Basic calculations
  • Order of precedence
CHARTING - Creating and editing charts
  • Basic charting
  • Formatting charts


MICROSOFT EXCEL INTERMEDIATE TRAINING

The intermediate Microsoft Excel training course is suitable for existing users of Excel and focuses on working with large spreadsheets, manipulating data and advanced charting techniques.
 
DATA MANIPULATION - Controlling data using:
  • Auto filtering
  • Grouping and outlining
  • Freeze panes and splitting
  • Sorting data
  • Working with comments
RANGES - Manipulating worksheets using:
  • Named ranges
  • Conditional formatting
  • Hiding/un-hiding data
ADVANCED CHARTING - Building on basic charting using:
  • Combining multi-chart types
  • Custom chart formats
  • Creating secondary axis
 
COURSE DURATION
  • Half day
MAXIMUM COURSE PLACES
  • 8 places per course

Enquire now about MICROSOFT EXCEL TRAINING
t: +44 (0)1536 533 541
 

 

MICROSOFT EXCEL INTRODUCTION 

COURSE DATE: See course list
TIME: 9.00am - 1.00pm
VENUE: Merlin Training Suite
COURSE FEE: £150 plus VAT
CALL: 01536 533 541 to discuss
 

MICROSOFT EXCEL INTERMEDIATE

COURSE DATE: See course list
TIME: 9am - 1pm
VENUE: Merlin Training Suite
COURSE FEE: £150 plus VAT
CALL: 01536 533 541 to discuss
 

Customer Login
basket