I was live tweeting during our monthly PASS Business Analytics VC meeting, Here are the tweets to learn about 13 Excel Tips!
130+ folks already logged in for the webinar! It's not too late to Join! 13 #excel tips: http://t.co/deXvWxFw45 #sqlpass #sqlserver #msbi
— PASS BA VC (@passbavc) November 13, 2014
Excel Tip #1/13 – What if / Goal Seeking. #excel #sqlserver #sqlpass http://t.co/135Gu5irmt
— PASS BA VC (@passbavc) November 13, 2014
Excel Tip #2/13 – VLOOKUP #excel #data http://t.co/135Gu5irmt
— PASS BA VC (@passbavc) November 13, 2014
Excel Tip #4/13 – Pivot Table against data sources (OLTP/OLAP). #excel #olap #sqlpass http://t.co/135Gu5irmt
— PASS BA VC (@passbavc) November 13, 2014
Kevin Goff (@KevinSGoff ) demo'ing some lesser known Pivot Table features: visual slicers, sorting & "show values as" features. #sqlpass
— PASS BA VC (@passbavc) November 13, 2014
Excel Tip #3/13 – Named Ranges in Excel –@KevinSGoff #excel
— PASS BA VC (@passbavc) November 13, 2014
Nice tip for #Excel Pivot Tables: use filters when you have long list (customer names). use slicers if you have a short list (5 countries)
— PASS BA VC (@passbavc) November 13, 2014
Tip #6/13 – Pivot Charts with Sparklines. #excel #sqlpass
— PASS BA VC (@passbavc) November 13, 2014
Tip #5/13 – Pivot Table options: Implementing Top and ALL OTHER in Pivot Charts/Tables.
— PASS BA VC (@passbavc) November 13, 2014
Tip #7/13 – Highlighting High Point & Low point in sparklines. #excel #sqlpass pic.twitter.com/91k3Ce2ULj
— PASS BA VC (@passbavc) November 13, 2014
Kevin Goff (@KevinSGoff ) demo'ing using conditional formatting & macro recording. #excel #sqlpass http://t.co/deXvWxFw45
— PASS BA VC (@passbavc) November 13, 2014
Tip #8/13 – Power Pivot! #excel #powerbi #sqlpass #powerpivot <- A must try tool for all data professionals!
— PASS BA VC (@passbavc) November 13, 2014
Excel Tip #9/13 – KPI's and DAX formula's in Power Pivot. #powerbi #sqlpass #excel http://t.co/2WcWDqSJEP
— PASS BA VC (@passbavc) November 13, 2014
Excel Tip #10/13 – Power View #sqlpass http://t.co/2WcWDqSJEP
— PASS BA VC (@passbavc) November 13, 2014
Keving Goff comparing Power View, SSRS and Excel Pivot Tables/Charts features for reporting/dashboard. #sqlpass #excel
— PASS BA VC (@passbavc) November 13, 2014
Excel Tip #11/13 – Want to write custom MDX in Pivot Tabels? Check out: http://t.co/9RkrGSNr0J #sqlpass #excel #olap #ssas #mdx
— PASS BA VC (@passbavc) November 13, 2014
Excel Tip #12/13: A special pivot chart: pic.twitter.com/2DPspZdsUm
— PASS BA VC (@passbavc) November 13, 2014
Excel Tip #13/13: Follow @Technitrain @marcorus @FerrariAlberto blog's for #Excel, #DAX, #PowerBI & #PowerPivot, etc. #sqlpass
— PASS BA VC (@passbavc) November 13, 2014
Thanks everyone who attended, I hope it was helpful!
Here are some ways to follow the Virtual Chapter:
Website: http://bavc.sqlpass.org/
Youtube: https://www.youtube.com/channel/UCOiRAA4gBxEeVxwmEZ1qy1w
Twitter: https://twitter.com/passbavc
LinkedIn: https://www.linkedin.com/groups/PASS-Business-Analytics-Virtual-Chapter-6701113