Excel Business Intelligence and Dashboards
|
Summary
|
|
|||||||||||||
Excel Business Intelligence and Dashboards
Excel Business Intelligence and Dashboards -2 day course in Crawley
This Excel Business Intelligence and Dashboards Course is a designed to give frequent users of Excel the ability to implement the software for better business intellegence and reporting.
The course includes dealing with imports of data, analysing data using pivot tables and getting the most out of the extensive graphing features in Excel.
It also looks at combining information into easy to use dashboards to show key trends and relationships without the need for high levels of detail.
Versions: 2003, 2007, 2010
By the end of the course delegates will be able to:
- Work with different data formats
- Connect to external data sources
- Build pivot tables
- Create business charts
- Create dashboards
If you want to find out more about Excel Business Intelligence and Dashboards, you can make an information request below and the school will contact you with further information.
Suitability and application
This 2-day Excel Business Intelligence and Dashboards Course is designed for existing users of Excel who can build simple Excel spreadsheets and want to develop their skills in using Excel for better business intelligence and reporting.
Prerequisites: You should be a confident Excel user and be able to create and edit worksheets and write basic formulas.
Enquire to see if this Excel Business
Intelligence and Dashboards Course is suitable for you here.
Excel Business Intelligence and Dashboards Course Content
This Excel Business Intelligence and Dashboards Course is designed to cover the following areas:
Analysing information using pivot tables
- Building a pivot table
- Pivot table structure
- Data formatting
- Subtotalling data
Using external data sources for pivot tables
- Creating a pivot table with an external data source
- Data source options
- Pivot table options
- Publishing to a web page
External data sources
- Creating database queries
- Setting external data range properties
- Creating web queries
Data Structure
- Importing text files
- Data layout and structures
- Merging and consolidating information
Dashboard charting techniques
- Creating and customising charts
- Adding more data
- Creating user-defined chart types
- Changing the default chart type
- Creating miniature charts suitable for dashboards
Data analysis in charts
- Target vs actual charts
- Using bubble charts
- Create charts directly in cells
Creating a dashboard
- Dashboard layouts, best practice
- Linking to analysed data
Advanced charting techniques
- Using invert if negative (not available in 2007)
- Combining different chart types in one chart
- Creating custom markers
Creating advanced background formats
- Creating a quadrant background
- Emphasising data with vertical banding
- Mean and Standard Deviation lines
Using conditional formatting to highlight data
- Conditionally format stacked columns
- Conditional formatting based on values
- Conditionally format axis labels
Specialist charts
- Simple waterfall chart
- Thermometer chart
- Tornado chart
Create a dashboard example using your own data
- Bring along some of your own data and our trainer will help you build a dashboard
Expenses
The cost of this Excel Business Intelligence and Dashboards Course is £398.00 + VAT.
Lunch and refreshments: As part of your time with us you will enjoy delicious hot and cold food and refreshments daily from our restaurant.
Reference material: As part of your training you will be provided with a participant manual for you to use during your training. You can then take it away with you to use as a practical reference tool back at the office.
In House training: Should you want to hold a bespoke course at a different venue, please contact us here.
Thales Training
Thales Training - Business Training Courses & Bespoke Training Services
Thales Training & Consultancy, part of the international Thales Group, is an established training services organisation who works in partnership with our customers to develop individual, organisational and commercial advantage. Since 1998 we have been providing innovative training and managed services. Each year we continue to see our business grow delivering training and development solutions to over 10,000 participants internationally.
What we do
Thales Training & Consultancy delivers over 100 training courses in the areas of Management and People Development, IT and Computing, Technology, Project and Risk Management and Systems Engineering. All our courses are highly practical, include examples of best practice and can equip you with the skills and confidence you need to succeed in the workplace.
- Short Training Courses
- Outsourced Training Managed Service /Training Supply Management services
- Management and People Development Training
- IT / Computer Training
- Training Design and Consultancy
- Coaching Consultancy
- Health and Safety Training
- Bespoke Learning and Development Solutions
Courses designed by our trainers
All our courses are exclusively designed and regularly updated by our team of business experienced and expert trainers. This means when you attend one of our training courses you always benefit from the latest thinking and developments.
Our learning environment
All our training courses are held at our state of the art training centre in Crawley. The training centre provides a learning environment that is relaxed, offers great food, easy access, free parking and an exceptional customer service. All of which leads to time out of the office that we believe you’ll want to do again.
Show all courses with
Thales Training
Request information - obligation free
Contact information for Thales Training
Thales Training
RH10 9XN Crawley
Phone no: +44 (0)800 028 3045 
www.thales-trainingconsultancy.com
Contact Thales Training
To request information from Excel Business Intelligence and Dashboards, please fill out the following details:
