Excel Dashboards and Data Visualization 1-Day Course, Birmingham,Virtual

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.More about us:training@pcworkshopslondon.co.ukOur classes are instructor led, in our Live Virtual ClassroomCourses well developed by registered, qualified instructors with a wealth of experience in software development and training.The maximum groups size that can access our Virtual Classroom, is 4.Every one gets personalised attention.Why learn with us at PCWorkshops:Excellent, up-to-date courses, following latest trends and technologies.Excellent trainers with professional experience.Award Winning Trainer21 Years In BusinessExcellent Client ReferencesPCWorkshops CertificateWeekdays, Evenings and WeekendsAt PCWorkshops, we love out job!We offer Training Courses in Software Packages:Java ProgrammingPython Programming, Python data analytics, Python Machine LearningDatabase design and Data NormalisationSQL CoursesData Analysis andMS Excel, data analyses with Excel. Excel VBAAccess Database Courses.MS Project TrainingMS Office TrainingOur Style:Relaxed, Practical, UsefulMethods of instruction:Classroom training with max class-size 4 peopleVirtual classrooms via online video links1-1 mentoringCustomised trainingCertification:Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.Our clients are:Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualificationCustomisation:We can tailor all our courses. Email to customise location, times, content.Terms and Conditions:B﻿y booking a course with us, you agree to the terms and conditions specified on our website:https://pcworkshopslondon.co.uk/termsandconditions.html

PCWorkshops

In classroom in Birmingham, so you could compare your Excel Data visuals with classmates

<h4>EXCEL DATA VISUALISATION AND DASHBOARDS</h4>
<h4>COURSE SUMMARY</h4>
<p>Dashboards will summarize and present the key indications of large data in an attractive visual display, hightlighting the most important trends so the most imporatnf aspects of data could could be seen in a snap second by glancing at attractive, colourful charts. PowerPivot helps analyze the data and brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. Power Pivot help analyze and understand the growing quantities of data that are created on a daily basis. <strong>Who should attend? </strong></p>
<ul>
<li>Business users who analyse data with Excel or create management reports </li>
<li>Excel users who want to analyze large data sets and also create relationships between tables </li>
<li>Excel users who know how to Pivot Tables and Pivot Charts </li>
<li>Excel users who wish to create interactive dashboards</li>
</ul>
<h4>COURSE OUTLINE</h4>
<p><strong>Introduction</strong> Activating Power Pivot in Excel Browse, Filter and Sort PowerPivot Data PowerPivot Menu Options The AutoSum Function in Power Pivot <strong>Creating Pivot Tables with PowerPivot Data </strong>Creating PivotTables Changing the Method of Calculation Pivot Table Calculations Filtering with Slicers PivotTable Filters and Slicers Filtering PivotTables and PivotCharts Creating Hierarchies <strong>Excel techniques that are essential for Dashboards</strong>Offset Lookup formulae (Vlookup, Hlookup, Match, Index) Conditional formulae (If, Countifs, And, Or, etc.) Aggregate formulae Advanced filters to organise columns and filter rows <strong>Visuals </strong>Sparklines Charting: Pie, Line, Area, Column, Scatter, Bar charts, Charting: Axes, 2D, 3D chart elements, Sizing of charts Charting: Formatting of charts Create dashboard heat maps and other shapes Conditional Formatting Highlight top and bottom products/ people etc Excel Dashboard Tips and Tricks including <strong>Adding inter-activity </strong>Forms and controls (for drop down lists to choose what you are comparing) Linking cells to a text box Linking cells to chart labels Linking dynamically to changing ranges and values <strong>Create Relationships with PowerPivot Data </strong>Create Relationships to Master Data Create PivotTables with Table Relationships <strong>Refreshing Dashboards inline with changing data</strong></p>
<strong>WHAT IS INCLUDED:</strong>
<ul>
<li>Laptops and data for the course. Let us know beforehand if you would like to bring your own </li>
<li>Excel Course Certificate on completion (assessment based) </li>
<li>Excel Course notes </li>
<li>Practical Class exercises, Excel Course Homework </li>
<li>Tea, coffees, but no lunch </li>
<li>To assist after the course, 1 free session for questions online via Skype or Teamviewer. </li>
<li>Max group size is 4.</li>
</ul>

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Excel Dashboards and Data Visualization 1-Day Course, Birmingham,Virtual

More events from PCWorkshops

Discover more events from PCWorkshops, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

Excel Dashboards and Data Visualization 1-Day Course, Birmingham,Virtual

More events from PCWorkshops

Discover more events from PCWorkshops, from Science & Tech to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.