Aggregated Posts (sorted by date)
Feb 3, The purpose of Find All
Abstract from Advanced Excel (Indexed 2012-02-03):
Find all was introduced in Excel 2003. The purpose of find all is to help to select cells containing the find condition.
I’m presenting at the International SharePoint Conference in London April 2012
Abstract from Andrew Connell (Indexed 2012-02-02):
[Image]Im very much looking forward to this show every year. Ive got a handful of sessions Im co-presenting with other folks as the show is doing something a bit different. Ill be in the Developer track and as it states on the site: This track is for all the Developers out there who are just starting a SharePoint journey of discovery and for those developers who have been developing for a while and now need to hone their skills to a more advanced level. There is so much that you can do with Sha...(truncated)...
ZoomIn
Abstract from Slipstick Systems (Indexed 2012-02-02):
ZoomIn can save your preferred Outlook email zoom setting.
Authenticating & Working with the Salesforce REST API & OAuth
Abstract from Andrew Connell (Indexed 2012-02-01):
In the past Ive complained about the Salesforce SOAP API for reading/writing your CRM databases. Last year Salesforce added a new API, one founded on RESTful principals, for developers to work with. I wish it was implemented as an OData service, but I guess the Salesforce guys are stuck behind the times. At any rate, I had a need to read/write to a Salesforce instance and couldnt bear to use their SOAP API again so I decided to give the REST API a go. Their developer site doesnt do that much in...(truncated)...
Excel: The Basics (Video)
Abstract from David Gainer (Indexed 2012-02-01):
[Image]For those of us who crunch words instead of numbers, Excel can be intimidating. We don't know the difference between a workbook and a worksheet, and for sure don't know to ask about conditional formatting (a cool way to visually display data). Then one day your boss asks you to create a report--with numbers. Gulp.In this video, the Office 911 emergency responders show a beginning Excel user how to add a table to a worksheet so she can better organize and view her data. ...(read more)[Imag...(truncated)...
Excel Versions
Abstract from Dick Kusleika (Indexed 2012-01-31):
I currently have Excel 2003 and Excel 2007 installed. I’m pretty happy with this arrangement from an Excel standpoint, but Word and Access are always trying to install themselves. Happy or not, I’m in a situation where I need to install Excel 2010. I don’t know what to do. What I want to do is [...]
Excel Versions
Abstract from Daily Dose of Excel (Indexed 2012-01-31):
I currently have Excel 2003 and Excel 2007 installed. I’m pretty happy with this arrangement from an Excel standpoint, but Word and Access are always trying to install themselves. Happy or not, I’m in a situation where I need to install Excel 2010. I don’t know what to do. What I want to do is [...]
ProperSync
Abstract from Slipstick Systems (Indexed 2012-01-31):
Synchronize Outlook calendars, tasks and contacts with SharePoint 2007 or higher. Items can be put directly on your personal calendar or in your primary contact list. A great way to synchronize with your team. Free trial available.
Colligo Contributor Add-In for Outlook
Abstract from Slipstick Systems (Indexed 2012-01-31):
Integrate Outlook and SharePoint: easily save emails and attachments to SharePoint through Send and File, drag-and-drop, and Outlook rules, or copy entire Outlook folders to SharePoint. Sync document libraries and folders to Colligo Contributor from the toolbar.
I’ll be presenting at the SharePoint Connections FREE Virtual Conference - February 16, 2012
Abstract from Andrew Connell (Indexed 2012-01-30):
The folks who bring you SharePoint Connections are putting on another free online virtual conference. The show, Afraid of the Dark? Keep SharePoint Running!, is on February 16th, 2012. This one day show has a killer price point its FREE!!! Ill be presenting one session, Out of the Sandbox and into the Cloud: Build Your Next SharePoint App on Azure. Hope to see you there! SharePoint Virtual Conference Afraid of the Dark? Keep SharePoint Running Technorati Tags: sharepoint online,sharepoint,off...(truncated)...
The Big Dummies Guide for Windows Phone Developer Resources
Abstract from Bil Simser (Indexed 2012-01-30):
Windows Phone apps are growing in popularity as does the 50,000 60,000 apps in the marketplace today. Microsoft has done a great job at putting together some resources for developers including full documentation. When you first land on App Hub theres all kind of samples, toolkits, and quick starts to get you going. This post is to fill in some gaps and direct you to some additional resources that Ive built up over the last couple of years of building phone apps. I wont regurgitate the Microsoft...(truncated)...
Excel Mashup #2
Abstract from Dick Kusleika (Indexed 2012-01-29):
Following up on the previous post (http://www.dailydoseofexcel.com/archives/2012/01/25/excel-mashup-1/) I extended the capability to create a Polar plot using a 2nd worksheet in the same workbook. The consumer provides graph parameters, including the graph type, using HTML form controls. The graph is in an Excel workbook. Graph any Excel formula in a XY (Cartesian) chart or a [...]
Jan 29, The purpose of Find All
Abstract from Advanced Excel (Indexed 2012-01-29):
Find all was introduced in Excel 2003. The purpose of find all is to help to select cells containing the find condition.
Excel Mashup #2
Abstract from Daily Dose of Excel (Indexed 2012-01-29):
Following up on the previous post (http://www.dailydoseofexcel.com/archives/2012/01/25/excel-mashup-1/) I extended the capability to create a Polar plot using a 2nd worksheet in the same workbook. The consumer provides graph parameters, including the graph type, using HTML form controls. The graph is in an Excel workbook. Graph any Excel formula in a XY (Cartesian) chart or a [...]
Five most popular posts on the Excel blog in 2011
Abstract from David Gainer (Indexed 2012-01-26):
It's still January. There's still time to share the most popular posts on the Excel blog in 2011. Thanks for reading them! Can't remember all those Excel keyboard shortcuts? Now you don't have to! There are a lot of keyword shortcuts in Excel. You can scroll through a long list of them on Office.com, or you can download Quick Reference Cards from our blog and pin them to your corkboard. There are cards for Keyboard shortcuts with the Ctrl keys , Keyboard shortcuts with Function keys , and Miscel...(truncated)...
How to save your Access SharePoint password
Abstract from Erik Rucker (Indexed 2012-01-26):
Recently, someone posted a comment on IT Impact Inc.'s blog asking how to get SharePoint to remember his password when he logged in via Access. He wanted to avoid having to log in every time. Ben Clothier, a Senior Access Developer at IT Impact, knew the answer. He wrote a detailed blog post (with plenty of screenshots) that we'd like to share with you. ITImpact has been building custom databases with Microsoft Access since 1994, serving customers around the world. Ben Clothier has been Microsof...(truncated)...
Jan 26, Advanced Excel book for Sales & Marketing Professionals
Abstract from Advanced Excel (Indexed 2012-01-26):
This excel book contains case studies developed from questions and enquiries fielded by participants from different business functions.
Jan 26, Excel Book - Hidden Secrets of Data Analysis with Excel
Abstract from Advanced Excel (Indexed 2012-01-26):
This excel book contains case studies developed from questions and enquiries fielded by participants from different business functions.
Excel Dev Con Live Blogging
Abstract from Dick Kusleika (Indexed 2012-01-25):
Ross is live blogging the Excel Dev Conference in the UK. It’s already after lunch over there, but if you’re interested, check it out.
Excel Mashup #1
Abstract from Dick Kusleika (Indexed 2012-01-25):
Recently, Microsoft introduced a way to create a “mashup” using Excel. Fellow MVP, Jan Karel, put together a tutorial on how he created his first mashup. It helped me understand the basics, which are also well explained by Microsoft itself. In my case, for a long, long time I have wanted to draw any graph [...]