Excel Tips and Tricks for Researchers

This two-hour online course is not a general introduction to Excel, but rather focuses on time-saving features that will be of particular interest to both quantitative and qualitative researchers. Topics include tips and tricks for data entry, techniques for cleaning and manipulating data, pivot tables, graph creation and formatting, and using formulas. We’ll also discuss how Excel is useful for working with more than just numerical information, and demonstrate how it can be used for basic analysis of qualitative data.

By the end of this course attendees will have a good understanding of how to:

Enter data efficiently, including the use of data validation
Clean/screen spreadsheets before analysis begins
Conduct basic analysis and manipulate data
Work with pivot tables
Create Excel charts
Use macros for speedy formatting
Analyse qualitative data with Excel.

Course preview

Course registration

Register your interest
Sorry, no Excel Tips and Tricks for Researchers courses are currently scheduled.

Team sessions
Do you have a team that would benefit from attending this course? Contact us to discuss our team training options.

Testimonials

What people say about our Microsoft Office courses

The information was incredibly useful - I have already applied some of the tips to my thesis and it is just 15 minutes after the session has finished - thank you!

PhD Candidate University of Auckland

The content was thorough for the time allocated. Lyn is very good at explaining the material and I was very happy with what I learned. Thank you for providing something like this, really appreciated.

PhD Candidate AUT University

Have a question about this course?

Call us on 09 522 0676 or complete the form below: