Microsoft Excel (module 307)
(307)
This course requires an enrolment keyThe enrollment key for this course is the same as Microsoft Excel (module 306)
Learn how data is stored in Excel, the cell structure with columns and rows allows the idea structure to convert from and to comma separated (comma delimited), tab separated and others. Understand the importance of the the first row (header record).
Learn how to sort and filter your data to show exactly which information you want to see. Use Find and replace and other functions like combine to simplify your data for use in mail merges and other activities where you use your data.
Learn how to manipulate data in many different programs including Word and Notepad and the power of having data in txt (Text) format.
A new addition to this course includes information on how to use the Advanced Filter tools in Microsoft Excel + Using data validation to create drop down lists in your Excel spreadsheet.
Purchase this course only with 12 months access for only $9.95 by clicking the button below- Administrator: Richard Dabba
