Microsoft Excel Boot Camp (Part 6): Importing/exporting CSV files, working with sheets, conditional formatting - PDF of Slideshow
This PDF contains the slides from the 6th part of the Boot Camp series about Microsoft Excel (see www.itandcoffee.com.au/microsoft365-classes for more details about these Boot Camps).
In this sixth session of our Microsoft Excel Boot Camp, we look at importing a ‘comma-delimited’ file (a file in text format, with commas – or some other ‘delimiter’ separating the fields) into Excel format, and at how to create a CSV file from a sheet in your Excel workbook.
We look at working with multiple sheets – adding, copying, renaming, moving, creating another workbook from a sheet, hiding, and protecting sheets.
We also look at setting up conditional formatting that will automatically bold, colour, underline (or any other format) cells, columns and rows in your sheet