Office

MS Word, Most Important Keyboard Shortcut Keys ... 2020 watch

noreply@blogger.com (Sayma) — Fri, 17 Apr 2020 09:35:00 +0000

MS Access 2016 - Create Simple Database -2020

noreply@blogger.com (Sayma) — Fri, 17 Apr 2020 09:30:00 +0000

The Beginner's Guide to Microsoft Publisher - 2020

noreply@blogger.com (Sayma) — Fri, 17 Apr 2020 09:25:00 +0000

Getting started with SharePoint plus Microsoft Teams - 2020

noreply@blogger.com (Sayma) — Fri, 17 Apr 2020 09:22:00 +0000

Complete Outlook Tutorial in Hindi - माइक्रोसॉफ्ट

noreply@blogger.com (Sayma) — Fri, 17 Apr 2020 09:18:00 +0000

Microsoft OneNote 2019 - Full Tutorial for Beginners in 10 ... www.youtube.com › watch

noreply@blogger.com (Sayma) — Fri, 17 Apr 2020 08:21:00 +0000

Microsoft OneNote 2019 - Full Tutorial for Beginners in 10 ...
www.youtube.com › watch

Microsoft Office Training Home and Student 2020 for 1 Windows

noreply@blogger.com (Sayma) — Fri, 17 Apr 2020 08:17:00 +0000

Microsoft Office is a collection of office-related applications. Each application serves a unique purpose and offers a specific service to its users. For example, Microsoft Word is used to create documents. Microsoft PowerPoint is used to create presentations.

The Office suite includes Word, a word-processing program; Excel, a financial spreadsheet program; Access, a database program; Publisher, for desktop publishing; PowerPoint, a program for creating presentations; Outlook, a program for email and scheduling; OneNote, to keep your notes organized; and InfoPath, an .

Microsoft Office is available in 35 different languages and is supported by Windows, Mac and most Linux variants. It mainly consists of Word, Excel, PowerPoint, Access, OneNote, Outlook and Publisher applications.

Learn Microsoft Office

Word.
Excel.
PowerPoint.
OneNote.
Outlook.
Access.
Publisher.
SharePoint.

Microsoft Office suite is application software's packaged with one bundle. It means you can use Microsoft Word, Excel, PowerPoint, MS-Access, Publisher etc. to create professional looking documents, charts, calculation, reports, and presentations in high speed and accuracy

50 Ultimate Excel Tips and Tricks for 2020 - YouTube www.youtube.com › watch

noreply@blogger.com (Sayma) — Fri, 17 Apr 2020 08:06:00 +0000

50 Ultimate Excel Tips and Tricks for 2020 - YouTube
www.youtube.com › watch

MS Word के 4 Top Best Expert Tips और Tricks जो आपको gie success | Blog 2020 | Sayma Coaching

noreply@blogger.com (Sayma) — Fri, 17 Apr 2020 07:57:00 +0000

MS Word के 4 Expert Tips और Tricks जो आपको Videos|Sayma Coaching 2020

How to create presentations in PowerPoint? (Step by step) Chapter 1

noreply@blogger.com (Sayma) — Fri, 03 Apr 2020 15:18:00 +0000

In this chapter, we will understand how to get started with PowerPoint 2010. We will understand how to start PowerPoint 2010 application in simple steps. To access PowerPoint 2010, you must have Microsoft Office 2010 installed in your PC. Only Office 2010 Home and Student, Home and Business, Standard, Professional and Professional Plus packages have PowerPoint included in them. Other packages may have a viewer, but you cannot create presentations with them.

Step 1 − Click the Start button.

Step 2 − Click All Programs option from the menu.

Step 3 − Search for Microsoft Office from the sub menu and click it.

Step 4 − Search for Microsoft PowerPoint 2010 from the submenu and click it.

This will launch the Microsoft PowerPoint 2010 application and you will see the following presentation window.

The following screenshot shows the various areas in a standard PowerPoint file. It is important to familiarize yourself with these areas as it makes learning and using PowerPoint easier.

File Tab

This tab opens the Backstage view which basically allows you to manage the file and settings in PowerPoint. You can save presentations, open existing ones and create new presentations based on blank or predefined templates. The other file related operations can also be executed from this view.

Ribbon

The ribbon contains three components −

Tabs − They appear across the top of the Ribbon and contain groups of related commands. Home, Insert, Page Layout are examples of ribbon tabs.
Groups − They organize related commands; each group name appears below the group on the Ribbon. For example, a group of commands related to fonts or a group of commands related to alignment, etc.
Commands − Commands appear within each group as mentioned above.

Title Bar

This is the top section of the window. It shows the name of the file followed by the name of the program which in this case is Microsoft PowerPoint.

Slide Area

This is the area where the actual slide is created and edited. You can add, edit and delete text, images, shapes and multimedia in this section.

Help

The Help Icon can be used to get PowerPoint related help anytime you need. Clicking on the "?" opens the PowerPoint Help window where you have a list of common topics to browse from. You can also search for specific topics from the search bar at the top.

Zoom Options

The zoom control lets you zoom in for a closer look at your text. The zoom control consists of a slider that you can slide left or right to zoom in or out, you can click on the - and + buttons to increase or decrease the zoom factor. The maximum zoom supported by PowerPoint is 400% and the 100% is indicated by the mark in the middle.

Slide Views

The group of four buttons located to the left of the Zoom control, near the bottom of the screen, lets you switch between PowerPoint views.

Normal Layout view − This displays page in normal view with the slide on the right and a list of thumbnails to the left. This view allows you to edit individual slides and also rearrange them.
Slide Sorter view − This displays all the slides as a matrix. This view only allows you to rearrange the slides but not edit the contents of each slide.
Reading View − This view is like a slideshow with access to the Windows task bar in case you need to switch windows. However, like the slideshow you cannot edit anything in this view.

Notes Section

This sections allows you to add notes for the presentation. These notes will not be displayed on the screen during the presentation; these are just quick reference for the presenter.

Quick Access Toolbar

The Quick Access Toolbar is located just under the ribbon. This toolbar offers a convenient place to group the most commonly used commands in PowerPoint. You can customize this toolbar to suit your needs.

Slide Tab

This section is available only in the Normal view. It displays all the slides in sequence. You can add, delete and reorder slides from this section.

In Office 2010, Microsoft replaced the traditional file menu with the new Backstage view. This view not only offers all the menu items under the file menu, but additional details which makes management of your files a lot easier.

Accessing Backstage View

You can access the Backstage view simply by clicking on the File tab. You can exit this view by clicking on any tab (including the File tab again). You can also press the 'Esc' button on the keyboard.

Organization of Backstage View

The backstage view has three sections or panes.

First Pane − This is the commands pane which consists of all the commands you would typically find in the file menu of older versions. You also have the Options menu which lets you edit the options on the program like customizing the ribbon.

Various commands under the first pane are described in the table below −

S.No	Command & Description
1	Save This allows you to save a new file or an existing file in standard format. If you are working on a previously saved file this will save the new changes in the same file format. If you are working on a new file, this command would be similar to the Save As command.
2	Save As Allows you to specify the file name and the file type before saving the file.
3	Open Allows you to open new PowerPoint files.
4	Close Allows you to close an existing file.
5	Info Displays the information about the current file.
6	Recent Lists series of recently viewed or edited PowerPoint files.
7	New Allows you to create a new file using blank or pre-defined templates.
8	Print Allows you to select the printer settings and print the presentation.
9	Save & Send Allows you to share your presentation with larger audience via emails, web, cloud services, etc.
10	Help Provides access to PowerPoint Help.
11	Options Allows you to set various options related to PowerPoint program.
12	Exit Closes the presentation and exits the program.

Second Pane − This is the subcommands pane. This will list all the commands related to the main command you choose in the first pane. For example, if you select Print in the first pane, you get to choose the printer and adjust the print settings in the second pane.
Third Pane − This is the preview or file information page. Depending on the command and the subcommand you select, this pane will either display the properties of the file or give you a preview of the file.

PowerPoint offers a host of tools that will aid you in creating a presentation. These tools are organized logically into various ribbons in PowerPoint. The table below describes the various commands you can access from the different menus.

Menu Category	Ribbon Commands
Home	Clipboard functions, manipulating slides, fonts, paragraph settings, drawing objects and editing functions.
Insert	Insert tables, pictures, images, shapes, charts, special texts, multimedia and symbols.
Design	Slide setup, slide orientation, presentation themes and background.
Transitions	Commands related to slide transitions.
Animations	Commands related to animation within the individual slides.
Slide Show	Commands related to slideshow set up and previews.
Review	Proofing content, language selection, comments and comparing presentations.
View	Commands related to presentation views, Master slides, color settings and window arrangements.

Besides these depending on the objects selected in the slide, there are other menu tabs that get enabled.

How to create presentations in PowerPoint? (Step by step) Chapter 2

noreply@blogger.com (Sayma) — Fri, 03 Apr 2020 15:17:00 +0000

In this chapter, we will understand how to add new slides in an existing presentation. Here are the steps that allow you to insert a new slide in the deck −

Step 1 − Right-click in the Navigation Pane under any existing slide and click on the New Slide option.

Step 2 − The new slide is inserted. You can now change the layout of this slide to suit your design requirements.

Step 3 − To change the slide layout, right-click on the newly inserted slide and go to the Layout option where you can choose from the existing layout styles available to you.

You can follow the same steps to insert a new slide in between existing slides or at the end on the slide list.

When we insert a new slide, it inherits the layout of its previous slide with one exception. If you are inserting a new slide after the first slide (Title slide), the subsequent slide will have the Title and Content layout.

You will also notice that if you right-click in the first step without selecting any slide the menu options you get are different, although you can insert a new slide from this menu too.

PowerPoint allows users to add text to the slide in a well-defined manner to ensure the content is well distributed and easy to read. The procedure to add the text in a PowerPoint slide is always the same - just click in the text box and start typing. The text will follow the default formatting set for the text box, although this formatting can be changed later as required. What changes is the different kinds of content boxes that support text in a PowerPoint slide.

Given below are some of the most common content blocks you will see in PowerPoint.

Title Box

This is typically found on slides with the title layout and in all the slides that have a title box in them. This box is indicated by "Click to add title".

Subtitle Box

This is found only in slides with the Title layout. This is indicated by "Click to add subtitle"

Content Box

This is found in most of the slides that have a placeholder for adding content. This is indicated by "Click to add text". As you can see, this box allows you to add text as well as non-text content. To add text to such a box, click anywhere on the box, except on one of the content icons in the center and start typing.

Text Only Box

This is not a default content box available in PowerPoint, but you can create it using Slide Master, if required. This is also indicated by "Click to add text". The only difference between the Text Only Box and the Content Box is that the former only supports text in the content area.

This chapter will teach you how to add new text boxes in a slide. Most of the standard layouts come with the text box option. As mentioned in the previous chapter, text boxes will have "Click to add text" as the default text. Here are the steps to add new text boxes in slide.

Step 1 − Click on the Text Box icon in the Home ribbon under the Drawingsection.

Step 2 − You will get the insert text box cursor that looks like an inverted cross.

Step 3 − Click to insert a text box. You can now start typing directly into the text box.

Step 4 − Alternately, you can click and drag the cursor without releasing the click to create a text box.

The size of the text box can be adjusted by selecting one of the edges marked by squares or corners marked by circles.

How to create presentations in PowerPoint? (Step by step) Chapter 3

noreply@blogger.com (Sayma) — Fri, 03 Apr 2020 15:17:00 +0000

There are times while building a slide deck, you may need to delete some slides. This can be done easily from PowerPoint. You can delete the slides from the Normal view as well as the Slide Sorter view. In each view, you can delete the slides in two ways.

Deleting from Normal View

Step 1 − Go to the Normal view.

Step 2 − Right-click on the slide to be deleted and select the Delete Slideoption.

Alternately, you can select the slide and press the Delete button on your key board.

Deleting from Slide Sorter View

Let us now understand how to deleted slides from the Slide Sorter View.

Step 1 − Go to the Slide Sorter view.

Step 2 − Right-click on the slide to be deleted and select the Delete Slideoption.

Alternately, you can select the slide and press the Delete button on your key board.

How to create presentations in PowerPoint? (Step by step) Chapter 4 Rearranging Slides and Adding Slides Notes

noreply@blogger.com (Sayma) — Fri, 03 Apr 2020 15:15:00 +0000

Rearranging slides is important when it comes to organizing the overall presentation flow. While it is vital that you get the right content in every slide, it is equally important that you are able to present them in a format that makes it easier for the audience to understand the content too; most times this will require rearranging the slides.

You can rearrange slides from two views in PowerPoint - Normal View and Slide Sorter View. Given below are the steps to rearrange slides from different views.

Normal View

Step 1 − Select the slide to be moved.

Step 2 − Left click on the slide and drag it to the position in the sequence where you want to place it. PowerPoint will indicate the insert position with a line in-between existing slides.

Step 3 − When you get to the right position release the left click button to insert the slide. Alternately you can also cut the selected slide and paste it back in the sequence as shown below.

Slide Sorter View

Let us now understand how the Slide Sorter View works.

Step 1 − Select the slide to be moved.

Step 2 − Left click on the slide and drag it to the position in the sequence where you want to place it. PowerPoint will indicate the insert position with a line in-between existing slides.

Step 3 − When you get to the right position release the left click button to insert the slide. Alternately you can also cut the selected slide and paste it back in the sequence as shown below.

Slide notes can be very useful tools for presentation. These notes are not displayed on the screen in the Slideshow mode, but the presenter can see them so they can prepare well to present the slides. Depending on your Print settings, you can also print the slide notes along with the slides.

This chapter will show you how to add slide notes to an existing presentation.

Step 1 − To locate the slide notes, set the view in Normal mode.

Step 2 − The Slide Notes section is indicated by "Click to add notes".

Step 3 − You can click on the top border and drag the section to increase its size to make it easier to type.

Step 4 − Type your text in this section as slide notes.

You can only use bullets, numbering and alignment functions in the Slide Notes section. All other functions can be selected, but can be applied only to the selected slide, not the notes.

Slide notes can be printed from the print menu under the Backstage view. From the Print Layout option, select Notes Pages or 3 Slides. Notes Pages will print a single slide with the slide notes below it. The 3 Slides will print all three slides with notes on the right side.

How to create presentations in PowerPoint? (Step by step) Chapter 5 | ecourse | Adding Slides | Notes Managing Sections | Rearranging Sections | Powerpoint Sidebar | Working with Outlines.

noreply@blogger.com (Sayma) — Fri, 03 Apr 2020 15:15:00 +0000

This chapter will show you how to add slide notes to an existing presentation.

Step 1 − To locate the slide notes, set the view in Normal mode.

Step 2 − The Slide Notes section is indicated by "Click to add notes".

Step 3 − You can click on the top border and drag the section to increase its size to make it easier to type.

Step 4 − Type your text in this section as slide notes.

You can only use bullets, numbering and alignment functions in the Slide Notes section. All other functions can be selected, but can be applied only to the selected slide, not the notes.

Given the popularity of PowerPoint and its versatility, there are situations when you are dealing with very large slide decks or just collaborating with different people to build the slides. In such cases, it is always helpful to be able to segregate the slides into smaller groups and work with these groups. PowerPoint 2010 introduces the concept of sections to achieve this. Here are the main functions you can execute with sections.

Creating Sections

The steps to create a new section are as follows. You can execute these steps from the Normal view or the Slide Sorter view.

Step 1 − In the Normal view or the Slide Sorter view, right-click at the position where you want to add the section and select add section.

Step 2 − The new section gets added to the presentation with all the subsequent slides being included in this section.

Step 3 − By default, the new section is named "Untitled Section" but you can change the section name. Right-click on the section and select "Rename Section".

Step 4 − In the Rename Section dialog box, enter the new section name. This accepts all the characters including alphabets, numbers, special characters, punctuations, etc.

Step 5 − Click on the "Rename" button on the dialog to rename the section.

Rearranging Sections

One of the advantages of sections is that you can not only group slides together, but also rearrange them as one set. Instead of having to move each slide individually, you can move the entire section. Just like rearranging slides you can drag and move the sections. Alternately, you can right-click on the section and move it up or down as shown below.

If there are many slides to work with, you can collapse them so you view just the sections. This makes rearranging them less confusing too.

Deleting Sections

PowerPoint 2010 provides three options to delete sections. The table below explains the function of each option.

S.No	Delete Option & Description
1	Remove Section Deletes the selected section and merges slides with the previous section.
2	Remove Section & Slide Deletes the selected section and all the slides in the section.
3	Remove All Sections Deletes all the sections and merges all the slides into a presentation without sections.

PowerPoint is a great program that allows you to bring together text, images, shapes and multimedia. However, sometimes you may just want to review the text without focusing on the non-text aspects of the slide deck. This is where the Outline view in PowerPoint is quite useful. The Outline view can be accessed from the tab adjacent to the Slide tab in the Normal view.

The outline view shows just the text content from various slides. This view does not show the text entered in the non-text box like SmartArt, WordArt or any other shapes.

By default, the outline pane size is the same as the slide tab pane; hence it is small. However, you can drag the pane out to increase the size to improve readability.

PowerPoint slides have a left-hand side bar which offers two invaluable views. These views are great to review the slides and edit them. The side bar is available in the Normal view and by default, it is set to the Slides tab.

Slides Tab

This tab shows all the slides stacked vertically in a sequential manner. You can select individual slides from this tab and also perform some tasks like changing slide layouts, reordering slides, inserting new slides, deleting slides, etc. Although you cannot edit the slide contents from this tab, you can select the slide and make edits from the slide displayed to the right.

Outline Tab

This is the tab right next to the Slides tab and as the name suggests, this provides the outline for the slide. This section just displays all the textual content from every slide - this can be very useful if there is a lot of non-text content in the slide and reviewing just the written part gets difficult. Unlike in the slides tab, you can edit the text from this section.

If you need greater viewing space, you can close the sidebar by click on the X on the top right of this bar.

To recover the sidebar, just click on the Normal view icon again.

How To Create Presentations In PowerPoint? (Step by step) Chapter 6 | Presentation Views| Setting Backgrounds| Slide Orientations| Saving Presentation |Review Presentation | Adding Slide Numbers | Adding Header and Footer

noreply@blogger.com (Sayma) — Fri, 03 Apr 2020 15:15:00 +0000

PowerPoint supports multiple views to allow users to gain the maximum from the features available in the program. Each view supports a different set of functions and is designed accordingly.

PowerPoint views can be accessed from two locations.

Views can be accessed quickly from the bottom bar just to the left of the zoom settings.

Views can also be accessed from the Presentation Views section in the View ribbon

Here is a short description of the various views and their features.

Normal View

This is the default view in PowerPoint and this is primarily used to create and edit slides. You can create/ delete/ edit/ rearrange slides, add/ remove/ modify content and manipulate sections from this view.

Slide Sorter View

This view is primarily used to sort slides and rearrange them. This view is also ideal to add or remove sections as it presents the slides in a more compact manner making it easier to rearrange them.

Reading View

This view is new to PowerPoint 2010 and it was created mainly to review the slideshow without losing access to rest of the Windows applications. Typically, when you run the slideshow, the presentation takes up the entire screen so other applications cannot be accessed from the taskbar. In the reading view the taskbar is still available while viewing the slideshow which is convenient. You cannot make any modifications when on this view.

SlidesShow

This is the traditional slideshow view available in all the earlier versions of PowerPoint. This view is used to run the slideshow during presentation.

As PowerPoint is a design-based program, backgrounds are effective ways of improving the aesthetics and readability of the slides. The Themes in PowerPoint help select the backgrounds by default, so every time you change the theme, the default background is set automatically. Theme includes more than just backgrounds, so you can retain other aspects of the theme while changing the default background.

Given below are the steps to apply backgrounds in PowerPoint.

Step 1 − In the Design ribbon, under the Background group, click the Background Styles command.

Step 2 − Select one of the background styles that suits your requirements.

Step 3 − To edit the background for a specific slide, right-click on the desired background slide and select "Apply to Selected Slides".

Step 4 − Selected slide(s) now have the new background.

The graphics in the slide background can distract you from the actual content, in such cases you can hide the graphics and retain a plain background till you finish working on the content. To do this, select the slide and check the "Hide Background Graphics" checkbox.

In the recent years, presentations are being used for more than just as a high end replacement for transparencies and projectors. With its unique features, PowerPoint is becoming quite versatile in the kind of information it can depict and very flexible in its usage. The slide orientations are invaluable part of this improved list of PowerPoint features. Like most other applications PowerPoint supports two orientations: landscape and portrait.

The Landscape layout is the default PowerPoint layout and it is probably the more commonly used one. In the landscape layout, the longer edge is horizontal so the slides align better with the screens and projectors.

The Portrait layout is where the shorter edge is horizontal. This is sometimes better for print depending on the kind of content you want to present.

Slide orientations in PowerPoint can be changed from the Design ribbon using the Slide Orientation command.

One of the most basic tasks in PowerPoint is being able to save your work; this is probably the most important task as well. There are many users who have burnt their fingers for not saving their work in time and losing hours of hard work. The following are the basic steps to save a presentation.

Step 1 − Click on the File tab to launch the Backstage view and select Save.

Step 2 − In the Save As dialog, type in the file name and click "Save".

Step 3 − The default file format is .pptx. If you want to save the file with a different name, choose one of the file types from the "Save as type" dropdown list.

If you are working on an already saved file, the "Save" option in the Backstage view will directly save the file in the existing format with the existing name. If you want to change the format or filename of an existing file, use the Save As option instead.

Reviewing the presentation can be a very powerful way of eliminating the errors and perfecting the slides. PowerPoint offers a wide range of reviewing options for you to use. Some of them are automatic or system driven, while others aid other users to collaborate and review the slides. All the reviewing tools are grouped under the Review ribbon.

Review Section

Functions

Proofing

Spellchecking − Identify spelling and grammar based on selected language preference
Research − Reference language related research tools based on specific reference books and research sites
Thesaurus − Provide synonyms for selected text

Language

Translate − Provides translation services for selected words for multilingual support
Language − Sets the default language for the presentation - this will be used as default language for proofing

Comments

Show Marking − Show/hide the user comments in the slide
New Comment − Add new comment against the selected content
Edit Comment − Edit an existing comment
Delete Comment − Delete a selected comment, all comments in the selected slide or all the comments in the presentation
Previous / Next Comment − Move to previous / next comments

Compare

Compare − Compare the current presentation with another presentation and identify the differences
Accept/ Reject − Accept or reject the differences to be incorporated into the current presentation
Previous/ Next − Move to the previous or the next difference in the comparison.
End Review − End the review and discard any unapplied changes

Just like you have page numbers for books, it is usually a good idea to add slide numbers to presentations. There are two ways you can add slide numbers to your presentation and this chapter will show you both those techniques.

Step 1 − Under the Insert ribbon, Text group click on Slide Numbercommand.

Step 2 − The Header and Footer dialog opens up.

Step 3 − Check the Slide number check box.

Step 4 − The Preview shows the section where the slide number will be placed.

Instead of clicking on the Slide Number command, you can also click on the Header & Footer menu item to launch the same dialog as in Step 2.

PowerPoint offers the ability to add header and footers to the slides. While having footers in presentations is logical, header may not be quite evident at first. Typically, the slide title would be the header in the main slide, however when it comes to printing out handouts a separate header would be quite useful.

Here are the steps to add header and footer information to slides

Step 1 − In the Insert ribbon, click on the Header & Footer menu item.

Step 2 − The Header and Footer dialog has two tabs — the Slide tab and the Notes and Handouts tab.

Step 3 − You can add details to the slide footer from the Slide tab.

S.No	Slide Footer Options & Description
1	Date and time Add date and time to the footer Specify the format of the date and time entered Set up the footer to update automatically or use a fixed number
2	Slide Number Insert Slide number in the footer
3	Footer Add designated text to the footer - a good example of this is the confidentiality clause or copyright clause
4	Don't show on title slide Decide on whether the footer information should be displayed on the title slide or not

Step 4 − You can add the details to the handouts from the Notes and Handouts tab.

S.No	Notes and Handouts Options & Description
1	Date and time Add date and time to the footer Specify the format of the date and time entered Set up the footer to update automatically or use a fixed number
2	Header Add the header information for every page on the handout
3	Page Number Insert page number in the footer
4	Footer Add designated text to the footer - a good example of this is the confidentiality clause or copyright clause

When you check any of the header and footer checkboxes in either tabs, you can see the location where the detail is inserted in the preview section.

How To Create Presentations In PowerPoint? (Step by step) Chapter 7 Running Slide Show | Keyboard Shortcuts | Get Context Help

noreply@blogger.com (Sayma) — Fri, 03 Apr 2020 15:14:00 +0000

Most PowerPoint presentations are created to be run as a slideshow. Given all the advanced features available in PowerPoint 2010, it is no surprise that there are many features related to running the slideshow that have been included in this program too. Most of these features are really to help you create a good slideshow without having to go through the entire presentation over and over again after every minor change. Features related to running the slideshow are grouped under the Slideshow ribbon.

Section	Menu Item	Description
Start Slideshow	From Beginning	Starts slideshow from beginning
	From Current Slide	Starts slideshow from the current slide
	Broadcast Slideshow	Allows users to broadcast the slideshows using Microsoft's PowerPoint Broadcast Service
	Custom Slideshow	Builds a custom slideshow by picking the slides you want to run
Set Up	Set Up Slideshow	Helps set up the slideshow including browser/ full screen display, show options with or without narration/ animation, pen and laser color during the slideshow and the slides to be presented during the show
	Hide Slide	Helps mark/ unmark the slide as hidden, so it is skipped or shown during the slideshow respectively
	Rehearse Timing	Allows users to rehearse the timing on each slide and the entire slideshow
	Record Slideshow	Records the slideshow including narration and animation
	Slideshow Checkboxes	Helps set or avoid the use of narrative audio and rehearsed timings during the show. Display media controls in the slideshow view
Monitors	Resolution	Defines resolution in slideshow view
	Show Presentation on	Picks the monitor to display the presentation one - in case of multiple monitors
	Use Presenter View	Run presentation in Presenter view rather than just slideshow view Keyboard Shortcuts Like the other windows based programs, PowerPoint 2010 also offers a wide range of keyboard shortcuts. For the current PowerPoint users, there is a major change in the way these shortcuts are being mapped in the 2010 release compared to some of the older ones. With a whole new range of features being added to PowerPoint, it is evident why there are so many changes to the keyboard shortcuts. We will understand how to read and figure out the shortcuts with ease. Step 1 − The first step to access the keyboard shortcuts is to press the Altkey on your keyboard. This will display the first level of shortcuts indicated by alphabets or numbers as shown. For example, the shortcut to access the Home ribbon is 'H' and for saving the presentation, the shortcut is '1'. Step 2 − Once you select the first level of shortcut, the second level of shortcuts for respective commands are shown. Notice that some of these shortcuts are disabled or displayed in a lighter shade than others. This is because the disabled shortcuts cannot be used in the current state. For example, all the font related commands are disabled as no text has been selected. If you execute the same steps after selecting a portion of text, these shortcuts will be enabled too. In some cases, there are two alphabets associated with a single shortcut; in such cases, you need to key in both of them immediately after another to get the desired effect. Get Context Help Despite getting a good grasp of the program, we may need help on the different aspects from time to time. To aid in such scenarios, PowerPoint has created the Context Help feature. With this feature, if you get stuck in any dialog, you can press F1 and PowerPoint will open the help topic related to that dialog. This is extremely beneficial as you need not spend time trying to browse through all the help topics just to get to the one you need. The context help is based on the active window and not on the object you have selected. So if you select an image and press F1, you will get the generic help windows as your active window is still the main PowerPoint program. If you select any other dialog or window, PowerPoint context help will show the related help topic when you press F1. If you continue to work only with the ribbon options on the screen, the context help would not work. But if you right-click on the shapes or objects and open the related editing dialogs, you can press F1 and can learn more about the related functionalities of those shapes and objects.

Beginner Computer Typing Lesson 7- Part 7 (Shortcut Keys and Basic )

noreply@blogger.com (Sayma) — Wed, 25 Sep 2019 09:52:00 +0000

LEARN TYPING TESTIMONY

"I am a beginner. I don't really keep my fingers on the home keys but I do type with all fingers. I tried a whole bunch of different websites and games but none of them worked. I am going into 5th grade. I was really worried that I was going to fail because I couldn't type properly. But now after two hours I can type properly. I still have to work on the speed but that will be easy because I know how to type and that is all thanks to this program." - beginning typer

ADDITIONAL DRILLS common letter combinations

BUT NOT using Z X C V B N M Q Y U P

Keep referring to your keyboard chart.

th the there these their this that this is; that is; these are;

they are; there is; with those thistle father other whether

is his this is his; this is his; is this his; is this his; wish list;

this list; his list; lists wish dish fish wrist fist kiss kissed

fist wrist list listed twist twisted twister this is a twister;

all wall walls fall falls hall halls taller tallest call calls

all tall stall stalls stalled walls; all tall walls fall; hallowed

wh where whether whose what whole where whether

whose what whole whew whist whistle whither whale

et wet wetter set sets setter get regrets jet let letter kettle

ill kill jill hill fills sills rills till trill trills will bill tiller filler

ttle wattle rattle rattles tattle tattles little kettle settle

sh she shell shells shelter shelters sheet sheets shift shaft

SHIFT KEYS - Use the TAB key to move to the next text box

Gore

Wakari

Fairfield

Westside

Kaikorai

Stuart St

Kelso

Leith

Westlake

Hokitika

Halswell

St Kilda

CONGRATULATIONS!!!

YOU HAVE COMPLETED THE BEGINNERS COURSE!

And yes, you can still repeat to get better :)

Beginner Computer Typing Lesson 6- Part 6 (Keyboard Keys and Shortcut keys)

noreply@blogger.com (Sayma) — Wed, 25 Sep 2019 09:52:00 +0000

LEARN TYPING TESTIMONY

"Hi, I am a new Business Apps teacher (middle school) and I actually teach typing to my 6th graders. I got a new student today so I did a Google search and found your site right away. I started her out at your site and I have to sing your praises. It is awesome and the new student will be able to catch up with the class in no time. I'm surprised that there is no way to donate money to keep this free site going. This site will be critical to the success of my students. Thank you!

INTRODUCTION to PUNCTUATION

P u n c t u a t i o n - check the chart above for the correct finger position.

The comma is next to M and the fullstop to its right. They are below K & L.

To type a capital letter or character (*) do the following ...

Hold the Right Shift Key for a Left Hand letter or character

Hold the Left Shift Key for a Right Hand letter or character.

Type these instruction lines into the yellow boxes below them.

For the question mark, hold down the left Shift key while you type the / key.

For the exclamation mark, hold down the right Shift key while you type the 1 key.

The colon is on the semi-colon key and needs the left Shift key held.

For the dash and for the hyphen use the same upper row key, between 0 and =

The single quotation mark (beside the colon) is also used for the apostrophe.

For the double quotation mark first hold down the Left Shift key.

Type the sentences below to practise your punctuation.

If you practise your typing each day, it will soon become easy.

Instead of a comma - you could use the dash - above the P key.

Join for hyphen. First-class. Did you enjoy this typing course? I hope so!

"Hullo," said Julia to George. "Isn't it a really lovely day?"

"Stop! There's too much noise! It's giving me a headache!"

Press down the Caps Lock (above the Left Shift key) for full capitals headings.

Press to release.

Press the Tab key (above the Caps Lock) to jump across the page to line up lists.

Do not use the space bar; you may not line up exactly.

MONDAY

TUESDAY

WEDNESDAY

THURSDAY

FRIDAY

Swimming

Soccer

Netball

Skydiving

Drama

Brackets. ( ) are above 9 and 0 - hold the Shift key while you type these.

And these { } are beside P near the Shift key.

Hold the Shift key while you type these

[ ] do not need the Shift key so are perhaps handier.

They are on the same keys as { }

To Underline words first click the mouse on the U on the toolbar.

You can also click on B for Bold, or I for Italics.

Repeat this action (with the mouse) when you want this feature to stop.

WELL DONE!

You have completed Lesson 6.

Repeat to get better.

Beginner Typing Lesson 5- Part 5 (Home Keys and Basic Drills)

noreply@blogger.com (Sayma) — Wed, 25 Sep 2019 09:52:00 +0000

LEARN TYPING TESTIMONY

"I didn't think I could learn through a webpage but, I am typing faster and finally using all my fingers. I am surprised at how quickly I learned this new skill. Thank you!"

Type A with the Left little finger and P with the Right little finger

LEFT HAND RIGHT HAND

faf far fat fatter far farmer faf far fat fatter far farmer

fan ran tan jan land hand band fan ran tan jan land hand band

pot port pit put pop pup puppy pot port pit put pop pup puppy

purr top rope romp trap tramp trumpet purr top rope romp trap tramp trumpet

More with G - stretch out Left index finger

fig rig tig pig got grip green fig rig tig pig got grip green

ring ding dong song sang singer arrange ring ding dong song sang singer range

Q with Left little finger

quit quite quiet quill queen quilt queer quit quite quiet quill queen quilt queer

quote quoted equate equation equal quack quaint quote quoted equate equation

Z and X to finish. Check chart for fingers

zoo zulu zigzag fax tax text exit zoo zulu zigzag fax tax text exit

We went to see the zebras and giraffes at the zoo last Friday. That was fun.

Make sure you type the correct text in your document or it will not make sense.

If you enjoyed this typing course please tell others who would find it helpful.

I hope the course has helped you enjoy your computer typing.

Type this paragraph and the one below it. There is no need to press the Enter key to start new lines. Keep typing and the computer will know when to drop down to the next line. At the end of each paragraph press Enter twice to leave a blank line between paragraphs.

I hope you have enjoyed this typing course and can now visualize where each letter key is situated on your keyboard and which is the best finger to use for each key. If you can do that you will find you will use less energy, and finish your typing more quickly.

WELL DONE!

You have completed Lesson 5.

Repeat to get better.

Beginner Typing Lesson 3- Part 4(Home Keys and Basic Drills)

noreply@blogger.com (Sayma) — Wed, 25 Sep 2019 09:52:00 +0000

If you have completed Beginner Lessons 1 & 2 then carry on with Beginner Lesson 3 below :)

Bottom row keys for the index fingers - stretch down, visualise the keys.

Left Hand - v & b (same finger) Right Hand - n & m (same finger)

fvf frfvf fbf frfbf rev vet fvf frfvf fbf frfbf rev vet

five fiver fib fibber very every five fiver fib fibber very every

jmj jujmj jnj jujnj jmj jujmj jnj jujnj

jim him tim rim hem them jim him tim rim hem them

jnj jujnj tin fin din dint tint jnj jujnj tin fin din dint tint

ten tent often den dent over oven ten tent often den dent over oven

men mend mended mine mind moment remember mend mended mine mind

Right Hand top row vowels:

ou ough rough tough trough enough ou ough rough tough trough enough

though thought through thorough though thought through thorough

house houses mouse mound mounds house houses mouse mound mounds

round rounds sound resounded round rounds sound resounded

ion lion mention vision visions ion lion mention vision visions

iou ious conscious envious mission missions iou ious conscious envious missions

Some phrases to type - use the right little finger for the semi-colon beside L

john mentioned the lions and tigers; they looked very tough;

the little mouse went round the house which stood on a high mound;

i remember the mission which is built on the high ground beyond the valley;

i rested in my house before playing two rounds of golf;

WELL DONE!

You have completed Lesson 3.

Repeat to get better.

Beginner Typing Lesson 4- Part 4(Home Keys and Basic Drills)

noreply@blogger.com (Sayma) — Wed, 25 Sep 2019 09:52:00 +0000

LEARN TYPING TESTIMONY

"Thank you very much for this course... I love it! I am 35 and finally decided to learn typing, as I am tired of having to keep looking at the keyboard (and the screen...) -which translates in tiresome extra minutes every time I have to write an email... I am at Beginner - Lesson 4 at the moment and find your course veeeeeeeeery helpful... I will let you know how I get on at the end of it. Thank you very much indeed. -"

LEFT RIGHT

Left hand Finger 2, drops from D to bottom row C

ded dcd dedcd decided deck decked check cheese chest

cheek creek creeks dice slice sliced twice

Type these phrases using the right little finger for the semi-colon

type slowly with correct fingers; check the colours in the finger columns;

notice which finger should type the letter key you need;

when you come to tricky words type them more times;

To type Capital letters you will need to use the Shift keys, above the Ctrl keys on each side of the letter key block. Left of Z and Right of ?

The Shift keys are used also for Upper Characters like @ $ % * <

For a Left Hand capital hold the RIGHT Shift key - type the letter, then lift the Shift key. For a Right Hand capital hold the LEFT Shift key.

Try these sentences

The full stop is on the bottom row; use the ring finger.

The comma is to the left of the full stop; use your longest finger.

To start a new line, press the Enter key once.

Hold the Right Shift key for these left hand capitals.

Try to keep your fingers curved.

Do not let your wrists rest on the desk. That wastes energy.

The trees were very, very wet. We will get wet when we go outside.

Do not type for too long without stretching your shoulders, neck, wrists, fingers.

Hold the Left Shift key for these right hand capitals

Keep your legs uncrossed. Keep your feet on the floor.

It helps if you remember which finger types which key.

Look before you cross the street or you might get knocked down.

Jimmy took Henry to town to buy something. He bought four good story books.

WELL DONE!

You have completed Lesson 4.

Repeat to get better.

Beginner Typing Lesson 2 - part 1 (Two KEY letters and more word practice)

noreply@blogger.com (Sayma) — Wed, 25 Sep 2019 09:52:00 +0000

Beginner Typing Lesson 2 - part 1 (Two KEY letters and more word practice)

Flex your fingers to loosen them. Notice the two keys G and H in the centre of the keyboard. Sit so that these are in front of the centre of your body. Use fingers as shown

Keeping your fingers over the two sets of four keys we just practised - stretch your index fingers across to G & H (left hand for "G" and right hand for "H") and type the following:

Both Hands

gh gh gh gh gh gh gh gh gh gh gh gh gh

Stretch your Left index finger up/out to T (look on the keyboard) and type:

th th th th th th th th ght ght ght ght ght ght ght

feet fret get greet regret regretted rift drift gift gifted fig figure

dirt diet tire tired retire retired tried he her here the there

jut jutted jud jug judge judged hug hugged dug drug drugged

ugh high higher thigh tight fight right fright tight height eighth hut hurt

Flex your fingers again and your shoulders. Tap the table drill 1234 1234 Try typingasdf asdf and jkl; jkl; again for a line. Enter text in the box below.

MORE FUN PHRASES

freddie tried the fridge; the right fridge; keith agreed; the huge free feed;

red jug; guide the tight red kite higher; the hired guide urged the rugged hiker;

the right judge; the third huge tiger tried; true ruth tried the third free gift;

Beginner Typing Lesson 2 - part 2

New keys using 3^rd fingers

LEFT HAND RIGHT HAND

LEFT HAND RING FINGER (no 3) - W & S (stretch the F finger to T)

wee weed wed were wet sweet sweeter wee weed wed were wet sweet sweeter

weeds weeded seed seeds seeded weeds weeded seed seeds seeded

RIGHT HAND RING FINGER - Introducing the letters L & O

lool look loot hoot tool fool fools lool look loot hoot tool fool fools

dull duller full fuller hull hulls hullo dull duller full fuller hull hulls hullo

toll tolls roll rolls told fold folds toll tolls roll rolls told fold folds

NEW - RIGHT INDEX FINGER - stretch the J finger to Y

juj jyyj joy toy roy try fry juj jyyj joy toy roy try fry juj jyyj joy toy roy try fry

jit hit fit dit wit lit litter jit hit fit dit wit lit litter jit hit fit dit wit lit litter

wet wets jet jets let lets letters wet wets jet jets let lets letters

MORE FUN PHRASES Use the right little finger for the semi-colon beside the L key.

try fried food; jets fly high; wet litter; try to fly; try fried food; jets fly high; wet litter;

folded rolls; fred looks duller; red toy kite; jittery jet; freds red roll looks duller;

the first red kite flies higher; let the wet kite dry; weed seeds;

little red dolls roll; toy dolls for wee jill; look for freddie;

first flight for fred; jill jilted hugh west; first flight for fred; jill jilted hugh west;

WELL DONE!

You have finished Part 2 of Lesson 2.

Repeat to get better.

Beginner Typing Lesson 1 - Part 1 (Home Keys and Basic Drills)

noreply@blogger.com (Sayma) — Wed, 25 Sep 2019 09:51:00 +0000

Beginner Typing Lesson 1 - Part 1 (Home Keys and Basic Drills)

HOME KEYS AND CORRECT FINGER POSITION

The two images below shows the Home Keys for the left and right hand. They are called the Home Keys because these are the keys your fingers must return to after typing any other key. The first image shows correct finger position for Home Keys. The second image has colour and number codes for each finger. For example, throughout this course your right index finger is used on all RED keys (also shown as number 1). Most keyboards have small bumps on the F and J keys to help you find them without looking. As you progress through your typing lessons you will learn the correct finger position for all keys.

OK - LETS GET STARTED!!

Move the mouse cursor (pointer) over the first yellow exercise box (below). Now click the left mouse button and you will see the cursor 'blinking' inside the box. You are ready to start typing.

With your fingers over the HOME KEYS, copy the text from ABOVE each exercise box by tapping the same key on your keyboard. ALWAYS USE THE CORRECT FINGER POSITION. We will start with left hand. Begin by tapping the letter "F" with the index finger (also called the pointer finger) on the left hand. Tap "F" four times. Then tap the space bar once with your right thumb. Next tap "D" four times, then "S" and finally "A". Each time you have typed the letters FDSA, press the space bar with your right thumb. Do this whenever you see a space between letters. Keep copying the letters until you reach the end of the line. Now go back and repeat this exercise box (read below for a quick tip on deleting the text you have typed).

With the mouse cursor inside a text box, hold down the Control Key and tap (type) the letter A. This will block (highlight) everything inside the text box. The very first letter you type will delete this text making it easy to start again. Always do each exercise box two times. Now press the TAB key to move to the next exercise box.

Left Hand

ffff dddd ssss aaaa ffff dddd ssss aaaa ffff dddd ssss aaaa

asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf

fdsa fdsa fdsa fdsa fdsa fdsa fdsa fdsa fdsa fdsa

Right Hand

jjjj kkkk llll ;;;; jjjj kkkk llll ;;;; jjjj kkkk llll ;;;;

jkl; jkl; jkl; jkl; jkl; jkl; jkl; jkl; jkl; jkl; jkl; jkl;

;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj ;lkj

To move to the next box, press the TAB key or left click inside the box with your mouse.

Both Hands

fd fds fdsa jk jkl jkl; fd fds fdsa jk jkl jkl; fd fds fdsa jk jkl jkl;

WELL DONE!

You have finished Part 1 of Lesson 1.

Repeat to get better.

Beginner Typing Lesson 1 - Part 2 (Introducing words and 3 more vowels)

Follow the colours and finger numbers in the next chart to practise lines of each pattern or word of the following. Visualise where the letter keys are and use the fingers shown.

Using only the four Left hand letter keys, D and F on the Home Key row with E and R on the row above we can feel out the word ‘fred’ which is one of 16 words that can be formed from only these four letters.

Place your fingers over the Home Keys. With the Left hand first finger lightly tap f r f r f r f r. Now with the second finger lightly tap d e d e d e d e.

On the Home Keys tap these fingers on d f d f d f d f then on the row above tap e r e r e r e r.

Within these four letters the Left hand can type the patterns de ed re er. Feel them out now by lightly touching the keys.

These patterns are used in words like demand remind asked walker.

Left Hand

deed frrf deer reed red deed frrf deer reed red deed frrf deer reed red

free freed fred feed fed free freed fred feed fed free freed fred feed fed

reef reef ref ref refer refer defer defer referred deferred refereed

The Right hand fingers 1 and 2 use Home Keys J and K and U and I in the row above.
Lightly tap these fingers on j k j k j k j k, then on the row above, u i u i u i u i.
Now type the following practise line twice.

Right Hand

juuj kiik juj kik juuj kiik juj kik juuj kiik juj kik juuj kiik juj kik

Please Note: we can not type any words with only these four letter keys.

Both Hands

jude jude dud dud dude dude rude rude due due rudder rudder

fur fur fir fir fire fire fired fired ride ride fried fried rider rider

kid kid did did die die died died dried dried ride ride drier drier

TRY THESE FUN PHRASES

Type the semi-colon with the Right little finger or leave it out till a later lesson.

red deer; feed freddie; red fire; free feed; fried deer;

eddie died; free ride; eddie fired fred; did eddie die;

edifier rider dude freed red fur deer; kidder eddie rudder fed red deer;

freed fed red deer died; fred fuji fried freed fed red deer;

duke jeered rude referee jed; did irked kirk fire rude jerk;

did freddie duke feed jeff kirk free fried red deer; rude eddie kerr jerked duke kirk;

WELL DONE!

You have finished Part 2 of Lesson 1.

Repeat to get better.

How to fix or remove background noise,Buzzing sound while recording through microphone on windows Pc

noreply@blogger.com (Sayma) — Wed, 03 Jul 2019 03:02:00 +0000

How to fix or remove background noise,Buzzing sound while recording

Did you have a lots of data in a text document and you wish you could easily copy that to Excel?

noreply@blogger.com (Sayma) — Sun, 07 Apr 2019 13:14:00 +0000

Keyboard Shortcuts

You will save tons of time and make moves like a ninja once you master the keyboard shortcuts. Here are some of my favorites:

|Ctrl + A|: will select all of the data

|Ctrl + C|: will copy the selected data (or object)

|Ctrl + V|: will paste the copied data (or object)

|Ctrl + End|: will take you to the last cell of your data

|Ctrl + Home|: will take you to the first cell of your data

|Ctrl + Up Arrow|: will take you to the first cell of your active column

|Ctrl + Down Arrow|: will take you to the last cell of your active column

|Shift + Space|: will select row(s) of your active cell(s)

|Ctrl + Space|: will select column(s) of your active cell(s)

|Shift + Space|: will select row(s) of your active cell(s)v

|Ctrl + minus sign|: will give you Delete options

Copy Formula Down

To quickly copy a formula down:

Hover to the bottom-right corner of the cell with the formula (you will notice that the cursor has turned to a thick black plus sign)

Double click the plus sign

Copying Values or Formulas

When tip #2 doesn’t work because there’s a blank cell between your starting cell and the end cell of your range or you don¢t want to drag a formula down to 1000 rows, try this:

Go to the first cell that you would like to copy or fill in other cells

In the name box, type in the address of the last cell of the range, where you want to fill data or formula and hit |Shift + Enter|

Press F2 to edit the formula in your first cell

Then hit |Ctr + Enter|

You can see the name box highlighted in the red box. You will find this box right next to the fFormula Bar

Total a Column or a Row

To quickly total a column or a row, in the last cell, hit |Alt + =| (equal to sign).

Delete Duplicate Rows

To delete rows with duplicated data, follow these steps:

Select the range of the data that you want de-duplicated (usually, |Ctrl + A| works)

Click on the Data menu option from the menu ribbon

Click on the Remove Duplicates button

Choose whether your range has a header row

Hit OK

Add Leading Zeros

You often find the need to add leading zeros to a number and most likely the result value is a text format. For example, you may want to show the number 7893 as 0000007893, making the number a text value with a length of 10 characters. If your number is in A1 and you want to convert that to text with leading zeros with a maximum length of 10 characters, enter this formula in B1:

=TEXT(A1,REPT("0",10))

Repeat Header for Printing

While printing a multi-page sheet, it is useful to repeat the header row(s) on every page. To do so,

Click on Page Layout menu option on the riboon

Click on Print Titles button

Select the row(s) you want to repeat at the top in Rows to Repeat at Top box

Create Named Ranges

For sheets with large number of rows, it is useful to give names to ranges so that you can refer to these names in your formulas without clicking and selecting long ranges. To quickly give names to your ranges:

Click on the Formulas menu option on the ribbon

Click on the Create from Selection button

Select the ranges to give names from usually Top Row works well as this row is the header row

Copy Values

To speed up copying only values and not the formulas, use this keyboard shortcut sequence:

|Ctrl + A| to select the whole range of data (or select your range with the help of the mouse)

|Ctrl + C| to copy the data

Import a Table from the Web

Often you need to import data from the internet and you wish for a better way of doing so. Well, here is one way. Let¢s say you want to import the list of all time leaders of home run hitters in baseball from baseball almanac. Follow these steps to enjoy seeing this data in an Excel file:

Click on Data menu option from the ribbon

Click on From Web

In the browser window, enter the URL: http://www.baseball-almanac.com/hitting/hihr1.shtml

Hit the Go button on the browser window

Scroll down to the table of home runs

Click on Click to select this table check box

Click on Import

Click on OK

Only a ninja can import raw tables from the web to the Excel files!

Delete Current Row(s)

To quickly delete current row(s), follow these two steps

Select the row(s) by |Shift + Space|

Delete the selected row(s) by |Ctrl + - (minus sign)|

Delete Current Column(s)

To quickly delete current column(s), follow these two steps

Select the column(s) by |Ctrl + Space|

Delete the selected column(s) by |Ctrl + - (minus sign)|

Quick Aggregation

Quick Tool provide aggregate statistics, such as Average, Count, Numerical Count, Max, Min, and Sum of the data from a selected range without entering any formula. To show these statistics in the bottom toolbar, right click on the toolbar and choose the desired statistic.

Finding a Related Value

Often you have to translate or cross-walk a value, say a state code, to it a related value, in this case the fully spelled state name. You can write multiple, nested |IF|, but a ninja way is to use a |VLOOKUP| formula. The syntax of VLOOKUP formula is: =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

In the above example, our lookup value is the state code and table array is a table with the state codes and their descriptions.

The column index is the column that we want to return after matching a code

The range lookup is an argument to search for exact matches (1 or TRUE) or approximate matches (0 or FALSE)

Let’s say, your customer IDs in Column A, their mailing state code in Column B, and in Column C you want to see the state spelled out. To do so, follow these steps:

Create a table of codes and their fully-spelled values in Column E and F
In |C2|, enter this formula: =VLOOKUP(B2,E3:F6,2,0)
Copy the formula down

Converting Numbers to Ranges

Did you ever find yourself with the need to convert a number column to discrete ranges for easier summaries or graphs? Did you wish there was a better way? Well, there is: the |VLOOKUP| formula. You saw the syntax: The syntax of VLOOKUP formula is:=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) To convert numbers to ranges, you use the |range_lookup| argument with a value of |TRUE|, which will tell Excel to make an approximate match to the lookup value. We can use this to our advantage. Let’s say, you have some measure, such as, population, revenue, sales, # of units, etc, in Column A. You want to convert these measures to certain ranges. To do so, follow these steps:

Create a table of measures and their discrete ranges in Column F and G

In |C2|, enter this formula: =VLOOKUP(A2,F3:G8,2,1)

Copy the formula down

Text to Columns

Did you have a lots of data in a text document and you wish you could easily copy that to Excel? Let’s say you have a Word document with some bullet points, like this:

Vendor A: 5,000

Vendor X: 9,900

Vendor D: 10,000

Vendor Z: 3,500

To copy and keep the desired formatting for easier manipulation, follow these steps:

Copy the data from your Word document

Paste the data in a blank Excel spreadsheet (say starting from cell |A1|)

Select column A

Click on the Data menu on the ribbon

Click on Text to Columns button

In the Convert Text to Columns Wizard — Step 1, select “Delimited”

In Step 2, check the “Other” box and enter |:| (colon) as the delimiter.

Hit Next/Finish and complete the wizard

The text will be separated by your delimiter and data will be in separate columns