How To Customize Slide Design In Microsoft PowerPoint 2003

customizing slides im ms powerpoint 2003
 Tags:-office.com/ setup,office.com /setupoffice.com/setup  

Introduction

Before the finish of this module, you ought to have the capacity to:

  • Apply a slide outline format
  • Adjust the shading plan of an outline layout
  • Alter the shading plan

Modifying the slide plan

When you select an outline layout, PowerPoint applies predefined plan components, for example, textual style and size, foundation shading, and slug shape and shading to each slide appear.

To customize the slide design:

  • Select FormatactionSlide Design from the primary menu. The Slide Design sheet will show up.
  • Tap the plan layout you like. As a matter of course, PowerPoint will apply this plan to all slides in the slide appear; be that as it may, you can right-tap the bolt next to every format to alter the default setting.
  • Tap the Color Schemes interface.
  • Select the shading plan you like. As a matter of course, PowerPoint will apply this outline to all slides in the slide appear; be that as it may, you can right-tap the bolt adjacent to every layout to alter the default setting.
  • Tap the Edit Color Schemes connect to alter particular components of the shading plan.

Customize Slide Design

  • Select the component you might want to alter in the Scheme hues area.
  • Snap Change Color.
  • Select the shading you like on either the Custom or Standard exchange box tab.
  • Snap OK.
  • Rehash the past four stages until the point that you have changed every one of the components you wish.
  • Snap Apply.

Blogs :    Install office key

 

How To Add Signature In Microsoft Outlook 2003

Signature in ms outlook 2010
 Tags:-office.com/ setup,office.com /setupoffice.com/setup  

Making an email signature

An email signature comprises of content as well as pictures that are consequently added to the finish of active email messages. You can make numerous custom marks for various gatherings of people, for example, for business contacts or close companions. Business email marks ordinarily contain your name, work title, and business contact data. Your own email mark may incorporate a photo, shutting welcome, quote, or some other data. There are no tenets for what data you can incorporate into your mark.

To make an email signature:

  • Select ToolsactionOptions from the principle menu. The Options exchange box will show up.
  • Select the Mail Format tab.
  • Tap the Signatures catch in the Signatures area.
  • Snap New. The Create New Signature discourse box will show up.
  • Enter a name for your mark. In the case beneath, the mark is named “Business”.

Business Signature

  • Select Start with clear signature. On the off chance that you have a current mark spared in Outlook or as a document on your PC, you can utilize it as a layout now.
  • Snap Next. The Edit Signature exchange box will show up.
  • Sort the content you need as your email signature.
  • Feature the content utilizing your mouse.
  • Snap Font. The Font exchange box will show up.
  • Select the textual style, style, size, and shading you need to arrange your mark.
  • Snap OK. The organized mark will show up in the Edit Signature discourse box.

Formatted Signature

  • Audit the mark and confirm that it shows up as you need.
  • Snap Finish.
  • Snap OK in the Create Signature discourse box.
  • Snap OK in the Options discourse box. Your mark will now naturally seem each time you make another email message.

Blogs :   office.com /setup

Let’s Discuss How To Manage Databases and Objects In Microsoft Access 2016

create_a_query_with_user_input_in_microsoft_access 2016
 Tags:-office.com/ setup,office.com /setupoffice.com/setup  

Presentation

Each Access database comprises of different items that let you associate with information. Databases can incorporate structures for entering information, questions for seeking inside it, reports for investigating it, and tables for putting away it. At whatever point you work with your database, you are working with a significant number of these items on the double. Luckily, Access makes dealing with these articles truly simple.

In this lesson, you will figure out how to open and close databases, and also how to open, close, and spare articles.

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 open a current database:

Before you enter information or change your articles, you should open your database.

  1. Select the File tab to go to Backstage view.

Clicking the File tab

2. Snap Open.

Clicking Open

3. Snap Browse.

Clicking Browse

The Open exchange box will show up. Find and select the database, at that point click Open.

Opening an Access database

At least one notice messages may show up when you open your database. In the event that the database contains altered capacities, a yellow bar with a security cautioning may show up underneath the Ribbon. On the off chance that you put stock in the wellspring of your database, click Enable Content for your database to show effectively.

Enabling database content

In the wake of empowering all substance in the database, you may see a message inquiring as to whether you need to make the database a Trusted Document. Snap Yes on the off chance that you might want all substance to be consequently empowered each time you open the database.

Making the database a trusted document

You may likewise be incited to sign in to the database. Select your name from the login list. On the off chance that your name does not show up, click Add User to enter your data.

To close a database:

  1. Select the File tab to go to Backstage view.

2. Select Close.

Clicking Close

On the off chance that you have any unsaved items, a discourse box will show up for every one inquiring as to whether you might want to spare it. Select Yes to spare the protest, No to close it without sparing, or Cancel to leave your database open.

Saving unsaved objects

Working with objects

It’s useful to think about your database as a huge folio or envelope in which you store your information. The information itself is contained in database objects. Access regards every one of these items as discrete archives, which implies you should open and spare them exclusively keeping in mind the end goal to work with them.

You may have seen that this lesson contains no guidelines for sparing a database. This is on the grounds that you can’t spare a whole database without a moment’s delay. Or maybe, you should exclusively spare the articles contained inside the database.

To open a protest:

1. In the Navigation sheet, find and double tap the coveted protest.

Opening an object

2. The protest will show up as a tab in the Document Tabs bar.

The object opened in Access

3. As a matter of course, the most as of late opened protest will show up in the primary window as the present question. To see another open question, click its tab in the Document Tabs bar.

Clicking a tab to open a different object

Sparing items

You’ll have to spare any progressions you make to each question before shutting your database. Keep in mind, sparing early and frequently can keep your work from being lost. Be that as it may, you will likewise be provoked to spare any unsaved work when you endeavor to close your database.

To spare another protest:

1. Select the question you need to spare by clicking its tab in the Document Tabs bar.

2. Tap the Save charge on the Quick Access Toolbar, or press Ctrl+S on your console.

Clicking the Save command

3. The first occasion when you spare a protest, you will be incited to name it. Enter the coveted question name, at that point click OK.

Saving an object

The protest will be spared. Tap the Save charge again to spare any progressions to the question.

To close a question:

  1. Select the question you need to close, at that point tap the X to one side of the Document Tabs bar.

Closing an object

2. On the off chance that there are any unsaved changes to the question, you will be incited to spare it. Select Yes to spare, No to close it without sparing your progressions, and Cancel to leave the question open.

You can likewise close a question by right-clicking its tab on the Document Tabs bar and choosing Close. Select Close All to close all open items.

Right-clicking to close an object

To rename a question:

1. In the event that the question you need to rename is open, close it.

2. In the Navigation sheet, right-tap the coveted protest, at that point select Rename.

Clicking Rename

3. Sort the new protest name, at that point press Enter on your console.

Renaming an object

Blogs  :  Office.com/setup

 

How To Create and Open Documents In Microsoft Word 2016

create and open document word 2016

Tags:-office.com/ setup,office.com /setupoffice.com/setup  

 Intoduction

Word records are called archives. At whatever point you begin another undertaking in Word, you’ll have to make another report, which can either be clear or from a layout. You’ll likewise need to know how to open a current record.

 To make another clear record:

When starting another undertaking in Word, you’ll regularly need to begin with another clear record.

1. Select the File tab to get to Backstage view.

clicking the File tab

2. Select New, at that point click Blank report.

creating a new blank document

3. Another clear report will show up.

To make another report from a format:

A format is a predesigned report you can use to make another archive rapidly. Layouts frequently incorporate custom organizing and outlines, so they can spare you a ton of time and exertion when beginning another task.

1. Tap the File tab to get to Backstage view, at that point select New.

2. A few formats will show up underneath the Blank report alternative. You can likewise utilize the pursuit bar to discover something more particular. In our illustration, we’ll look for a flyer layout.

searching for a specific template

3. When you discover something you like, select a format to see it.

clicking a template to preview it

4. A preview of the format will show up. Snap Create to utilize the chose layout.

creating a document from a template

5. Another record will show up with the chose format.You can likewise peruse formats by classification in the wake of playing out a hunt.

To open an existing document:

Notwithstanding making new archives, you’ll regularly need to open a record that was beforehand spared. To take in more about sparing reports, visit our lesson on Saving and Sharing Documents.

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

clicking the Open command in Backstage view

2. Select This PC, at that point click Browse. Then again, you can pick OneDrive to open records put away on your OneDrive.

selecting Browse to look for a file to open

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

opening an existing file

4. The chose record will show up.

Most highlights in Microsoft Office, including Word, are intended for sparing and sharing records on the web. This is finished with OneDrive, which is an online storage room for your reports and records. In the event that you need to utilize OneDrive, ensure you’re marked in to Word with your Microsoft account. Audit our lesson on Understanding OneDrive to take in more.

 To stick a report:

On the off chance that you as often as possible work with a similar record, you can stick it to Backstage view for fast access.

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

2. A rundown of as of late altered reports will show up. Drift the mouse over the record you need to stick, at that point tap the pushpin symbol.

pinning a document

 

3. The report will remain in Recent archives list until the point that it is unfastened. To unfasten a report, tap the pushpin symbol once more.

unpinning a document

 

To change over an archive:

On the off chance that you need access to all Word 2016 highlights, you can change over the record to the 2016 document design.

1. Tap the File tab to get to Backstage view, at that point find and select the Convert summon.

clicking the Convert command

2. A discourse box will show up. Snap OK to affirm the document redesign.

converting a file to the newest file type

3. The report will be changed over to the most current document write.

Changing over a record may make a few changes the first format of the report.

Blogs :    Activate Office

How To Add Objects In Microsoft PowerPoint 2000

adding objects in powerpoint
 Tags:-office.com/ setup,office.com /setupoffice.com/setup  

Introduction

Before the finish of this exercise, you ought to have the capacity to:

  • Add articles to slides
  • Embed cut workmanship

Including objects

  • Some slide designs contain exceptional spots for pictures, cut workmanship, diagrams, and graphs. These articles can help upgrade the presence of slides.

Placeholder Slide

  • A question placeholder indicates the sort of thing you should put in it. It prompts you to double tap inside the placeholder to include the protest.

Embeddings cut craftsmanship

Clasp craftsmanship is a picture or pictures you can add to your introduction.

To add cut craftsmanship to a slide:

  • Pick InsertactionNew Slide from the menu bar (Ctrl+M).
  • Pick a slide format containing a clasp workmanship placeholder.
  • Double tap in the placeholder box.
  • The Microsoft Clip Gallery opens. It contains classes of clasp workmanship.

Clip Gallery

  • Pick a class, for example, top picks, scholarly, or creatures.
  • Pick a photo.
  • Snap OK.

Essential pointYou can likewise add cut craftsmanship to a slide by clicking InsertactionPictureactionClip Art. The Microsoft Clip Gallery opens.

Blogs :    Office com setup

How To Create Formulas In Microsoft Excel 2000

create-autosum-formula-2000
 Tags:-office.com/ setup,office.com /setupoffice.com/setup  

Making equations

In school, you may have needed to retain certain equations to work math issues. Microsoft Excel utilizes recipes to perform counts inside a spreadsheet. In this exercise, you will figure out how to utilize Excel’s recipe highlights.

Addition                                                           +

Subtraction                                                   

Multiplication                                                *

Division                                                             /

Exponentiation (to the power of)        ^

Priority (do this first)                (put in brackets)

Break even with to                                 =

Not equivalent to                                  < >

More prominent than                            >

Less than                                                     <

Creating a simple formula

How about we begin with a straightforward recipe that contains one numerical task. All equations start with the equivalents sign (=), regardless of whether the recipe comprises of including, subtracting, duplicating, or separating. Here’s a case of a straightforward recipe: =B2-B3.

Formula Palette

To make a straightforward recipe utilizing the point-and-snap strategy:

  • Enter the numbers you need to compute.
  • Tap the cell where you need the outcome to show up.
  • Sort the equivalents sign (=).
  • Tap the primary cell to be incorporated into the equation.
  • Sort a numerical administrator, (for example, the expansion image +). The administrator shows in the cell and in the Formula bar.
  • Tap the following cell in the recipe.
  • Rehash stages 4 and 5 until the point when the whole equation is entered.
  • Press Enter or tap the Enter catch on the Formula bar. This progression closes the equation.
  • Imperative pointIf you move to another cell, Excel will incorporate that cell in the equation.
  • Tap the equivalents sign catch on the Formula bar as opposed to the equivalents sign on the console to open the Formula Palette, which gives you a chance to see the improvement of a recipe as you enter it.

blogs :  Office.com /setup

How To Check Spelling and Grammatical Error In Microsoft Excel

excel-spell-check-menus-in excel
 Tags:-office.com/ setup,office.com /setupoffice.com/setup  

 Introduction

Before sharing an exercise manual, you’ll need to ensure it does exclude any spelling mistakes. Luckily, Excel incorporates a Spell Check instrument you can use to ensure everything in your exercise manual is spelled accurately.

In the event that you’ve utilized the Spell Check highlight in Microsoft Word, simply know that the Spell Check instrument in Excel, while accommodating, isn’t as capable. For instance, it won’t check for language structure issues or check spelling as you compose.

Discretionary: Download our training exercise manual.

                                              To utilize Spell Check:

1. From the Review tab, tap the Spelling summon.

Selecting the spelling command

2. The Spelling discourse box will show up. For each spelling blunder in your worksheet, Spell Check will attempt to offer proposals for the right spelling. Pick a recommendation, at that point click Change to revise the mistake.

Clicking change to correct a spelling error

3. A discourse box will show up in the wake of exploring all spelling blunders. Snap OK to close Spell Check.

Clicking ok to close spell check

On the off chance that there are no suitable recommendations, you can likewise enter the right spelling physically.

                                          Disregarding spelling “blunders”

Spell Check isn’t generally right. It will at times stamp certain words as mistaken regardless of whether they’re spelled effectively. This regularly occurs with names, which may not be in the lexicon. You can pick not to change a spelling “blunder” utilizing one of the accompanying three choices:

  • Overlook Once: This will avoid the word without evolving it.
  • Overlook All: This will avoid the word without transforming it and furthermore skirt every single other case of the word in your worksheet.
  • Include: This adds the word to the lexicon so it will never show up as a blunder again. Ensure the word is spelled effectively before picking this alternative.

Blogs  :    Office.com /setup

 

Let’s Discuss Query Design Options In Microsoft Access

create_a_query_in_microsoft_access
 Tags:-office.com/ setup,office.com /setupoffice.com/setup  

Introduction

Access offers a few choices that let you outline and run questions that arrival precisely the data you’re searching for. For example, consider the possibility that you have to discover what number of something exists inside your database. For sure on the off chance that you might want your question results to consequently be arranged a specific way? On the off chance that you know how to utilize Access’ inquiry choices, you can outline any question you need.

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

Changing inquiries

Access offers a few choices for improving your inquiries work for you. Notwithstanding changing your inquiry criteria and joins after you fabricate your questions, you can sort and conceal fields in your inquiry comes about.

To alter your inquiry:

When you open a current inquiry in Access, it is shown in Datasheet see, which means you will see your question brings about a table. To alter your inquiry, you should enter Design see, the view you utilized while making it. There are two approaches to change to Design see:

  • On the Home tab of the Ribbon, tap the View order. Select Design View starting from the drop menu that shows up.

Screenshot of Access 2013

  • In the base right corner of your Access window, find the little view symbols. Tap the Design View symbol, which is the symbol most distant to one side.

Screenshot of Access 2013

Once in Design see, roll out the coveted improvements, at that point select the Run order to see your refreshed outcomes.

You may see that Access likewise offers SQL see. You can disregard this. SQL see enables you to make propelled capacities that you won’t have to use for this instructional exercise or for most Access capacities.

Arranging inquiries

Access enables you to apply various sorts without a moment’s delay while you’re planning your question. This enables you to see your information precisely the way you need.

A sort that incorporates in excess of one arranged field is known as a multilevel sort. A multilevel sort enables you to apply an underlying sort, at that point additionally arrange information with extra sorts. For example, on the off chance that you had a table loaded with clients and their locations, you may decide to first sort the records by city, at that point one after another in order by last name.

At the point when in excess of one sort is incorporated into an inquiry, Access peruses the sorts from left to right. This implies the furthest left sort will be connected first. In the case underneath, clients will be arranged first by the City where they live and after that by the Zip Code inside that city.

Screenshot of Access 2013

To apply a multilevel sort:

  • Open the inquiry and change to Design see.
  • Find the field you need to sort first. In the Sort: push, tap the drop-down bolt to choose either an Ascending or Descending sort.

Screenshot of Access 2013

  • Rehash the procedure in alternate fields to include extra sorts. Keep in mind, the sorts are connected from left to right, so any extra sorts must be connected to fields situated to one side of your essential sort. On the off chance that important, you can improve the fields by tapping the highest point of a field and dragging it to another area.

Screenshot of Access 2013

  • To apply the sort, tap the Run charge.

Screenshot of Access 2013

  • Your inquiry results will show up with the coveted sort.

Screenshot of Access 2013

You can likewise apply multilevel sorts to tables that don’t have inquiries connected to them. On the Home tab on the Ribbon, select the Advanced drop-down order in the Sort and Filter gathering. From the menu that shows up, select Advanced Filter/Sort and make the multilevel sort as you regularly would. When you’re done, tap the Toggle Filter summon to apply your sort.

Screenshot of Access 2013

Concealing fields inside inquiries

Once in a while you may have fields that contain imperative criteria, yet you should not have to really observe the data from that field in the last outcomes. For instance, take one of the questions we worked in our last lesson: an inquiry to discover the names and contact data of clients who had put orders. We included Order ID numbers in our inquiry since we needed to ensure we just pulled clients who had put orders.

Notwithstanding, we truly didn’t have to see this data in our last inquiry comes about. Truth be told, in the event that we were simply searching for client names and addresses, seeing the request number blended in there might have been diverting. Luckily, Access makes it simple to shroud fields while as yet including any criteria they contain.

To conceal a field inside a question:

  1. Open the question and change to Design see.
  2. Find the field you need to cover up.
  3. Tap the checkbox in the Show: column to uncheck it.Screenshot of Access 2013
  4. To see the refreshed question, select the Run charge. The field will be covered up.

To unhide a concealed field, essentially come back to Design view and tap the checkbox in the field’s Show: push once more.

Blogs :  office.com/setup

How To Use Backspace/Delete and Undo/Repeat Option In Word Document

undo backspace in ms word 2003
 Tags:-office.com/ setup,office.com /setupoffice.com/setup  

Introduction

Before the finish of this exercise, you ought to have the capacity to:

  • Utilize delete and erase
  • Utilize fix and rehash

Backspace and Delete

  • Utilize the Backspace and Delete keys (on your console) to eradicate message in your record.
  • The Backspace key eradicates the content to one side of the addition point one character at any given moment.
  • The Delete key (situated under the Insert key) eradicates content to one side of the inclusion point.

Utilizing Undo

Have you at any point committed an error in your report and expected to return and roll out improvements, yet you thought it was past the point of no return? Uplifting news! Word offers an element that keeps this from happening.

The Undo charge gives you a chance to fix, or erase, the last change made to your record. As you can envision, this is an extremely helpful component. In the event that you commit a change or error you don’t need or did not intend to do, you can essentially “fix” your activity.

To utilize Undo:

  • Snap Edit on the menu bar.
  • Select Undo. This charge will change names contingent upon the move you simply made. On the off chance that you coincidentally erased a sentence, it will state Undo Clear.
  • Press Ctrl+Z on your console for an easy route to Undo.

Or on the other hand

  • Fix the greater part of your ongoing activities by over and again tapping the Undo catch situated on the Standard toolbar.

Undo Button

  • Notice the little rundown bolt alongside the Undo catch. When you tap on it, you’ll see a rundown of all the different activities you have performed on the report you are taking a shot at. You can choose the same number of activities as you need to fix.

Essential: If you fix an activity amidst the rundown, you will likewise fix every one of the activities over the one you select. For instance, on the off chance that you fix the fifteenth activity in your rundown, you will likewise be fixing the 14 activities that preceded the one you select.

Undo List

Utilizing Repeat

  • The Repeat highlight enables you to rehash the last activity and can spare a great deal of time as you make your record.

To utilize Repeat:

  • Snap Edit on the menu bar.
  • Select Repeat. This order will change names contingent upon the move you simply made. On the off chance that you have to arrange a title on one page and wish to organize another title a similar way utilizing Repeat, it will state Repeat Style.
  • Press Ctrl+Y on your console for an alternate way to Repeat.

Repeat Typing Command

Blogs :   www.office.com/ setup

How To Find Different Record In Microsoft Access 2003

find records

 Tags:-office.com/ setup,office.com /setupoffice.com/setup  

Presentation

Before the finish of this exercise, you ought to have the capacity to:

  • Play out a basic find
  • Utilize a trump card to discover a record

Performing a simple find

When you have a to a great degree substantial database comprising of thousands of records, you may need to rapidly find one of them. Access gives a simple method to discover singular records: the Find work.

To utilize the Find work:

  • Snap anyplace in the field that contains the information you need to look (e.g., Last Name).
  • Pick EditFind on the menu bar, or tap the Find catch on the toolbar to open the Find and Replace discourse box.
  • In the Find What field, type the data you need to look for. It might be a last name (e.g., Manning) or a bit of the last name (e.g., Man).

Find and Replace Dialog Box

  • The Look In drop-down box defaults to the field or section where the cursor was situated when the Find was started. You can leave the definition as is whether you know the data is contained in this field, or you can choose Search the whole table starting from the drop menu list.

Look In Field

  • In the Match field Access defaults to Whole Field, however you can alternatively choose either Any Part of Field or Start of Field.

Match Field

  • Tap the Find Next catch to look for the principal event of a record that matches the inquiry.

Playing out a straightforward find

  • Tap the Cancel catch if the record was found. The Find and Replace exchange box will close.
  • Or on the other hand
  • Tap the Find Next catch to look for the following record that meets the Find criteria.
  • In the occasion that Access did not discover a counterpart for the hunt, the Office Assistant will fly up to illuminate you that there were no coordinated records found.Item Not Found Dialog Box

To look for a record utilizing a special case:

  • Pick EditFind on the menu bar, or tap the Find catch on the toolbar to open the Find and Replace exchange box.
  • In the Find What field, type the trump card blend (e.g., B*) to locate the main record where the Last Name starts with the letter B.

Found Record

  • Tap the Find Next catch to start the inquiry. The main record found that matches the pursuit is featured.

Found Record

  • (The Office Assistant will give warning if no coordinating records were found.)
  • Tap the Cancel catch if the record was found. The Find and Replace discourse box will close.
  • Or on the other hand
  • Tap the Find Next catch to scan for the following record that meets the Find criteria.

Blogs :  www.office.com/setup