Master the skills of data search, validation and macros in Excel 2013. Excel 2013 provides time-saving tools to manage data, validate data, and automate repetitive tasks. You can import files, and add and adjust columns and rows, as well as edit workbook properties. Find and replace allows users to find and replace data, in a specific format, or within the worksheet or workbook. It also allows you to use wildcard characters to customise the search. Data validation can be applied to a cell or range to restrict the data being entered. You can put upper and lower limits, restrict the number of characters, put items in a list, or validate against other cells. You can also add error alerts and identify invalid data. This course will also introduce you to macros in Excel and show you how to automate repetitive tasks to make working in Excel easier.
For an optimal experience please check the minimum computer system requirements.
This online course forms part of the SkillsNet short course suite.
Please note this course is only available to CPA Australia members.
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification