Advanced Excel

• Utilising 365 Cloud Storage
• Use of Sparklines
• Timeline Slicer
• Formulas / Functions
• Working with Dates
• Statistical Functions
• Data Analysis
• Clipboard
• Working with Power B1
• Work Related Spreadsheets

The last section of the workshops gives you the opportunity to work on Excel in relation to your specific work, related requirements.  You may have a spreadsheet which is not fit for purpose or is too complicated to understand. You may have ‘inherited’ a spreadsheet from a colleague who is no longer with your company, or you may be using a process which is pen/paper/calculator based and could be converted into Excel.

Please email your ‘troublesome’ spreadsheets to the workshop to wdinfo@dncolleges.ac.uk and remove any confidential information beforehand, and be prepared to outline your requirement to the other delegates on the course and to devise a solution for each scenario.