Do you know how to work in Excel, but would like to be able to do more complicated tasks? This class will cover more advanced skills like how to create linking formulas, copying worksheet structure, creating name ranges, templates, protecting worksheets, and locking/unlocking cells for editing. Learn how to convert your spreadsheet to a table, use filter techniques, subtotaling and Pivot-Tables. You will use integration techniques to link your spreadsheet into a PowerPoint presentation and Word document.