MS Excel Tips - Copy Print Settings Across Multiple Worksheets

Many of the print settings available in Excel are by default specific to an individual work sheet. These settings include orientation, margins, headers and footers. These types of settings are specified in the Page Layout Tab - Page Set Up group.

This can create flexibility in your Excel work book presentations, for example you can have your first sheet in landscape with a margin of 10 centimeters and your second sheet in portrait with a margin of 5 centimeters with no need to reset any settings between the worksheets.

It is important to note that any new work sheets that are added to the work book will take default the Excel settings. If you are adding sheets to your work books that require specific settings of margins, headers, footers and orientation then manually changing each new work sheet as it is added can be time consuming and difficult to get everything exactly matching.

With a few clicks though you can easily and quickly copy your page set up settings across multiple work sheets as well as impressing your colleagues!

First, get your first page exactly as your want it with your headers, footers, orientation and margins perfectly placed to your requirements by using the Page Layout Tab.

• Activate the first sheet, i.e the sheet that contains your required settings. This becomes your reference or source sheet.
• Select all of your other work sheets in the work book. The have now become the targets sheets.
• Use the CTRL+ click to select the sheets your and your targets for the settings.
• In Excel 2007 onwards use Page Layout Tab - Page Set Up Group.
• Hit the dialog box launcher.
• Once opened hit OK to close the dialog box.

You will notice that the sheets now are grouped together, you can see this status on the top of the work book in the title bar, it will be displayed as [Group]. Your sheets now need to to be ungrouped.

Right click on any of the grouped sheets and a short menu will appear. Select the ungroup option to ungroup your work sheets. That is all there is to it. The settings from the original or source sheet will now be copied over to your target work sheets.

This really does take the hassle out of formatting individual sheets allowing you to quickly apply uniform page set up and formatting to all of your work book sheets.

Want more Excel Tips and Tricks? Look no further! BJ Johnston has been an advanced Excel user for 15 years and is the creator of http://www.howtoexcelatexcel.com a site that shares Excel tips and tricks with it's enthusiastic members. Join in the discussion, where users are working smarter and faster with Excel and don't forget to sign up for a FREE newsletter and as a bonus receive a FREE eBook - 50 Top Tips and Tricks.

Article Source: http://EzineArticles.com/?expert=BJ_Johnston

Article Source: http://EzineArticles.com/6793637

Advantages of Active Directory Monitoring

It has been considerably observed that in order to smoothly run all the administrative tasks, there is a great need of Active Directory. To drive all administrative tasks efficiently and to execute the organization's behavioral as well as operational activities, Active Directory plays a vital role. Active Directory is the directory service included with Windows servers and provides the methodology to manage the identities and relationships that make up the network environment. As the AD affects the whole network and draws impact on the productivity of an organization, it is mandatory to regularly monitor the AD. The monitoring process also helps in detecting and resolving any kind of potential network problem before they arise, so that users can have fluent access to their critical services.

Features

AD Monitoring - Monitor Active Directory System Performance

This tool helps in monitoring the performance of CPU and other computer peripherals; it also ensures the utilization of computer resources like memory and disk space. Operators can achieve both real time and historical statistics for CPU, memory and disk space utilization. Using customizable thresholds, operators can be notified well in advance and thereby proactively prevent outages before they occur. User can also view the number of processes that are currently active on the system.

AD Monitoring - Monitor Critical Processes & Counters

Active Directory monitors the usage of critical LSASS & NTFRS processes. The parameters which are monitored include CPU usage, physical RAM, file reads, file writes, cache hits, etc. You can also monitor critical network counters like Connected Users, LDAP Client Sessions, & LDAP Bind Time as well as performance counters like NTLM Authentication, Kerberos Authentication & LDAP Searches.

Benefits

There are several benefits of AD monitoring which primarily include the following:

Ensures agent less monitoring

Capable of detecting AD problems quickly

Locates the exact failure

Real time alerting - proactive response for problems impacting Active Directory service

Minimize AD downtime

Provides you information about the health of your Directory Server

The Active Directory monitoring helps in controlling the performance and availability of the server around the network. Active Directory depends on certain critical services for proper operation. The first step in ensuring AD availability is to monitor these critical services.

This tool monitors the following critical services

Server Service that enables the computer to connect to other computers on the network based on the SMB protocol.

File Replication Service that maintains file synchronization of file directory contents among multiple servers.

DNS Client service that resolves and caches DNS names.

Security Accounts Manager Service that signals other services that the Security Accounts Manager subsystem is ready to accept requests.

Intersite Messaging Service that is used for email-based replication between sites.

Net Logon Service that supports pass-through authentication of account logon events for computers in a domain.

There are various AD utilities available among which Lepide AD Management & Reporting is counted as the best. It is the perfect solution to the complex problems of built-in Windows administration tools. This tool provides a simple but efficient mechanism to manage all organizational units around the network.

The author of this article is a renowned network administrator having hands-on experience in reviewing Active Directory utilities. The author has delivered various articles that help the users to easily understand the concept of Active Directory monitoring.

Article Source: http://EzineArticles.com/?expert=Andrew_Paul_Clarke

Article Source: http://EzineArticles.com/6796972

MS Excel Tutorial - How To Create A Custom Theme In Excel 2007

Using a document theme is a great way to personalise and standardise your own personal or company image for consistency and a professional look in your Microsoft Office documents. Excel is no exception.

It is really not complicated to do, and can save you valuable time whilst maintaining your image or brand. A few mouse clicks is all it takes to change the look of your work book.

The elements that are controlled in Excel by theme are:

• Cells and ranges that use any theme colors (not standard colours)
• Charts
• Tables
• Pivot tables
• SmartArt
• Shapes
• WordArt
• Sheet Tab Colors

The choices that you have are vast for setting your own individual look. To see what is available just select:

• Page
• Layout
• Themes

If you try this, you will see a 'live preview' of the changes, as you move the mouse over the different themes it changes live on the active sheet. When you see a theme you like simply click it to apply that theme to all of the worksheets in your workbook.

So, remember you cannot have different themes on different worksheets, they apply to the whole workbook.

Once you have chosen your theme, you will find that the choices of the gallery will reflect the new theme, for example,the chart styles that are available for you to choose will change.

Once you have applied your new theme some adjustments to your workbook maybe needed.

The fonts and font sizes change with the varying themes, therefore the layout of your worksheet will change, so a worksheet that fitted on one page for printing, may not do so after you change the theme.

The Page Layout is also affected. In the Themes Group (in the Page Layout Tab) contains three other controls- Colours, Fonts and Effects. These three controls can be actually used to 'fine tune' your theme for example if you have a found a theme you really like but are not taken with the Font used you can specify another font by selecting:

1. Page Layout
2. Themes
3. Font
4. Create new Theme Font

Each theme uses two fonts, one for the Header Section and one for the Body Text. In some themes they are the same but in other they do differ. Once you have selected the create new theme font give it a name and select save.

You can repeat the above to change the theme colours just select Colours instead of Fonts. If you want to go even further you can create a customer set of colours by choosing:

1. Page Layout
2. Themes
3. Colors
4. Create Theme Colors

Each theme has 12 colours, four of them are for text and backgrounds, six for accents and two for hyperlinks. The theme effects on SmartArt, Shapes and Charts are operated by the theme and cannot be customised any further.

To save your newly created masterpiece of a theme just do the following:

1. Page Layout
2. Themes
3. Save Current Theme.

Your customised themes will appear in the theme list in Custom Category, and other Office 2007 Applications such as Word and Powerpoint will be able to use these theme files.

BJ Johnston has been an advanced Excel user for 15 years and is the creator of http://www.howtoexcelatexcel.com/?page_id=2 a site that shares Excel tips and tricks with it's enthusiastic members. To join in the discussion, where users are working smarter and faster with Excel sign up for the FREE newsletter and as a bonus receive a FREE EBook- 50 Top Tips and Tricks. http://www.howtoexcelatexcel.com/

Article Source: http://EzineArticles.com/?expert=BJ_Johnston

Article Source: http://EzineArticles.com/6805701

Create Memories With a DVD Slide Show Builder

Have you ever wanted to organize and correlate your slides into collections that you can share with all of your friends or family? If not then don't worry at all because these days there are number of websites that provide you with the remarkable download that can not only help you to collect your slides, but can also add many effects to your presentations that will have your viewers on the edge of their seats as they watch your pictures and videos as a slide show.

Downloading the free slide show builder application is quick and easy. Once installed, there will be two modes available, standard mode and advanced mode. The advanced mode is geared towards processing standard slides into an effective presentation, while the standard mode can create a photo movie with its per-loaded movie styles.

Adding files to your application is a breeze with a few simple clicks of your mouse. As each 2 photos or videos are selected, various effects will automatically be randomly displayed for your consideration. Amusing slide shows can also be made from Webcam and TV Card as an additional feature of this versatile program.

Authoring your slide shows is simple with several per-programmed templates that will allow you to personalize your DVD with flair. Using the tab buttons located at the top of the screen will provide you with a host of options to edit and enhance your slide show. There is also the ability to completely customize your own personal menu template to add to your production. Customizing your menu template is recommended and easy to do with the slide show builder application.

When you are happy with your production you will be ready to burn the final product to DVD. Nothing could be easier to do with this simple application. A click on the create tab and you can transform your slides into presentations to be displayed on a wide variety of media such as YouTube or your mobile phone. The possibilities are everywhere. Make sure you select the appropriate NTSC or PAL setting before burning your DVD. These settings determine which format the recording shall be made in dependent upon which country your playbacks will be performed. The wrong setting will result in a distorted playback if the wrong one is chosen.

The DVD slide show builder is a simple and progressive application to help organize and transform your slides and videos into a portable source of storage. Why not download a copy today and show the world your capabilities and wow a few of your friends and family along the way.

Get to know more about DVD Slideshow builder? Please visit us to find more about it.

Article Source: http://EzineArticles.com/?expert=Jaina_Wang

Article Source: http://EzineArticles.com/6801639

Converting AVI Files to DVD

One of the more commonly utilized digital video formats these days is AVI. A large portion of modern-day digitized cameras and camcorders use this popular format to store the data of their recordings. While easy to watch through the viewfinder of the camera itself, transferring the images to a DVD might be the only way to view the recordings on such devices as a TV.

Unfortunately, the typical available free download from the Internet is not an option for this process, at least not applications you can trust or that are legitimate. Don't despair though, the investment you make buying the converter will pay off in the long run with compact, portable DVDs that will entertain you and your friends for many years to come.

Once you purchase the WinAVI converter and install it, the painful part of transferring the images to DVD is over. The on screen directions are simple and easy to read and in reality the entire process present nothing to fear but fear itself. Once the product has been registered online, (if you don't and try to run the program in the trial mode a watermark will be imprinted on all of your images), clicking on the DVD tab will open a screen with all available AVI's to record. Adding several to the DVD is a snap and the tutorial will walk you easily through the process of adding or deleting files to burn. You can merge the files into a compilation or keep them separate by titling each one by choosing your preferred method of organization on the disc.

When you have successfully chosen the files and organized them to your liking you are ready for the last remaining decision to make before final production. That decision would be the output setting for which format is the one you want. A quick browse through the output directory will determine the appropriate choice. If the program is functioning properly, the default setting is already set to the DVD option so it shouldn't be a difficult task. A simple click on OK and the process will commence. This might take a while depending on file size and you might choose to have your computer shut down after completion so you will know when the DVD is ready to view.

DVD's are a simple and convenient way of storing your accumulated videos. The WinAVI converter will provide you with permanent DVD copies easily that are of professional quality, economical and dependable.

Avi to DVD converter can make your work easy. Please visit us to find more about it.

Article Source: http://EzineArticles.com/?expert=Jaina_Wang

Article Source: http://EzineArticles.com/6801645

Why Request a Facebook App Quote?

Right now Facebook is the leading social networking website and continuously growing at a remarkable speed as million of new users sign up every month. The rise in usage of Facebook can be estimated from that fact that not only every individual but every brand also has its own fan page with complete profile that helps to communicate with people and share things.

Facebook opened up their network with FB Connect, their API that enables outside developers to come up with applications that Facebook users could install on their profile to add more functionality and attraction and make them more entertaining. These apps proved to be most beneficial for brands and businesses that used them to connect with customers by enabling them to play games, helped businesses collect feedback from them and enable them to share the fan page content with other fans.

While almost all the brands want to make use of these wonderful apps for more exposure to their target audience, yet most of the businessmen do not know how to go about getting one. Ready made apps would not be enough as each business is selling its own individual products and services that cannot be highlighted with a one for all kind of app. For promoting a particular business and getting more fans, a brand needs its own app that would help customers relate to it. Thus, as an entrepreneur, you need to take a close look at the internet market and find a capable and talented Facebook developer who would develop a great app for you.

In most of the cases, it has been observed that entrepreneurs consult a particular agency or freelancer and after negotiating a little over costs, they handover the project to them. While it is by no means wrong or pose any problem, yet in some cases, the entrepreneurs are overcharged as they actually do not know anything about development especially app development and they end up paying more than actually the app is worth just because they are unaware of the market costs.

The best thing to do in this regard is to get an app quote. There are hundreds of online app development companies as well as freelancers who would be happy to give you a quote regarding the costs of Facebook application development. With app quotes from various sources, you will be better able to understand how much an app should reasonably costs and then handover the project to the most suitable candidate who is capable of doing the job and charges just the right price.

Requesting app quote is a very simple process. Almost every development company has a separate page for it which requests your name, email address and provides a box where you can enter details regarding the type of app you want to have developed. As soon as you send these details, they go over them and replay on your email address with their response telling you about how much time and money it would take to develop an app.

Facebook apps are the best way to attract visitors and customers to your business and in most of the cases, it's the viral effect where successful applications installed by few are inspiration for others and spread the word around. However, getting the job done within your budget is the most important thing and if you collect price quotes from various resources, it would make it very easy to select the right professional company or individual for the job, spread the word about your business and engage your market with a great Facebook application.

If you are one of the people who is still a novice and on the lookout for comprehensive guidance and knowledge based execution of Facebook Developers NY, we can help you out, 

Article Source: http://EzineArticles.com/?expert=Roses_Mark

Article Source: http://EzineArticles.com/6790682

Calculating Facebook App Development Cost

Applications are the most prominent feature of Facebook that help to make it so popular and well accepted among the users. Brands and businesses are seeking better and innovative means to get their apps developed by most talented of professional for best results.

Applications help to make a Facebook fan page entertaining, engaging and assists in getting lots of things done such as collecting feedback, sending virtual gifts, sharing content and playing games along with much more. However, getting an application is not so easy and cheap too. It all depends on how technically complicated an idea or a concept is and how much time it would take to give life and soul to that idea. Getting an application developed can be difficult if you do not know how much time or effort it would require and where to find the best professional for the project who does a good job and does not over charge.

While some apps costs are calculated according to the number of hours they would take in development, some calculate app costs according to the amount of work that is involved and how much effort it would take. In both cases, it becomes important to see the time and effort needed and calculate the balance amount.

In most of the cases, a designer and programmer is needed when it comes to developing an application for Facebook which means an increase in costs. However, as the two fields of programming and designing are closely related, it is a possibility that you will find a good programmer and a designer but it might not go as planned as not every developer will understand the designing needs. The best thing is to hire a company who will provide you the complete services and save the hassle of looking for both designer and programmer and include their services in the app cost. If you go out looking for a programmer as well as a designer, it might cost you more than what you had actually planned on spending for app development.

If you do not have the budget to hire a big development company and want to cut the costs, then it might be a good option to seek some freelancer who would do the job and charge lesser. Freelance developers can be easily found online and the app cost will be definitely more reasonable and within budget. However, it remains to be seen if the person you have found is good enough with the job and understands your concept and idea of application to come up with the right product. The easiest way to do it is to send an online request describing your development needs or app concept to a development company and see how they respond. There are hundreds of websites of app development companies on the internet who would be happy to help you out.

Facebook app costs cannot be calculated in exact amount as this is one task that cannot be ascertained for sure unless it's complete. Facebook app costs can range from as little as $60 to as high as $50,000 depending on your idea and what you want the app to do. While some developers would ask to be paid by hour, some would prefer to be paid as per project. The best thing to calculate the cost of your Facebook app is to provide the developer with a brief outline of what you are looking forward to getting. This would help to know how many hours it would take and get an idea of what reasonable development cost would be.

If you are one of the people who is still a novice and on the lookout for comprehensive guidance and knowledege based execution of Facebook Developers NY, we can help you out

Article Source: http://EzineArticles.com/?expert=Roses_Mark

Article Source: http://EzineArticles.com/6790714