Excel - Adv - Evening Course (6-8 pm) - Content A

Our evening Courses have been tailored to meet the needs of professionals who need to improve their own personal development and meet the requirements set by their particular institutes.

They run between 6pm and 8pm.

CONTENT A

Advanced Functions

• IF Function & Nested IF Statements
• And & Or Functions
• Conditional Formatting

3D Ranges

• Create & Maintain (Within Worksheets in a single file & between external files)

Data

• Sort data into Lists
• Filter data ?€? Autofilter, Advanced Filter
• Validation Rules to restrict data entry

Outlines

• Group Row/ Column Data to create Outline
• Levels based on Worksheet Formulae
• Display Summary Rows and Summary Styles

Custom Views

• Create and modify
• Include hidden Rows, Columns, Filter Settings

Click here to download our Course Content:

ExcelEveningSessions_A&B