stat480

Introduction and Excel basics

The Juice analytics weblog. "Juice Analytics helps small and mid-market companies develop deep prospect and customer understanding through visualization and analytics of existing data." The following entries are particular relevant:
- Excel training worksheet. Practice the skills you learned with this worksheet.
- Essential Excel Skills…or What is the Core Knowledge Pack for Data Analysts?, especially the comments
Example to practice your tidy-up skills on
Another tutorial which might be useful if you haven't done much excel before
Tips and tricks for data entry including a good listing of keyboard shortcuts
Jan's excel basics: Autofill. Step by step introduction to autofill, describing some of the many different types of sequences that it recognises