Course Description

Microsoft Excel 2016 Intermediate Online Course

Microsoft Excel 2016 Intermediate Online Course is a course run by 1 Training, Dublin. For more information about Microsoft Excel 2016 Intermediate Online Course at 1 Training, please review the details below.

Microsoft Excel 2016 Intermediate Online Course


Improve your Excel skills! Understand PivotTables, Slicers, Charting, Sparklines and other unique features of Microsoft Excel 2016. A good understanding of Excel will give you the edge as this power-packed Microsoft office program can boost your productivity.

The Microsoft Excel 2016 Intermediate course will upgrade your basic understanding of Microsoft Excel. The knowledge and understanding of Microsoft Excel skills at the intermediate level will afford you the opportunity to work with speed and accuracy for numerical calculations. Also, by the upgrading of your skills, the presented data will look more sharp and professional.

The Microsoft Excel 2016 features changes on the user interface, besides there are many new features that have been added and enhanced to make using Excel more user-friendly and efficient.

Why consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects, online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility make it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

Learning Outcomes

  • Learn to use formulas and functions.
  • Create and modify charts.
  • Convert, sort, filter, and manage lists.
  • Insert and modify illustrations in a worksheet.
  • Learn to work with tables.
  • Learn to use conditional formatting and styles.

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at any time.

Who is this Course aimed at?

  • This Microsoft Excel 2016 Intermediate course is ideal for professionals and students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. The learners will also work with charts and advanced formatting including styles.

Method of Assessment

At the end of the Microsoft Excel 2016 Intermediate course, you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.


Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2016 Intermediate course

Awarding Body

The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV stand-out and encourage employers to see your motivation in expanding your skills and knowledge in the IT enterprise.

Other Benefits

  • Written and designed by the industry’s finest expert instructors with over 15 years of experience
  • Repeat and rewind all your lectures and enjoy a personalised learning experience
  • Gain access to quality video tutorials
  • Unlimited 12 months access from anywhere, anytime

Course Curriculum 

➤ Module 01 – Working with Functions
1.0 Topic A: Work with Ranges
1.1 Cell and Range Names
1.2 Names and the Name Box
1.3 The Create from Selection Command
1.4 The Name Manager Dialog Box
1.5 Demo – Naming and Editing Ranges
1.6 Cell and Range Names in Formulas
1.7 The Use in Formula Command Method
1.8 The Formula AutoComplete Method
1.9 Demo – Using Defined Names in a Formula
2.0 Topic B: Use Specialized Functions
2.1 The Excel Function Reference
2.2 Function Syntax
2.3 Date Calculations
2.4 Demo – Locating and Using Specialized Functions
3.0 Topic C: Work with Logical Functions
3.1 Comparison Operators
3.2 The IF Function
3.3 The AND Function
3.4 The OR Function
3.5 The NOT Function
3.6 Demo – Working with Logical Functions
3.7 Nesting
3.8 Nested Function Syntax
3.9 Demo – Combining Functions
4.0 Topic D: Work with Date & Time Functions
4.1 The TODAY Function
4.2 The NOW Function
4.3 The DATE Function
4.4 The NETWORKDAYS Function
4.5 The WEEKDAY Function
4.6 The WORKDAY Function
4.7 The ISOWEEKNUM Function
4.8 Demo – Work with Date & Time Functions
5.0 Topic E: Work with Text Functions
5.1 The LEFT Function
5.2 The RIGHT Function
5.3 Convert Text to Columns Wizard
5.4 The MID Function
5.5 The CONCATENATE Function
5.6 Text Concatenation with the Ampersand
5.7 The UPPER Function
5.8 The LOWER Function
5.9 The PROPER Function
5.10 Demo – Working with Text Functions
5.11 Module 01 Review

➤ Module 02 – Working with Lists
1.0 Topic A: Sort Data
1.1 Sorting
1.2 Multiple Column/Row Sorting
1.3 Quick Sorts
1.4 The Sort Dialog Box
1.5 The Sort Options Dialog Box
1.6 Demo – Sorting Data
2.0 Topic B: Filter Data
2.1 Filtering
2.2 AutoFilters
2.3 The Custom AutoFilter Dialog Box
2.4 Advanced Filtering
2.5 The Criteria Range
2.6 Demo – Filtering Data
3.0 Topic C: Query Data with Database Functions
3.1 Database Functions
3.2 Database Function Syntax
3.3 Demo – Using Database Functions
4.0 Topic D: Outline and Subtotal Data
4.1 Outlines
4.2 The SUBTOTAL Function
4.3 The Subtotals Feature
4.4 The Subtotal Dialog Box
4.5 Demo – Using Subtotals to Summarize Data
4.6 Module 02 Review9

➤ Module 03 – Analyzing Data
1.0 Topic A: Create and Modify Tables
1.1 Tables
1.2 Table Components
1.3 The Create Table Dialog Box
1.4 The Table Tools Design Contextual Tab
1.5 Table Styles and Quick Styles
1.6 The New Table Style Dialog Box
1.7 Quick Analysis
1.8 Demo – Creating and Modifying Tables
1.9 Demo – Using Summary Functions in Tables
2.0 Topic B: Apply Intermediate Conditional Formatting
2.1 The New Formatting Rule Dialog Box
2.2 The Conditional Formatting Rules Manager Dialog Box
2.3 Rule Precedence
2.4 Demo – Applying Intermediate Conditional Formatting
3.0 Topic C: Apply Advanced Conditional Formatting
3.1 The Use a Formula to Determine Which Cells to Format Rule
3.2 Demo – Using Logical Functions to Apply Conditional Formatting
3.3 Module 03 Review

➤ Module 04 – Visualizing Data with Charts
1.0 Topic A: Create Charts
1.1 Charts
1.2 Chart Basics
1.3 Chart Types
1.4 Recommended Charts
1.5 The Insert Chart Dialog Box
1.6 Demo – Creating Charts
2.0 Topic B: Modify and Format Charts
2.1 Chart Modifications
2.2 Chart Formatting
2.3 Chart Elements
2.4 The Design Tab
2.5 The Format Tab
2.6 The Format Task Pane
2.7 The Chart Tools Buttons
2.8 The Select Data Source Dialog Box
2.9 Demo – Modifying and Formatting Charts
3.0 Topic C: Use Advanced Chart Features
3.1 Dual-Axis Charts
3.2 Trendlines
3.3 The Format Trendline Task Pane
3.4 Demo – Creating a Dual-Axis Chart
3.5 Chart Templates
3.6 Demo – Creating a Chart Template
3.7 Module 04 Review

➤ Module 05 – Using PivotTables and PivotCharts
1.0 Topic A: Create a PivotTable
1.1 Pivoting
1.2 PivotTables
1.3 Transactional Data
1.4 The Create PivotTable Dialog Box
1.5 The PivotTable Fields Task Pane
1.6 Demo – Creating a PivotTable
2.0 Topic B: Analyze PivotTable Data
2.1 The Analyze Tab
2.2 The Design Tab
2.3 The Value Field Settings Dialog Box
2.4 SUM Function Only
2.5 Percentage of Total
2.6 Difference from Option
2.7 The GETPIVOTDATA Function
2.8 Demo – Analyzing PivotTable Data
3.0 Topic C: Present Data with PivotCharts
3.1 PivotCharts
3.2 The PivotChart Fields Task Pane
3.3 PivotChart Filters
3.4 Demo – Presenting Data with PivotCharts
4.0 Topic D: Filter Data by Using Timelines and Slicers
4.1 Slicers
4.2 The Insert Slicers Dialog Box
4.3 The Slicer Tools Contextual Tab
4.4 The Report Connections Dialog Box
4.5 Timelines
4.6 The Insert Timelines Dialog Box
4.7 The Timeline Tools Contextual Tab
4.8 Demo – Filtering Data by Using Slicers and Timelines
4.9 Module 05 Review
4.10 Course Closure

  • Excellent Tutor Support Service (Monday to Friday)
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Quizzes, tests mock exams, practice exams to ensure you are 100% ready
  • Eligible for an NUS discount card
  • Free Career Support Service
  • 25% Discount on personal Statement and covering letter writing service
  • Free Access to Over 150 courses for 2 days (48 hours)
  • Free access to the course before you purchase (For selected courses only)


The Microsoft Excel 2016 Intermediate Online Course course at 1 Training is listed in's national courses finder.
Training Provider1 Training
Course LocationDublin
Course Fee18
Entry Requirements• You must be over the age of 16 and have a basic understanding of Maths, English and ICT • Job seekers/graduates/school leavers
Carear Path• Office Administrator – £17,158 per annum • Office Manager £24,073 per annum • Receptionist – £15,961 per annum • Personal Assistant – £25,003 per annum • Project Assistant – £20,785 per annum • Business Executive – £23,667 per annum • Secretary £19,460 per annum • Business Analyst – £35,543 per annum • Technical Support Analyst – £22,753 per annum
Phone+44 208 610 9650
For more information about 1 Training, please visit our College page on by clicking here.

Course Provider

1 Training

63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE, Dublin, United Kingdom. Eircode: EC1N 8LE

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to 1 Training

Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the community.