This course is not suitable for anyone using Microsoft Excel Standard, Home or Student Editions. *Some of the tools and features are only available in Microsoft Excel 2013 and include add-ins. It is assumed that the majority of attendees on the course have either migrated to Microsoft Excel 2013 from a previous version or whose role has changed requiring the use of data tools. Next, on the Design tab, in the External Table Data group, click Refresh. When your Access data changes, you can easily refresh the data in Excel. Select how you want to view this data, where you want to put it, and click OK. Target AudienceĪnyone who needs to work with Excel in order to connect to, process, analyse and display data in order to produce suitable output at all levels within an organisation. Click Finish to return the data to Microsoft Excel. Analysis and outputs include data and graphical tools available in Microsoft Excel 2013.
Features covered range from data importing to analysis leading to subsequent output in Excel. The course is designed to examine a combination of new and revised features which are available to help you work with data in Microsoft Excel 2013. This is the first of a two part series of courses examining the data tools and features found in Microsoft Excel 2013 Professional and Pro Plus*. Managing, Leading & Personal Effectiveness.All Alison courses are free to enrol, study and complete.
Digital Productivity & Office Applications Mastering Data Analysis using Microsoft Excel: Formulas & Pivot Tables - Course Assessment.
0 kommentar(er)
