Wednesday, March 14, 2012

Say What? Five Old Words With New Meanings

AppId is over the quota
AppId is over the quota

Newspaper and magnifying glass Technology is changing our vocabulary. It's got us writing in shorthand (OMG, I'm ROTFL!), and it's given us new meanings for lots of words. When I was a kid, tag was something I played outside. Today it's how I track friends and family photos on Facebook.

As you look at productivity solutions in the cloud for your business, you're bound to come across many more terms with newly coined definitions. Here is a list of words that we've compiled to help you better understand what Office 365 delivers:

Cloud:  A way that computer programs and services are delivered over the Internet to a device such as your PC or mobile phone rather than via software in a box. Phrases such as "web-based," "cloud-based" or software-as-a-service (SaaS) basically mean the same thing. Virtual Community:  This is a group of people who share information in online locations, such as a forum. The Office 365 Community website is an active portal with blogs, wikis, a forum and troubleshooting page. Here you can interact with product experts at Microsoft and other Office 365 users including customers and partners. Kiosk:  Kiosk Workers are "deskless", shift, or retail store workers who use shared computers. Learn how New Belgium Brewing, an Office 365 customer, supports its deskless workers. Presence:  Presence tells people your online availability. For instance, if you're in a meeting, your "presence" status is red, indicating that you're busy. You can learn more about different ways to manage your Presence with Microsoft Lync, and how it's integrated into the Office 365 services here. Dashboard:  Similar to what's in your car, a dashboard is a single display that shows the status of all Office 365 services and tools in real time. You'll also see this referred to as an administration user interface. Watch a video about Office 365 administration to learn more.

So let's hear it - what other words have taken on a new life with technology? Share your ideas in the comments below.

TAFN!


View the original article here

Tip: Finding a job-specific resume template in Word

AppId is over the quota
AppId is over the quota

Resume of an electricianWhen someone needs a new resume, he or she either starts from scratch or searches the Web for a template. What they don't know is that access to free resume templates is hiding in plain sight in Word.  All you have to do in Word is click New, look under Office.com Templates, and make your pick. Word then takes you to Office.com to download the resume to your computer.

 The trickiest part of creating a resume is gearing it to a particular profession. For example, say you're a high school graduate who loves animals and wants to work as a veterinary tech. Or a military veteran transitioning to the private sector? Or just about any job-seeker looking to work in a profession. Here, too, Word can help out.

Open Word and click File > New. Scroll down and click Resumes and CVs, then choose the Job-specific resumes folder.

 File New, Resumes and CVs, takes you to job-specific resumes

When you click the Jobs-specific resumes folder, you go right to the job-specific resume templates collection on Office.com.  Scroll to find the resume you want.  Look! There's the vet tech resume. Download it and save it to your computer, and replace the pre-populated information with your own, either by typing it in or copying and pasting from an existing resume.

Select and download a resume

You can find lots of good information elsewhere on Microsoft sites about resume prep, job hunting, interviewing, and more-it's kind of like having your own personal job coach, but it's free!  Check out some of these links:

Career Center for job seekers 

Resume tips by Kim Isaacs, director of ResumePower.com

Office casual: how to get your resume noticed by using the right keywords

Let Word be your resume professional


View the original article here

Death by PowerPoint? Not so fast

Microsoft Publisher development

Editor is never used, although his part of the package, there are many reasons for this, that other not might have known some of you. Here are some suggestions to make it better and a part of everyday business.

1. Merge Microsoft ad Center and Publisher in one, why? These tools are used both for marketing, one for online marketing (adCenter) and one for offline marketing (eds.).

2. AdCenter must and everything in a marketing tool that allows users to promote, track, and digital signage networks, respond to all networks TV, games, online video sites, sites, outdoor made this Publisher mobile phones etc. helps small and medium-sized companies all over the world a lot.

3. the template store is no where to find the one you have is terrible, please better templates have 3rd party artist, and have links to the memory for user-defined work to do really

This for Excel, excel is very useful, but not for serious mathematical analysis, so create a MATLAB version or buy Mathematica, MATLAB, and integrate into Excel, make the analytical tool for all use of excel.


View the original article here

A quick look at what it took to build an Office Blog app for Windows Phone 7

AppId is over the quota
AppId is over the quota
 This post is written Craig Kerwien, the Director of Site Management in the Office Division Product Management Group; he helped bring this app to life.

Screenshot of Office Blog Windows Phone 7 Building an Office Blog app for the Windows Phone began as a weekend DIY project. Although many people are familiar with RSS readers as a way to monitor blog activity (learn more about the Office Blog RSS feeds here), I was looking for a quicker way to monitor and stay up to date on the latest news from the Office Blog.

While rummaging around MSDN for code examples, I stumbled upon Chris Koenig's Windows Phone Starter Kit for Schools, which is an easy way for anyone to create and publish a Windows Phone app for your favorite school.  Chris is a Microsoft Windows Phone Evangelist based in Texas, who developed a code package so beginning developers can easily build and publish a full-featured app by adjusting just a few settings. I thought this would be a great way to develop an app for the Office blogs.

 In the span of a few hours on a Saturday, I had a working app. Here's all I had to do:

Installed the Windows Phone SDK for the first time, and loaded up the Starter Kit project.Created and fine-tuned the logos and color scheme so that they shared the same look and feel as the blog's design.Organized the app pages and blog feeds for each of the Office programsRemoved pages and code that related to building an app for a school.

 At this point, I could have declared the app done and published it to the Marketplace under my name. But I had higher ambitions:  I wanted to publish the app under the Microsoft name, which would give it the Microsoft 'seal of approval' and provide broad visibility as an example for others to use and build from. We think it's cool that anyone can create a simple app for their blog using the same code that we used for the Office Blog app. So we kicked off the internal review process that all Microsoft products must undergo before they are released to the public.

screenshot of Office Blog app for Windows PhoneI'll spare everyone the blow-by-blow details it takes to shepherd a Windows Phone app through the quality assurance reviews at Microsoft, which cover privacy, geopolitics, accessibility, Trustworthy Computing, and of course security reviews. Suffice to say it took longer than a few hours on a Saturday afternoon, and I think the effort was worth it.

Let me take this opportunity to thank Chris for developing the Windows Phone Starter Kit for School and helping me make code adjustments during code review. He recently developed another Starter Kit just for RSS-based applications, such as blogs. I encourage other blog owners to explore it.

If you want to try it out, the Starter Kit is free, and so are the development tools. To publish to the Windows Phone Marketplace, all you need to do is purchase an annual subscription at App Hub @ $99 USD/yr.

And, of course, we hope you'll use the app to monitor the news and information from the Office Blog.  Enjoy! 

-- Craig Kerwien


View the original article here

Tuesday, March 13, 2012

Tip: Add page numbers - and only page numbers - in your Word document

So why emphasize the title of this post add only a page number? As in Word, page numbers to a header or footer means add, that this simple task run, need to know how they work. Open the header or footer option you can find many information, such as a document name and date to the top or the bottom of your document include. But Word offers also a bare bones page number option, which you can open a header or footer and add only page numbers.

It is a two-step process: go to Insert > page number, and select the page number should be used. This opens either in the header or footer to your document so you can see how the page numbers on the page will look.

Below you will see an option: the page number is at the top of the page and it is right aligned.

screen shot of insert page number option

After you make these decisions, you will see that the header or footer and header & Footer Tools into your document are open. If you want to, you can further changes to the page numbers using these tools.

 Header and Footer Tools in Word

All pages of the document are the number in the same place and are numbered consecutively. To close the header or footer to your document, click Close header and footer to the draft only tab, or double-click the button in the body of the document. If you want to change the position of the page number, click the option page number again.

If you learn as you do different things with page numbers, or the header or footer to add other information, see these articles:

Add or remove headers, footers, and page numbers

Header and footer & page numbers, Oh my!

Insert from page X of y page numbers in only one section

Education: Get control of the page numbers, headers, and footers


View the original article here

Bea's Insurance Agency & Office 365

AppId is over the quota
AppId is over the quota

See why Bea's Insurance Agency, located in East Palestine, Ohio, chose Office 365 to support and grow their business. Bea's Insurance offers commercial, personal auto, home, and life insurance to customers throughout Ohio and western Pennsylvania.


]


View the original article here

Three Power Tips for Reading the Office Blog

AppId is over the quota
AppId is over the quota

This post is written by Craig Kerwien, the Director of Site Management in the Office Division Product Management Group.

Girl reading the Office Blog app on a Windows PhoneWe're all about productivity and getting things done here in the back offices of the Office Blog command center. We've made a few changes to the blog in the past several months that make it super easy to read  and keep up with our latest posts. All you need to know are these three power tips.

Tip# 1:  Use all of Outlook's nifty RSS features

Do you use an RSS reader? Chances are good you already have one - Outlook comes with most editions of Office today (except for Home & Student), and it has a few cool reading features built in:

Share how to add the main feedMove feed shortcut up to favoritesTeach how to find the other RSS feeds so people can plug in or use another reader.Provide feed list

Tip# 2:  Read the Office Blog on your Windows Phone                    

Have a Windows Phone? We just released a quick simple app that you lets scan the latest blog headlines, click a post, and read it on your phone. If you don't have a Windows Phone, then you can just use your favorite RSS reader on your mobile device and plug in any of the RSS feeds shared above.

Creating a Windows Phone App for the blog was a fun little side project for us. We used a simple Windows Phone app toolkit from Microsoft Evangelist Chris Koenig and created it in a weekend. If you'd like to learn more about how we created the app, check out this behind-the-scenes post.

Tip# 3:  Pin Office Blog to your task bar

Do you use IE9 and Windows 7? Then you can pin the Office Blogs to your task bar for an easy way to scan the latest posts or go directly to the Office Blog or Office app home pages. 

-- Craig Kerwien


View the original article here

Q & A: things that you really want to know about Excel if function

image

Today's post is brought to you by Frederique Klitgaard. Frédérique is a writer on Office.com (Note: this is a previously published post we publish again because it answers many.)

On my previous post about the if function, I showed follow-up in which you a very simple application of this formula, I would like to address some questions about how to use this function regularly coming.

The classification is pointed out to me, example isn't the best for the if function, but I think that it still helps illustrate the answers to the following questions.

Yes, you can do this using conditional formatting. I have a conditional formatting rule to distinguish the different results of the formula in the worksheet, a different color for cells that contain specific text.

image

For more information about using conditional formatting see Add, modify, search, or clear conditional formats.

Yes, meet to multiple conditions, you can use the and include and/or or functions, so that you can specify additional criteria, the up in value, whether true or false. If test results are I for testing the entire quarter, I can, for example, the AND function, to determine which completed the quarter with flying colors on the basis of the following formula:

IF(and(B2+E2>=178), "Excellent!", "")

image

Yes, you can text in all arguments to this function, as long as you enclose it in quotation marks. In the examples above, the formulas have returned text-based results, but you can also text in the argument test as . Want to use a star system, in addition to class, can I use, for example, the following formula:

IF (D2 = "A", "**", IF (D2 = "B", "**", IF (D2 = "C", "**", "")))

image

Keep in mind that two of the cells were empty. By adding two quotation marks without text in between (the last argument of this formula), I specify that cells should be empty, if the values are not the criteria. And Yes, I centered the stars after entering the formula just for looks!

Yes, you can include calculations in the formula, do the percentages. Use a point system, I could use such as the following formula:

= IF (B2 > 79, B2 B. 1%, IF (B2 > 89%, B2 ** 5%, ""))

image

Because commas argument in a formula are used as delimiters, be they carefully not to use as the decimal separator in the values that you want to calculate.

For more information on this feature, see our function reference article, If function.


View the original article here

Tool for troubleshooting and other technical resources for Office 365

Small business owners wear many hats. You are responsible for everything, what of the drive of the company to make sure that the printer paper is not running strategic vision. While you are on your own for many of the problems that come in the economy, Office comes 365 with the power of an international community and a simple tool to help meet your demands.

As Office 365 first went into beta testing, we have resources and tips and tricks, simply collect answers to your questions. Below, you can see the full list of resources. The vibrant community that takes on it includes small and medium sized enterprises to understand entrepreneurs, IT people and people here at Microsoft Office 365 products and services inside and out. More help you, we a troubleshooting tool added, which offers a quick way to find solutions.

The good news? Its just a few clicks away from the following technical and support resources:

Troubleshooting tool - answer four simple questions on the issue you have experienced and you are immediately presented with links to possible solutions. Office 365 Community - our community site is full of information from Microsoft and people who use the product every day. This page contains information about product updates and frequently asked questions.Office 365 technical blog - as the name implies, this blog is a great technical resource. Because it is managed by our engineers, you really get responses directly from the source.Office 365 forums & wikis -these pages cover, which pretty much thanks to the simple search function and clear headings you will find everything related to Office 365. information to almost any topic.

This blog is also a resource for you. If there product features you will not find are information, or some where you want only learn more about, send an email or comment me below.

Office 365 Troubleshooting tool


View the original article here

Go beyond the basic chart type

AppId is over the quota
AppId is over the quota

Lots and lots of you want to brush up on your Excel skills by going beyond creating basic charts. How do we know?  Because so many of you click this page. Today, we're moving it back to the top of our home page to make it easier for you to find.

Excel comes with lots of chart types, including column, line, pie, and so on. However, many of you ask how to make other kinds of charts, such as floating column charts, Gantt charts, combination charts, organization charts, flow charts, hierarchy charts, histograms, or Pareto charts.

While none of the charts above are available as predefined chart types, don't worry. There are ways to create them in Excel.

A floating column chart is great for comparing the low and high levels in a value range, represented by the bottom and top of the floating columns, as you can see in this daily blood sugar level ranges chart.

For the chart below, I create a stacked column chart from two data series on the worksheet. The first data series measures to the lowest value of each daily blood sugar range and the second data series measures the actual blood sugar level range that I want to display in the chart. Then I hide the first data series to simulate a floating effect.

This floating column chart shows daily blood sugar level ranges

For more information, see Present your data in a column chart.

I can use the same method to create a Gantt chart that displays the sequence of a few tasks I have scheduled. For this chart, I'll use a stacked bar chart that has two data series. When I hide the first data series, the chart will show floating bars, which is perfect for a Gantt chart.

This Gantt chart uses floating bars to present the 5 tasks in sequence

For more information, see Present your data in a Gantt chart in Excel.

Combination (or combo) charts are also not available in the list of predefined chart types. When I want to emphasize different types of information in a chart, I can use two or more chart types in the same chart. I often combine a column chart with a line chart for an instant visual effect that might make the chart easier to understand. If the data of the different chart types varies a lot, I also use a second vertical axis (the one on the right in the chart below) for the second chart type. This really helps clarify the data that's shown in a combo chart.

This combo chart shows recent home sales

For more information, see Present your data in a combination chart.

Organization, flow, and hierarchy charts are an entirely different animal. There's no easy way to simulate these types of charts by using predefined chart types. Instead, I need to use SmartArt graphics to create them.

This example shows an organization chart

For more information, see Create an organization chart.

Histogram and Pareto charts are column charts that display frequency data, but they are not available as predefined chart types either. To create them, I've used the Histogram tool of the Analysis ToolPak, an Excel add-in program that comes with Excel.

This example shows a histogram

For more information, see Present your data in a histogram.

These are just a few examples that may inspire you to create that "other" chart type. I'd love to hear about any creative ways you have used to present your data in a chart type that simply isn't available in the list of chart types.


View the original article here

Better search in Outlook 2010

A common problem with e-Mail addiction is that they may return too many results. For example by typing someone's name may return matches where appears the name in parts of the body of the message, even though you should search for messages from that person. There may be other criteria to narrow help enter your search how hard, whether it has an attachment or that a certain category has applied. It would not be great, if you simply specify this parameter and get a better results - find what you want, or faster? Outlook 2010 makes it easier!

Outlook 2010 helps your mailbox searching more efficiently with two new features: search search contextual tab in the Ribbon and the suggestion list.

Contextual search tab

Search Contextual Tab

The contextual search tab is displayed every time that you click in the search box. It allows you, your search results with a variety of parameters, including filter:

· The sender name

Subject keywords ·

· Presence of attachments

· Categories

· Sent date

· Flagged messages

· The name of the recipient in the to or CC

· Importance

Read/unread status ·

•... and much more!

You can use this tab so that you can quickly and easily find news. For example, suppose you are looking after a message with the phrase "Food Blog", but more than 100 elements return the search query. Let's assume that you also remind you that this message has an attachment. Now you can limit immediately, to find the results to a much smaller what you seek, by clicking the attachments in the contextual tab set search:

Search Tab Filters

And this is just one of the many filters in search contextual tab available!

Search suggestion list

Search Suggestion List

A combination of keywords, along with the name of the sender or a well-known phrase in the subject line contain the vast majority of the search. Restrict the results to a specific sender is a powerful filter which helps often quickly narrow down results.

If you start a query, you see a list below the search field to Outlook 2010. You can just type and then Arrorw after the search to e-Mail from a person or to a specific topic below limited. The results returned are only those who show a match in the name (or subject) against your query!

This is just a taste of the new powerful search capabilities integrated into Outlook 2010. We hope you enjoy this new experience and that it helps you more productive every time you will need to find a message in your mailbox.

Nelson Siu
Outlook program manager


View the original article here

Interview with Bo Burlingham - author small giant of technology and the development of interaction

Next week the Office 365 be a sponsor for Inc. events GrowCo Conference in New Orleans, La. On Wednesday, 7 March, 1: 40 CST, we delighted to take part in a Twitter interview (on the @ Smallgiantsbuzz;) @ office365 (Ch) with Bo Burlingham, author of the small Giants: companies choose, be great instead of big during the session "Networking with purpose" by the little giant communityplace. We thought it would be a good opportunity to talk with Bo and his take on how technology affects relations between small business owners, customers and colleagues to get. Check out the interview below just remains for more information on what in the business, how technology marching forward.

Office 365 : how see you change the value of the technology network, like people?
Bo Burlingham: Technology has indisputably made it possible, much more networking with a lot more people do, but I don't think it necessarily raised the value of networking at all. Networking the value - online or offline - depends on two things: the quality of connections that make and learn the importance of what. Honestly I don't see a lot of time Twitter wasted on trivial networking via Facebook, etc. I'm skeptical that the connections that learned it can be there and things have nearly the impact on your business or your life as what by networking in person man. Which online networks can do is to opportunities remind you, that you can track offline.

Office 365: How you think the development of technology will affect small businesses in their interactions with customers?
Bo Burlingham: The new tools open opportunities and means of communication which are not of course. But technology changes not the basic dynamics of the business. Great customer service is now, since always and forever about the development of large, close, long-term relationships with customers. Torn businessmen use the new tools of technology, to make that better. Not-so-smart business-people will use to bombard customers with information to which they want neither does not care.

Office 365: how have emerging technologies and interfaces (everything from Twitter to tablets) your readership to reach small business affected you?
Bo Burlingham: Thanks to Facebook, Twitter, LinkedIn, and simple old E-mail, I have much more contact with people who read what I write and say a better feel for its effect than I, 1995 previously. I hear from many people in many different countries, I would have never even given never before. So my earlier answers error examples not. I am a big fan of the new technology. I can not say I help full use of the possibilities offered by it which but it has to touch me more people and help, allows more people, and makes it possible, to touch more people and me.

Office 365: what advice do you have for small business owners to increase their networks or their networks increase in value?
Bo Burlingham: I would advise advice from someone get knows them much more about these technologies and their use as I do. I know just enough to be dangerous. Seth Godin is the person I look for wisdom on this topic. I recommend also Phil Simon book, the new small, so very convincingly, the new technological tools bigger allow small businesses and give them decisive advantages in competition with larger companies.

Sure to follow @ Smallgiantsbuzz and @ office365 Twitter feeds on Wednesday, 7 March for his live Twitter interview at 1: 40 pm CST. Can your own at Bo questions during this time, you will receive an immediate reply and you closed Conference in the powerful discussion instead of Inc GrowCo 2012 are on. You can also use the # growco Hashtag for all kinds of great content and insight from the Conference.


View the original article here

Change the default line spacing in Word

(Note: because so many people continue to questions about, as you change in Word 2010 line spacing, we decided to publish this post.)

If the default line spacing more spacious 1.15 line spacing in Word 2007 and Word 2010 changed slightly in documents from simple line spacing in Word 2003 on a customer asked the inevitable: why change the default line spacing? And how do I change it back?

The short answer is that the standard line spacing in Word 2007 documents more readable changed. You want to change the default line spacing in Word 2007 or Word 2010, or find out the best resources that we have found step by step instructions are here set in a document such as the line spacing.

So that every document that you open a new line spacing your choice set try to learn how to change the default line spacing in Word 2007 or Word 2010 change Word 2007 default line spacing matches earlier versions (these steps also apply to Word 2010).

Change the line spacing in a document , single-spacing, blank lines or other document spacing or change the spacing between paragraphs, check out the article Customize the line spacing between text or paragraphs for Word 2003, Word 2007or Word 2010.

Video to change line spacing,View video: change line spacing in Word 2007 or video: adjust the line spacing in Word 2010.

And if you want more training about the document formatting, including the line and paragraph spacing, try this training: get to know Word 2007 III: make documents look good and create your first word document (Word 2010) II.

For more discussion about specific row also find spacing issues details in the comments for my blog post, fine tune of your line spacing in Word 2010useful. Let us know if you have any further questions.

--Leslie H. Cole


View the original article here

Tip: Elegantere ways to print white lines PowerPoint (video)

This is the fourteenth in a series of quick video tips for executives, with PowerPoint of guest blogger Bruce Gabrielle, author of PowerPoint to speak.

PowerPoint experts share tips presentations to improve with each other, how such as each other.  Presentation Designer Krzysztof Baszton Bruce Gabriel to him more elegant ways to print white lines show contacted in PowerPoint than those, who portrayed Bruce in his previous video.

This tip comes in handy when you realize that the white line in your PowerPoint turn black, if you print the slides.  This video gives you additional options to avoid this problem.  View


View the original article here

Conditional Formatting Rules Simplified

AppId is over the quota
AppId is over the quota

imageThanks to Amit Velingkar for writing this blog post.  (We are re-publishing this post first published in April 2010.  Why? Because so many of you keep searching for it. This is the second in a series of oldies but goodies Excel posts.) 

Conditional formatting is a popular feature and is a great way to easily identify cells with a range that meet some criteria. However, users often want to create conditional formatting rules that go beyond comparing a cell’s value to a single value or a single cell reference - row or column comparisons are commonly requested operations. In this blog post, we will learn how to use relative references in conditional formatting rules to make such tasks easier.

For example, consider the spreadsheet below where we have sales data for different branches of an organization over the years 2005 to 2009:

image

Let’s say we want to highlight the cells where sales have decreased compared to the previous year. By default, conditional formatting inserts an absolute reference when we select another cell as a reference. (ExcellsFun has a great video that explains relative and absolute cell references). When absolute references are used in conditional formatting rules, every cell to which the conditional formatting rule is applied is compared to that single referenced cell.

For complex conditional formatting rules, users often get around that problem by creating lots of individual rules applied to single cells. In our example, we select cell C2 and click on “Conditional Formatting -> Highlight Cell Rules -> Less Than” on the home tab. When the Less Than dialog pops up, we select the cell B2 against which we want to compare. Notice that the value is the dialog gets replaced by an absolute reference to cell B2 ($B$2).

image

To perform column comparisons in this fashion, the user ends up having to create a new rule for each cell and select the neighboring cell for comparison.

image

This small table consists of as many as 20 individual rules - each comparing the cell’s value to its neighbor on the left. Besides being a tedious task (users often automate such tasks by using subroutines), there are other problems with this approach:

- Performance hit: Having lots of individual conditional formatting rules can degrade performance.

- Difficult to Maintain: Such rules are hard to maintain. Besides having to edit multiple rules for any changes, the rules won’t adjust if you insert a new row or column.

There is an easier way to do this by using just one Conditional Formatting Rule applied to the entire range. To do this, select the entire range of cells to which you want to apply the rule (in our example: C2:F6) and click on “Conditional Formatting -> Highlight Cell Rules -> Less Than” on the home tab. When the Less Than dialog pops up, we again select the cell B2 to get an absolute reference ($B$2). However, this time we use change the reference to be a relative reference (B2).

TIP: you can use the F4 key to cycle through different types of relative references until you get B2 without the $ signs.

And there you have it; we have just one Conditional Formatting rules where every cell’s value is compared. We get exactly, the same result as before. And there’s more, the rules automatically adjust to if new rows are added in the middle of this range. For example, let us add information about a new branch in Boston.

image

image

In conditional formatting rules, cell references are relative to the top-left most cell in the Applies to range. To simplify things, I like to pretend as if I have only selected the top-left most cell and I am writing a formula in that particular cell. In our case, the top-left cell C2 was compared against the cell to its left (B2). Hence, all the other cells in the range were compared with the cell to their left.

The diagrams below are examples of how to setup two commonly used CF rules – row and column comparisons. The cells with blue borders indicate the range to which this CF rule is applied, the bold blue border is used to illustrate the top-left most cell in the CF range and the red border shows the cell referenced by the CF formula. The black arrow indicates the direct relationship between the top-left cell and the cell reference, while the gray arrows indicate the implied relationships that are formed as a result.


imageimage

You can always verify this by using the Conditional Formatting Rules Manager (select any cell within this range and clicking on the “Conditional Formatting -> Manage Rules” on the home tab) as shown below:

image

Also, you can toggle between the different types of relative references to compare against a particular column or a particular row. Relative references can also be used inside formulas to create complex Conditional Formatting rules.

Anytime you need to conditional formatting using complex cell comparisons, consider using relative references to make things easier. Remember, rules are relative to the top-left most cell in the Applies To range. I would love to hear more feedback on Conditional Formatting and ideas that you might have for future versions of Excel.


View the original article here

Office 911: Help for hard-core gamers (video)

AppId is over the quota
AppId is over the quota

DUDE'S!....

"And your QUEST is to help Clippy get back through time".

Say WHAT ?!

NO, NO, SAY it isn't true!  Don't bring Clippy back from oblivion into Office 2010, nooooooooo!!  ;-)

A /little/ more serious here..  You guys are cruel ;-)  Once this guy realizes what a menance Clippy actually was he'll wish he'd never have tried to help the nuisance ;-)

SO well, I didn't enjoy this ep. as much as the previous one but your acting is pretty good (and still silly) IMO :-)

"Y2 WHAT?!"  :-))

Can't wait for that one, I can see it now...  "No, unfortunately Office 2010 is NOT Y2K compliant and as such will not run after purchasing it. IN order to do that you'd need to change the date on your computer and turn the year back to 1998.  The good ole Windows 98 years, just don't connect an USB scanner just in case ;-)".

Sorry, sorry, maybe a little bad humor but still ;-)

More seriously; what helped for me so far with Office 2010 was either setting a goal and simply trying to reach it (template in Word 2010 which would be able to make me a letter, quote or bill for example) OR to use a program for something /completely/ different than it was designed for and have some fun!

I learned most of my current PowerPoint skills by trying to make up an "Evangelion" cartoon (Anime series). You know; new dia, add picture, remove background, place picture, animate stuff, add 'caption' shapes, etc. I even added some sound effects and such.

All play, nothing serious, but in the end you /will/ end up with a lot of experience which you can use for some real work!


View the original article here

ruby – types

ruby – types « dustWorld function clearSearch() {document.search_form.s.value = "";} adobe.com      dustWorld / ruby – typesby Yao Zhang  

View the original article here

Monday, March 12, 2012

Lightroom 4 video tutorials

Lightroom 4 video tutorials « Phosphors function clearSearch() {document.search_form.s.value = "";} .recentcomments a{display:inline !important;padding:0 !important;margin:0 !important;}.avatar {vertical-align:middle}.credit {font-size: 50%;}adobe.com      Phosphors / Lightroom 4 video tutorialsby Michael Salinero  

View the original article here

Adobe VP Aseem Chandra talks Adobe Summit on Twitter

Sorry, I could not read the content fromt this page.

View the original article here

mysql – CJK char set

mysql – CJK char set « dustWorld function clearSearch() {document.search_form.s.value = "";} adobe.com      dustWorld / mysql – CJK char setby Yao Zhang  

View the original article here

CQ 5.4: how to export the user list as a CSV file

CQ 5.4: how to export the user list as a CSV file « Adobe enterprise product blog – David McMahon function clearSearch() {document.search_form.s.value = "";} .recentcomments a{display:inline !important;padding:0 !important;margin:0 !important;}adobe.com      Adobe enterprise product blog – David McMahon / CQ 5.4: how to export the user list as a CSV fileby dmcmahoncsv (1)export (1)report (1)reporting (1)user (6)  

View the original article here

ruby – symbol

ruby – symbol « dustWorld function clearSearch() {document.search_form.s.value = "";} adobe.com      dustWorld / ruby – symbolby Yao Zhang  

View the original article here

ADPS Single Edition発表

ADPS Single Edition?? « ??????? function clearSearch() {document.search_form.s.value = "";} .recentcomments a{display:inline !important;padding:0 !important;margin:0 !important;}adobe.com      ??????? / ADPS Single Edition??by Takashi Iwamoto  

View the original article here

And the winners are…

February 23, 2012

If you missed watching Dr. Allen Partridge on yesterday’s episode of eLearn Chat, then you definitely missed the names of the winners of Adobe Captivate HTML5 Contest.

So, especially for you, here are the names of the winners re-announced :)

We had three winners for this contest, who will be getting an iPad each:

Iesha Sharma – The Beauty of J&K (1741 likes)Michael Hinze – Mobile Phone User Guide (1672 likes)Ravi Kumar T – Seven Wonders of the Worlds (1505 likes)

Congratulations to the winners!!! :)


View the original article here

Quiz Reports in Course Companion for Adobe Captivate

February 20, 2012

I hope many of you have already tried the course companion by now and have taken a look at the Dashboard. In my previous blog, I explained the concept of Progress Index. In this blog, I will explain the Quiz reports that you can access by clicking the Quiz tab on the Dashboard. Quiz reports provide insight in to how learners are performing in the quiz included in a course.

With the quiz reports you can analyze the learners’ performance in quiz and find out:

The questions which many learners are skipping or answering incorrectly. This metric gives you a hint about the topics in the content which people haven’t really understood well.The average quiz score. This metric is an indicator of overall performance of the course. A high average quiz score generally indicates that the course has been received or understood well by the learners.The ‘differentiator’ questions — the questions that differentiate top performers from average performers.Overall summary of quiz performance such as number of learners who have scored below the average quiz score, number of learners failing the quiz etc

Question details graph

This graph shows how learners have performed in each of the questions. Each question is represented by a bar in the graph. For each question, the graph shows how many learners have answered it correctly (green part of the bar), how many answered it wrongly (red part of the bar) and how many skipped it (black part of the bar). You may hover on each of the question bar to see the exact number of learners who skipped the question or answered it correctly or wrongly.
Just adjacent to the graph,you can see two pie charts on Quiz Status and Question Status. Quiz status graph shows the percentage of learners who have:
• Passed the quiz (green part of the pie),
• Failed the quiz (red part of the pie)
• Not attempted the quiz (black part of the pie).
Question status graph shows the above details for every question that you select in the Question Details graph. i.
Hover on each part of the pie chart to see the exact percentage numbers.

Learner List graph

The learner list shows a list of all the learners who have taken this course. Each learner is represented by a bar, and the learners are sorted in ascending order of their quiz scores. A failed learner is represented by red bar and a passed one by green bar.
You can increase or decrease the number of learners visible in this graph using the “No of Learners” slider above the graph. If you select any learner in this graph, the question details graph will reflect the quiz performance of the selected learner alone. Hover on each bar to get some more information such as quiz score, number of sittings etc.

Quiz Summary

This report shows a summary of the quiz. The summary includes Average quiz score, learners with below average score, question with maximum correct answer etc.

You can download and read more about the Course companion for Adobe Captivate at http://labs.adobe.com/technologies/captivate_course/


View the original article here