HOME
 

After Work Excel – Evening Bite Size Focus Session

BPP Professional Education
Course summary
3 hours
315 GBP excl. VAT
London
Next available date: 10/12/2019 - London

Course description

After Work Excel – Evening Bite Size Focus Session

By the end of this session, delegates will be able to:Apply more complex calculations to their spreadsheetsAchieve greater flexibility and control while building integrityManipulate formulae to do what you want them toUse a variety of tricks in processing with speed

Suitability - Who should attend?

This session is designed to complement the knowledge gained from attending Data Analysis with Excel - Intermediate or Data Analysis with Excel - Advanced. Attendees can build on those techniques to widen their skill-set and have better control over their working models.This hands-on evening bite size session offers a focused look at some of the key areas of concern with Excel in business, and provides fast tricks to enhance processing of Excel Workbooks. The session covers lots of tips and tricks in formula writing, fast calculation techniques, getting back control of spreadsheets, and building integrity into Excel models.This session is very hands-on and provides solutions to many day-to-day data problems faced in today’s businesses. We go through a variety of lesser known techniques and functions within Excel that are not covered on any other course.

Training Course Content

Learning outcomes include:Analyse some common business problems / limitationsManipulate formulae for extra powerData imports and update issuesFind the ‘nth’ instance in a rangeUsing CHOOSE as an array for greater flexibilityFixing PivotTable issuesTackle the top 5 dangers of using Excel in business and financeHealthy solutions for streamlined spreadsheetsReduce risk and take back controlPrecision settingsAlways making your charts dynamicRestrict data inputSecurityTips and tricksShortcuts and hotkeysIntro to Flash FillIntro to SparklinesTips for evaluating and reviewing calculationsBonus sectionBuild a lightning quick dashboardFast techniques for expandable / flexible data ranges

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 After Work Excel – Evening Bite Size Focus Session.

  Contact the provider

  Get more information

  Register your interest

Contact info

BPP Professional Education

3 London Wall Buildings
EC2M 5PD London

 Show phone number
www.bpp.com

Request information

Find out more about this After Work Excel – Evening Bite Size Focus Session 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 first annual U.K. L&D Report!

UK 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