Call Us: 020 3744 0626 | REQUEST CALL BACK
Students will learn how to work more effectively with Excel 2013 workbooks and worksheets. Students will undertake tasks using complex formulas and functions, advanced formatting, absolute referencing, conditional formatting and charting features. Once students have completed the course they will be able to manage, manipulate and analyse complex data.
Course Length
This course is intended for current Microsoft Excel 2013 users who wish to extend their knowledge and skills beyond building simple workbooks.
Participants should have already completed the Excel 2013 Beginner Course before attending this course or have equivalent skills or experience. It is also important to have a general understanding of computers and the Windows operating system.
Unit 1: Fill Techniques
Unit 2: Worksheet Techniques
Unit 3: Page Setup
Unit 4: Applying Borders
Unit 5: Essential Functions
Unit 6: Complex Formulas
Unit 7: Financial Functions
Unit 8: Date and Time Functions
Unit 9: Defined Names
Unit 10: Number Formatting Techniques
Unit 11: Conditional Formatting
Unit 12: Goal Seeking
Unit 13: The Quick Analysis Tools
Unit 14: Worksheet Tables
Unit 15: Pivot Tables
Unit 16: Chart Elements
Unit 17: Chart Object Formatting