Microsoft Excel Intermediate
This intermediate-level workshop is designed to help participants take their Excel skills to the next level. The course will focus on shortcuts for navigation, selection, and commands, as well as the application of exciting formulas to save time and improve efficiency. Participants will also learn how to protect their worksheets and workbooks, apply data validation techniques, manipulate text data through formula, and link cells, worksheets, and workbooks for dynamic automatic reporting.
Description
Attending this course will help you to:
Learn great shortcuts of navigation, selection, and commands.
Apply exciting formulas to save time, such as if statements, sum-if, and count-if
Protect your worksheets and workbooks.
Apply data validation techniques to automate functions.
Manipulate text data through formula.
Work efficiently with relative and absolute referencing.
Link cells, worksheets, and workbooks to create dynamic automatic reports.
Prerequisites
A basic understanding of Excel is recommended.