Excel 2016 Intermediate

EXCEL 2016 INTERMEDIATE

LEARNING OUTCOMES

At the completion of this course you should be able to:

• Use Date Functions
• Count and Sum based on Criteria
• Use Defined Names in a Function
• Use Vlookup to compare or merge data
• Use Flash Fill to extract data
• Freeze Row and Column headings
• Use Conditional Formatting to highlight cells based on their value
• Use Conditional Formatting to present data using data bars or icon sets
• Sort and Filter
• Protect your workbook in a variety of circumstances
• Create Charts including new chart types such as Waterfall or Funnel
• Format Chart Elements
• Use Quick Analysis to quickly analyse or present your data.

COURSE DETAILS


The skills and knowledge acquired in Microsoft Excel 2016 – Intermediate enables users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.


SUMMARY


Module 1: Date Functions
Module 2: Summing and Counting based on Criteria
Module 3: Defined Names
Module 4: Vlookup
Module 5: Flash Fill
Module 6: Freezing Rows and Columns
Module 7: Conditional Formatting
Module 8: Sorting and Filtering
Module 9: Protection
Module 10: Charts
Module 11: Quick Analysis