Advanced Microsoft Excel Skills

This course covers how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and use the sorting and filtering features to manage and analyse data.

Learning Outcomes:

• Use the fill operations available to fill a data series
• understand and use formula cell referencing to create more complex formulas
• use a range of logical functions
• apply conditional formatting to ranges in a worksheet
• Create and use labels in a workbook
• Work with various elements of a worksheet
• Use a range of techniques to work with worksheets
• Use a range of find and replace techniques
• Apply a variety of page setup techniques
• Sort data in a list in a worksheet
• Filter data in a table
• Create effective charts in Microsoft excel
• Use a range of techniques to enhance charts
• Apply formatting techniques to text on charts

Day 1

• UNIT 1: Conditional Formatting
• UNIT 2: Sorting Data
• UNIT 3: Filtering Data
• UNIT 4: Filling Data

Day 2

• UNIT 5: PivotTables
• UNIT 6: Dynamic table (New feature)
• UNIT 8: Creating Charts
• UNIT 9: Advance Validation
• UNIT 10: Text options

Day 3

• UNIT 11: Macros
• UNIT 12: File / Data Security
• UNIT 13: Formulas
• UNIT 14: Formula Referencing
• UNIT 15: Logical Functions
• UNIT 16: Lookup Functions