In this week’s webinar, you’ll learn about Office 365. For small and big businesses, it gives secure, anywhere access to email and calendars, and lets you collaborate with others using Office Web Apps, instant messaging, conferencing, and file sharing. What you will learn at Tuesday's webinar:...(read more)
Microsoft Office
-
Most Topular Stories
-
Webinar: What is Office 365?
The Microsoft Office Blog14 May 2012 | 12:38 pm -
Getting Started with ASP.NET MVC 3, Logging, and Depency Injection
The latest blogs from your friends at OfficeZealot.com15 May 2012 | 8:35 pmI started a new ASP.NET MVC project recently and wanted to give you a little insight on kicking off new projects. There’s some setup time you want to spend setting up your solution and getting the plumbing in order before you dive into writing unit tests and building out your site. For a full on, blow my mind, ultimate guide you *have* to go watch Rob Conery and his 90 minute walkthrough of setting up his MVC projects. I’ve watched this video a few times and Rob is awesome and knows his stuff. The tips he gives are gold. You can also check out the MVC 3 Starter Kit on CodePlex which is… -
Part 1: The Office 365 approach to privacy in the public cloud – Responsibility
The Microsoft Office Blog15 May 2012 | 11:00 amMicrosoft Office 365 is an online business service that was purposely built to optimize the flexibility, responsiveness, and efficiency of the cloud. It was also created with a strong emphasis on data protection and with Microsoft's three tenets of privacy - responsibility, transparency, and choice - at its core. This week we'll explore each principle as explained in the Microsoft whitepaper "Privacy in the Public Cloud: The Office 365 Approach" and on the Office 365 Trust Center , which provides...(read more) -
A Sneak Peak on the Queensland Microsoft Innovation Centre Launch
Microsoft Office News16 May 2012 | 4:35 amWithout giving too much away, I thought I would share a sneak peak of what is happening on the night of our Queensland Microsoft Innovation Centre Launch. -
InterCall's eCommerce Portal Offers Microsoft Office 365 to Small Businesses - EON: Enhanced Online News (press release)
"MICROSOFT OFFICE" - Google News16 May 2012 | 2:00 amInterCall's eCommerce Portal Offers Microsoft Office 365 to Small BusinessesEON: Enhanced Online News (press release)CHICAGO--(EON: Enhanced Online News)--InterCall®, a subsidiary of West Corporation and the world's largest conferencing and collaboration services provider, announced today the availability of Microsoft Office 365 productivity tools to small businesses and more »
-
The latest blogs from your friends at OfficeZealot.com
-
Getting Started with ASP.NET MVC 3, Logging, and Depency Injection
15 May 2012 | 8:35 pmI started a new ASP.NET MVC project recently and wanted to give you a little insight on kicking off new projects. There’s some setup time you want to spend setting up your solution and getting the plumbing in order before you dive into writing unit tests and building out your site. For a full on, blow my mind, ultimate guide you *have* to go watch Rob Conery and his 90 minute walkthrough of setting up his MVC projects. I’ve watched this video a few times and Rob is awesome and knows his stuff. The tips he gives are gold. You can also check out the MVC 3 Starter Kit on CodePlex which is… -
Create a header cell with text separated by a diagonal line
15 May 2012 | 6:41 pmIn creating a table header that explains what the row and column values represent, a common approach is to use a cell with text separated by a diagonal line. This, first for me, video tutorial explains how. For those who prefer a text explanation: Format the cell “border” to add a diagonal from the left-top [...] -
Survey: What Version of Excel Do You Use?
15 May 2012 | 2:00 amSurvey closed This quick and dirty survey has been closed. Thanks to all who participated. Results will be posted in the near future. In addition, a newer and better version of the survey will be/has been posted at New Survey: What Spreadsheet Programs Do You Use? If it’s not posted when you first click on [...] -
Quick Trick: Resizing column widths in pivot tables
14 May 2012 | 11:39 amWho could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way. In this first one, she shows us how to change the default width of a column in a pivot table. Knowing this is especially helpful when you're working with data that that makes a row really long....(read more) -
Slice of Life: Converting my Personal Site
13 May 2012 | 11:32 amOver the last few months I have been having a lot of fun converting my personal site (http://drusellers.com) from a pure static html site, to one that uses a back end server side language. When I first started the main … Continue reading →
-
The Microsoft Office Blog
-
Part 1: The Office 365 approach to privacy in the public cloud – Responsibility
15 May 2012 | 11:00 amMicrosoft Office 365 is an online business service that was purposely built to optimize the flexibility, responsiveness, and efficiency of the cloud. It was also created with a strong emphasis on data protection and with Microsoft's three tenets of privacy - responsibility, transparency, and choice - at its core. This week we'll explore each principle as explained in the Microsoft whitepaper "Privacy in the Public Cloud: The Office 365 Approach" and on the Office 365 Trust Center , which provides...(read more) -
Filtering emails in Outlook
14 May 2012 | 5:38 pmOutlook offers several ways to filter emails. A filter lets you see only those messages that meet certain criteria. For example, you could pick a filter that lets you see only emails that have attachments or are unread. Here's how it works....(read more) -
Webinar: What is Office 365?
14 May 2012 | 12:38 pmIn this week’s webinar, you’ll learn about Office 365. For small and big businesses, it gives secure, anywhere access to email and calendars, and lets you collaborate with others using Office Web Apps, instant messaging, conferencing, and file sharing. What you will learn at Tuesday's webinar:...(read more) -
Quick Trick: Resizing column widths in pivot tables
14 May 2012 | 11:39 amWho could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way. In this first one, she shows us how to change the default width of a column in a pivot table. Knowing this is especially helpful when you're working with data that that makes a row really long....(read more) -
Grouping emails by conversations
11 May 2012 | 1:53 pmHave you ever had to find an email that was part of a long thread--an email with lots of replies about the same topic? For example, your boss might have asked for the results of last month's important meeting, and you know Sherry sent an email outlining them, but then you remember that Todd followed hers with more information. If you group your emails into conversations, you can find the emails you want more quickly....(read more)
-
Microsoft Office News
-
A Sneak Peak on the Queensland Microsoft Innovation Centre Launch
16 May 2012 | 4:35 amWithout giving too much away, I thought I would share a sneak peak of what is happening on the night of our Queensland Microsoft Innovation Centre Launch. -
Nationwide Health Information Network: Conditions for Trusted Exchange
16 May 2012 | 3:30 amSUMMARY: The nationwide health information network is defined as the set of standards, services, and policies that enable secure health information exchange over the Internet. -
Giving iPad PowerPoint Presentations Just Got a Lot Better
15 May 2012 | 11:26 pmOne of the iPad's more intriguing business uses is making presentations before a live audience. -
Feeding America Turns to Microsoft for Anywhere, Anytime Access
15 May 2012 | 10:21 pmThe move strengthens Feeding America's capabilities as it complements the organization's use of other Microsoft solutions including Microsoft Office 2010 and Microsoft Lync Server 2010. -
Market Research Intern
15 May 2012 | 6:11 pmHall and Partners is a specialist in brand and communications research, offering both qualitative and quantitative research solutions to some of the most vibrant domestic and international brands.
-
"MICROSOFT OFFICE" - Google News
-
InterCall's eCommerce Portal Offers Microsoft Office 365 to Small Businesses - EON: Enhanced Online News (press release)
16 May 2012 | 2:00 amInterCall's eCommerce Portal Offers Microsoft Office 365 to Small BusinessesEON: Enhanced Online News (press release)CHICAGO--(EON: Enhanced Online News)--InterCall®, a subsidiary of West Corporation and the world's largest conferencing and collaboration services provider, announced today the availability of Microsoft Office 365 productivity tools to small businesses and more » -
Microsoft touts 400 per cent Asia growth for Office 365 - Register
16 May 2012 | 1:48 amITProPortalMicrosoft touts 400 per cent Asia growth for Office 365RegisterOffice 365, Microsoft's “Office in the cloud” play, was launched initially in Singapore, Malaysia, Australia and New Zealand on 29 June 2011, with other Asian countries following later. Microsoft could not disclose actual numbers of customers won in Note AB Switches From Google Docs To Office 365ITProPortalall 5 news articles » -
Avira Antivirus update cripples millions of Windows PCs - ZDNet (blog)
15 May 2012 | 10:56 ameSecurity PlanetAvira Antivirus update cripples millions of Windows PCsZDNet (blog)The update is also blocking other Microsoft software (such as Microsoft Office and Microsoft Works) as well as various third-party applications, including Byki 4 Express, Documents To Go, Garmin, Google Talk, iPod and Palm services, Opera, Oops! Avira AV Update Blocks Apps, Hangs PCsPC MagazineAvira AV update hangs systems - UpdateThe Hall 16 news articles » -
InterCall's eCommerce Portal Offers Microsoft Office 365 to Small Businesses - MarketWatch (press release)
15 May 2012 | 8:01 amInterCall's eCommerce Portal Offers Microsoft Office 365 to Small BusinessesMarketWatch (press release)CHICAGO, May 15, 2012 (BUSINESS WIRE) -- InterCall(R), a subsidiary of West Corporation and the world's largest conferencing and collaboration services provider, announced today the availability of Microsoft Office 365 productivity tools to small and more » -
TrueContext Launches ProntoForms Windows Phone App With Powerful ... - MarketWatch (press release)
15 May 2012 | 7:53 amTrueContext Launches ProntoForms Windows Phone App With Powerful MarketWatch (press release)The Windows Phone release is an important step for the business solution ProntoForms, as it accentuates vital support for Microsoft Office File formats and interconnectivity with Microsoft cloud computing and management services, including SharePoint and more »
-
Word Blog
-
Tricks from Word Expert Hilary Powers
11 May 2012 | 1:19 pmIf Hilary Powers can teach editors tricks about using Word, then we ordinary folk can definitely benefit from listening to her. Hilary's the author of Making Word Work for You , a handbook for editors, and the maker of creatures out of felt. As an editor, I collaborate with a lot of people and so continually use Track Changes . If you know how to use it, your back and forth with co-workers, or in my line of work, with authors, speeds up getting a document from first draft to final draft. Here are...(read more) -
Office Tip Classics: Make table headers repeat, get a prom date (video)
9 May 2012 | 1:02 pmEdna Jean's parents aren't sure about Conrad taking her to the prom, even though he's her "hunky wunk". Then she tells them that in Word, he can make table headers repeat over multiple-page tables. Will this seal the deal with Edna Jean's parents?...(read more) -
Webinar: Mail Merge
30 Apr 2012 | 10:41 amThis week's webinar is a bit of cooking class. The dish? Fresh Mail Merge. This is a process, not just a few clicks. We'll show you some free tools at Office.com that we’ll show you, including a cookbook (of sorts). Go to http://aka.ms/offweb for more information on how to join the series. What you will learn at Tuesday’s webinar: You need good data for good mail merge Our cookbook: Mail Merge made easy Creating... ...(read more) -
Word video: Convert a table to text
28 Mar 2012 | 6:38 pmIn Microsoft Word, you can convert a table into text, and vice versa. In this video, you'll learn how to change names and addresses in a table into a list separated by commas. If you just want the text version of the instructions, read the full post....(read more) -
Change the default line spacing in Word
6 Mar 2012 | 3:00 pmWhen the default line spacing in documents changed from single spacing in Word 2003 to a slightly roomier 1.15 spacing in Word 2007 and Word 2010, customers asked the inevitable: Why did the default line spacing change? And how do I change it back? The short answer is that the default line spacing changed in Word 2007 to make online documents more readable. If you want to change the default line spacing in Word 2007 or Word 2010, or learn how to set the line spacing in a single document, here are the best resources we've found for step-by-step instructions....(read more)
-
microsoft-office « WordPress.com Tag Feed
-
Office2003的符號表不見
24 Apr 2012 | 6:47 pmhttp://blog.smps.tp.edu.tw/~kcodavid/index.php?load=read&id=490 -
POETRY AND POCKETS!
24 Apr 2012 | 4:11 pmPoetry is bliss! Whether I read, write, sing, listen to it, poetry makes my day! That is why the Poetry Month of April is such an amazing month for me despite rain, snow, wind, and mud. Last year I wrote a blog post, urging people to Celebrate Poetry Month With ‘Poem in Your Pocket Day’ . 2012 April Snow In 2012, I am celebrating once again by upcycling a piece of paper into a small book as a home for a poem. There are many simple, foldable formats for making such a book that is small enough to carry in your pocket. Here are 3 possibilities: I have just discovered a new version of this… -
MS Office: Excel Practice 5
24 Apr 2012 | 9:10 amExcel Practice 5: Charts Open your Excel Practice 3 (Office Sales).xlsx from Google Docs. In the Computer Items worksheet, make a pie chart of the data. Name the chart: Computer Items Change the color of the pie chart to purple hues In the Desk Supplies worksheet, make a 3-d column graph Name the graph: Desk Supplies (you may have to insert a new text box under layout to do this). Change the color of the graph to blue hues Create a new worksheet titled “Charts” and color the tab to orange Move the pie chart and column graph to this new worksheet. Make sure they are the same size… -
Windows 8 Release Preview Announced
24 Apr 2012 | 7:07 amThe Building Windows 8 Twitter account has announced that the Windows 8 Release Preview is set to hi -
Nihiwatu, an award-winning eco-luxury resort located on Sumba Island
23 Apr 2012 | 11:29 pmNihiwatu, an award-winning eco-luxury resort located on Sumba Island is searching for some positions. Information on the resort is available at www.nihiwatu.com. Human Resources Job Location: Nihiwatu Resort, West Sumba ·Indonesian citizen. ·Comfortable spending extended periods of time in a remote location. ·Working closely with departments, increasingly in a consultancy role, assisting line managers to understand and implement policies and procedures. ·Liaising with a wide range of people involved in policy areas such as staff…
-
Excel Blog
-
Quick Trick: Resizing column widths in pivot tables
14 May 2012 | 11:39 amWho could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way. In this first one, she shows us how to change the default width of a column in a pivot table. Knowing this is especially helpful when you're working with data that that makes a row really long....(read more) -
Count values that meet a condition with the COUNTIF function
4 May 2012 | 11:39 amUpdate: See near the bottom of this post for the latest Office how-tos on embedding Excel and PowerPoint files on web pages. You probably know how to use the COUNT function to count cells that contain a value. But what if you want to count only the cells that meet a condition, such as being greater than or equal to a number or date you specify, or that matches text? That's where the COUNTIF function comes in really handy. Keep reading to learn more, and try out this great function for free using the embedded worksheet in this post....(read more) -
Using multiple criteria in Excel Lookup formulas
26 Apr 2012 | 8:01 pmIf you want to look up a value in a table using one criteria, it's simple. You can use a plain VLOOKUP formula. But if you want to use more than one criteria, what can you do? There are lots of ways using several Excel functions such as VLOOKUP, LOOKUP, MATCH, INDEX, etc. In this blog post, I'll show you a few of those ways....(read more) -
Merging and splitting cells or data
12 Apr 2012 | 12:30 pmThe title of this post sounds simple. Should be easy to do, right? But customers tell us that it's very confusing and not at all clear where to find the features to get the results they want. It all depends on what you want to merge or split. For example, you may want to create a large header cell by splitting the cells below it into a number of smaller cells. I often create such headers but use a different method than you'd expect, because an individual cell simply cannot be split into smaller cells. Instead, I merge several cells into one larger cell above the cells for which it will be the… -
And the winner of the VLOOKUP Great White Shark Award is...
11 Apr 2012 | 4:13 pmJP Pinto! Congratulations! His post was one of seven chosen by Bill Jelen as the most innovative ones published during VLOOKUP Week. He won a copy Bill Jelens book Microsoft Excel 2010 In Depth. You can find links to all seven posts and see the voting results in our wrap-up post of VLOOKUP Week. ...(read more)
-
Outlook Blog
-
Filtering emails in Outlook
14 May 2012 | 5:38 pmOutlook offers several ways to filter emails. A filter lets you see only those messages that meet certain criteria. For example, you could pick a filter that lets you see only emails that have attachments or are unread. Here's how it works....(read more) -
Grouping emails by conversations
11 May 2012 | 1:53 pmHave you ever had to find an email that was part of a long thread--an email with lots of replies about the same topic? For example, your boss might have asked for the results of last month's important meeting, and you know Sherry sent an email outlining them, but then you remember that Todd followed hers with more information. If you group your emails into conversations, you can find the emails you want more quickly....(read more) -
Conditional Formatting: Highlight your most important mails
10 May 2012 | 1:08 pmConditional formatting is an Outlook tool for making sure your important email messages stick out in your Inbox. The tool lets you customize how different messages appear in your Inbox based on criteria that you set. This post shows you how....(read more) -
Remember to update your Facebook provider for OSC
23 Apr 2012 | 5:58 pmIn January of this year, we released an update to the software that connects Outlook Social Connector (OSC) to Facebook. Starting on May 1st, all users of the Facebook provider for the OSC will need to download this update to continue getting social media updates from their Facebook contacts and to avoid getting errors when they connect to Facebook via the OSC....(read more) -
Quick Rule Creation in Outlook 2010
23 Apr 2012 | 5:28 pmIf you are a heavy email user like me, chances are good that you subscribe to a lot of mailing lists. Unsolicited spam is one issue we battle in our inboxes, but perhaps more perplexing is the amount of email messages that we call “graymail.” Graymail consists of all those newsletters and notifications that can be useful, but aren’t necessarily what you you want at the top of your Inbox. The Rules feature in Outlook 2010 makes it easy to sort emails that need your attention from the graymail ones that don't. This post shows you how....(read more)
-
PowerPoint Blog
-
Download the PowerPoint 2010 Viewer
9 May 2012 | 4:55 pm(This post, originally published in 2010, announced the availability of the PowerPoint 2010 Viewer. This post remains incredibly popular because so people find the Viewer to be a useful tool. We're republishing it so readers of our blog can find and use it, too.) I’m excited to announce that our new PowerPoint Viewer is now available here for free download . By installing the PowerPoint Viewer, you can open and watch PowerPoint presentations in all formats, no matter what computer you’re...(read more) -
Kid, you've got what it takes to add a video to PowerPoint
1 May 2012 | 3:39 pmWelcome to Office Tip Classics -- a series of one-minute videos where you'll get to see clips of film classics and learn a tip about Office 2010. In this episode, school tough-guy Marty has a hard time keeping his cool after losing the class presentation contest. His teacher tries to cheer him up, explaining how to add a video to his PowerPoint presentation. Maybe he won't be such a sore loser next time....(read more) -
Webinar: Better PowerPoint Presentations
23 Apr 2012 | 12:46 pmIn this week’s webinar, we'll show you some nuggets for making better PowerPoint presentations. You can join Office webinars at 9:15 am Pacific on Tuesdays. Go to http://aka.ms/offweb for complete information. What you will learn at Tuesday’s webinar: How PowerPoint is like your resume Using the Notes section In PowerPoint Using Presenter’s View in... ...(read more) -
Crop around irregular images
11 Apr 2012 | 7:01 pmHow do you crop the background out of photos, leaving behind an irregular shape like a coffee cup, stop sign or even a human being? Here's one way, using the drawing tools in PowerPoint. Guest blogger Bruce Gabrielle shows you how....(read more) -
Make an image within an image stand out
4 Apr 2012 | 1:09 pmFive math whizzes from the same city go to Harvard to study business and only one becomes a CEO of his own company. You want to use visuals in your PowerPoint presentation to help tell their story to budding entrepreneurs at an upcoming event. In this short video, Bruce Gabrielle shows you how to use the Transitions and Artistic Effects features in PowerPoint to make parts of an image fade into the background and another part come into focus. ...(read more)
-
Access Blog
-
Using a Combo Box to search as you type
3 May 2012 | 10:27 amHere's a neat trick that you can use to filter a Continuous or Split form while your users are typing in a Combo Box. As the user types, the form filter updates to display full or partial matches for the value entered. This example uses a slightly modified version of the Northwind 2007 Template, available for download from Microsoft. The "Customer List" form is a Split form that displays a list of all customers. We want to allow users to filter this list to easily find a customer, even without knowing the full customer name....(read more) -
Access 2010: How to write expressions for Web queries, forms, and reports
19 Mar 2012 | 10:24 amBefore Access 2010, Access supported a wide variety of expressions in different areas of the application. Tables and fields, queries, form and report properties, controls, and macros can all use expressions to evaluate data or logic to drive the behavior of an application. In the past, each of these contexts in which an expression is used have shared a single, common expression evaluation engine. This means that no matter where you use an expression, the functions and operators available to you will likely be the same. Things change when you start to build web databases with Access… -
Q&A with Access developer Juan Soto
17 Feb 2012 | 10:55 amWorking in an ice cream factory in Chicago led Juan Soto to found IT Impact, Inc., an Access development consulting firm. The ice cream factory's large Enterprise Resource Planning system required that he spend hours manually calculating whether a final batch of ice cream really made the company money. He had to factor the waste for every step of the manufacturing process and soon realized that he could automate the analysis with Access. He built a complex Access system which was soon used throughout the entire operation. In this Q&A, we asked Juan to share his experiences and… -
Five Common Pitfalls When Upgrading Access to SQL Server
17 Feb 2012 | 10:54 amGuest blogger Juan Soto, an Access MVP and founder of IT Impact, Inc., shares five tips on upgrading Access to SQL, including information about using the SQL Server Migration Assistant, adding tables, bit fields, and foreign keys. You can also read more about Juan and his knowledge of Access in our Q&A with him. ...(read more) -
How to save your Access SharePoint password
26 Jan 2012 | 10:52 amRecently, 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 Microsoft...(read more)
-
Microsoft Project 2010
-
You want your team to work on Saturday? Serious?! OK. Here’s how.
14 May 2012 | 1:18 pmWork typically isn’t difficult to describe. We all do it, and sometimes wish we had less of it. In Microsoft Project, on the other hand, defining work can get a little tricky, especially when setting up the working calendar for the team in your project schedule. Usually, Project considers working time to be Monday through Friday, from 8 a.m. to 5 p.m ., with weekends off. So far so good, especially the part about the weekends. But you can change this to any time you want. If you want everyone to work Saturdays or all evenings, so be it. The following graphic will show you how to use the… -
Microsoft Kicks off Project Conference 2012!
20 Mar 2012 | 4:01 amSpecial message from Project & Visio Director Chris Crane This morning, Kirk Koenigsbauer – Corporate Vice President of the Office Division Product Management Group – kicked off the Microsoft Project Conference 2012 in sunny Phoenix, Arizona with an opening keynote address. This year’s event celebrates the success of Project 2010 and showcases how it continues to evolve in order to meet the changing collaboration and project management needs within organizations of all sizes. At the heart of that evolution is Microsoft’s focus on an integrated platform… -
Microsoft Project Server 2010 and ERP Integration
13 Mar 2012 | 1:54 pmA common ask from customers nowadays is to integrate their Project Portfolio Management (PPM) solution with their Enterprise Resource Planning (ERP) solutions to achieve end to end visibility into portfolios, projects, resources and finance. Microsoft Project Server 2010 offers an extensive and powerful platform that can easily be integrated with leading ERP, including out of the box integration with Microsoft Dynamics AX and SL. A number of PPM partners have built solutions that connects Project Server with other line of business applications, please check Microsoft Enterprise Project… -
Finding Project Server documentation on TechNet
12 Mar 2012 | 12:21 pmNeed help finding Project Server documentation on TechNet? Watch this video to learn more about where to find Project Server content, what content is available, and how to provide feedback. -
Project Conference 2012–The Biggest Ever!
5 Mar 2012 | 4:55 pmThe Microsoft Project Conference 2012 has the largest Sponsor and Exhibitor momentum in the history of all Microsoft Project Conferences! We’d like express our gratitude to all sponsors & exhibitors who have committed to make this event a great success! All sponsors (listed below) and exhibitors will be available in their booths to demonstrate how they contribute to the momentum of Project 2010! In addition to standard expo hall hours all sponsors and exhibitors will be ready to greet you at the Welcome Reception Monday Evening – make sure to visit the Expo Hall to enjoy the food,…
-
Arpan Shah's Blog
-
Office 365 : Continuous Innovation
6 May 2012 | 11:40 amOne of the great things about Office 365 is that we can continuously innovate and improve our service. And that’s exactly what we’ve been doing. You can learn all about our updates @ http://community.office365.com/en-us/w/office_365_service_updates/default.aspx. I encourage you to sign up for a trial of Office 365 if you haven’t already and experience it yourself! All you need to do is go to http://www.office365.com and within minutes you’ll be up and running. -
To The Cloud!
1 Mar 2012 | 12:43 amI’ve taken a new role in the Microsoft Office Division and I’m excited to say that my new team will be leading core product management for our Office 365 Suites. Our mission is to deliver the best online productivity solution in the industry to our customers. My team will work closely with engineering as well as our outbound channels. While I am super excited about my new role, I will miss being part of the Project team. The Project team is one of the best teams I’ve been a part of at Microsoft – great people, great technology and great community. It has truly been a pleasure &… -
Project Collaboration with Microsoft Project 2010 and Office 365
31 Jan 2012 | 4:09 pmI wanted to call out some really interesting content that highlights the power of Microsoft Project 2010, Office 2010 and Office 365. I definitely recommend reading the article and watching the videos from http://blogs.msdn.com/b/project/archive/2012/01/25/leveraging-office-365-for-project-collaboration-success.aspx -
Cell Phone Trends in Asia
31 Dec 2011 | 12:08 pmI had a unique opportunity to spend 6 weeks in Asia – specifically in India, Cambodia and Thailand from early November to late December. And while this was a personal trip, I observed technology trends that were quite different from the US. Here are a few that I noticed: - WiFi is not ubiquitous. Unlike many places in the US where WiFi is present in many homes, coffee shops, airports and city centers, WiFi is not everywhere in India. There are definitely pockets of WiFi access, but even in many homes, it’s not available. - BlackBerry is a popular smartphone in India. Caveat: while I was… -
Project Conference 2012 – Register now!
27 Nov 2011 | 4:56 amThe Project Conference 2012 is less than 4 months away! It’s an opportunity to see the Microsoft Project team and share ideas & experiences with the greater Microsoft Project community. This conference is ideal for Business owners, Project Managers, partners, developers and IT Managers – check out the tracks at http://msprojectconference.com/pages/tracks.aspx. You can also register now at http://www.msprojectconference.com I’m looking forward to meeting you in Phoenix, AZ, next March!
-
Murray Sargent: Math in Office
-
RichEdit 8.0 TOM Table Interfaces
22 Apr 2012 | 11:19 pmAn earlier post describes the RichEdit nested table facility and how the EM_INSERTTABLE and EM_GETTABLEPARMS messages could be used to insert and examine tables. Now those messages are documented in MSDN along with a new message, EM_SETTABLEPARMS that allows one to modify tables. For additional convenience, RichEdit 8.0 adds table support to the TOM text object model. The APIs are all documented in MSDN, but it’s worthwhile to give an overview here to help motivate the approach. If you’d just like to insert a table with any number of identical rows and default properties, call… -
RichEdit 8.0 Preview
3 Mar 2012 | 9:50 amThere’s been a lot of buzz about the Windows 8 Consumer Preview and it is really exciting. One particularly exciting thing missing in the buzz is that Windows 8 contains a new RichEdit! Since the new version is now publically documented on MSDN, I can write about it. I found the public documentation by Binging for ITextRange2, one of the TOM2 interfaces introduced in RichEdit 6.0. As you can imagine, I’ve been dying to write about RichEdit 8 in Windows 8 for quite a while. There’s so much to say that there will be several posts on it. In contrast, Windows 7 has RichEdit 4.1… -
RichEdit Character Formatting
8 Feb 2012 | 1:21 pmRichEdit’s name derives from its ability to represent rich text. Such text is comprised of text runs with different sets of character and paragraph formatting properties along with embedded objects, such as images. Some discussion of paragraph formatting is given in an earlier post. The present post discusses how character formatting is represented in RichEdit and how it differs from CSS (cascading style sheet) formatting used, for example, with HTML. Typical character formatting properties include bold, italic, underline, text color, background color and font. These properties affect… -
Math in Office Links
9 Jan 2012 | 10:30 amI started this blog in 2006 and now it’s 2012. How time flies! At this point it seems worthwhile to post links to previous posts grouped according to subject. The present post provides links relevant to the main theme of the blog, math editing and display in Microsoft Office. Eventually it would be nice to have a book on this subject. A future post will provide links to a secondary theme, RichEdit-specific documentation. A number of readers have provided auxiliary information, “cheat sheets”, short cuts, etc. I’d like to collect a list of these, so if you have links to… -
Keyboard Operator Shortcuts
2 Dec 2011 | 5:02 pmThe previous post introduces Hermann Klinke’s math input notation, which he developed to speed up entry of equations for real-time note taking in OneNote. The post is followed by a very interesting set of comments comparing high-speed, and yet easy-to-remember, input sequences. Some of these involve hot keys and some can be done with math autocorrect. Both approaches are significantly faster than TeX input. In a future post, I’ll write about possible use of hot keys in math zones, which seems like a really powerful feature (MathType has it). The present post deals with a simple,…
-
SGriffin's MAPI Internals
-
Missing Replication State Machine Constant
2 May 2012 | 12:48 pmOn this page, talking about eh Upload Folder State, we have a note which references the constant UPS_ONE_FOLDER. This constant is not defined in our list of MAPI Constants or in a header file. This is an oversight. Here’s the definition for this constant: #define UPS_ONE_FOLDER 0x00000004 That is all. -
April 2012 Release of MFCMAPI and MrMAPI
23 Apr 2012 | 2:20 pmThe April 2012 Release (build 15.0.0.1033) is live: http://mfcmapi.codeplex.com. I ship a new build of MFCMAPI every two months. That’s a personal goal I keep to help motivate me. Somehow I got it in my head that I was due to release a new build of MFCMAPI here in April. So I worked extra hard to track down some bugs and implement some new features to make the new build worth it. Only when that was done did I realize I shipped a new build in March – one month ago. So here you go – bonus build! When you start this new build, you’ll see a new menu, which is a feature I’m quite proud… -
Cached Mode Quotas
17 Apr 2012 | 4:06 pmIf you’ve ever tried to use MFCMAPI to troubleshoot Exchange server mailbox quotas, you’re probably familiar with the properties PR_STORAGE_QUOTA_LIMIT, PR_PROHIBIT_SEND_QUOTA, and PR_PROHIBIT_RECEIVE_QUOTA. These properties live on the message store object and tell you what your various quotas are. The problem with these properties is that they only work with an online profile. If you’re working with a cached mode profile, these properties will not work. Prior to Outlook 2010, the only workaround was to either build an online profile or bypass the cache. As of Outlook 2010, there’s… -
Simplified MAPI Stub Library
16 Apr 2012 | 2:24 pmA while back I mentioned our MAPI Stub Library. This is a couple of .cpp files you can drop in to your project instead of linking to mapi32.lib, Alternatively, you can build your own version of mapi32.lib. You can read more about the whys and wherefores on the codeplex site or in the MSDN article on MAPI linking. We just updated the logic used to find the correct MAPI binary to both make it more correct and to simplify it. According to the dev who did the work, we were able to eliminate two thirds of the code from StubUtils.cpp. The code is now more future proof, so if you were using the… -
Conversation View and Categories
12 Mar 2012 | 5:06 pmFrom time to time, folks ask me what they need to do in their message store provider to support Outlook 2010’s conversation view. I tell them they need to support restrictions on message store tables as discussed in the MAPI documentation. If Outlook hands them a restriction, they can’t return MAPI_E_TOO_COMPLEX and expect the conversation view to work. I also tell them their table needs to support categorization with multivalued columns and MV_INSTANCE. Because they support categorization, they also need to return STORE_CATEGORIZE_OK in PR_STORE_SUPPORT_MASK. Basically, when you turn on…
-
Arrow Tips- Brought to you by Advena Artemis
-
Weekly Educational Moment: Use Your Network to Promote Your Blog [Digg]
15 May 2012 | 3:05 pmToday during our educational moment we talked about how our group can help support each other through promoting each other’s blog posts. We took a quick look at some of our members’ b... -
What Was Chandler’s Job Anyway? [Digg]
14 May 2012 | 2:19 pmWere you a fan of the TV show Friends? Anyone remember what Chandler‘s job was? Neither does anyone else because his best friends couldn’t even explain what he did. (See: What Was Chandler Bing\’s Job?) As a consultant, I can -
Say no to wind farms: Shale of the century | The Spectator [Digg]
20 Oct 2011 | 9:34 amThe arguments for wind farms just became obsolete. We’re entering an era when gas will be cheap, plentiful – and green -
Outlook 2010 – It’s a Love Hate Thing Argh!
7 Apr 2011 | 3:27 pmI upgraded to Office 2010 earlier this year when I purchased a new PC and have been adjusting ever since. At first, I didn’t see much not to like (other than having to find a few things again). But then, disaster struck – Microsoft removed on of my favorite features and one that made Outlook a serious contender in the contact management software world. Read on to see what I love and what I hate about Outlook 2010 so you can decide if an update is to be embraced or avoided. What I Love! Finally a real product version – Usually Microsoft releases a new version of Windows or… -
What Happened to Arrow-Tips?
5 Jan 2011 | 11:56 amHappy New Year! Wow – have I been neglecting this poor blog! And, as those of you who have seen me in the past six months know, it is horribly out of date for what we are doing with Advena Artemis now. So, its time for a redesign and I’m bringing on an intern to help facilitate the process with my wonderful designers at Bread n Beyond. In the mean time, here are some quick updates: Sale of Gulf Coast Welding Yay – we sold my former client (owned by none other than my Mom) Gulf Coast Welding Corp.. The deal with the new owners from Viacap was inked earlier this…
-
Legal Office Guru
-
From the Comments: Cool TOA trick
2 May 2012 | 5:48 amWant your Table of Authorities entry to line-wrap at a specific point? A fellow Legal Office Guru reader shares her (fantastic) tip on how to accomplish that. -
When a tab is not just a tab, part 3: Center tabs
10 Apr 2012 | 8:36 pmIf you've ever wanted to center text on a point somewhere other than dead center between the page margins, you need to learn how to use Center tabs. Click through to the full article for a quick video showing you how to set one up. -
Reader Question: How to automatically number your discovery requests … in 5 keystrokes
28 Feb 2012 | 7:30 amIf your law firm does litigation work, you've probably prepared lots of discovery. And you may have wondered if there's any way you can avoid typing the phrase "Interrogatory No. X" in Microsoft Word over and over again and get that X to be an automatically incrementing number. If so, the answer is, yes, you can! Click through for a complete tutorial on how to use field codes in Microsoft Word to automatically number interrogatories, requests for production, requests for admission, or other legal discovery. -
Guest Post @ Lawyerist: Fix Formatting Fast – Five Microsoft Word Tricks
14 Feb 2012 | 9:21 pmFive little-known tricks for fixing unruly formatting in Microsoft Word. -
How to set tabs (without tearing your hair out)
9 Feb 2012 | 9:40 amHaving trouble setting tabs in Microsoft Word? Here are two quick methods, plus a tip on how to set tabs for one section of your document without messing up the rest of your text.
-
SSWUG.ORG MEDIA
-
SSWUGtv: should you be using PowerPivot? Dan Clark talks about his thoughts. Is it the tool for your self-service BI?
13 May 2012 | 7:00 pm -
Cloud implementations, technologies, including software (specifically databases) as a service and much more.
10 May 2012 | 7:00 pm -
How do you clean data? Do you clean data? Do you clean it after it has been brought into your systems?
7 May 2012 | 7:00 pm -
Josef Richberg talking about SSIS - Common mistakes, things to know and tips - all for SSIS and SQL Server.
3 May 2012 | 7:00 pm -
SSWUGtv: Michael Crump talks about development with #sql2012 on the show today - important tips and more.
29 Apr 2012 | 7:00 pm
-
I Came, I Saw, I Learned...
-
Adobe Captivate 5/5.5: Switch TTS Agents in a Snap
15 May 2012 | 2:31 pmby Kevin Siegel During every Captivate beginner class, time is spent on the second day teaching everyone how to use Captivate's Text-to-Speech feature to convert slide notes into speech.Recently, one of the students asked an excellent question: "Is there an easy way to change my mind? I'd love it if there was a pain-free way to quickly change the agent from Kate, to Paul and then maybe back to Kate."You can switch between one agent to another. The solution, while easy, isn't obvious. Here's how:First, go through your project and convert the slide notes to… -
Adobe Captivate: Reuse Text to Speech
10 May 2012 | 3:11 pmThe Adobe Captivate BLOG features a video that goes into Captivate's Text to Speech feature and how to reuse audio files in multiple projects. Read more -
PowerPoint: Chart Templates
10 May 2012 | 3:10 pmby AJ George I was perusing the Microsoft Office Forums and came across an unanswered question from someone about chart formatting. This PowerPoint user wanted to be able to create multiple charts with the same formatting (ie bars on a graph with a gradient effect) without having to individually format each separate piece of every new chart. An attempt at copying and pasting the slide using the Keep Source Fformatting option did not keep the chart's formatting. The person struggling with this issue also mentioned that there were more than 300 charts that needed formatting and dreaded… -
Adobe Captivate 5/5.5: It's Alive... Preview
8 May 2012 | 10:29 amby Kevin Siegel Last week I wrote about how you can save and share effects you've added to the Effects panel (so the effects can be used in other projects or by other developers). I'd like to stick with the Effects theme for another week. If you've used the Effects panel, there's a good chance that you've missed a useful feature--it's often overlooked by even veteran developers.The most common way to preview an effect or a slide animation is to either Preview the project, the next 5 slides or from the current slide (these options are all found… -
Adobe RoboHelp: Top 10 Mistakes to Avoid When Creating a Help System
5 May 2012 | 3:04 pmNeil Perlin has written a well-rounded white paper covering the top mistakes Help authors make when creating a Help System. Among the mistakes: Not developing mechanisms to support content consistency Not developing mechanisms to support format consistency Not revisiting project design in light of 'environmental' changes Not planning to test QA (Quality Assurance) and usability Not planning to create an index Read more
-
Chandoo.org - Learn Excel & Charting Online
-
Please Enroll in our Excel & Dashboards Masterclass – Melbourne
15 May 2012 | 7:19 pmHello folks, I have a quick announcement. As you may know, I am doing a set of Excel & Dashboards Masterclasses in Sydney, Melbourne & Brisbane. We had a fantastic session in Sydney (with 18 delegates). We are sold out in Melbourne & have 2 spots left in Brisbane. But we kept getting requests for more in Melbourne. So we have added an additional session in Melbourne. This is right after Queen’s birthday – on 12th & 13th of June. Please use below links to enroll for the masterclass if you are interested. Melbourne Masterclass – 12 & 13 June Brisbane… -
VBA Move data from one sheet to multiple sheets
14 May 2012 | 4:30 amThis is a guest post by Vijay, our in-house VBA Expert. Suresh sent an email with interesting problem. There is one data entry sheet where all the data needs will be entered, however once done we want the data to be stored separately in multiple sheets designated by the Employee code. In this article we will learn how to use VBA to help in resolving the problem Suresh was facing at work. We will do this using VBA and the below procedure illustrates how this was done. Sub copyPasteData() Dim strSourceSheet As String Dim strDestinationSheet As String Dim lastRow As Long strSourceSheet = "Data… -
Interactive Sales Chart using MS Excel [video]
9 May 2012 | 3:28 amFinally, I got some time to sit down and do what I love most – write a blog post to make you awesome in Excel. After a whirlwind trip to Sydney, I am back in India to spend few days with my kids & wife before rushing to Australia to run 2nd leg of my training programs (in Perth, Melbourne & Brisbane). I did 2 sessions in Sydney – one for KPMG and other for public and both went very well. We got lots of positive feedback and people really loved it. I am saving the details for another post, but today lets talk about Interactive Sales Chart using Excel. Take a look at the… -
Catchup with Chandoo in Perth
8 May 2012 | 2:00 amHi All As you know Chandoo is running a series of his Dashboard Classes across Australia during May. Chandoo will be in Perth in the last week of May. I am planning to have a SunDowner with Chandoo to welcome Chandoo to Perth. The evening will involve a few drinks and maybe dinner and You are all invited. When: Tuesday 22nd May at 5pm Where: Botanical Cafe (a part of Frasers Restaurant) Kings Park. RSVP: 20 May – Can you please email Hui ( ihuitson at gmail dot com ) or leave a comment here, Let me know if you can come and if you want to stay for dinner. Miss Out: This is what… -
Displaying Text Values in Pivot Tables without VBA
7 May 2012 | 3:00 amPivot Tables take tables of data and allow the user to summarise and consolidate the data at the same time. This is a great and very fast method of analysis but is restricted to handling mathematical functions on the value field resulting in numerical summaries. It is possible to combine Custom Number Formats with the Pivot Table to produce Text based answers. Download some sample data and follow along here: Sample File. On the Simple Example worksheet You will see that we have a sample table consisting of 5 fields, Names, Email, Opened and Date Next add a numerical field “Open”,…
-
Excel Everest - Blog
-
A Suvey, S'il Vous Plait
15 May 2012 | 3:10 amS'il Vous Plait, Messrs. Google and Google inform me, translates as "If you please". Couldn't be more appropriate, if you ask me. The (quite frankly) awesome Jon Peltier has come out with a survey asking us Excel users a couple of questions. And in our humble opinion, anything we can do that will help Jon make the Excel world a better place to live in is well worth our time. So head on over to this link, and click the appropriate boxes, please. Danke! -
Roman To Arabic... And Back Again!
14 May 2012 | 5:18 amEver wondered if it was possible to convert Roman numerals to Arabic in Excel? Given Excel's proclivity in coming up with formulas that range from the impressively versatile to the mind-bogglingly vague, you'd figure the odds are good, and as you're about to find out in a minute, you wouldn't be far off the mark. But first, a little lesson in what we're talking about. Arabic numberals are the numbers that you and I use in everyday life. You know, 1,2,3 and so on. Roman numerals are those infuriatingly complicated beasts that seem resolutely indecipherable at the best of times. You know,… -
Preserving Leading Zeros
1 May 2012 | 6:21 amThe always awesome Chandoo comes up with a tip that needs to shared as widely as possible, more about which in just a second. Have you ever needed to enter numbers in a sheet where for whatever reason, they need to be entered as 001, rather than 1? Of course you have, who hasn't? Well, in that case, you have also obviously suffered from the bang-my-head-against-the-wall syndrome, because Excel is, in this case, more stubborn than an obdurate mule. If you don't know waht I'm talking about, simply fire up an Excel sheet and enter "001" without the inverted commas in any cell ... and hit… -
A Treasure Trove. Literally.
25 Apr 2012 | 12:23 amEvery now and then, our sojours on the Internet seas lead us to places where not too many people have trodden before. These virgin, unexplored islands are often that-a-ways for a reason; they're poorly designed, perhaps, or maybe the content is not too useful. We just heave resigned sighs and set sail from them, in search of better lands. Every now and then, though, we just luck out, plain and simple. And the link that we're going to share with you today is one such internet treasure. The unimaginatively titled "Site Map | Microsoft Office" - I mean, c'mon! - is actually a repository of link… -
Poems about VLOOKUPS. Whatever next?
13 Apr 2012 | 12:42 amJust a quick post, this, and it isn't going to make you any better at Excel. It'll make the world a more cheery, whacky and weird place, though, that much we can guarantee. Presenting the world's first ever, one and only... (drum roll, please)... Ode To Vlookup: VLOOKUP, VLOOKUP, How do I love thee? Let me count the ways ... The tens of thousands of records, nay, The now 1,048,576 potential records per sheet, A full 16,384 potential fields wide, Would be a mountain of bad data Too high to climb... Whether tracking statewide underground facility…


