Hi there @Braveen,
welcome to KNIME Community!
This is possible with KNIME. So you need to build workflow with KNIME that you need to start when new data comes (weekly/monthly) which reads data from Excel, manipulates and transforms it and then writes it back to Excel or somewhere else or sends email.
Now will you be able to pull everything off and how long will it take depends on your wishes/requirements. So as @izaychik63 already suggested if you provide specific steps (and requirements) I’m sure you’ll get more help/advises/ideas to evaluate KNIME for your use case…
Regarding learning KNIME see here:
Br,
Ivan