Ads

Showing posts with label ms. Show all posts
Showing posts with label ms. Show all posts

Excel Formulae: Letters In Sequence : A, B, C.....


I would like to create a column with letters from alphabet in a sequence.
If I write A and in cell below I put B then highlight the two cells and drag down I get a repetition of A and B.

How do I get the following alphabet letters ie. C,D, E etc.?

If you type the first letter into first cell (say A1), then below:
=CHAR(CODE(LEFT(A1,1))+1)


copy down ...
note once you get beyond Z you will get odd results, do you plan to go beyond Z and if so what should succeed Z ... if it is AA you can revert to an ADDRESS approach.
 
For example:
Say first letter was always A and was to start in A1:
=SUBSTITUTE(ADDRESS(1,ROWS(A$1:A1),2),"$1","")


copy down as far as required --
27th entry would become AA, 28th AB etc...
-->

T8ZU3RT4ER6Z

10 hidden features in Windows 8 - short and crisp!

1. Windows Store

Microsoft enters the lucrative app market, no surprise here. While "Windows Store" (which is the company's name for the online app shop) obviously doesn't work in this early build, the related DLLs and XML resources are already in place and ready to be examined by a variety of tools, such as PE Explorer or Resource Hacker. 



All the basic features of any app store are also present in Windows Store -- such as the ability to browse through categories, make in-app purchases, rate apps, download trials and so forth. New, however, is the ability to "stream" apps to your PC, which could lead to a couple of scenarios: 1) an app could be launched instantly after the purchase -- no need to wait until it is fully downloaded; 2) apps could be hosted in the cloud so that users stream only the part of the app they need at any given moment. That would be convenient for someone who'd like a larger product, say an Office suite, on a tablet with limited disk space, or who'd like to access the app from another machine.

Windows 8 collects all apps in its own "Application Explorer" and categorizes each app as either an "Immersive" or a traditional "Desktop" application (see below for more on that):


2. Two-class society

Windows 8 will come in two separate interfaces flavors -- one traditional UI that resembles Windows 7's Aero and one touch-friendly UI specifically tailored to tablets dubbed "Immersive UI". The latter isn't fully implemented (or is too well hidden) in the early Milestone build, yet some specific tablet applications have already been unlocked:

Internet Explorer Immersive: A touch-centric version of Microsoft's IE browser that includes just an address bar (which auto-hides), a browser history and a tabbed view.


Modern Reader: Microsoft's own implementation of a (basic) PDF viewer that has only bare navigation and bookmarking support. (Still, Adobe likely won't be too happy about this.)

System Settings: A touch-optimized "Control Panel" that caters to mobile needs, such as connectivity, time zone settings or device management.

 
These few tablet apps are literally the tip of the iceberg -- the entire UI has yet to be revealed. While digging through Windows 8's various files, I found hints suggesting that users will be able to switch between the traditional Windows 8 UI and the tablet UI, through what's codenamed the "UIPicker". Also, we've found traces of a "Dock" that is supposed to hold built-in Windows features (such as a search box) and 3rd party apps.


3. Boot in under 20 seconds?

Windows 8 sports a new Hybrid Boot mode which drastically reduces (cold) boot time and will most likely be the default boot option going forward. In essence, it's a combination of "Log Off" and "Hibernate" -- the moment users click on the shutdown button, Windows closes all running applications, logs off and then goes into hibernation mode. Instead of booting up regularly, which usually involves loading hundreds of files and initializing services, drivers and so forth, Windows 8 simply loads the single hibernation file into memory and presents you with the log on screen. I've bench-marked the results on two machines and came away impressed:
However, Hybrid Boot works only if users actually shut down their machines. If a user restarts his or her machine, it boots up cold.
 
4. Automatic Maintenance

Microsoft puts a heavy emphasis on optimizing and increasing overall stability of Windows 8: A new "Automatic Maintenance" regularly checks for solutions to problems (via Windows Error Report), runs the .NET Optimization Service and defrags all hard disks automatically -- all of this happens while the PC is on idle, of course.

5. Disk Defragmenter
Speaking of defragmentation, the new Disk Defragmenter is finally capable of handling SSD drives and allows users to perform the TRIM command much easier than in Windows 7. 
 

In addition, I've found a new Windows service called "Spot Verifier". According to its descriptions and its related DLL files, it checks for bad sectors in real-time and marks them as "bad" in order to avoid data loss or damage. I've also dug up traces of some underlying file system changes that I couldn't quite make sense of, such as an entirely new file system driver called "NT Protogon FS driver", which looks like a kernel mode driver for some sort of (yet unknown) file system called Protogon. It's unclear, whether this is a major new file system or just some minor subsystem.
 
6. Performance boost

In the performance department, Microsoft has also made some serious improvements: After four weeks of productive use (and even putting it under the load of dozens of applications), Windows 8 somehow manages to perform snappier than an identically configured Windows 7 installation. The log on/off process, launching applications, doing heavy multitasking and performing day-to-day tasks is just a tad quicker -- Microsoft managed to reduce any delay there was and improve responsiveness.
 

7. Usability goal: Click reduction

Neither the traditional nor the classic Windows UI are anywhere near finished. Yet, Microsoft's usability department is busy simplifying the user interface and reducing overall complexity.

For example, once you connect to a public Wi-Fi, Windows 8 offers a new dialog to enter the user name and password to get online access:


 

Windows 7 users would need to connect to the Wi-Fi, open up a browser and then wait for the online provider's landing page to pop up.
 
8. Windows Explorer

Windows Explorer is the next tool that received (quite) a UI overhaul and a perfect example of where Microsoft reduces the steps necessary to perform tasks: Like it or not, Windows 8 is likely to come with a ribbonized version of Windows Explorer, as first revealed by Windows experts Paul Thurott and Rafael Rivera. While actually working with this explorer for a couple of weeks we have to admit that, despite its hideous look, it's absolutely wonderful to work with. Day-to-day file tasks are simpler and the ribbon adapts to the file contents (for example, "Music Tools" below). 


 

9. ISO mounting

Additionally, Windows 8 sports its own ISO mounting tool, thus eliminating the need to go and download 3rd party tools, which are often riddled with annoying toolbars and ads.


10: Windows Time Machine

Last but not least, Microsoft finally managed to give its "Restore Previous Versions" (Volume Shadow Copy) feature a usable and intuitive interface: History Vault lets you go back in time and restore earlier versions of a folder – just in case you accidentally made some unwanted changes or deleted some of its contents, which is pretty similar to Apples Time Machine in Mac OS X.


 

This is the kind of stuff they'll make all the usability fanatics go wild: Technology that has been there before, but which is (for the first time ever) actually easy to use and accessible to beginners.
More to come?

Windows 8 won't be available next year, but even this early build looks promising and we believe there is still tons of hidden stuff to be discovered. We'll keep you posted on our findings.

Source

Get started with PivotTable reports in Excel 2007


Your worksheet has lots of data, but do you know what the numbers mean? Does your data answer all your questions? PivotTable reports can help to analyze numerical data and answer questions about it.





 

In seconds you can see who sold the most, and where. See which quarters were the most profitable, and which product sold best. Ask questions, see the answers.

With PivotTable reports, you can look at the same information in different ways with just a few mouse clicks. Data swings into place, answering questions, telling you what the data means.

In this short course you'll learn how PivotTable reports work and you'll make a PivotTable report in Excel 2007.


Make sense out of data.
Learn about Microsoft Office Excel 2007 PivotTable reports, a fast and powerful way to analyze data and answer questions you have about it.

About this course
This course includes:

    1) One self-paced lesson and one practice session for hands-on experience. The practice session does not require you to have Excel 2007 on your computer.
    2) A short test at the end of the lesson; tests are not scored.
    3) A Quick Reference Card you can take away from the course.

Goals
After completing this course you will be able to:

    1) Use a PivotTable report to analyze and summarize your data.

Level: Intermediate
Length: 40 - 50 minutes

MS Office 2007

How to reveal hidden tab in Word 2007
Posted in Spreadsheet tips.


In the default view mode of Word 2007, there are seven tabs presence. Tabs showed in the Ribbon are Home, Insert, Page layout, References, Mailings, Review and View.





A hidden tab could be revealed through excel options. What are in the hidden tab?


The hidden tab contains commands related to developer services called Developer.



This tab consist of five group commands: code, controls, xml, protect and templates. In the code group, it placed visual basic command to launch visual basic editor. A command to view macro list provided in this group as well as record macro command.
See the image for more details.


Protect document command allows user to set a password of current document. The password will restrict people from making certain manipulation.


The developer tab not only presence in Excel, but it can be revealed in Word and PowerPoint also. In Excel, Developer tab has only three command groups, without Document template command.





While in PowerPoint shows two command groups: code and controls.





 Step to show developer tab:





































• Goto office tab button and choose word options or excel options at the bottom.
• A panel appears with different options to choose from.
• Check the option Shows developer tab in the Ribbon

When you activate this tab in one MS Office application, it gets visible in all the others. For ex. if you activate  this tab on Word, then on PPT and Excel too this tab gets visibility.