Microsoft Excel Intermediate Eğitimi

This course is aimed at existing Excel users who need to further their knowledge. Delegates are assumed to have experience of entering data and writing basic formulas, including common functions such as SUM and AVERAGE.

• Work with more advanced formulas
• Excel’s formula auditing tools
• Work with lists, including sorting, filtering, and subtotalling
• Master Excel’s powerful Tables feature
• Analyse and visualise data with charts
• Work with comments, links, templates, and options
• Present data using conditional formatting

Module 1: Formulas

• Quick Analysis
• Absolute and mixed referencing
• Working with Range Names
• Calculating across worksheets
• Exploring Excel’s functions
• Criteria-based functions
• Text functions
• Calculating with dates
• Logical functions
• Using the VLOOKUP function
• Using XLOOKUP (Excel 365 only)

Module 2: The Auditing tools

• Tracing precedents and dependents
• Tracing errors
• Viewing formulas
• The Watch Window
• Evaluating formulas

Module 3: Working with data lists

• Creating an effective list
• Applying basic sorting
• Advanced sorting
• Summarising data with subtotals

Module 4: Filtering data lists

• Applying basic filters
• Advanced filters
• Custom views

Module 5: Mastering Excel tables

• Introducing tables
• Creating a table
• Managing a table
• Calculations and totals in tables
• Formatting a table
• Further table tools

Module 6: Charts

• Understanding charts
• Creating a chart
• Resizing and moving charts
• Managing a chart
• Working with chart elements
• Formatting charts
• Working with chart templates
• Analyse data with sparklines

Module 7: Additional features

• Comments and notes
• Hyperlinks
• Templates
• Excel options

Module 8: Conditional formatting

• Applying conditional formatting
• Modifying and deleting
• Creating custom conditional formats
• Sorting and filtering by colour