Excel 2 – Lower Intermediate

Course information:

You will learn how to compose tables from a variety of other sources with an emphasis on data consistency. Your spreadsheets will be able to change colours themselves according to different conditions. You will learn to work effectively with large databases. You will also master working with comments and advanced methods of setting up printing.

Content:

• Custom special cell formats
• Cell styles – built-in and custom
• Insert differently – different options for inserting the contents of the clipboard
• Selected logic functions
• Selected mathematical functions
• Selected information functions
• Selected search functions
• Selected text functions
• Mutual combination of several functions
• Using partitions to work with large tables
• Efficiently control of displaying multiple windows on a single screen
• Working areas
• Conditional formatting
• Compatibility with older versions of Excel
• Comments in cells and their settings relative to print
• Row and column header repeat print settings