This tutorial on using conditional formatting to highlight dates is brought to us by MVP Frédéric Le Guen, with special acknowledgment and thanks to Ken Puls for assistance with translation from French to English.
Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. The NOW function, which calculates values based on the current date and time, is a great example of this.
Taking this functionality a step further, when you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near or differentiates between types of days, like weekends and weekdays.
THE BASICS OF CONDITIONAL FORMATTING FOR DATES
To find conditional formatting for dates, go to
Home > Conditional Formatting > Highlight Cell Rules > A Date Occuring.
www.office.com/setup
You can select the following date options, ranging from yesterday to next month:
www.office.com/setup
These 10 date options generate rules based on the current date. If you need to create rules for other dates (e.g., greater than a month from the current date), you can create your own new rule.
Below are step-by-step instructions for a few of my favorite conditional formats for dates.
HIGHLIGHTING WEEKENDS
When you design an automated calendar you don't need to color the weekends yourself. With the conditional formatting tool, you can automatically change the colors of weekends by basing the format on the WEEKDAY function. Assume that you have the date table-a calendar without conditional formatting:
www.office.com/setup
To change the color of the weekends, open the menu Conditional Formatting > New Rule
www.office.com/setup
In the next dialog box, select the menu Use a formula to determine which cell to format.
www.office.com/setup
In the text box Format values where this formula is true, enter the following WEEKDAY formula to determ
A since deceased, highly-regarded fellow faculty member, Anthony (Tony) Athos, occasionally sat on a bench on a nice day at the Harvard Business School, apparently staring off into space. When asked what he was doing, ever the iconoclast, he would say, "Nothing." His colleagues, trained to admire and teach action, would walk away shaking their heads and asking each other, "Is he alright?" It is perhaps no coincidence that Tony often came up with some of the most profound insights at faculty meetings and informal gatherings.
This story captures much of the sense of the responses to this month's question about why managers don't think deeply. The list of causes was much longer than the list of proposed responses. But in the process, some other questions were posed.
Ben Kirk kicked off the list of reasons for the phenomenon when he commented, "… what rises to the top levels are very productive and very diligent individuals who tend not to … reflect and are extremely efficient at deploying other people's ideas," implying that this type of leader is not likely to understand, encourage, or recognize deep thinking in others.
Adnan Younis added the possibility that "… managers are not trained for it." Dianne Jacobs cited the possibility that persisting assumptions borne out of success serve as "roadblocks to act on needed change" (proposed by those who engage in deep thinking?).
Ulysses U. Pardey, whose comment triggered my recollection of Tony Athos, wrote that "Time-for-thinking is a special moment which can be resource consuming and an unsafe activity …" (Fortunately, Athos held a tenured position in an academic organization.)
A number of comments alluded to the triumph of bureaucracies and large organizations over deep thinking. As Lorre Zuppan said, "I think Jeff Immelt's efforts to protect deep thinking reflect a nice sentiment but … If his team could carry the ball, would he need to announce that he's protecting it?" Tom Henkel was more succinct: "Ther
"Your wallet and your phone are probably the two items you carry around with you the most. What if you can combine the two together and carry just one item?
Now you can with the new Q Card Case for the iPhone 5 by CM4.
The Q Card Case is a 2-in-1 device that functions both as a protective casing for your iPhone5 as well as a wallet.
It has space to comfortably fit 3 credit card sized cards plus cash. The case is made from a special patent pending soft-touch rubber and premium fabric. It also has a cut out slots for quick access to the cards as well for accessing all the buttons on your iPhone.
It even has a big cut out at the bottom of the case to allow for in-case charging as well as fully compatible with Apple's Lightning port to 30-pin port adapter.
The Q Card Case is available in 4 colors - Black Onyx, Mahogany Brown, Pacific Green and Red Rouge."
By-The Xpert Crew @ http://techvedic.comhttps://www.facebook.com/techvedicinchttps://twitter.com/techvedicinchttp://pinterest.com/techvedic1http://techvedicinc.tumblr.com/https://plus.google.com/u/0/110467075169904075419/
While it becomes impossible to live without your iPhone 4S, you must be a bit worried about the habit of the gadget eating up all the battery at inopportune times.there are still some vital tips and tricks you can follow to improve your Smartphones battery life.
Low Down The Screen Brightness
Just as it goes for your laptop devices, you need to lower down the brightness of your iPhone screen, which will enhance the battery life. Adjust the screen brightness under the Settings tab.
Make Use of Wi-Fi When You Can
Instead of making Voice calls, downloading apps or browsing the Web over your iPhone 3G or cellular connection, it is recommended to always find a Wifi hotspot or make use of your home network. This will help you keep away not only from data charges but also will aid you have a better battery life as your device will not be searching for the data signals. Remember, if you are in an area where there is no Wi-Fi hotspot, it is better to turn off the search and it will help save the battery life of your iPhone 4S.
Do Not Use The GPS Tracking Feature
If you are using apps that support the feature of Automatic GPS tagging and location such as Twitter, Instagram and Facebook, your iPhone is working overtime to determine your location. If you do not want to be Geo-tag your updates and posts, must keep the GPS function off.
Do Not Use The 'Fetch' & 'Push' feature
If you have your iPhone 4S set to 'fetch' the data after every 30 minutes time along with numerous apps to push new alerts and messages as they happen, then you need to turn off this feature on your device. This feature is going to drain your battery. Only use the facility when you really need it otherwise keep it off.
Keep Your Notifications In Check
To enhance your iPhone 4S battery time, you need to limit your app notifications to just the apps you make use of more often. This actually means that you have to say 'no' to the requests for all kinds of notifications you ge
Join Raptivity for a 60 minutes session with Jay Cross, the Guru of Informal Learning, on April 30, 2013 at 11:00 am PDT to see how you can make learning stick in your learners' minds using a variety of innovative techniques.
To help the learner remember and recall the learning material. Raptivity had organized a special webinar titled 'Making Learning Stick!' on Apr 30, 2013 with Jay Cross, CEO and Chief Unlearning Officer, Internet Time Alliance as the guest speaker.
You can access and share Office documents with browser-based versions of Word, PowerPoint, Excel, and OneNote. Learn some of the basics and the latest features of these free tools.
Note: Office Online was formerly known as Office Web Apps.
There is an updated webinar about Office Online at http://aka.ms/online123.
Can't see this video? It's also available at Microsoft Showcase? Need a sneak peek? Here's a 30-second trailer.
What you will learn at Tuesday's webinar
Yes, Office Online is different than Office 365
Storing docs with OneDrive
New features customers asked for
Working on a doc with someone else at the same time
References for this webinar
Office Web Apps:
Office Online Home Page
Get started with Office Online (how-to & video)
Edit documents in OneDrive (how-to)
Sign-in no longer required to edit Office docs in OneDrive (blog post)
4 new ways to edit Office documents in your browser (blog post)
Co-authoring: Two dudes share a spreadsheet (video)
SkyDrive:
OneDrive Home Page
Sign into OneDrive
Share Office documents stored on OneDrive
OneDrive tips including Fetch
NEW! Download free Office Webinar Apps: Windows 8 App and the Windows Phone 8 App.
Go to http://aka.ms/offweb to join us live every Tuesday for an Office Webinar and a Q&A session.
-Doug Thomas
Remember the vintage game "Pull the Rug Out?" It is a board game where players stack different items on top of a rug. Eventually, one of the players tries to pull out the rug without tumbling the pieces stacked on top of it.
Google's recent announcement that it is phasing out several additional services, including the highly popular Google Reader, reminded me of this game, as I recall that the stack most always toppled to the ground. Google introduced Google Reader, gradually built up its popularity, and then pulled the rug out with little warning, causing its customers to stumble. As one Google customer put it: "Google spends millions of wasted dollars on pet projects, then kills one of their best products on a whim."
Google's most recent spring cleaning brings the total number of services it has discontinued to 70 in just a year-and-a-half. That's right-a whopping 70 services that have been shut down in just 18 months.
Among the services Google will discontinue with little warning is Google Cloud Connect, introduced with a lot of fanfare just two years ago. Cloud Connect is a plug-in that enables Google users to share and edit Microsoft Word, PowerPoint and Excel files. To continue collaborating with Microsoft Office, Google users have just four weeks to uninstall Cloud Connect and install Google Drive. Companies that can't get to it by April 30 will be out of luck, leaving them without a way to collaborate on Office documents used by millions of employees, partners, and customers.
But of all the services Google is discontinuing this time, the one that's drawing the biggest backlash is Google Reader, a service used by hundreds of thousands of users to keep track of their favorite websites and blogs via RSS feeds.
The news of Google Reader's shut down drew outrage from users, who put together a petition demanding that Google reinstate the service. "Our confidence in Google's other products - Gmail, YouTube, and yes, even Plus - requ
Meeting notes, vacation plans, grocery lists, great quotes, notes to self-let me count the ways to use OneNote. Consolidate all of your crucial information chunks and snippets in one place, then link with OneDrive to share this virtual notebook with yourself (roaming), with other people (collaboration), and with other devices (OneNote ecosystem).
Can't view this video? It's also on Microsoft Showcase. Need a peek? Here's a 30-second trailer.
Note SkyDrive is now OneDrive, and SkyDrive Pro is now OneDrive for Business. Read more about this change at From SkyDrive to OneDrive.
What you will learn at Tuesday's webinar
Using OneNote for your next household project
Ways to share OneNote meeting notes
Share with OneNote, even if you don't have it
OneNote for Android, iPhone, iPad.
References for this webinar
Share your notebook (video)
Share notes with other people (how-to)
Work together on a shared notebook (OneNote 2010 training course)
Share notes in a meeting (how-to)
Plan a trip with others (video)
OneNote keyboard shortcuts (2010) and (2013)
OneNote mobile apps
Go to http://aka.ms/offweb for more information on how to join the series.
-Doug Thomas
WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION
www.office.com/setup Blogs: By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells.
Optional: Download our practice workbook.
Watch the video below to learn more about modifying columns, rows, and cells.
TO MODIFY COLUMN WIDTH:
In our example below, column C is too narrow to display all of the content in these cells. We can make all of this content visible by changing the width of column C.
Position the mouse over the column line in the column heading so the cursor becomes a double arrow.
positioning the mouse over the column line - www.office.com/setup
Click and drag the mouse to increase or decrease the column width.
increasing the column width - www.office.com/setup
Release the mouse. The column width will be changed.
the resized column - www.office.com/setup
With numerical data, the cell will display pound signs (#######) if the column is too narrow. Simply increase the column width to make the data visible.
TO AUTOFIT COLUMN WIDTH:
The AutoFit feature will allow you to set a column's width to fit its content automatically.
Position the mouse over the column line in the column heading so the cursor becomes a double arrow.
autofitting the column width - www.office.com/setup
Double-click the mouse. The column width will be changed automatically to fit the content.
the autofit column width - www.office.com/setup
You can also AutoFit the width for several columns at the same time. Simply select the columns you want to AutoFit, then select the AutoFit Column Width command from the Format drop-down menu on the Home tab. This method can also be used for row height.
autofitting column width for multiple columns - www.office.com/setup
TO MODIFY ROW HEIGHT:
Position the cursor over the row line so the cursor becomes a double arrow.
hovering over a <a href=row line - www.of
www.office.com/setup Blogs: Today marks the general availability of Office 2016 for Windows, a suite of desktop applications that together with new mobile and web apps pushes Microsoft's new vision for PC-based productivity. Office 2016 is available immediately to Office 365 subscribers, as well as to individuals who would prefer to buy the software in standalone form.
"We see Office 2016 as being just as important as the first release of Office," Microsoft group program manager Shawn Villaron told me in a briefing last week. "In the early days, Office was about bringing really important tools together to empower the individual for personal productivity. That was the way people wanted to work at that time. And for 20 to 30 years, Office fit right in. Today, things are changing. More people collaborate on work as groups and teams, so Office 2016 represents the change from personal productivity to team productivity."
And that, really, is Office 2016 in a nutshell. If you're a typical information worker, student, or other person in need of standard productivity tools, Office 2016 of course works fine and represents an obvious and stable evolution from the Office version you're currently using. But the real meat in this release-now and going forward, as Office will of course be updated regularly, like Windows 10-is the designed around this new way of working.
Confusing matters somewhat, Office-not Office 2016, but Office generally-is all over the place now. In addition to the classic, full-featured desktop suites on both Windows and Mac, Microsoft has high-quality Office Online web apps, mobile apps for Android, iOS, and Windows/Windows phones-and Office 365-specific solutions that are often available as web apps but are sometimes just integrated into the desktop applications. This ain't your father's Office anymore.
Office everywhere: Microsoft Office is available on virtually any device you care to use. - www.office.com/setup
Office eve
www.office.com/setup Blogs: Excel 2016 includes a powerful new set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.
Today, we are pleased to announce 10 new data transformation and connectivity features that have been requested by customers.
These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can take advantage of these updates by downloading the latest Power Query for Excel add-in.
Updates include the following new or improved data connectivity and transformation features:
Web Connector-UX support for specifying HTTP Request Headers.
OData Connector-support for "Select Related Tables" option.
Oracle Connector-improved Navigator preview performance.
SAP HANA Connector-enhancements to parameter input UX.
Query Dependencies view from Query Editor.
Query Editor ribbon support for scalar values.
Add custom column based on function invocation.
Expand & Aggregate columns provide support for "Load More" values.
Convert table column to a list-new transformation.
Select as you type in drop-down menus.
WEB CONNECTOR-UX SUPPORT FOR SPECIFYING HTTP REQUEST HEADERS
With this update, we have added support for specifying HTTP Request Headers within the Web connector dialog. Users can specify header name/value pairs from the Advanced mode in this dialog.
november-2016-updates-for-get-transform-in-excel-1 - www.office.com/setup
ODATA CONNECTOR-SUPPORT FOR "SELECT RELATED TABLES" OPTION
In this update, we have added relationship detection support for OData V4 feeds. When connecting to OData V4 feeds, users will be able to use the Select Related Tables button in the Navigator dialog to help you easily select all the tables needed for your reports.
november-2016-updates-for-get-
Find list of Top 47 eLearning & Workplace Learning Blogs (in alphabetical order) that Upside Learning team follows.
1. Adventures in Corporate Education
2. Bersin & Associates : Blogs
3. Big Dog, Little Dog
4. Blogger in Middle-earth
5. Bozarthzone
6. Clark Aldrich On Simulations and Serious Games
7. Clive on Learning
8. Connectivism
9. Daretoshare
10. Dave's Whiteboard
11. Donald Clark Plan B
12. eLearning Blog // Don't Waste Your Time…
13. e-Clippings (Learning As Art)
14. E-Learning Curve Blog
15. eLearning in the Corporate Sector
16. eLearning Technology
17. eLearning Weekly
18. elearningpost
19. elearnspace
20. Engaged Learning
21. Experiencing E-Learning
22. Harold Jarche
23. ID and Other Reflections
24. In the Middle of the Curve
25. Informal Learning Blog
26. Internet Time Blog
27. Jane's E-Learning Pick of the Day
28. Kapp Notes
29. Learn and Lead
30. Learning Conversations
31. Learning TRENDS
32. Learning Visions
33. Learnlets
34. Making Change - Ideas for Lively eLearning
35. Mobile Learning
36. Nigel Paine
37. Stephen's Web
38. T+D Blog
39. Take An E-Learning Break
40. The Bamboo Project Blog
41. The eLearning Coach
42. The Learning Circuits Blog
43. The Rapid eLearning Blog
44. The Upside Learning Solutions Blog
45. TogetherLearn
46. Will at Work Learning
47. Workplace Learning Today