![]() ![]() Lesson One: Using AutoFill, carrying out date calculations, adding a picture as a watermark, creating and working with tables, converting text to columns, removing duplicates, using Flash Fill, consolidating data, using paste special, creating a custom format After studying this course you will be confident in a range of Excel’s more sophisticated features including using AutoFill, creating and working with tables, using/hiding worksheets, custom formats defining, using and managing named ranges using conditional formatting and filtering data recording and running macros summarising data, database functions and pivot tables using data across worksheets, switching between workbooks and workbook templates worksheet, file and cell properties and using Excel’s statistical functions.īelow is the lesson plan for this course:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |