Microsoft Excel

Excel Intermediate (2007, 2010 & 2013)

£149.00

SKU: excel-intermediate Categories: , ,

Product Description

This hands-on one-day training course has been designed for delegates with a basic understanding of Microsoft Excel 2007, 2010 or 2013 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.

Enquire Now!

This course covers Microsoft Excel 2007, 2010 and 2013.

Content covered:

Advanced File Tasks

  • Saving and File Management
  • Converting and Encrypting Files
  • File Properties and Digital Signatures
  • File Accessibility and Compatibility

Working with Functions and Formulas

  • Autosum Functions (SUM & AVERAGE)
  • IF and Nested Functions
  • Working with Named Ranges
  • Array Functions (SUMIF & AVERAGEIF)
  • Formula Auditing
  • Managing Tables in Microsoft Excel
  • Creating Excel Tables
  • Working with Records and Filters
  • Advanced Filters

Data Tools in Excel

  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate

Doing More with Charts in Excel

  • Trendlines
  • Error Bars
  • Working with Axis Options
  • Advanced Chart Formatting

Sparklines

  • Creating Sparklines
  • Editing Sparklines

Reviews

There are no reviews yet.

Be the first to review “Excel Intermediate (2007, 2010 & 2013)”