Using multiple workbooks and worksheets

Course overview

By the end of this course you will be able to work with multiple worksheets and workbooks, alter your worksheet display, work with additional formatting options such as custom number formats and paste special, use conditional formatting and find blank cells, work with ranges of cells using named ranges, work with objects i.e. text boxes and screenshots, work with Tables, sort and filter data, use outlining and consolidate and use subtotals, protect worksheets/books and create and manage templates.