Take your Excel skills to the next level!

This Microsoft Excel course is designed for delegates who have used Excel before and want to expand their knowledge. Improving formatting, organizing data, highlighting key information and creating formulas/links between sheets. Learn how to work smarter in Excel, improve your efficiency and impress with your results. You will learn how to better organize, analyze and present your day-to-day data using Excel spreadsheets. Create complex formulas, use a range of functions and develop dynamic charts and reports. We also introduce pivot tables, conditional formatting, and defined names and data validation. The course covers key concepts relevant for the workplace.

WHO SHOULD ATTEND?

The course is aimed at those familiar with Excel but looking to learn how to get the most out of the in-built features.

COURSE OBJECTIVES

At the end of this training course, participants will be able to:

• Understand and use formula cell referencing
• master the skills of working with: diagrams, Microsoft Excel and sorts;
• learn to use this software confidently;
• understand the fundamental functions of Excel: the user interface of Excel, the basic terminology of Excel
• Create and use defined names in a workbook
• Use the fill operations available to fill a data series
• Use common worksheet functions
• Work with tables in Microsoft Excel
• Modify Excel options
• Understand and use formula cell referencing
• Use the fill operations available to fill a data series

Please follow and like us: