MS Excel Data Analysis for modern managers, London

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

<DIV>
<DIV>
<H2>Course summary</H2>
<DIV CLASS="cont">
Excel Techniques required for manipulating sets of data stored in Excel, to analyse and obtain useful business insights from the data
Course Outline
Working with Names and Ranges, Working with Array Formulas Conditional Formatting, Data Validation, custom lists Function wizard for statistical functions:
<UL>
<LI>-- If,</LI>
<LI>-- Sumif(s), Averageif(s), Countif(s)</LI>
</UL>
Working with Tables, Working with Records and Fields, Working with Tables and Filters Using Excel as a Database:
<UL>
<LI>-- Advanced Filter</LI>
<LI>-- Setting up criteria</LI>
<LI>-- Using Wildcards</LI>
</UL>
Subtotals, Group, Outline Dsum, Daverage, Dcount Hlookup, Vlookup, Match, Index Pivot Tables Working with sheets and files Graphs and Pivot charts
 
INCLUDED:
<UL>
<LI>What can/can't I bring to the event?</LI>
<LI>You can bring your own Laptop - let us know beforehand</LI>
<LI>You canbring your own data and examples - let us know beforehand</LI>
<LI>Refreshments: Tees, coffees and light refreshments are included in the price</LI>
<LI>Certificates: You will get attendance certificates</LI>
<LI>Notes: You will get brief course notes</LI>
<LI>After course support: Scheduled Skype sessions</LI>
</UL>
</DIV>
<DIV CLASS="cont"> </DIV>
</DIV>
 
 
 
 
</DIV>

PC Workshops at The Grand

<h2>Excel Formulas and Functions</h2>You can work on Excel but sometimes marvel at the formulas, that your colleagues have created. Excel is easy. We will cover formulae in depth in this interesting course. Course OutlineSession 1:Popular Functions:<ul><li>Sum, Average, Count, Counta, Countblank, Maximum and minimum.</li></ul>Create from Scratch:<ul><li>Program general arithmetics into Excel,</li><li>using addition, subtraction, multiply, divide, brackets</li></ul>Copy Formulae<ul><li>using absoulte $ or relative, down accross and both</li></ul>Excel function wizard for statistical functions:<ul><li>If,</li><li>Nested if,</li><li>Sumif(s), Averageif(s), Countif(s)</li></ul>Names, Ranges and Tables,<ul><li>To simplify cell-referencing</li><li>Using Ranges as Tables</li><li>Conditional Formatting</li></ul>Working with Excel sheets and files,<ul><li>calculating using multiple sheets</li><li>or files</li></ul> Session 2:SubTotals:<ul><li>Excel Subtotals,</li><li>Group, Outline</li></ul>Cross referencing data:<ul><li>Xlookup,</li><li>Vlookup,</li><li>Hlookup,</li><li>Match,</li><li>Index,</li><li>Indirect</li></ul>Excel Pivot Tables<ul><li>Create</li><li>Modify</li><li>Format</li><li>Sort</li><li>Group</li></ul>Charts and Pivot Charts

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}

MS Excel Data Analysis for modern managers, London

More events from PCWorkshops

Discover more events from PCWorkshops, from Business to other experiences you might love.

Still looking for the right event?

Explore all events in London and filter by date, category, and more to find the perfect fit.

MS Excel Data Analysis for modern managers, London

More events from PCWorkshops

Discover more events from PCWorkshops, from Business to other experiences you might love.

More Business events

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

Still looking for the right event?

Explore all events in London and filter by date, category, and more to find the perfect fit.