www.expertrain.co.uk Open in urlscan Pro
34.249.200.254  Public Scan

Form analysis
3 forms found in the DOM

/search

<form action="/search" class="search-content w-clearfix w-form" style="transform: translate3d(0px, 0px, 0px) scale3d(1.1, 1.1, 1) rotateX(0deg) rotateY(0deg) rotateZ(0deg) skew(0deg, 0deg); transform-style: preserve-3d; opacity: 0;"><input
    class="search-input w-input" maxlength="256" name="query" placeholder="Hit enter to search..." type="search" id="search" required=""><input type="submit" class="search-button w-button" value="">
  <div class="search-line" style="width: 0%;"></div>
</form>

Name: wf-form-Course-Enquiry-Form — GET

<form id="wf-form-Course-Enquiry-Form" name="wf-form-Course-Enquiry-Form" data-name="Course Enquiry Form" method="get" class="form" data-wf-page-id="65ff21527ea9ef76220fb9ce" data-wf-element-id="3add7b2c-e81d-6cf7-1d7d-941ec0013bec"
  aria-label="Course Enquiry Form">
  <div class="top-title half-space">
    <h2 class="heading-white">Enquire about this course</h2>
    <div class="html-embed w-embed">Microsoft Excel Advanced</div>
    <div class="line-divider center-line"></div>
  </div>
  <div>
    <div class="w-row">
      <div class="w-col w-col-6"><input class="text-field w-input" maxlength="256" name="name" data-name="Name" placeholder="Enter your name" type="text" id="name" required=""></div>
      <div class="w-col w-col-6"><input class="text-field w-input" maxlength="256" name="Email" data-name="Email" placeholder="Enter your email address" type="email" id="Email" required=""></div>
    </div>
  </div>
  <div>
    <div class="w-row">
      <div class="w-col w-col-6"><input class="text-field w-input" maxlength="256" name="Company" data-name="Company" placeholder="Enter your company name" type="text" id="Company"></div>
      <div class="w-col w-col-6"><input class="text-field w-input" maxlength="256" name="Phone" data-name="Phone" placeholder="Enter phone number" type="tel" id="Phone" required=""></div>
    </div>
  </div>
  <div>
    <div class="w-embed"><input type="hidden" name="course" value="Microsoft Excel Advanced"></div><textarea id="Message" name="Message" maxlength="5000" data-name="Message" placeholder="Enter your message..." required=""
      class="text-field area w-input"></textarea>
  </div>
  <div><input type="submit" data-wait="Please wait..." class="submit-button w-button" value="Submit"></div>
</form>

Name: wf-form-Mailing-List-Form — GET

<form id="wf-form-Mailing-List-Form" name="wf-form-Mailing-List-Form" data-name="Mailing List Form" method="get" class="form" data-wf-page-id="65ff21527ea9ef76220fb9ce" data-wf-element-id="359ca9b9-9af7-1fdf-e2e5-384b829b8d56"
  aria-label="Mailing List Form">
  <div class="top-title half-space">
    <h2 class="heading-white">Join our mailing list</h2>
    <p class="paragraph-biger whiter">Receive details on our new courses and special offers</p>
    <div class="line-divider center-line"></div>
  </div>
  <div>
    <div class="w-row">
      <div class="w-col w-col-6"><input class="text-field w-input" maxlength="256" name="Name" data-name="Name" placeholder="Enter your name" type="text" id="Name-3" required=""></div>
      <div class="w-col w-col-6"><input class="text-field w-input" maxlength="256" name="Email" data-name="Email" placeholder="Enter your email" type="email" id="Email-3" required=""></div>
    </div>
  </div>
  <div><input type="submit" data-wait="Please wait..." class="submit-button w-button" value="Sign me up"></div>
</form>

Text Content

Have any questions?
Email: enquiries@expertrain.co.uk
Call: 0800 841 1000

Home

Courses

Adobe ApplicationsAmazon Web Services (AWS)Artificial Intelligence
(AI)CiscoCompTIA®DevOpsEC-CouncilFinanceITIL® & IT Service ManagementManagement
and LeadershipMicrosoft Office / 365 ApplicationsMicrosoft TechnicalProfessional
DevelopmentProject Management
certifications

Amazon Web Services (AWS) CertificationsCompTIA® CertificationsITIL®
CertificationsMicrosoft Certifications
Events

Blog

delivery formats

About Us

Contact




Microsoft Applications


MICROSOFT EXCEL ADVANCED

Duration:
1 Day
Home

all courses

Microsoft Applications

Microsoft Excel Advanced


MICROSOFT EXCEL ADVANCED

ENQUIRE ABOUT this course

COURSE SCHEDULE

29
Aug 2024


MICROSOFT EXCEL ADVANCED

1 Day

9:30am - 4:30pm

Online Live

Price:
Discounted Price:

£150 per delegate




23
Sep 2024


MICROSOFT EXCEL ADVANCED

1 Day

9:30am - 4:30pm

Online Live

Price:
Discounted Price:

£150 per delegate




31
Oct 2024


MICROSOFT EXCEL ADVANCED

1 Day

9:30am - 4:30pm

Online Live

Price:
Discounted Price:

£150 per delegate




description
PRICING
FULL course schedule

COURSE AIMS

This Microsoft Excel Advanced course is for attendees who want to expand their
knowledge into some of the more advanced functions, analyse / summarise tables
of data and automate common tasks.

‍

COURSE PRE-REQUISITES

Attendees who wish to attend this course must have a good knowledge of Excel and
be competent at working with formulas using absolute cell references, use basic
functions like sum, average, max, min, count and be able to write formulas
across multiple sheets and multiple workbooks.

‍

COURSE OBJECTIVES

On completion of this course, delegates will be able to:

 * Use logical, lookup, statistical and error functions
 * Use auditing tools
 * Create range names and use range names in formulas
 * Set restrictions on data entry using data validation
 * Protect an Excel cell, worksheet, and workbook
 * Automate common task by recording a basic macro
 * Create, edit, format Pivot Tables and Pivot Charts

‍

COURSE CONTENT

‍

Introduction and Objectives

 

Using Logical, Lookup and Statistical Functions

 * Using the VLOOKUP / HLOOKUP functions
 * Using IF, AND & OR function
 * Using the IFERROR function
 * Using COUNTIF & SUMIF

 

Using Auditing Tools

 * Displaying precedents and dependents
 * Removing arrows
 * Evaluating a formula
 * Setting manual & automatic calculation

 

Using Range Names

 * Assigning names to ranges
 * Using range names in formulas
 * Editing and deleting named ranges

 

Using Data Validation

 * Validating data using a data validation list
 * Creating a custom input and error message
 * Editing a validation list
 * Removing data validation

 

Protecting Excel Data

 * Protecting entire worksheet
 * Protecting and unprotecting certain cells within a worksheet
 * Protecting workbook structure

‍

Introduction to Basic Macros

 * What is a macro?
 * How to record macros
 * How to run a macro using different methods
 * Editing and deleting macros

 

Creating / Revising Pivot Tables and Pivot Charts

 * Creating a Pivot Table
 * Adding, moving, removing Pivot Table fields
 * Formatting and structuring a Pivot Table
 * Filtering Pivot Table items
 * Changing the summary function
 * Summarising data as percentages
 * Refreshing a Pivot Table
 * Changing the data source for a Pivot Table
 * Adding a Pivot Table slicer
 * Moving & deleting a Pivot Table
 * Creating more than one pivot table on the same worksheet
 * Creating a Pivot Chart
 * Formatting a Pivot Chart

 

 Hints and Tips

‍

Related Courses

 * Excel VBA Introduction
 * Power BI Desktop Introduction

‍

Download PDF Outline


PUBLIC SCHEDULE

RRP:  
£225 per delegate
Our price:  
£150 per delegate


VIRTUAL PRIVATE TRAINING

Contact us for pricing

‍

‍


ONSITE TRAINING

Contact us for pricing

‍


NOTE

All prices exclude VAT at 20%.

VAT registration number: 450 4347 14

‍

29
Aug 2024


MICROSOFT EXCEL ADVANCED

1 Day

9:30am - 4:30pm

Online Live

Price:
Discounted Price:

£150 per delegate




23
Sep 2024


MICROSOFT EXCEL ADVANCED

1 Day

9:30am - 4:30pm

Online Live

Price:
Discounted Price:

£150 per delegate




31
Oct 2024


MICROSOFT EXCEL ADVANCED

1 Day

9:30am - 4:30pm

Online Live

Price:
Discounted Price:

£150 per delegate




28
Nov 2024


MICROSOFT EXCEL ADVANCED

1 Day

9:30am - 4:30pm

Online Live

Price:
Discounted Price:

£150 per delegate




17
Dec 2024


MICROSOFT EXCEL ADVANCED

1 Day

9:30am - 4:30pm

Online Live

Price:
Discounted Price:

£150 per delegate




ENQUIRE ABOUT this course

CATEGORIES



Adobe Applications

Amazon Web Services (AWS)

Artificial Intelligence (AI)

Cisco

CompTIA

DevOps

EC-Council

Finance

ITIL® & IT Service Management

Management and Leadership

Microsoft Applications

Microsoft Technical

Professional Development

Project Management

LATEST COURSES



Microsoft Visio Intermediate

Enhance your skills with our Microsoft Visio Intermediate course. Learn advanced
diagramming techniques and streamline your workflow efficiently.

Microsoft Visio Introduction

If you are interested in learning how to use Microsoft Visio to help you create
visually engaging diagrams, then this course is perfect for you.

Implementing and Managing Windows 11

Learn to implement and manage Windows 11 with our course. Gain essential skills,
practical experience, and enhance your IT management capabilities.


YOU MAY ALSO LIKE...


View all Courses
Microsoft ApplicationsVIEW
COURSE DETAILS
Microsoft Visio Intermediate

Enhance your skills with our Microsoft Visio Intermediate course. Learn advanced
diagramming techniques and streamline your workflow efficiently.

Duration:

1 Day


Microsoft ApplicationsVIEW
COURSE DETAILS
Microsoft Visio Introduction

If you are interested in learning how to use Microsoft Visio to help you create
visually engaging diagrams, then this course is perfect for you.

Duration:

1 Day


Microsoft ApplicationsVIEW
COURSE DETAILS
Copilot for Microsoft 365 for Business Users

Enhance your productivity with the Copilot for Microsoft 365 course for business
users. Learn to leverage AI across Word, Excel, PowerPoint, Teams, and Outlook.

Duration:

1 day




ENQUIRE ABOUT THIS COURSE

Microsoft Excel Advanced





Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.




JOIN OUR MAILING LIST

Receive details on our new courses and special offers




Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

learn > grow > succeed

Call us on: 0800 841 1000

Email us at enquiries@expertrain.co.uk


ExperTrain Limited is a company registered in England and Wales (Company No.
15178884)
72 Perrycroft, Windsor, Berkshire, SL4 4HE.

UK Register of Learning Providers
UKPRN: 10094148


Social:


USEFUL LINKS


Terms and Conditions
Privacy Policy
Data Subject Rights Policy


LATEST NEWS




MICROSOFT COPILOT

Apr 15, 2024


DEMYSTIFYING PRINCE2®: A STEP-BY-STEP APPROACH TO PROJECT MANAGEMENT

Apr 5, 2024


A BEGINNER'S GUIDE TO COMPTIA CERTIFICATIONS

Apr 4, 2024

© Copyright 2024 ExperTrain Limited