Microsoft Excel Training Courses from Activia

Microsoft Excel Intermediate

A 1-Day Training Course

Course Content

Course Aims

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.

Who Should Attend

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.

Course Outline
This course is a 1-day training course structured into 7 modules.
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
    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
  • Module 7
    Excel Styles and Themes
    Topics covered
  • Applying Cell Styles
  • Creating Custom Styles
  • Working with Themes

  • Activia Training :   Training courses for business at twelve locations UK wide