Course not currently available

EXCEL INTERMEDIATE

Course

Online

£ 295 VAT inc.

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    1 Day

This hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts used in Excel 2007, 2010, 2013 or 2016, in order to increase their knowledge and productivity.

About this course


Users with a basic understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.


Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Auditing
  • IT
  • Microsoft Excel
  • Spreadsheet
  • IT Auditing
  • Web
  • Excel Formula
  • Excel Sheet
  • Microsoft excel training
  • MS Excel
  • Spreadsheets
  • Excel training
  • Excel v2007/2010

Teachers and trainers (1)

Taylor Mason

Taylor Mason

Very Experienced Trainers

All our trainers are experts in their field, most of which have worked for us for some time. From 1-1 coaching to complex change programmes we have the skills and experinece. We cover, Human Resouces, Communicaton Skills, Leadership and Supervision, Microsoft & IT, Sales & Marketing, Personal Development, Health & Safety, Project Management, PA & Office Skills,

Course programme

MODULE 1: Advanced File Tasks

Learning outcomes:

A look at some important administrative features which are useful for managing and controlling Excel files.

Topics covered:
  • Saving and File Management
  • Converting and Encrypting Files
  • File Properties and Digital Signatures
  • File Accessibility and Compatibility
MODULE 2: Working with Functions and Formulas

Learning outcomes:

Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.

Topics covered:
  • Autosum Functions (SUM & AVERAGE)
  • IF and Nested Functions
  • Working with Named Ranges
  • Array Functions (SUMIF & AVERAGEIF)
  • Formula Auditing
  • Formulas with Absolute References
  • Text Functions
MODULE 3: Managing Tables in Microsoft Excel

Learning outcomes:

Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.

Topics covered:
  • Creating Excel Tables
  • Working with Records and Filters
  • Advanced Filters
MODULE 4: Data Tools in Excel

Learning outcomes:

Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.

Topics covered:
  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate
MODULE 5: Doing More with Charts in Excel

Learning outcomes:

Developing your ability to effectively create charts and format them specific to the reader

Topics covered:
  • Trendlines
  • Error Bars
  • Working with Axis Options
  • Advanced Chart Formatting
MODULE 6: Sparklines

Learning outcomes:

Use Sparklines to help analyse data by creating small customisable charts within cells. Edit and format the Sparklines and data points to help your data stand out

Topics covered:
  • Creating Sparklines
  • Editing Sparklines

EXCEL INTERMEDIATE

£ 295 VAT inc.