Good Afternoon Everyone,
I hope everyone is doing well here at the end of the semester! With graduation and summer right around the corner it is a good time be in Chapel Hill.
I want to provide some updates on our upcoming Excel classes for university employees. Our June classes are now live! Our classes include Excel: Pivot Tables, Excel: Conditional Formatting, Excel: If Statements, and Excel: Intro to Formulas. View descriptions of the classes and register.
I also want to draw your attention to Yammer, one of the applications we have access to. The best way I can describe Yammer is that it is a sort of internal UNC Twitter. I’m trying to create a space where UNC employees can post questions and resources to help each other in excel, and have created an Excel Users Group that anyone can join. You can access Yammer by going to https://office.unc.edu/, logging in with your ONYEN and password, and clicking on Yammer under apps (may need to click view all apps to see Yammer for the first time). I will post our Excel guides from class online as well as outside resources! I will answer questions on Excel on Yammer so please feel free to post. Let me know your thoughts!
For additional help and resources between now and class time I recommend checking out the resources at Lynda.com and GCF Learn Free for introductory to intermediate videos and instructions on everything from formulas and functions in excel to Pivot Tables. In Lynda I recommend checking out the courses with Excel 2016 in the title. We’ve found those courses to be well made. For more intermediate to advanced excel resources check out Excel Jet. Excel Jet has quick guides on how to use specific functions in excel including function summaries and examples.
Alex’s Excel Tip: Are you looking filter data and sum only the filtered results? You may want to use the SUBTOTAL function. SUBTOTAL can perform a variety of functions including SUM, AVERAGE, MAX and more and will only take in the values that are filtered or showing. This makes SUBTOTAL a useful function for summarizing large data sets that you filter. It can be a little tricky as it has one extra argument called the function_number which tells SUBTOTAL which calculation to perform [SUM is 9] but it can be worth it if your data is going to be filtered multiple times. SUBTOTAL can also include or exclude manually hidden rows in your spreadsheet as well. For more information on SUBTOTAL check out Excel Jet.
I hope this helps! If you could please forward this email to any colleagues and employees who would like to learn more about Excel!
Please feel Free to reach out to me with any questions here or on Yammer!
CISDE Training Generalist