HOME
 

Excel Business Intelligence (BI) - Reporting and Charting

Activia Training
Course summary
1 day
249 GBP excl. VAT
English
Birmingham, Leeds, London, Manchester, Reading
Next available date: Enquire for more information - Leeds
Open / Scheduled

Course description

Our Excel Business Intelligence (BI) - Reporting and Charting course will push your Excel skills to a new level.

Do you need to pull out relevant information from large data sets? This is what our Excel BI Reporting and Charting course is designed to help you with: to show you a range of techniques that will assist you to get at the information you are interested in, quickly. We start by looking at how to get data into Excel from a number of different sources, then explore the best ways to display and manipulate that data to give you a professional result.  We also use a range of advanced functions and sheet controls and explore a number of advanced chart types.

Do you have questions about COVID-19 in relation to this course?

At findcourses.co.uk we are committed to helping everyone who wants to learn, to learn. So are our trusted partner providers.

Get in touch on this page to find out whether there are any changes to this course in light of COVID-19.

Training Course Content

Importing and Linking Data
  • Importing Data from a text file
  • Importing Data from an XML file
  • Linking to an External Data Source
  • Using Query to Control Linked Data
  • Modify and Update Connections
Data Manipulation with Pivot Tables
  • Creating Basic Pivot Tables
  • Grouping Pivot Data
  • Calculated Fields in Pivot Tables
  • Filtering Pivot Data
  • Changing the Pivot Table Display Methods
Advanced Reporting Functions
  • Using the GetPivotData Function
  • Using the Index Function
  • Using the Match Function
  • Using Index and Match Together
  • Using the Choose Function
  • Using the Frequency Function
Automating Reports with Controls
  • Using Form Controls
  • Record and Run Simple Macros
  • Assign Macros to Form Controls
Advanced Charting Features
  • Creating Combination Charts
  • Displaying a Secondary Axis
  • Modifying Axis Options
  • Display Data Trends
  • Charting an Acceptable Range
  • Charting Targets

Why choose Activia Training

25 years of training businesses

10 centers nationwide

278 active courses

Get Inspired! Watch the Video

About provider

Activia Training

Activia Training

When you organise your training, you need a partner who is able to deliver the skills improvements you need, and Activia have grown into a major UK provider on the strength of excellence in key areas. Whether it's competitive prices,...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Excel Business Intelligence (BI) - Reporting and Charting.

  Contact the provider

  Get more information

  Register your interest

Contact info

Activia Training

Berkshire
Regus House, 268 Bath Road
SL1 4DX Slough

 Show phone number
www.activia.co.uk Course homepage


Request information

Find out more about this Excel Business Intelligence (BI) - Reporting and Charting course - simply fill out your details:

What do you want to know more about?
Do you offer this course online/virtually
I want to know more about this course
Do you offer discounts on more than one applicant?
I have another question
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here