How To Create And Open Workbook In Microsoft Excel 2016


       Tags:- setup, /                                                                Introduction

Exceed expectations records are called exercise manuals. At whatever point you begin another task in Excel, you’ll have to make another exercise manual. There are a few approaches to begin working with an exercise manual in Excel 2013. You can make another exercise manual—either with a clear exercise manual or a predesigned format—or open a current exercise manual.

            To create a new blank workbook:

1.  Select the File tab. Backstage view will show up.

Screenshot of Excel

2.  Select New, at that point click Blank exercise manual.

Screenshot of Excel 2013

3.  Another clear exercise manual will show up.

              To open a current exercise manual:

Notwithstanding making new exercise manuals, you’ll regularly need to open an exercise manual that was already spared. To take in more about sparing exercise manuals, visit our lesson on Saving and Sharing Workbooks.

1.  Explore to Backstage view, at that point click Open.

Screenshot of Excel 2013

2. Select Computer, at that point click Browse. On the other hand, you can pick OneDrive (beforehand known as SkyDrive) to open records put away on your OneDrive.

Screenshot of Excel 2013

3.  The Open exchange box will show up. Find and select your exercise manual, at that point click Open.

Screenshot of Excel 2013

4.  In the event that you’ve opened the coveted exercise manual as of late, you can peruse your Recent Workbooks instead of look for the record.

Screenshot of Excel 2013

         To pin a workbook:

1.  Explore to Backstage view, at that point click Open. Your as of late altered exercise manuals will show up.

Screenshot of Excel 2013

2.  Drift the mouse over the exercise manual you need to stick. A pushpin symbol will show up alongside the exercise manual. Tap the pushpin symbol.

Screenshot of Excel 2013

3. The exercise manual will remain in Recent Workbooks. To unfasten an exercise manual, basically tap the pushpin symbol once more.

Screenshot of Excel 2013

4.  You can likewise stick organizers to Backstage view for speedier access. From Backstage view, click Open, at that point find the envelope you need to stick and tap the pushpin symbol.

Screenshot of Excel 2013

                 To convert a workbook:

If you want access to all of the Excel 2013 features, you can convert the workbook to the 2013 file format.

1.  Click the File tab to access Backstage view.

Screenshot of Excel

2.  Locate and select Convert command.

Screenshot of Excel 2013

3.  The Save As dialog box will appear. Select the location where you want to save the workbook, enter a file name for the presentation, and click Save.

Screenshot of Excel 2013
4.  The workbook will be converted to the newest file type.
Blogs :

Introducing New and Modern Chart Types In Microsoft Access


       Tags:- setup, /     

When chatting with Access clients, we regularly find out about the key part that Access reports play for chiefs hoping to draw effective bits of knowledge out of their business’ information. The want for Access to give a fresher, more current information representations – and additionally a streamlined procedure for making those perceptions – has been conspicuous in these discussions and also in different channels, for example, User Voice.

  • Today, the Access group is eager to uncover our reaction to these worries: another arrangement of cleaner, more spellbinding Access outlines that give more approaches to imagine your information and present it in another and current way.
  • Make proper acquaintance with the as good as ever Column, Line, Bar, Pie, and Combo diagrams! Every one of these outline writes can without much of a stretch be added to a frame or answer to imagine your information and enable you to settle on more educated choices.


Section Chart


Line Chart


Bar Chart


Pie Chart


Combo Chart

Each outline can be redone to fit your particular needs utilizing the new and natural Chart Settings sheet and the well-known Property Sheet. Utilize these highlights to change the style and design of the diagram, include graph components like legends and information marks, and tweak the textual styles and hues.

These updates are accessible as a component of an Office 365 membership. On the off chance that you are an Office 365 endorser, discover how to get these most recent updates.

            Present day and Classic Side By Side

We understand that numerous current client arrangements depend on the current (otherwise known as exemplary) graphs, and those arrangements will keep on working – you’ll simply have more alternatives to browse. Access designers can utilize the new graphs close by the exemplary diagrams inside a similar arrangement, and progress to the new outlines at the pace they want.


We trust you’ll try the new graphs – we’d love your input! We’re continually searching for more approaches to make strides.

Blogs : setup


How To Use Mail Merge In Microsoft Word 2010


       Tags:- setup, /     

Mail Merge is a valuable apparatus that will enable you to effectively deliver various letters, names, envelopes, and all the more utilizing data put away in a rundown, database, or spreadsheet. In this lesson, you will figure out how to utilize the Mail Merge Wizard to make an information source and a frame letter, and investigate other wizard highlights. Furthermore, you will figure out how to utilize the Ribbon summons to get to Mail Merge devices outside of the wizard.

                 To utilize Mail Merge:

  • Select the Mailings on the Ribbon.
  • Select the Start Mail Merge summon.

Mail Merge

  • Select Step by Step Mail Merge Wizard.

The Mail Merge undertaking sheet shows up and will manage you through the six principle ventures to finish a consolidation. You will have a few choices to make amid the procedure. The accompanying is a case of how to make a shape letter and consolidation the letter with an information list.

Stages 1-3

  • Pick the sort of archive you need to make. In this illustration, select Letters.
  • Snap Next:Starting archive to move to Step 2.
  • Select Use the present archive.
  • Snap Next:Select beneficiaries to move to Step 3.
  • Select the Type another rundown catch.
  • Snap Create to make an information source. The New Address List exchange box shows up.
    • Snap Customize in the exchange box. The Customize Address List discourse box shows up.
    • Select any field you don’t need, and snap Delete.
    • Snap Yes to affirm that you need to erase the field.
    • Keep on deleting any pointless fields.
    • Snap Add. The Add Field exchange box shows up.
    • Enter the new field name.
    • Snap OK.
    • Keep on adding any fields vital.
    • Snap OK to close the Customize Address List discourse box.

                      To redo the new address list:

Mail Merge

  • Enter the vital information in the New Address List exchange box.
  • Snap New Entry to enter another record.
  • Snap Close when you have entered the greater part of your information records.
  • Enter the document name you need to spare the information list as.
  • Pick the area where you need to spare the record.
  • Snap Save. The Mail Merge Recipients discourse box shows up and shows the greater part of the information records in the rundown.
  • Affirm that the information list is right, and snap OK.
  • Snap Next:Write your letter to move to Step 4.

Stages 4-6

  • Compose a letter in the present Word report, or utilize an open existing record.

To embed beneficiary information from the rundown:

  • Place the inclusion point in the report where you need the data to show up.
  • Select Address piece, Greeting line, or Electronic postage from the errand sheet. A discourse box with alternatives will seem in light of your choice.

Merge Fields


  • Select More Items. The Insert Merge Field discourse box will show up.
  • Select the field you need to embed in the archive.
  • Snap Insert. Notice that a placeholder shows up where data from the information record will in the end show up.
  • Rehash these means each time you have to enter data from your information record.
  • Snap Next: Preview your letters in the assignment sheet once you have finished your letter.
  • See the letters to ensure the data from the information record shows up accurately in the letter.
  • Snap Next: Complete the union.
  • Snap Print to print the letters.
  • Snap All.
  • Snap OK in the Merge to Printer discourse box.
  • Snap OK to send the letters to the printer.

The Mail Merge Wizard enables you to finish the union procedure in an assortment of ways. The most ideal approach to figure out how to utilize the distinctive capacities in Mail Merge is to attempt to build up a few of the diverse reports—letters, names, and envelopes—utilizing the distinctive kinds of information sources.

Blogs : Office Setup

How To Create forms In Microsoft Word 2013

creating forms in ms word

       Tags:- setup, /     

If you’ve ever used Microsoft Word, you’ve probably spent a lot of time customizing different options to get your document to look exactly the way you want. But have you ever created a document for other people to use?

For example, let’s say you’re organizing a field trip and want everyone to send in their permission forms electronically. To simplify the process, you could create a form in Microsoft Word. A form allows you to create placeholders for different types of information, such as text, dates, yes-no questions, and so on. This makes it easier for everyone to know what type of information to include, and it also helps ensure all of the information is formatted the same way.

We’ll use Word 2013 to show you how to create a form, but this should work the same way for Word 2010 or Word 2007. You can also download our example file if you’d like to follow along.

 Step 1: Turn on the Developer tab
Before you create form elements in a document, you’ll need to activate the Developer tab on the Ribbon. To do this, click File > Options to access the Word Options dialog box. Select Customize Ribbon, then click the check box for the Developer tab.

Screenshot of Microsoft Word

The Developer tab will appear on the Ribbon.

Screenshot of Microsoft Word


 Step 2: Add content controls
Now you’re ready to add the different parts of the form, which Word calls content control fields. To add a content control field, place your cursor in the desired location, then choose a field from the Controls group on the Developer tab. You can hover your mouse over the fields to see the different options. In this example, we’re adding a text field so users can type their first names.

Screenshot of Microsoft Word

The content control field will appear in the document.

Screenshot of Microsoft Word

You can add several types of fields. For example, you can add check boxes for a yes-no question:

Screenshot of Microsoft Word

Or even a date selection field:

Screenshot of Microsoft Word

Once you’ve added all of your fields to the document, you’re ready to send out the form for others to use!

Step 3: Customize as needed
If you want even more control over the way your form looks, you can turn on Design Mode from the Controls group on the Developer tab.

Screenshot of Microsoft Word

Then you can modify the properties for each content control field, including the text that will appear in each field. If you’re willing to spend a little more time customizing each field, you can build a pretty robust form. For example, you could create your own custom drop-down list, as in the example below:

Screenshot of Microsoft Word
Those are the basics of creating your own custom form in Microsoft Word. If you want to learn more, check out this article from Microsoft on how to Create a Fillable Form.

Blogs : Office Setup Help

Using Different Formulas In Microsoft Excel 2013


       Tags:- setup, /     


A standout amongst the most effective highlights in Excel is the capacity to compute numerical data utilizing equations. Much the same as a number cruncher, Excel can include, subtract, duplicate, and gap. In this lesson, we’ll demonstrate to you best practices to utilize cell references to make straightforward recipes.

                                       Mathematical operators

Exceed expectations utilizes standard administrators for recipes, for example, an or more sign for expansion (+), a less sign for subtraction (- ), a bullet for increase (*), a forward slice for division (/), and a caret (^) for types.

Mathematical operators in Excel

All recipes in Excel must start with an equivalents sign (=). This is on the grounds that the cell contains, or is equivalent to, the equation and the esteem it computes.

                                    Understanding cell references

While you can make basic recipes in Excel utilizing numbers (for instance, =2+2 or =5*5), more often than not you will utilize cell delivers to make an equation. This is known as influencing a cell to reference. Utilizing cell references will guarantee that your recipes are constantly precise in light of the fact that you can change the estimation of referenced cells without rewriting the equation.

In the recipe beneath, cell A3 includes the estimations of cells A1 and A2 by making cell references:

A formula in Excel using cell references

When you press Enter, the equation computes and shows the appropriate response in cell A3:

The formula automatically calculates the result.

On the off chance that the qualities in the referenced cells change, the recipe consequently recalculates:

The formula automatically updates if one of the referenced cells changes.

By consolidating a numerical administrator with cell references, you can make an assortment of straightforward equations in Excel. Recipes can likewise incorporate a mix of cell references and numbers, as in the cases beneath:

Illustration of simple formulas

                                                           To make a recipe:

In our case underneath, we’ll utilize a straightforward equation and cell references to figure a financial plan.

1. Select the cell that will contain the recipe. In our case, we’ll select cell D12.

Selecting cells

2. Sort the equivalents sign (=). Notice how it shows up in both the cell and the recipe bar.

Starting the formula with an equals sign

3. Sort the cell address of the cell you need to reference first in the equation: cell D10 in our illustration. A blue outskirt will show up around the referenced cell.

Entering the cell reference for D10

4. Sort the scientific administrator you need to utilize. In our illustration, we’ll compose the expansion sign (+).

5. Sort the cell address of the cell you need to reference second in the equation: cell D11 in our case. A red outskirt will show up around the referenced cell.

Entering the addition operator and the reference for cell D11

6. Press Enter on your console. The recipe will be ascertained, and the esteem will be shown in the cell. On the off chance that you select the cell once more, see that the cell shows the outcome, while the recipe bar shows the equation.

Press enter to complete the formula and display the result

In the event that the aftereffect of a recipe is too extensive to be shown in a cell, it might show up as pound signs rather than an esteem. This implies the segment isn’t sufficiently wide to show the cell content. Essentially increment the section width to demonstrate the cell content.


    To make an equation utilizing the point-and-snap technique:

Rather than composing cell addresses physically, you can point and tap the phones you need to incorporate into your recipe. This technique can spare a great deal of time and exertion while making recipes. In our case underneath, we’ll make a recipe to ascertain the cost of requesting a few boxes of plastic flatware.

1. Select the cell that will contain the equation. In our case, we’ll select cell D4.

Selecting cells

2. Sort the equivalents sign (=).

3. Select the cell you need to reference first in the equation: cell B4 in our case. The cell address will show up in the equation.

Selecting the first cell to reference in the formula

4. Sort the scientific administrator you need to utilize. In our case, we’ll write the augmentation sign (*).

5. Select the cell you need to reference second in the equation: cell C4 in our case. The cell address will show up in the recipe.

Selecting the second cell to reference in the formula

6. Press Enter on your console. The equation will be figured, and the esteem will be shown in the cell.

Press enter to complete the formula and display the result

                                       Duplicating recipes with the fill handle

Recipes can likewise be duplicated to adjoining cells with the fill handle, which can spare a great deal of time and exertion on the off chance that you have to play out a similar count various circumstances in a worksheet. The fill handle is the little square at the base right corner of the chose cell(s).

1. Select the cell containing the equation you need to duplicate. Snap and drag the fill handle over the cells you need to fill.

Drag the fill handle

2. After you discharge the mouse, the equation will be duplicated to the chosen cells.

The formula is copied into the selected cells.

                                        To alter an equation:

Now and then you might need to adjust a current recipe. In the case beneath, we’ve entered an inaccurate cell address in our equation, so we’ll have to redress it.

1. Select the cell containing the recipe you need to alter. In our case, we’ll select cell D12.

Selecting cells

2. Tap the recipe bar to alter the equation. You can likewise double tap the cell to see and alter the equation straightforwardly inside the cell.

Clicking the formula bar to edit the formula

3. An outskirt will show up around any referenced cells. In our case, we’ll change the initial segment of the equation to reference cell D10 rather than cell D9.

Editing the formula

4. When you’re done, press Enter on your console or select the Enter charge in the equation bar.

Press enter to finish editing

5. The recipe will be refreshed, and the new esteem will be shown in the cell.

The new formula displays its result

6. On the off chance that you alter your opinion, you can press the Esc key on your console or tap the Cancel charge in the recipe bar to maintain a strategic distance from inadvertently rolling out improvements to your equation.

Cancel an edit to a formula

To demonstrate the greater part of the equations in a spreadsheet, you can hold the Ctrl key and press ` (grave highlight). The grave emphasize enter is typically situated in the upper left corner of the console. You can press Ctrl+` again to change back to the ordinary view.

Blogs :  Office Com Setup

How To Create Photo Albums In Microsoft PowerPoint 2013

poerpoint photo albums

 Tags:- setup, /     

                           Making a photograph collection

PowerPoint enables you to import an arrangement of pictures into a photograph collection introduction. With the photograph collection highlight you can choose, revamp, alter, and add content to your photos. As a matter of course, one picture will show up on each slide, yet you can alter the slide design to incorporate various pictures in the event that you need.

                       To make a photograph collection:

1.  Select the Insert tab.

2. Tap the Photo Album summon in the Images gathering, at that point select New Photo Album.Inserting New Photo Album

3. The Photo Album discourse box shows up. Find and tap on the File/Disk button.

Accessing images in files

4. To choose all pictures in your organizer.

  • Tap  the principal picture, at that point press and hold the Shift key and select the last picture.
  • To choose different nonadjacent pictures, press and hold the Control key while tapping the coveted pictures.

Selecting pictures from files

5. The Photo Album discourse box gives a few alternatives to moving, modifying, and changing the format of pictures. Alter as required, at that point click Create to embed pictures into the photograph collection.

Creating Photo Album

6. A different introduction will be made for the photograph collection. Of course, it will incorporate a cover sheet and one picture for each slide.

Photo Album results

Blogs : /setup


How To Insert Picture In Microsoft PowerPoint 2013

 Tags:- setup, /     


Including pictures can make your introductions all the more fascinating and locks in. You can embed a photo from a document on your PC onto any slide. PowerPoint even incorporates apparatuses for finding on the web pictures and adding screen captures to your introduction.

To insert a picture from a file:

  1. Select the Insert tab, at that point tap the Pictures order in the Images gathering.Screenshot of PowerPoint 2013
  2. Screen capture of PowerPoint 2013Screenshot of PowerPoint 2013
  3. An exchange box will show up. Find and select the coveted picture document, at that point click Insert.Screenshot of PowerPoint 2013

The photo will show up on the presently chose slide.

You can likewise tap the Pictures order in a placeholder to embed pictures.

Screenshot of PowerPoint 2013

Blogs : setup


Let’s Discuss Number Format In Microsoft Excel

ms excel formats

              Tags:- setup, /                                                                      What are number Formats?

At whatever point you’re working with a spreadsheet, it’s a smart thought to utilize fitting number configurations for your information. Number configurations tell your spreadsheet precisely what sort of information you’re utilizing, similar to rates (%), money ($), times, dates, et cetera.

  Why utilize number organizations?

Number arrangements don’t simply make your spreadsheet less demanding to peruse—they likewise make it simpler to utilize. When you apply a number organization, you’re telling your spreadsheet precisely what kinds of qualities are put away in a cell. For instance, the date organize tells the spreadsheet that you’re entering particular schedule dates. This enables the spreadsheet to better comprehend your information, which can help guarantee that your information stays reliable and that your equations are figured effectively.

In the event that you don’t have to utilize a particular number configuration, the spreadsheet will more often than not make a difference the general number organization as a matter of course. Nonetheless, the general organization may apply some little arranging changes to your information.

                                     Applying number configurations

Much the same as different kinds of organizing, for example, changing the text style shading, you’ll apply number arrangements by choosing cells and picking the coveted designing choice. There are two primary approaches to pick a number organization:

  • Go to the Home tab, tap the Number Format drop-down menu in the Number gathering, and select the coveted organization.

The Number Format menu

  • You can likewise click one of the snappy number-designing charges underneath the drop-down menu.

The Number formatting quick commands

  • You can likewise choose the coveted cells and press Ctrl+1 on your console to get to more number-designing alternatives.

In this case, we’ve connected the Currency number organization, which includes money images ($) and shows two decimal spots for any numerical qualities.

Applying the Currency format

  • On the off chance that you select any cells with number arranging, you can see the genuine estimation of the cell in the equation bar. The spreadsheet will utilize this incentive for equations and different computations.

The actual value in the formula bar

                 Utilizing number configurations accurately

There’s a whole other world to number designing than choosing cells and applying a configuration. Spreadsheets can really apply a considerable measure of number designing consequently in view of the way you enter information. This implies you’ll have to enter information in a way the program can comprehend, and after that guarantee that those cells are utilizing the best possible number arrangement. For instance, the picture underneath demonstrates to utilize number organizations effectively for dates, rates, and times:

chart illustration best practices for number formatting in spreadsheets

Since you find out about how number configurations function, we’ll take a gander at a couple of various number organizations in real life.

                   Percentage formats

A standout amongst the most accommodating number configurations is the rate (%) design. It shows esteems as rates, for example, 20% or 55%. This is particularly useful while ascertaining things like the cost of offers charge or a tip. When you compose a percent sign (%) after a number, the rate number arrangement will be connected to that phone naturally.

screenshot of excel 2013

As you may recall from math class, a rate can likewise be composed as a decimal. So 15% is an indistinguishable thing from 0.15, 7.5% is 0.075, 20% is 0.20, 55% is 0.55, et cetera. You can audit this lesson from our Math instructional exercises to take in more about changing over rates to decimals.

There are commonly when rate designing will be helpful. For instance, in the pictures underneath, see how the business impose rate is designed diversely for every spreadsheet (5, 5%, and 0.05):

image showing correct and incorrect calculations based on percentage formatting

As should be obvious, the figuring in the spreadsheet on the left didn’t work accurately. Without the rate number configuration, our spreadsheet supposes we need to increase $22.50 by 5, not 5%. And keeping in mind that the spreadsheet on the correct still works without rate arranging, the spreadsheet in the center is less demanding to peruse.

    Date formats

Spreadsheets don’t comprehend data a similar way a man would. For example, on the off chance that you write October into a phone, the spreadsheet won’t know you’re entering a date so it will treat it like some other content. Rather, when you enter a date, you’ll have to utilize a particular organization your spreadsheet sees, for example, month/day/year (or day/month/year relying upon which nation you’re in). In the case beneath, we’ll write 10/12/2014 for October 12, 2014. Our spreadsheet will then naturally apply the date number organization for the cell.

screenshot of excel 2013

Since we have our date effectively designed, we can do a wide range of things with this information. For instance, we could utilize the fill handle to proceed with the dates through the section, so an alternate day shows up in every cell:

Screenshot of Excel 2013

Screenshot of Excel 2013

On the off chance that the date arranging isn’t connected naturally, it implies the spreadsheet did not comprehend the information you entered. In the case underneath, we’ve written March fifteenth. The spreadsheet did not comprehend that we were alluding to a date, so this cell is as yet utilizing the general number organization.

screenshot of excel 2013

Then again, in the event that we write March 15 (without the “th”), the spreadsheet will remember it as a date. Since it does exclude a year, the spreadsheet will consequently include the present year so the date will have the greater part of the essential data. We could likewise type the date a few different routes, for example, 3/15, 3/15/2014, or March 15 2014, and the spreadsheet would in any case remember it as a date.

Blogs : office com/setup

How To Create Reports In Microsoft Access 2016


Tags:- setup, /                                     


On the off chance that you have to impart data from your database to somebody yet don’t need that individual really working with your database, consider making a report. Reports enable you to arrange and display your information in a peruser well disposed, outwardly engaging configuration. Access makes it simple to make and alter a report utilizing information from any question or table in your database.

  • All through this instructional exercise, we will utilize an example database. In the event that you might want to take after along, you’ll have to download our Access 2016 example database. You should approach 2016 introduced on your PC keeping in mind the end goal to open the case.

                         To make a report:

Reports enable you to show parts of your database in a simple to-peruse, printable organization. Access gives you a chance to make reports from the two tables and questions.

1. Open the table or question you need to use in your report. We need to print a rundown of treats we’ve sold, so we’ll open the Cookies Sold inquiry.

The Cookies Sold query

 2. Select the Create tab on the Ribbon. Find the Reports gathering, at that point tap the Report order.

Clicking the Report command

3.  Access will make another report in light of your protest.

4.  It’s imaginable that a portion of your information will be situated on the opposite side of the page break. To settle this, resize your fields. Just select a field, at that point snap and drag its edge until the point that the field is the coveted size. Rehash with extra fields until the point when the greater part of your fields fit.

Resizing fields in the report

5. To spare your report, tap the Save summon on the Quick Access Toolbar. Whenever provoked, type a name for your report, at that point click OK.

Saving and naming the report

Much the same as tables and inquiries, reports can be arranged and separated. Just right-tap the field you need to sort or channel, at that point select the coveted choice from the menu.

                       Erasing fields

You may find that your report contains a few fields you don’t generally need to see. For example, our report contains the Zip Code field, which isn’t essential in a rundown of requests. Luckily, you can erase fields in reports without influencing the table or inquiry where you snatched your information.

                        To erase a field in a report:

1.  Snap any cell in the field you need to erase, at that point press the Delete key on your console.

Deleting a field

2. The field will be erased.

When you erase a field, make sure to erase its header too. Just select the header and press the Delete key.

Deleting a field header after deleting the related field

Blogs : office com setup

How to Apply Themes In Microsoft PowerPoint

Apply Theme in ms powerpoint

Tags:- , ,  


A theme is a predefined combination of colors, fonts, and effects. Different themes also use different slide layouts. You’ve already been using a theme, even if you didn’t know it: the default Office theme. You can choose from a variety of new themes at any time, giving your entire presentation a consistent, professional look.

Watch the video below to learn more about applying themes in PowerPoint.

                                                What is a theme?
In PowerPoint, themes give you a quick and easy way to change the design of your presentation. They control your primary color palette, basic fonts, slide layout, and other important elements. All of the elements of a theme will work well together, which means you won’t have to spend as much time formatting your presentation.

Each theme uses its own set of slide layouts. These layouts control the way your content is arranged, so the effect can be dramatic. In the examples below, you can see that the placeholders, fonts, and colors are different.

The Frame theme and the Integral theme
If you use a unique slide layout—such as Quote with Caption or Name Card—and then switch to a theme that does not include that layout, it may give unexpected results.

Every PowerPoint theme—including the default Office theme—has its own theme elements. These elements are:

1. Theme Colors: There are 10 theme colors, along with darker and lighter variations, available from every Color menu.
Theme Colors
2. Theme Fonts: There are two theme fonts available at the top of the Font menu under Theme Fonts.
Theme Fonts
3. Theme Effects: These affect the preset shape styles. You can find shape styles on the Format tab whenever you select a shape or SmartArt graphic.
Theme Effects
When you switch to a different theme, all of these elements will update to reflect the new theme. You can drastically change the look of your presentation in a few clicks.

If you apply a font or color that isn’t part of the theme, it won’t change when you select a different theme. This includes colors selected from the Standard Colors or More Colors options and fonts selected from All Fonts. Using non-theme elements can be useful when you want certain text to be a specific color or font, like a logo.

You can also customize themes and define theme elements yourself. To learn more, see our Modifying Themes lesson.

                                Applying themes
All themes included in PowerPoint are located in the Themes group on the Design tab. Themes can be applied or changed at any time.

                                  To apply a theme:
1. Select the Design tab on the Ribbon, then locate the Themes group. Each image represents a theme.
2. Click the More drop-down arrow to see all available themes.
Clicking the More drop-down arrow
3. Select the desired theme.
Selecting a theme
4. The theme will be applied to the entire presentation. To apply a different theme, simply select it from the Design tab.
The applied theme
Once you’ve applied a theme, you can also select a variant for that theme from the Variants group. Variants use different theme colors while preserving a theme’s overall look.

Applying a theme variant

Blogs : Office Setup Help