FORGOT YOUR DETAILS?

Microsoft Excel Intermediate 2010/2013/2016 | Training Course

This Microsoft Excel Intermediate course is perfect if you're looking to take on new responsibilities at work, fill the gaps in your resume or simply investing in yourself.

Microsoft Excel is a powerful spreadsheet application designed to help you manage, share and present data in a modern working environment. Whether for professional or personal purposes, Microsoft Excel is an essential skill that will enable you to arrange and analyse data in a way that will make it easier to make informed decisions.

This practical course builds on the techniques and concepts learnt in our introductory unit. Upon completion, you will leave feeling confident about intuitively navigating the interface and creating professional worksheets. This intermediate training course will give you a core understanding of how to use Excel effectively to perform tasks such as opening and managing multiple workbooks, using functions to manipulate data, customise charts and graphs and much more.

Requirements

  • Students should be familiar with using a mouse and working in a Windows environment.
  • To get the most out of this class, you should have attended our Microsoft Excel Introduction course, or have gained similar knowledge in the workplace.
  • You should be comfortable performing basic tasks such as creating and saving workbooks; editing, modifying and formatting worksheets and data; creating basic calculations; using simple functions and preparing worksheets for printing.

Why take this course?

To improve your data presentations – Learning the topics covered in this course will give you more control over styles and formatting, allowing you to more accurately present data.

To access your spreadsheets from anywhere - Excel is used by most businesses and organisations. Learning Excel will enable you to access, edit and share spreadsheets from virtually anywhere.

Increase productivity -  You will learn useful tricks to help you to accomplish more on solo and collaborative projects.

Who should take this course?

  • Anyone interested in understanding the more advanced concepts of using a spreadsheet package within the Microsoft suite.
  • Users without formal Excel training looking to learn the techniques and shortcuts to make them more efficient.
  • Individuals aspiring to achieve Microsoft Certification status.

Duration

1 day

Microsoft Excel Intermediate 1-Day Course Content

  • Relative and absolute cell references
  • Applying and defining cell and range names
  • Using names in formulae
  • Conditional formatting
  • Quick analysis (including Sparklines)
  • Creating custom formats
  • Opening multiple workbooks
  • Switching between and arranging workbook windows
  • Creating formulae across multiple worksheets
  • Creating and managing data links across multiple workbooks
  • Using paste special to transfer data and other characteristics
  • Creating and editing templates
  • New templates
  • Creating a workspace file
  • Using functions to manipulate, tidy and represent text or numeric data accurately
  • Using conditional functions to summarise data
  • Using date and time functions
  • Using logical functions
  • Using nested functions
  • Using lookup functions to reference data
  • Identifying, formatting and modifying chart elements
  • Chart buttons: elements, styles/colour, values; formatting a chart axis
  • Adding a trendline to a chart
  • Creating a combination chart
  • Themes
  • Flash fill
  • Sorting data effectively
  • Using the autofilter tools
  • Creating custom filters
  • Basic data validation
TOP