The days activities!
After a brief recap of last week, we'll start off today with an exercise that will help us remember some of the more advanced functions of Excel (such as named Ranges, VLookups and Absolute vs. Relative referencing)! You can find the exercise spreadsheet on the S:... Remember to use each other as a learning resource... and ask questions!
We're then going to have a go at importing data into Excel, seeing the difference between delimited text files and fixed width text files, before having a go at our second activity for the day (from our recommended text).
Hopefully we'll still have time to record our first macros and learn a bit about VBA... we'll see!
0 Comments:
Post a Comment
<< Home