Microsoft Excel - 2013

Heading

Beginner course

Subjects covered in this course include:

  • Before you start
  • What is a spreadsheet program?
  • Getting started with Microsoft Excel
  • Workbook windows and views
  • Basic spreadsheet skills
  • Selecting cells
  • Edit copy and move cells
  • Tell me and help
  • Opening and saving workbooks
  • Using OneDrive
  • New workbooks and templates
  • Absolute and relative cell references
  • Auto sum and auto fill
  • Formatting numbers
  • Formatting cells
  • Cell alignment
  • Cells, rows and columns
  • Working with worksheets
  • Proofing workbooks
  • Page layout
  • Printing and previewing workbooks
  • Sharing workbooks
  • Basic options

Intermediate course

Subjects covered in this course include:

  • Defined names
  • Sorting data
  • Excel tables
  • Filtering data
  • Chart basics
  • Chart design tools
  • Chart format tools
  • More about charts
  • Introduction to functions
  • Date functions
  • Logical functions
  • Information functions
  • Financial functions
  • Find and replace
  • Headers and footers
  • Adding comments
  • Conditional formatting

Advanced course

Subjects covered in this course include:

  • Custom number formats
  • Custom lists
  • Formula auditing and error tracing
  • Text to columns
  • Data validation
  • Consolidate data
  • Text functions
  • Maths and trig functions
  • Statistical functions
  • Lookup functions
  • Database functions
  • What-if analysis - Goal seek
  • What-if analysis - Data tables
  • What-if analysis - Scenarios
  • Paste special
  • Subtotals and grouping
  • Getting external data
  • Pivot tables and pivot charts
  • Workbook properties and inspection
  • Protecting workbooks
  • Sharing workbooks
  • Tracking changes
  • Compare and merge workbooks
  • Linking data
  • Hyperlinks
  • Illustrations
  • An introduction to macros
15
£95 + VAT

If you would like more information regarding this e-learning course, please do not hesitate to contact us.

Funding maybe available for this course – contact us for availability.

Microsoft Excel - 2013

Beginner course

Subjects covered in this course include:

  • Before you start
  • What is a spreadsheet program?
  • Getting started with Microsoft Excel
  • Workbook windows and views
  • Basic spreadsheet skills
  • Selecting cells
  • Edit copy and move cells
  • Tell me and help
  • Opening and saving workbooks
  • Using OneDrive
  • New workbooks and templates
  • Absolute and relative cell references
  • Auto sum and auto fill
  • Formatting numbers
  • Formatting cells
  • Cell alignment
  • Cells, rows and columns
  • Working with worksheets
  • Proofing workbooks
  • Page layout
  • Printing and previewing workbooks
  • Sharing workbooks
  • Basic options

Intermediate course

Subjects covered in this course include:

  • Defined names
  • Sorting data
  • Excel tables
  • Filtering data
  • Chart basics
  • Chart design tools
  • Chart format tools
  • More about charts
  • Introduction to functions
  • Date functions
  • Logical functions
  • Information functions
  • Financial functions
  • Find and replace
  • Headers and footers
  • Adding comments
  • Conditional formatting

Advanced course

Subjects covered in this course include:

  • Custom number formats
  • Custom lists
  • Formula auditing and error tracing
  • Text to columns
  • Data validation
  • Consolidate data
  • Text functions
  • Maths and trig functions
  • Statistical functions
  • Lookup functions
  • Database functions
  • What-if analysis - Goal seek
  • What-if analysis - Data tables
  • What-if analysis - Scenarios
  • Paste special
  • Subtotals and grouping
  • Getting external data
  • Pivot tables and pivot charts
  • Workbook properties and inspection
  • Protecting workbooks
  • Sharing workbooks
  • Tracking changes
  • Compare and merge workbooks
  • Linking data
  • Hyperlinks
  • Illustrations
  • An introduction to macros

Other Courses in 

Microsoft Office Training

How to purchase a course

Choose a category

There are 6 categories to choose from including: Enterprise Programmes, Business Skills, Compliance, CSR, Well Being and Personal Skills.

01

Choose a course

Each category will contain a range of courses to choose from. For example, the category 'Personal Skills' contains the following courses: Personal Development, Management & Leadership, and Communication & Social Skills.

02
03

Purchase course online

If you like what you see then all you have to do is click on the 'Add To Cart' button which will bring up a panel on the right hand side of the page. From there you will be able to purchase the course you have chosen on a secure payment link.

04

Receive course login

You will receive your course login details within 24 working hours from cleared payment.

Don't miss MENTA mail - Let Us Help your Business

networking, training and business events in your inbox
heretohelp@menta.org.uk
0800 085 5090

top of page