Microsoft Excel 2010/2013 Intermediate

Course

Online

£ 199 + VAT

Description

  • Type

    Course

  • Methodology

    Online

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 and 2013, in order to increase their knowledge and productivity.

Target Audience Users 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. Maximum class size for Microsoft Excel courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegatesl What happens on the day If you are coming to our centre, dress code is smart casual.   Refreshments and a free buffet lunch will be provided, but please note that, as a training company who relies on caterers, we are unable to reliably provide for differing dietary requirements, so if you are in any doubt then please bring your own.  The timetable is as follows: 9:15: - Arrival time9:30: - Training starts11:00: - Mid-morning break1:00: - Lunch break (one hour)3:15: - Mid-afternoon break4:30: - Wrap up Note: break times can vary according to the needs of the training, and course duration for smaller class sizes can be shorter because fewer delegates have fewer questions. What you get You get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge. With all Excel 2007, 2010 and 2013 courses, you are also given 14-day access to free eLearning revision which will further help you to reinforce the lessons you have learned. Every delegate on a Microsoft Excel Intermediate (2007, 2010 & 2013) course also gets a Training Attendance Certificate. Learning Objectives Quickly summarise multiple tabs of dataTurn long lists and...

About this course

A working knowledge of Excel

Questions & Answers

Add your question

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

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MS Excel
  • Microsoft excel training
  • Microsoft Excel
  • Excel

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

Microsoft Excel 2010/2013 Intermediate

£ 199 + VAT