SEO and Digital Marketing

SharePoint

SEO is built in 2013
http://blog.mastykarz.nl/search-engine-optimization-sharepoint-2013/

Facebook

Power Editor
https://www.facebook.com/help/194355723944655

Track Analytics
https://www.facebook.com/help/search/?q=insights

Microsoft Cloud Links

Marketing

https://readytogo.microsoft.com/en-us/Pages/Home.aspx

Pricing

Pricing Tool
http://www.microsoft.com/en-us/download/details.aspx?id=43376
Pricing Calculator Website
http://azure.microsoft.com/en-us/pricing/calculator/

SMB Live

Slides http://aka.ms/smblive-day1
Slides http://aka.ms/smblive-day2

Azure Cost

Pricing Tool
http://www.microsoft.com/en-us/download/details.aspx?id=43376

Pricing Calculator Website
http://azure.microsoft.com/en-us/pricing/calculator/

Excel and Excel Services

Excel

Simple Connecting an Excel Spreadsheet to SharePoint 2010 List
http://www.fivenumber.com/connecting-an-excel-spreadsheet-to-sharepoint-2010-list/

Formulas Supported
https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx

Excel Services

Official blog from Microsoft on Excel Services
http://blogs.office.com/b/microsoft-excel/archive/2009/11/03/excel-services-2010-overview.aspx

Features that cause issues with Excel Services
http://msdn.microsoft.com/en-us/library/ms496823(v=office.12).aspx

Good video and demos on Excel Services
http://msdn.microsoft.com/en-us/office/ff436080

Nice Walk-Through on Excel Services
http://allcomputers.us/windows_server/sharepoint-2010---publishing-to-excel-services-(part-1)-.aspx

http://www.techgrowingpains.com/2010/07/sharepoint-2010-excel-services-failure-and-you/
I logged into the SQL server opened the mapped windows account by opening the following:
SQL server>Security>Logins>DOMAIN\SP_Service
Right click on account select properties. From there go to ‘User Mapping’ and check the target database and add db_owner and public permission set for that user. In addition I added the account ‘DOMAIN\SP_Service’ as the default Schema. Your mileage may vary but you get the idea. Just fill in your domain info as needed.  IISReset Followed

SharePoint Customizations

Books

Check out Mikes Book!
http://www.amazon.com/SharePoint-2007-2010-Customization-Owner/dp/0982899203

Commonly Asked Questions

Quick Launch Dropdown Menus
2013 - http://blog.advisicon.com/2013/12/03/right-way-enable-quicklaunch-fly-menu-sharepoint-2013/
2010 - https://www.nothingbutsharepoint.com/sites/eusp/pages/accordion-style-quick-launch-in-sharepoint-2010.aspx

Thanks Tiffany - Really cool trick people ask me to show them is when you are editing a Page, you can hyperlink a picture.  Once you add the picture, select the picture and click link...add the link.  BUT then it comes up with this ugly brown border.  To remove the border, go to Edit Page>HTML>Edit HTML Source...right before it says style="margin...add border="0"...click Ok and walla!  No more border.  This is also where you can do the scrolling marquee