Data Analysis with Excel - Intermediate (ICAS)

BPP Professional Education
Course summary
6 hours
395 GBP excl. VAT
Aberdeen, Glasgow, Online courses
Next available date: Online delivery option may be available - Please contact provider. - Online courses

Course description

Data Analysis with Excel - Intermediate (ICAS)

This one day course offers quick tips to utilise the power of Excel. This course involves; analysing large data sets, familiarity with a variety of reporting tools, array formulae and CSE keystrokes, nesting functions, data manipulation and text extraction, as well as scenario analysis and macro automation.

COVID-19 Update

This provider offers an online version of their classroom courses

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.

Suitability - Who should attend?

This course is aimed at those using Excel on a regular basis wishing to learn more about performing various forms of analysis. Also support staff, finance professionals and analysts wanting to increase their functional knowledge of Excel.

Training Course Content

Time saversPivot tables and chartsFrequency distribution tablesFunctionsLogicalConditionalErrorTextualNesting (for increased power)ArrayThe CSE keystroke methodSimplifying IF functionsMulti-cell array functionsThe LOOKUP familyFlexible lookup methodsVLOOKUP alternativesPractical solutions for complex data setsScenario buildingExtensive conditional formattingData barsUsing formula based rulesIncreased automation techniques using macrosApplying meaningful macro functionalityViewing and simple editing of macro VBA code

Get Inspired! Watch the Video

About provider

BPP Professional Education

BPP Professional Education -  Accountancy, Tax, Financial Services, Law & Insolvency Courses

BPP Professional Education is one of the specialist examination-based and professional development training arm of the BPP Group, Europe's biggest professional education and publishing provider with 2,000 staff members across 40 countries and over 30,000 students per year. BPP Professional Education...

Read more and show all courses with this provider

Request info

Fill out your details to find out more about Data Analysis with Excel - Intermediate (ICAS).

  Contact the provider

  Get more information

  Register your interest

Contact info

BPP Professional Education

3 London Wall Buildings
EC2M 5PD London

 Show phone number

Request information

Find out more about this Data Analysis with Excel - Intermediate (ICAS) course - simply fill out your details:

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!


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