This course is suitable for anyone in Business Intelligence, including Project Managers, or Data Analysts.
About this Event
Who Should Attend?
This course is suitable for anyone in Business Intelligence, including Project Managers, or Data Analysts.
PrerequisitesYou will be experienced users of Excel and would of attended or have a working knowledge of the features covered on the Excel Level 2 or Excel Level 3 training course.
Course ObjectivesOn this course you will learn some of the more advanced features of Excel and how they can be used to work together in an interactive and graphical way.
For more information about this course call (0151) 650 6907 or email [email protected].
Terms and Conditions.Generally, our courses run from 09:30 until 16:30 unless otherwise stated. Some courses will be more than 1 day so please read the dates at the time of booking.After booking via Eventbrite you will receive notification from them of your purchase. You will also receive joining instructions from the SquareOne team, confirming dates, times and location. We will also at that time check on any special needs or dietary requirements you may have.In the unlikely event that this course is cancelled – then SquareOne will work with you to schedule new dates.
Course Details
Duration: 1 Day Classroom Training or OnlineTimings: 09:30 - 16:30
Dashboards- What are they and why should we use them
- Examples and information sources
- Some Do’s and Don’ts
- Lists versus Tables
- Advanced Pivot tables
- Advanced Charting
- 3d addressing
- Naming cells and ranges
- Using Offset, Index and Match to control data
- Using Goal seek and Scenario manager
- Using Combos for data selection
- Using VBA Forms
- Hyperlinks to other information
- Obtaining data from other sources
- Using Windows vs Cells
- Using Multiple windows
- Protecting information
- Interactive dashboards
- Saving and loading dashboards
Event Venue
Online
GBP 250.00
