Course Information
| Session |
|---|
| Credits | 1.5 CEUs or 15 PDHs |
|---|---|
| Registration dates | We accept registrations through the first week of classes, unless enrollment is full, and unless the class was canceled before it started due to low enrollment. |
Advanced Excel
$250.00
Dates: November 3 - November 30Credits: 1.5 CEUs or 15 PDHs
Learn how to take your excel skills up to the next level. Excel continues to be a go-to tool in libraries and it is time to work smarter and not harder. You will see ways to clean up your data with formulas and Pivot Tables. Power Query is a recent feature that can manipulate your data even further. Using slicers and charts, you can create interactive dashboards that everyone can use to ask their own questions about the data. We will use library examples like weeding reports, analysing vendor data, work calendars, and more.
Course Description
Learn how to take your excel skills up to the next level. Excel continues to be a go-to tool in libraries and it is time to work smarter and not harder. You will see ways to clean up your data with formulas and Pivot Tables. Power Query is a recent feature that can manipulate your data even further. Using slicers and charts, you can create interactive dashboards that everyone can use to ask their own questions about the data. We will use library examples like weeding reports, analysing vendor data, work calendars, and more.
By the end of the class, students will:
- Use Pivot Tables to group data and create charts
- Use Ranges and Tables to control your datasets
- Create medium to advanced formulas
- Use Power Query to clean data and unpivot data
- Connect Excel to other data sources
- Build a Pivot Table dashboard
Trevor Smith
Trevor Smith is the Monograph Collections and Metadata Librarian at Douglas College and an adjunct faculty member at UBC SLIS where he teaches Project Management for Information Professionals. He has mainly worked in Academic libraries but has also worked in Start-ups. Prior to becoming a librarian, he worked in the tourism sector where he developed a railway reporting network using SharePoint and MS Access. He often presents workshops and talks on databases and Project Management.
How to Register
To enroll yourself or other participants in a class, use the “Register” button that follows the description of each course. If the “Register” button does not show up, try loading the page in a different web browser. Contact us if you have technical difficulties using our shopping cart system or would like to pay for an enrollment using another method. On the payment page in the shopping cart system, there is a place to add notes, such as the names and email addresses of participants you wish to enroll. We will contact you to request this information in response to your processed payment if you do not include it in the “notes” field. Prior to the start of the workshop, we will send participants their login instructions.Payment Info
Our shopping cart system allows you to pay with a credit card or with PayPal.Alternatively, if it is an institutional payment, we can arrange to invoice you. Contact us by email, and we can make arrangements to suit your institution's business processes.
Reviews
There are no reviews yet.