Course not currently available
Excel Intermediate
-
The instructor was excellent, I felt really confident as so many concept were cleared. Would recommend this course as its total value for money.
← | →
-
Trainers were great and made the session informative and engaging. I learned handy tips from the trainers and everything was great.
← | →
-
Information, interactive and engaging sessions of all time. I learned Excel here like no place. It was great. All concepts were cleared in detail in utmost lucid manner.
← | →
Short course
In London ()
Develop your abilities and learn how to manage tables in Microsoft Excel!
-
Type
Short course
-
Duration
1 Day
Do you want to improve your skills in Microsoft Excel? If the answer is yes, this course is right for you.
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.
Click on our website Emagister.co.uk in order to find all the information related to the Microsoft Excel Intermediate Course. We will inform you about the course without any obligation.
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.
Reviews
-
The instructor was excellent, I felt really confident as so many concept were cleared. Would recommend this course as its total value for money.
← | →
-
Trainers were great and made the session informative and engaging. I learned handy tips from the trainers and everything was great.
← | →
-
Information, interactive and engaging sessions of all time. I learned Excel here like no place. It was great. All concepts were cleared in detail in utmost lucid manner.
← | →
Course rating
Recommended
Centre rating
Daniella Keys
Helen Unsworth
Natasha Osborne
Susan SMITH
Charlene Jarrett
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 15 years
Subjects
- Excel
- Microsoft Excel
- Microsoft excel training
- MS Excel
- Sparklines
- Advanced File Tasks
- Working with Functions and Formulas
- Managing Tables in Microsoft Excel
- Data Tools in Excel
- Doing More with Charts in Excel
Teachers and trainers (1)
Simon Bradley
IT Trainer
Course programme
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
Learning outcomes: Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.
Topics covered:
- Formulas with Absolute References
- Autosum Functions (SUM & AVERAGE)
- IF and Nested Functions
- Working with Named Ranges
- Array Functions (SUMIF & AVERAGEIF)
- Formula Auditing
- Text Functions
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
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
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
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