Skip to main content
Loading
02476 854980
EMAIL US
Create Account
Bookings
Join Now
Find a Member
Toggle search
Toggle navigation
SEARCH
LOGIN
Home
About
Toggle
Strategic Partners
Awards
Careers
Our History
Our Team
Charity Partners
Membership
Toggle
Which Membership Is Right For Me?
Toggle
Merchants
Suppliers
Service Providers
Associates
What Our Members Say
Member Services
Young Merchants
Regional Centres of Excellence
Room Hire
Branding Power
Diversity in Merchanting
Policy & Public Affairs
Toggle
Policy outlook
Brexit Hub
Campaigns
Toggle
Changing the ratio
Avocado green
Aggregation of marginal gains
Leaving the European Union
Like a ton of bricks
Visits
Policy updates
Training
Toggle
BMF training centres
Events
Toggle
Forthcoming events
2020 events
2019 events
2018 events
2017 events
Information Centre
Toggle
COVID-19 bulletins
Publications
Market Data
Blog
Industry digitalisation
Jobs at the BMF
Useful resources
Website user guide
Testimonials
Business Guides
NHS Discounts
News
Contact
Home
»
Training
»
Registration
Share this page
Share on Facebook
Share on Twitter
Share on LinkedIn
Email
More options
select
Bookmarks
Google+
MySpace
Reddit
StumbleUpon
Tumblr
Yammer
Training Registration
½ Day Webinar - Data Analysis with Excel
Excel has a wealth of powerful features that can help you analyse your data – if you know where to find them!
Course type
National, regional or in-company
Learning format
Interactive online event (via Teams)
Programme duration
½ day
Course overview
This course introduces a range of powerful and insightful tools that will help you understand your data better and produce reports with real impact
Who would benefit?
Anyone who records and analyses data
Objectives
By the end of the training, you will be able to…
- Use a range of powerful data analysis tools.
- Create reports that give new insights into your data.
Course content
- How to check your data is suitable for analysis.
- How to Sort and Filter data to reveal trends.
- How to use the SUBTOTAL function to create a report.
- How to use basic statistical functions.
- How to analyse data with a Pivot Table.
- How to prevent errors during data entry.
- How to use Conditional Formatting to highlight key values and potential issues.
To book your place, please make sure you are
logged in.
The price of this course is £200.00 + VAT, the price below is inclusive of VAT.
When
3/16/2021 9:30 AM - 12:30 PM
Sign In
Username
Password
Keep me signed in
Forgot username?
|
Forgot password?
Create a new account
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##