Course description
After Work Excel - Evening Bite Size Focus Session
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. Who is this for? Finance professionals Data analystsSpreadsheet authorsExcel power usersFinance managersDecision makersFinancial controllersJunior accountants What will you learn? 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 flexibilityTackle the top 5 dangers for using Excel in business financeHealthy solutions for streamlined spreadsheetsReduce risk and taking 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 dashboardFixing PivotTable issuesFast techniques for expandable / flexible data ranges How will this help your career?Explore innovative and more complex techniques to solve problems on their spreadsheetsAchieve greater flexibility and control while building integrityManipulate formulae to do what you want them toUse a variety of unexplored tricks in processing with speedPlease read the following guidance carefully, which applies only if you are attending this course Virtual Classroom (Online):In addition to the Virtual Classroom (Online) Classroom, you will need to have your own version of Excel open to complete the exercisesIt does prove to be challenging to follow-on with the exercises using only 1 screen as you will need to be regularly switching between open windows. We recommend to either:Extend from a computer to a 2nd screen - please refer to this link for guidance on how to correctly setup a second monitor https://support.microsoft.com/en-us/help/4340331/windows-10-set-up-dual-monitors orUse 2 computers, orUse a tablet for the Virtual Classroom (Online) Classroom and a computer for the ExcelPlease note that our courses are based on Excel for Windows and it is recommended that you are using at least Excel 2010 or a later version. MAC users are welcome but please note that there may be some tools and functionality that will differ from what is being presented. The presenter will accommodate for MAC versions on the course.Related coursesIntroduction to ExcelData Analysis With Excel - Intermediate Data Analysis With Excel - Advanced
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
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