At the end of my third week, I took my final exam for the essential course on excel, in which I received a 97% on the final assessment. For the next three weeks, I will be building a solid layer of more advanced skills so that I can manage large datasets and create meaningful reports. I will be taking course two (Intermediate Excel Skills) with Macquarie University.
So far this week, I have completed week one in the new course. During this week, I learned how to work with multiple worksheets and workbooks. Additionally, I learned how to:
Compare the different methods of combining data from multiple sources
Use a variety of techniques to perform calculations across workbooks/worksheets
Manage datasets across multiple workbooks/worksheets