This Excel training covers practical skills for efficient data management and analysis.
Learners will learn to create formulas across multiple worksheets, enhancing their ability to perform calculations seamlessly.
It includes techniques for copying formats and values across multiple worksheets, ensuring consistent formatting throughout the workbook.
It explores the application of conditional formatting and custom formats, text manipulation and text functions, and learners will gain an understanding of Excel databases, including creating and modifying data tables.
COURSE PRE-REQUISITES:
Learners who wish to attend this course must have knowledge of Excel and feel comfortable with creating, formatting, and editing spreadsheets. They should be able to write formulas using multiplication, addition, subtraction, division and use thebasic functions, sum, average, max, min and count.